Table lawprod.MSCM.TRANSFER 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
TRANSFER_ID number 22
TRANSFER_NO varchar2 20
TRANSFER_DETAILS_VW.TRANSFER_NO Implied Constraint R
TRANSFER_LOG.TRANSFER_NO SYS_C00914146 R
TS_NO varchar2 10  √  null
TRAYSET.TS_NO SYS_C00914135 R
BATCH_NO varchar2 20  √  null
BATCH.BATCH_NO Implied Constraint R
USER_ID number 22
USERS.USER_ID SYS_C00914136 R
CARTSET_ASSM_NO varchar2 10  √  null
CASECART_ASSEMBLY.CARTSET_ASSM_NO SYS_C00914137 R
FROM_LOC_NO number 22  √  null
LOCATION.LOCATION_ID SYS_C00914138 R
FROM_BIN varchar2 7  √  null
TO_LOC_NO number 22  √  null
LOCATION.LOCATION_ID SYS_C00914139 R
TO_BIN varchar2 7  √  null
TYPE number 22
START_TIME date 7
END_TIME date 7
STATUS number 22
STAT_DESCR varchar2 200  √  null
INSTRUMENT_TRACK_ID number 20  √  null
INSTRUMENT_TRACK.INSTRUMENT_TRACK_ID SYS_C00914212 R
PATIENT_ID varchar2 14  √  null
COMMENTS varchar2 40  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
TRANSFER_NO Primary key Asc SYS_C00914134

Close relationships  within of separation: