Table lawprod.MSCM.BATCH 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
BATCH_ID number 22
BATCH_NO varchar2 20
BATCH_ITEMS.BATCH_NO SYS_C00914076 R
LOAD_CONTENT.BATCH_NO Implied Constraint R
TRANSFER.BATCH_NO Implied Constraint R
TEMP_BATCH_ID varchar2 20  √  null
USER_ID number 22
USERS.USER_ID SYS_C00914068 R
BATCH_DATE date 7
TOTAL number 22

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
BATCH_NO Primary key Asc SYS_C00914067

Close relationships  within of separation: