Table slot9.WORLD.TSTA.SUB_BEAT_POINTS
Legacy table. This table is not currently used

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
SUB_BEAT_ID number 38
SUB_BEAT_CODES.SUB_BEAT_ID SBP_SBC_FK R
LONGITUDE varchar2 30
LATITUDE varchar2 30
POINT_INDEX number 38

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"POINT_INDEX" IS NOT NULL SBP_INDEX_NN
"LATITUDE" IS NOT NULL SBP_LATITUDE_NN
"LONGITUDE" IS NOT NULL SBP_LONGITUDE_NN
"SUB_BEAT_ID" IS NOT NULL SBP_SUB_BEAT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
SUB_BEAT_ID + LATITUDE + LONGITUDE Primary key Asc/Asc/Asc SBP_PK
SUB_BEAT_ID Performance Asc SBP_SBC_FK_I

Close relationships  within of separation: