Table lawprod.MSCM.PO_HEADER 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
PO_ID number 20
PO_LINE.PO_ID SYS_C00914323 R
PO_RECEIPT.PO_ID SYS_C00914344 R
PO_NUMBER varchar2 14
COMPANY_NO number 4
COMPANY.COMPANY_NO SYS_C00914285 R
PO_RELEASE number 4  √  null
PO_CODE varchar2 4  √  null
VENDOR varchar2 9  √  null
CREATION_DATE date 7  √  null
DFLT_DATE date 7  √  null
LOC_ID number 38  √  null
LOCATION.LOCATION_ID SYS_C00914286 R
TOTAL_LINES number 22
CLOSED_LINE number 22
IS_RELEASED char 1
IS_CANCELED char 1
IS_CLOSED char 1
IS_DROP_SHIP char 1
CLS_DATE date 7  √  null
INT_STATUS char 1
EXT_STATUS char 1

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
PO_ID Primary key Asc SYS_C00914283
PO_NUMBER + COMPANY_NO + PO_RELEASE + PO_CODE Must be unique Asc/Asc/Asc/Asc SYS_C00914284

Close relationships  within of separation: