Table lawprod.MSCM.INSTRUMENT_TRACK Generated by
SchemaSpy
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
INSTRUMENT_TRACK_ID number 20
INSTRUMENT_TRACK_LOG.INSTRUMENT_TRACK_ID SYS_C00914190 R
TRANSFER.INSTRUMENT_TRACK_ID SYS_C00914212 R
TS_INST_TK_DATA.INSTRUMENT_TRACK_ID SYS_C00914198 R
LOCATION_ITEM_ID number 20
LOCATION_ITEM.LOCATION_ITEM_ID SYS_C00914182 R
CREATION_DT date 7
INSTRUMENT_ID varchar2 32  √  null
MFG_SR_NBR varchar2 16  √  null
LOCATION_ID number 22
LOCATION.LOCATION_ID SYS_C00914183 R
BIN_LOCATION varchar2 7  √  null
USER_ID number 22  √  null
USERS.USER_ID SYS_C00914184 R
ACTIVITY number 22  √  null
STATUS char 1  √  null
DT_TIME date 7
USAGE_COUNT number 22 0

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
INSTRUMENT_TRACK_ID Primary key Asc SYS_C00914181

Close relationships  within of separation: