Table lawprod.MSCM.COMPANY 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
COMPANY_NO number 4
CASE_CART_HISTORY_VW.COMPANY_NO Implied Constraint R
COUNTFORM.COMPANY_NO CF_COMPANY_FK R
INSTRUMENT_BY_LOCATION_VIEW.COMPANY_NO Implied Constraint R
INSTRUMENT_HISTORY_VIEW.COMPANY_NO Implied Constraint R
ITEMS_IN_TRAY_LISTS.COMPANY_NO Implied Constraint R
LOCATION.COMPANY_NO SYS_C00913475 R
OPERATOR_ACTIVITY_CYCLE_C.COMPANY_NO Implied Constraint R
OPERATOR_ACTIVITY_PAR.COMPANY_NO Implied Constraint R
PO_HEADER.COMPANY_NO SYS_C00914285 R
PRINTER.COMPANY_NO SYS_C00913611 R
RECEIPT_LINE_DISTRIB.DELIVERY_COMPANY_NO SYS_C00914564 R
REQUESTOR.COMPANY_NO SYS_C00913458 R
REVENUE_CENTER.COMPANY_NO SYS_C00914678 R
ROUTE.COMPANY SYS_C00913838 R
TRAY_INV_REP_VW.COMPANY_NO Implied Constraint R
TRAY_INV_SERVICE_REP_VW.COMPANY_NO Implied Constraint R
USER_LOCATION_MAP.COMPANY_NO SYS_C00913537 R
VENDOR_GROUP_COMPANY.COMPANY_NO SYS_C00914244 R
WORKSTATION.COMPANY_NO SYS_C00914720 R
ITEM_GROUP varchar2 5
ITEM_GROUP.ITEM_GROUP SYS_C00913452 R
DESCRIPTION varchar2 30  √  null
IS_ACTIVE char 1
ADDED_TO_MSC char 1
EXT_DATA_IND char 1
EXTERNAL_STATUS char 1  √  null
CREATION_DT date 7
LAST_MODIFIED_DT date 7
ID_CONFLICT_DT date 7  √  null
AUDIT_ITL_FL char 1  √  null
AUDIT_ITM_FL char 1  √  null
COST_METHOD varchar2 4  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
COMPANY_NO Primary key Asc SYS_C00913451

Close relationships  within of separation: