Table lawprod.MSCM.CASECART_ASSEMBLY 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
CARTSET_ASSM_ID number 22
CARTSET_ASSM_NO varchar2 10
CASECART_ASSEMBLY_LOG.CARTSET_ASSM_NO SYS_C00914100 R
CASECART_ITEMS.CARTSET_ASSM_NO SYS_C00914110 R
DECONTAM_DETAILS.CARTSET_ASSM_NO Implied Constraint R
PICK.CARTSET_ASSM_NO Implied Constraint R
PICKING_DETAILS.CARTSET_ASSM_NO Implied Constraint R
PICKLIST_CARTSET_MAP_VW.CARTSET_ASSM_NO Implied Constraint R
TRANSFER.CARTSET_ASSM_NO SYS_C00914137 R
CASECART_NO varchar2 8
CASECART.CASECART_NO SYS_C00914090 R
USER_ID number 22
USERS.USER_ID SYS_C00914091 R
ASM_TIME date 7
ASSM_LOC_NO number 22
LOCATION.LOCATION_ID SYS_C00914092 R
TOTAL number 22  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
CARTSET_ASSM_NO Primary key Asc SYS_C00914089

Close relationships  within of separation: