Table slot9.WORLD.TSTA.ITEM_ORDERS
This table stores the order information for inventory items as created in the application
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
ORDER_ID number 0
ITEM_CUSTODIES.ORDER_ID ITCU_ITORD_FK R
ITEM_ENTRIES.ORDER_ID ITENT_ITORD_FK R
ITEM_INSPECTION_ITEMS.CUSTODY_ORDER_ID ITINSPI_ITORD_FK R
ITEM_INST_CUSTODY_DESC_VW.ORDER_ID Implied Constraint R
ITEM_INST_CUSTODY_VW.ORDER_ID Implied Constraint R
ITEM_INSTANCES.CUSTODY_ORDER_ID ITII_ITORD_CUST_FK R
ITEM_INSTANCES.ORDER_ID ITII_ITORD_FK R
VENDOR_ID number 0
ITEM_VENDORS.VENDOR_ID ITORD_ITVD_FK R
ORDER_DATE date 7  √  null
RECEIVED_DATE date 7  √  null
ORDER_NUMBER varchar2 50  √  null
TRACKING_NUMBER varchar2 50  √  null
CONTRACT_NUMBER varchar2 50  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ITORD_AGNCY_CD_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL ITORD_AGNCY_CD_NN
"ORDER_ID" IS NOT NULL ITORD_ORDER_ID_NN
"VENDOR_ID" IS NOT NULL ITORD_VENDOR_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ORDER_ID Primary key Asc ITORD_PK
AGENCY_CODE Performance Asc ITORD_AGNCY_CD_FK_I
VENDOR_ID Performance Asc ITORD_ITVD_FK_I

Close relationships  within of separation: