Table lawprod.MSCM.LOCATION 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
LOCATION_ID number 22
ASSEMBLY.ASM_LOC_NO SYS_C00913968 R
BATCH_ITEMS.ACTIVITY_LOC_NO SYS_C00914078 R
CASE_CART_HISTORY_VW.LOCATION_ID Implied Constraint R
CASECART.LOC_NO SYS_C00914083 R
CASECART_ASSEMBLY.ASSM_LOC_NO SYS_C00914092 R
CASECART_ASSEMBLY_LOG.LOC_NO SYS_C00914102 R
CASECART_ITEMS.ACTIVITY_LOC_NO SYS_C00914112 R
CHARGE_DETAIL.SUPPLY_LOCATION_ID SYS_C00914788 R
CHARGE_SUPPLY_LOCATION.SUPPLY_LOCATION_ID SYS_C00914811 R
COUNTFORM_ITEMS.LOCATION_ID SYS_C00913718 R
DECONTAMINATION_UNIT.LOCATION_ID SYS_C001030830 R
DEFAULT_USER_LOCATION_TYPE.LOCATION_ID SYS_C00913531 R
DELIVERY_EVENT.LOCATION_ID Implied Constraint R
DELIVERY_TICKET.DELIVERY_LOCATION_ID SYS_C00914378 R
DELIVERY_TICKET.FROM_LOCATION_ID SYS_C00914379 R
DELIVERY_TICKET.RECV_LOCATION_ID SYS_C00914377 R
DOCKLOG.RECV_LOCATION_ID SYS_C00913762 R
INSTRUMENT_BY_LOCATION_VIEW.LOCATION_ID Implied Constraint R
INSTRUMENT_HISTORY_VIEW.LOCATION_ID Implied Constraint R
INSTRUMENT_TRACK.LOCATION_ID SYS_C00914183 R
INSTRUMENT_TRACK_LOG.LOCATION_ID SYS_C00914191 R
ITEMS_IN_TRAY_LISTS.LOCATION_ID Implied Constraint R
LOCATION_APP_MAP_VW.LOCATION_ID Implied Constraint R
LOCATION_BIN.LOCATION_ID SYS_C00913483 R
LOCATION_GROUP.LOCATION_ID SYS_C00913487 R
LOCATION_GROUP_DTLS.LOCATION_ID SYS_C00914670 R
LOCATION_ITEM.LOCATION_ID SYS_C00913500 R
LOCATION_ITEM.REPL_FROM_LOC_ID SYS_C00913502 R
LOCATION_SCHEDULE.SUPPLY_LOC_ID SYS_C00914866 R
LOCATION_TYPE_MAP.LOCATION_ID SYS_C00913525 R
NOTE.LOCATION_ID SYS_C00913601 R
PICK.PICK_LOC_NO SYS_C00914126 R
PICKLIST_HEADER.FROM_LOC_ID SYS_C00914490 R
PICKLIST_HEADER.REQ_LOC_ID SYS_C00914491 R
PO_HEADER.LOC_ID SYS_C00914286 R
PO_LINE.SHIP_TO_LOC SYS_C00914324 R
PO_LINE_DEL.DEL_LOC_ID SYS_C00914330 R
PO_LINE_RECEIPT_RECORD.RCV_LOC SYS_C00914360 R
PO_RECEIPT.RCV_LOC SYS_C00914346 R
PRINTER_LOCATION_MAP.LOCATION_ID SYS_C00913621 R
PRINTER_USER_MAP.LOCATION_ID SYS_C00914839 R
RECEIPT_HEADER.RECV_LOCATION_ID SYS_C00913776 R
RECEIPT_LINE_DISTRIB.DELIVERY_LOCATION_ID SYS_C00914562 R
ROUTE.TRANSFER_LOCATION_ID SYS_C00913839 R
ROUTE_SOURCE_LOC.LOCATION_ID SYS_C00913850 R
ROUTE_STOP.LOCATION_ID SYS_C00913844 R
STERILIZER_EQUIPMENT.LOC_NO SYS_C00913974 R
TASK.REQUESTING_LOCATION_ID SYS_C00913563 R
TRANSFER.FROM_LOC_NO SYS_C00914138 R
TRANSFER.TO_LOC_NO SYS_C00914139 R
TRANSFER_LOG.FROM_LOC_NO SYS_C00914147 R
TRANSFER_LOG.TO_LOC_NO SYS_C00914148 R
TRAY_ACTIVITY_VW.LOCATION_ID Implied Constraint R
TRAY_IN_LOCATION_VW.LOCATION_ID Implied Constraint R
TRAY_LIST.SOURCE_LOCATION_NO SYS_C00913918 R
TRAY_LIST.STORAGE_LOCATION_NO SYS_C00913917 R
TRAYSET.ASSM_LOC_NO SYS_C00913952 R
USER_LOCATION_MAP.LOCATION_ID SYS_C00913536 R
USERPARFORM.LOCATION_ID USRPF_PFID_FK R
WORKSTATION_SUPPLY_LOCATION.LOCATION_ID SYS_C00914727 R
LOCATION_CODE varchar2 5
COMPANY_NO number 4
COMPANY.COMPANY_NO SYS_C00913475 R
NAME varchar2 50
IS_ACTIVE char 1
ADDED_TO_MSC char 1
EXT_DATA_IND char 1  √  null
EXTERNAL_STATUS char 1  √  null
ADDRESS_ID number 22  √  null
ADDRESS.ADDRESS_ID SYS_C00913476 R
CREATION_DT date 7
LAST_MODIFIED_DT date 7
ID_CONFLICT_DT date 7  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
LOCATION_ID Primary key Asc SYS_C00913474
ADDRESS_ID Performance Asc LOC_ADDRESS_IDX
COMPANY_NO + LOCATION_CODE Must be unique Asc/Asc LOCATION_UK

Close relationships  within of separation: