Table lawprod.MSCM.DELIVERY_TICKET 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
DELIVERY_TICKET_ID varchar2 40
DELIVERY_UNIT.DELIVERY_TICKET_ID SYS_C00914387 R
RECEIPT_LOG_VW.DELIVERY_TICKET_ID Implied Constraint R
RECV_LOCATION_ID number 22
LOCATION.LOCATION_ID SYS_C00914377 R
RCV_USER_ID varchar2 80  √  null
CREATION_DT date 7
DELIVERY_LOCATION_ID number 22
LOCATION.LOCATION_ID SYS_C00914378 R
REQUISITION_NO varchar2 10  √  null
PO_NO varchar2 20  √  null
PO_CODE varchar2 4  √  null
PO_RELEASE number 4  √  null
REQUESTED_DEL_DT date 7  √  null
FROM_LOCATION_ID number 22  √  null
LOCATION.LOCATION_ID SYS_C00914379 R
RECEIVER_NO number 10  √  null
DELIVER_TO varchar2 30  √  null
REQUESTOR_ID number 22  √  null
REQUESTOR.REQUESTOR_ID SYS_C00914380 R
DELIVERY_TICKET_TYPE char 1
ACCEPT char 1
LAST_MODIFIED_DT date 7  √  null
ALT_REQUESTOR varchar2 10  √  null
DELIVERED varchar2 1 'F'
VENDOR_SYSTEM_ID number 22  √  null
VENDOR.VENDOR_SYSTEM_ID SYS_C00914381 R
SHIPMENT_NO number 20  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
DELIVERY_TICKET_ID Primary key Asc SYS_C00914376
CREATION_DT + DELIVERY_LOCATION_ID Performance Asc/Asc DT_CRDT_LOCID_IDX
DELIVERY_LOCATION_ID + DELIVERED Performance Asc/Asc DT_LOC_IDX
PO_NO Performance Asc DT_PO_NO_IDX
REQUISITION_NO Performance Asc DT_REQNO_IDX

Close relationships  within of separation: