| SchemaSpy Analysis of lawprod.MSCM - Constraints | Generated by SchemaSpy |
| 247 Foreign Key Constraints: |
|
| Constraint Name | Child Column | Parent Column | Delete Rule |
|---|---|---|---|
| ACTLOGTYPE_FK | ACTIVITY_LOG.ACTIVITY_TYPE | ACTIVITY_TYPE.ACTIVITY_TYPE | Restrict delete |
| ATTR_TYPE_ID_FK | ATTRIBUTE_VALUE_LIST.ATTRIBUTE_TYPE_ID | ATTRIBUTE_TYPE.ATTRIBUTE_TYPE_ID | Restrict delete |
| ATTRIB_TYPE_ID_FK | ATTRIBUTE.ATTRIBUTE_TYPE_ID | ATTRIBUTE_TYPE.ATTRIBUTE_TYPE_ID | Restrict delete |
| CF_COMPANY_FK | COUNTFORM.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| LOC_ITEM_BIN_FK | LOCATION_ITEM_BIN.LOCATION_ID LOCATION_ITEM_BIN.BIN |
LOCATION_BIN.LOCATION_ID LOCATION_BIN.BIN |
Restrict delete |
| OBJ_TYPE_ID_FK | ATTRIBUTE.OBJECT_TYPE_ID | OBJECT_TYPE.OBJECT_TYPE_ID | Restrict delete |
| SYS_C001030830 | DECONTAMINATION_UNIT.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C001030831 | DECONTAMINATION_UNIT.DECONTAM_METHOD_ID | DECONTAMINATION_METHOD.DECONTAM_METHOD_ID | Restrict delete |
| SYS_C001030846 | REPORT_SETTINGS_PARAMETER.REPORT_SETTINGS_ID | REPORT_SETTINGS.REPORT_SETTINGS_ID | Restrict delete |
| SYS_C001030852 | PO_TRANSDTL.DELIVERY_TICKET_ID PO_TRANSDTL.DELIVERY_UNIT_NO PO_TRANSDTL.DISTRIB_LINE_NO |
DISTRIB_LINE.DELIVERY_TICKET_ID DISTRIB_LINE.DELIVERY_UNIT_NO DISTRIB_LINE.DISTRIB_LINE_NO |
Restrict delete |
| SYS_C00913373 | USERGROUP_USERROLE.USR_ROLE_ID | USER_ROLE.USR_ROLE_ID | Restrict delete |
| SYS_C00913374 | USERGROUP_USERROLE.USR_GRP_ID | USER_GROUP.USR_GRP_ID | Restrict delete |
| SYS_C00913387 | USERS_USERGROUP.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913388 | USERS_USERGROUP.USR_GRP_ID | USER_GROUP.USR_GRP_ID | Restrict delete |
| SYS_C00913392 | UI_PAGES.USR_ROLE_ID | USER_ROLE.USR_ROLE_ID | Restrict delete |
| SYS_C00913397 | UI_PAGE_MAPPING.UI_PAGES_ID | UI_PAGES.UI_PAGES_ID | Restrict delete |
| SYS_C00913398 | UI_PAGE_MAPPING.MAP_TO | UI_PAGES.UI_PAGES_ID | Restrict delete |
| SYS_C00913419 | MFGR.ITEM_GROUP | ITEM_GROUP.ITEM_GROUP | Restrict delete |
| SYS_C00913430 | ITEM.ITEM_GROUP | ITEM_GROUP.ITEM_GROUP | Restrict delete |
| SYS_C00913431 | ITEM.MFR_ID | MFGR.MFR_ID | Restrict delete |
| SYS_C00913452 | COMPANY.ITEM_GROUP | ITEM_GROUP.ITEM_GROUP | Restrict delete |
| SYS_C00913458 | REQUESTOR.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00913475 | LOCATION.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00913476 | LOCATION.ADDRESS_ID | ADDRESS.ADDRESS_ID | Restrict delete |
| SYS_C00913483 | LOCATION_BIN.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913487 | LOCATION_GROUP.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913499 | LOCATION_ITEM.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00913500 | LOCATION_ITEM.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913501 | LOCATION_ITEM.ITEM_REPL_NO | ITEM.ITEM_ID | Restrict delete |
| SYS_C00913502 | LOCATION_ITEM.REPL_FROM_LOC_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913510 | LOCATION_ITEM_BIN.LOCATION_ITEM_ID | LOCATION_ITEM.LOCATION_ITEM_ID | Restrict delete |
| SYS_C00913518 | LOCATION_TYPE.APP_ID | APP_CONFIG.APP_ID | Restrict delete |
| SYS_C00913524 | LOCATION_TYPE_MAP.LOCATION_TYPE_ID | LOCATION_TYPE.LOCATION_TYPE_ID | Restrict delete |
| SYS_C00913525 | LOCATION_TYPE_MAP.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913529 | DEFAULT_USER_LOCATION_TYPE.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913530 | DEFAULT_USER_LOCATION_TYPE.LOCATION_TYPE_ID | LOCATION_TYPE.LOCATION_TYPE_ID | Restrict delete |
| SYS_C00913531 | DEFAULT_USER_LOCATION_TYPE.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913535 | USER_LOCATION_MAP.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913536 | USER_LOCATION_MAP.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913537 | USER_LOCATION_MAP.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00913555 | SYNC.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913562 | TASK.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00913563 | TASK.REQUESTING_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913576 | EVENT_HEADER.HEADER_UPLOAD_IND | EVENT_STATUS_RANK.STATUS_CODE | Restrict delete |
| SYS_C00913583 | EVENT_DETAIL.EVENT_HEADER_ID | EVENT_HEADER.EVENT_HEADER_ID | Restrict delete |
| SYS_C00913584 | EVENT_DETAIL.DETAIL_UPLOAD_IND | EVENT_STATUS_RANK.STATUS_CODE | Restrict delete |
| SYS_C00913595 | NOTE_TYPE.APP_ID | APP_CONFIG.APP_ID | Restrict delete |
| SYS_C00913600 | NOTE.NOTE_TYPE | NOTE_TYPE.NOTE_TYPE | Restrict delete |
| SYS_C00913601 | NOTE.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913611 | PRINTER.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00913612 | PRINTER.PROTOCOL_NAME | PRINTER_PROTOCOL.PROTOCOL_NAME | Restrict delete |
| SYS_C00913616 | WORKSTATION_PRINTER_MAP.PRINTER_ID | PRINTER.PRINTER_ID | Restrict delete |
| SYS_C00913620 | PRINTER_LOCATION_MAP.PRINTER_ID | PRINTER.PRINTER_ID | Restrict delete |
| SYS_C00913621 | PRINTER_LOCATION_MAP.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913716 | COUNTFORM_ITEMS.COUNTFORM_ID | COUNTFORM.COUNTFORM_ID | Restrict delete |
| SYS_C00913717 | COUNTFORM_ITEMS.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00913718 | COUNTFORM_ITEMS.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913754 | VENDOR_CARRIER_MAP.CARRIER_TRACKING_FORMAT_ID | CARRIER_TRACKING_FORMAT.CARRIER_TRACKING_FORMAT_ID | Restrict delete |
| SYS_C00913762 | DOCKLOG.RECV_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913763 | DOCKLOG.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913766 | DOCKLOG_LINE.DOCKLOG_ID | DOCKLOG.DOCKLOG_ID | Restrict delete |
| SYS_C00913776 | RECEIPT_HEADER.RECV_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913779 | RECEIPT_HEADER.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913780 | RECEIPT_HEADER.NOTE_ID | NOTE.NOTE_ID | Restrict delete |
| SYS_C00913786 | RECEIPT_LINE.RECEIPT_ID | RECEIPT_HEADER.RECEIPT_ID | Restrict delete |
| SYS_C00913838 | ROUTE.COMPANY | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00913839 | ROUTE.TRANSFER_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913844 | ROUTE_STOP.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913845 | ROUTE_STOP.ROUTE_ID | ROUTE.ROUTE_ID | Restrict delete |
| SYS_C00913849 | ROUTE_SOURCE_LOC.ROUTE_ID | ROUTE.ROUTE_ID | Restrict delete |
| SYS_C00913850 | ROUTE_SOURCE_LOC.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913861 | MANIFEST.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913916 | TRAY_LIST.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913917 | TRAY_LIST.STORAGE_LOCATION_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913918 | TRAY_LIST.SOURCE_LOCATION_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913925 | TL_GROUP.TL_ID | TRAY_LIST.TL_ID | Restrict delete |
| SYS_C00913926 | TL_GROUP.TS_GRP_NO | TRAY_GROUP.TS_GRP_NO | Restrict delete |
| SYS_C00913935 | TL_ITEM.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00913936 | TL_ITEM.TL_GRP_ID | TL_GROUP.TL_GRP_ID | Restrict delete |
| SYS_C00913952 | TRAYSET.ASSM_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913953 | TRAYSET.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913967 | ASSEMBLY.TS_NO | TRAYSET.TS_NO | Restrict delete |
| SYS_C00913968 | ASSEMBLY.ASM_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913969 | ASSEMBLY.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00913974 | STERILIZER_EQUIPMENT.LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00913975 | STERILIZER_EQUIPMENT.STER_NO | STERILIZATION_TYPE.STER_NO | Restrict delete |
| SYS_C00913982 | PROCESS.STER_NO | STERILIZATION_TYPE.STER_NO | Restrict delete |
| SYS_C00913995 | PROC_LOCATION.PROC_NO | PROCESS.PROCESS_NO | Restrict delete |
| SYS_C00913996 | PROC_LOCATION.LOC_NO | STERILIZER_EQUIPMENT.STERILIZER_EQ_NO | Restrict delete |
| SYS_C00914001 | PROC_STAGE.PROC_NO | PROCESS.PROCESS_NO | Restrict delete |
| SYS_C00914002 | PROC_STAGE.STAGE_NO | STAGE.STAGE_NO | Restrict delete |
| SYS_C00914008 | PROC_STAGE_SETTING.PROC_STAGE_DBID | PROC_STAGE.DB_ID | Restrict delete |
| SYS_C00914009 | PROC_STAGE_SETTING.SETTING_NO | SETTING.SETTING_NO | Restrict delete |
| SYS_C00914017 | LOAD_STER.PROC_NO | PROCESS.PROCESS_NO | Restrict delete |
| SYS_C00914018 | LOAD_STER.STERILIZER_EQ_NO | STERILIZER_EQUIPMENT.STERILIZER_EQ_NO | Restrict delete |
| SYS_C00914019 | LOAD_STER.CREATED_BY | USERS.USER_ID | Restrict delete |
| SYS_C00914026 | LOAD_CONTENT.LOAD_ID | LOAD_STER.LOAD_ID | Restrict delete |
| SYS_C00914027 | LOAD_CONTENT.ASID | TRAYSET.TS_NO | Restrict delete |
| SYS_C00914028 | LOAD_CONTENT.ADDED_BY | USERS.USER_ID | Restrict delete |
| SYS_C00914035 | LOAD_RESULT.LOAD_ID | LOAD_STER.LOAD_ID | Restrict delete |
| SYS_C00914036 | LOAD_RESULT.PARAM_ID | PROC_STAGE_SETTING.DB_ID | Restrict delete |
| SYS_C00914037 | LOAD_RESULT.RECORDED_BY | USERS.USER_ID | Restrict delete |
| SYS_C00914044 | CONTENT_RESULT.LOAD_ID | LOAD_STER.LOAD_ID | Restrict delete |
| SYS_C00914045 | CONTENT_RESULT.TEST_ID | PROC_STAGE_SETTING.DB_ID | Restrict delete |
| SYS_C00914046 | CONTENT_RESULT.ASID | TRAYSET.TS_NO | Restrict delete |
| SYS_C00914047 | CONTENT_RESULT.RECORDED_BY | USERS.USER_ID | Restrict delete |
| SYS_C00914050 | LOAD_CONTENT_LOG.LOAD_ID | LOAD_STER.LOAD_ID | Restrict delete |
| SYS_C00914051 | LOAD_CONTENT_LOG.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914054 | LOAD_RESULT_LOG.LOAD_ID | LOAD_STER.LOAD_ID | Restrict delete |
| SYS_C00914055 | LOAD_RESULT_LOG.PARAM_ID | PROC_STAGE_SETTING.DB_ID | Restrict delete |
| SYS_C00914056 | LOAD_RESULT_LOG.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914059 | CONTENT_RESULT_LOG.LOAD_ID | LOAD_STER.LOAD_ID | Restrict delete |
| SYS_C00914060 | CONTENT_RESULT_LOG.PARAM_ID | PROC_STAGE_SETTING.DB_ID | Restrict delete |
| SYS_C00914061 | CONTENT_RESULT_LOG.ASID | TRAYSET.TS_NO | Restrict delete |
| SYS_C00914062 | CONTENT_RESULT_LOG.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914068 | BATCH.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914076 | BATCH_ITEMS.BATCH_NO | BATCH.BATCH_NO | Restrict delete |
| SYS_C00914077 | BATCH_ITEMS.TS_NO | TRAYSET.TS_NO | Restrict delete |
| SYS_C00914078 | BATCH_ITEMS.ACTIVITY_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914083 | CASECART.LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914090 | CASECART_ASSEMBLY.CASECART_NO | CASECART.CASECART_NO | Restrict delete |
| SYS_C00914091 | CASECART_ASSEMBLY.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914092 | CASECART_ASSEMBLY.ASSM_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914100 | CASECART_ASSEMBLY_LOG.CARTSET_ASSM_NO | CASECART_ASSEMBLY.CARTSET_ASSM_NO | Restrict delete |
| SYS_C00914101 | CASECART_ASSEMBLY_LOG.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914102 | CASECART_ASSEMBLY_LOG.LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914110 | CASECART_ITEMS.CARTSET_ASSM_NO | CASECART_ASSEMBLY.CARTSET_ASSM_NO | Restrict delete |
| SYS_C00914111 | CASECART_ITEMS.TS_NO | TRAYSET.TS_NO | Restrict delete |
| SYS_C00914112 | CASECART_ITEMS.ACTIVITY_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914117 | PICKLIST.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914126 | PICK.PICK_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914127 | PICK.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914135 | TRANSFER.TS_NO | TRAYSET.TS_NO | Restrict delete |
| SYS_C00914136 | TRANSFER.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914137 | TRANSFER.CARTSET_ASSM_NO | CASECART_ASSEMBLY.CARTSET_ASSM_NO | Restrict delete |
| SYS_C00914138 | TRANSFER.FROM_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914139 | TRANSFER.TO_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914146 | TRANSFER_LOG.TRANSFER_NO | TRANSFER.TRANSFER_NO | Restrict delete |
| SYS_C00914147 | TRANSFER_LOG.FROM_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914148 | TRANSFER_LOG.TO_LOC_NO | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914182 | INSTRUMENT_TRACK.LOCATION_ITEM_ID | LOCATION_ITEM.LOCATION_ITEM_ID | Restrict delete |
| SYS_C00914183 | INSTRUMENT_TRACK.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914184 | INSTRUMENT_TRACK.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914190 | INSTRUMENT_TRACK_LOG.INSTRUMENT_TRACK_ID | INSTRUMENT_TRACK.INSTRUMENT_TRACK_ID | Restrict delete |
| SYS_C00914191 | INSTRUMENT_TRACK_LOG.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914192 | INSTRUMENT_TRACK_LOG.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914197 | TS_INST_TK_DATA.TL_ITEM_ID | TL_ITEM.TL_ITEM_ID | Restrict delete |
| SYS_C00914198 | TS_INST_TK_DATA.INSTRUMENT_TRACK_ID | INSTRUMENT_TRACK.INSTRUMENT_TRACK_ID | Restrict delete |
| SYS_C00914205 | TS_INST_TK_EXCEPTION.TS_INST_TK_DATA_ID | TS_INST_TK_DATA.TS_INST_TK_DATA_ID | Restrict delete |
| SYS_C00914212 | TRANSFER.INSTRUMENT_TRACK_ID | INSTRUMENT_TRACK.INSTRUMENT_TRACK_ID | Restrict delete |
| SYS_C00914239 | VENDOR.GROUP_ID | VENDOR_GROUP.GROUP_ID | Restrict delete |
| SYS_C00914243 | VENDOR_GROUP_COMPANY.GROUP_ID | VENDOR_GROUP.GROUP_ID | Restrict delete |
| SYS_C00914244 | VENDOR_GROUP_COMPANY.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00914246 | VENDOR_BUSINESS_RULES.VENDOR_SYSTEM_ID | VENDOR.VENDOR_SYSTEM_ID | Restrict delete |
| SYS_C00914247 | VENDOR_BUSINESS_RULES.CARRIER_TRACKING_FORMAT_ID | CARRIER_TRACKING_FORMAT.CARRIER_TRACKING_FORMAT_ID | Restrict delete |
| SYS_C00914248 | DOCKLOG.CARRIER_VENDOR_SYSTEM_ID | VENDOR.VENDOR_SYSTEM_ID | Restrict delete |
| SYS_C00914249 | RECEIPT_HEADER.CARRIER_VENDOR_SYSTEM_ID | VENDOR.VENDOR_SYSTEM_ID | Restrict delete |
| SYS_C00914250 | RECEIPT_HEADER.VENDOR_SYSTEM_ID | VENDOR.VENDOR_SYSTEM_ID | Restrict delete |
| SYS_C00914252 | VENDOR_CARRIER_MAP.VENDOR_SYSTEM_ID | VENDOR.VENDOR_SYSTEM_ID | Restrict delete |
| SYS_C00914285 | PO_HEADER.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00914286 | PO_HEADER.LOC_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914323 | PO_LINE.PO_ID | PO_HEADER.PO_ID | Restrict delete |
| SYS_C00914324 | PO_LINE.SHIP_TO_LOC | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914329 | PO_LINE_DEL.LINE_ID | PO_LINE.LINE_ID | Restrict delete |
| SYS_C00914330 | PO_LINE_DEL.DEL_LOC_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914344 | PO_RECEIPT.PO_ID | PO_HEADER.PO_ID | Restrict delete |
| SYS_C00914345 | PO_RECEIPT.RELEASED_BY | USERS.USER_ID | Restrict delete |
| SYS_C00914346 | PO_RECEIPT.RCV_LOC | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914358 | PO_LINE_RECEIPT_RECORD.LINE_ID | PO_LINE.LINE_ID | Restrict delete |
| SYS_C00914359 | PO_LINE_RECEIPT_RECORD.REC_ID | PO_RECEIPT.REC_ID | Restrict delete |
| SYS_C00914360 | PO_LINE_RECEIPT_RECORD.RCV_LOC | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914366 | PO_LINE_RECEIPT.LINE_ID | PO_LINE.LINE_ID | Restrict delete |
| SYS_C00914367 | PO_LINE_RECEIPT.REC_ID | PO_RECEIPT.REC_ID | Restrict delete |
| SYS_C00914377 | DELIVERY_TICKET.RECV_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914378 | DELIVERY_TICKET.DELIVERY_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914379 | DELIVERY_TICKET.FROM_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914380 | DELIVERY_TICKET.REQUESTOR_ID | REQUESTOR.REQUESTOR_ID | Restrict delete |
| SYS_C00914381 | DELIVERY_TICKET.VENDOR_SYSTEM_ID | VENDOR.VENDOR_SYSTEM_ID | Restrict delete |
| SYS_C00914387 | DELIVERY_UNIT.DELIVERY_TICKET_ID | DELIVERY_TICKET.DELIVERY_TICKET_ID | Restrict delete |
| SYS_C00914388 | DELIVERY_UNIT.NOTE_ID | NOTE.NOTE_ID | Restrict delete |
| SYS_C00914460 | LOCATION_ITEM_LOT.LOCATION_ITEM_ID | LOCATION_ITEM.LOCATION_ITEM_ID | Restrict delete |
| SYS_C00914469 | LOCATION_ITEM_SERIAL.LOCATION_ITEM_ID | LOCATION_ITEM.LOCATION_ITEM_ID | Restrict delete |
| SYS_C00914490 | PICKLIST_HEADER.FROM_LOC_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914491 | PICKLIST_HEADER.REQ_LOC_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914511 | PICKLIST_LOG.PICKLIST_ID | PICKLIST_HEADER.PICKLIST_ID | Restrict delete |
| SYS_C00914512 | PICKLIST_LOG.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914524 | DISTRIB_LINE.NOTE_ID | NOTE.NOTE_ID | Restrict delete |
| SYS_C00914525 | DISTRIB_LINE.DELIVERY_TICKET_ID DISTRIB_LINE.DELIVERY_UNIT_NO |
DELIVERY_UNIT.DELIVERY_TICKET_ID DELIVERY_UNIT.DELIVERY_UNIT_NO |
Restrict delete |
| SYS_C00914532 | ACCOUNT_DIST.DELIVERY_TICKET_ID ACCOUNT_DIST.DELIVERY_UNIT_NO ACCOUNT_DIST.DISTRIB_LINE_NO |
DISTRIB_LINE.DELIVERY_TICKET_ID DISTRIB_LINE.DELIVERY_UNIT_NO DISTRIB_LINE.DISTRIB_LINE_NO |
Restrict delete |
| SYS_C00914540 | DELIVERY_EVENT.RECIPIENT_ID | RECIPIENT.RECIPIENT_ID | Restrict delete |
| SYS_C00914541 | DELIVERY_EVENT.SIGNATURE_ID | SIGNATURE.SIGNATURE_ID | Restrict delete |
| SYS_C00914542 | DELIVERY_EVENT.MANIFEST_ID | MANIFEST.MANIFEST_ID | Restrict delete |
| SYS_C00914548 | DELIVERY_EVENT_LINE.DELIVERY_EVENT_ID | DELIVERY_EVENT.DELIVERY_EVENT_ID | Restrict delete |
| SYS_C00914549 | DELIVERY_EVENT_LINE.DELIVERY_TICKET_ID DELIVERY_EVENT_LINE.DELIVERY_UNIT_NO DELIVERY_EVENT_LINE.DISTRIB_LINE_NO |
DISTRIB_LINE.DELIVERY_TICKET_ID DISTRIB_LINE.DELIVERY_UNIT_NO DISTRIB_LINE.DISTRIB_LINE_NO |
Restrict delete |
| SYS_C00914555 | MANIFEST_LINE.MANIFEST_ID | MANIFEST.MANIFEST_ID | Restrict delete |
| SYS_C00914556 | MANIFEST_LINE.DELIVERY_TICKET_ID MANIFEST_LINE.DELIVERY_UNIT_NO MANIFEST_LINE.DISTRIB_LINE_NO |
DISTRIB_LINE.DELIVERY_TICKET_ID DISTRIB_LINE.DELIVERY_UNIT_NO DISTRIB_LINE.DISTRIB_LINE_NO |
Restrict delete |
| SYS_C00914561 | RECEIPT_LINE_DISTRIB.RECEIPT_ID RECEIPT_LINE_DISTRIB.RECEIPT_LINE_NO |
RECEIPT_LINE.RECEIPT_ID RECEIPT_LINE.RECEIPT_LINE_NO |
Restrict delete |
| SYS_C00914562 | RECEIPT_LINE_DISTRIB.DELIVERY_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914563 | RECEIPT_LINE_DISTRIB.DELIVERY_TICKET_ID RECEIPT_LINE_DISTRIB.DELIVERY_UNIT_NO RECEIPT_LINE_DISTRIB.DISTRIB_LINE_NO |
DISTRIB_LINE.DELIVERY_TICKET_ID DISTRIB_LINE.DELIVERY_UNIT_NO DISTRIB_LINE.DISTRIB_LINE_NO |
Restrict delete |
| SYS_C00914564 | RECEIPT_LINE_DISTRIB.DELIVERY_COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00914627 | VENDOR_CLASS.GROUP_ID | VENDOR_GROUP.GROUP_ID | Restrict delete |
| SYS_C00914656 | LOC_GROUP_TYPE.ACTIVITY_TYPE | ACTIVITY_TYPE.ACTIVITY_TYPE | Restrict delete |
| SYS_C00914663 | LOCATION_GROUP_HDR.LOC_GROUP_TYPE_ID | LOC_GROUP_TYPE.LOC_GROUP_TYPE_ID | Restrict delete |
| SYS_C00914669 | LOCATION_GROUP_DTLS.LOC_GROUP_ID | LOCATION_GROUP_HDR.LOC_GROUP_ID | Restrict delete |
| SYS_C00914670 | LOCATION_GROUP_DTLS.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914678 | REVENUE_CENTER.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00914686 | REVENUE_CENTER_ITEM.REVENUE_CENTER_ID | REVENUE_CENTER.REVENUE_CENTER_ID | Restrict delete |
| SYS_C00914687 | REVENUE_CENTER_ITEM.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00914691 | DEFAULT_REVENUE_CENTER.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914692 | DEFAULT_REVENUE_CENTER.REVENUE_CENTER_ID | REVENUE_CENTER.REVENUE_CENTER_ID | Restrict delete |
| SYS_C00914707 | PATIENT_LOCATION.FACILITY_ID | FACILITY.FACILITY_ID | Restrict delete |
| SYS_C00914710 | USER_FACILITY_MAP.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914711 | USER_FACILITY_MAP.FACILITY_ID | FACILITY.FACILITY_ID | Restrict delete |
| SYS_C00914720 | WORKSTATION.COMPANY_NO | COMPANY.COMPANY_NO | Restrict delete |
| SYS_C00914721 | WORKSTATION.DEFAULT_REV_CTR_ID | REVENUE_CENTER.REVENUE_CENTER_ID | Restrict delete |
| SYS_C00914727 | WORKSTATION_SUPPLY_LOCATION.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914728 | WORKSTATION_SUPPLY_LOCATION.WORKSTATION_ID | WORKSTATION.WORKSTATION_ID | Restrict delete |
| SYS_C00914734 | WORKSTATION_PATIENT_LOCATION.PATIENT_LOCATION_ID | PATIENT_LOCATION.PATIENT_LOCATION_ID | Restrict delete |
| SYS_C00914735 | WORKSTATION_PATIENT_LOCATION.WORKSTATION_ID | WORKSTATION.WORKSTATION_ID | Restrict delete |
| SYS_C00914741 | WORKSTATION_LOCATION_GROUP.LOC_GROUP_ID | LOCATION_GROUP_HDR.LOC_GROUP_ID | Restrict delete |
| SYS_C00914742 | WORKSTATION_LOCATION_GROUP.WORKSTATION_ID | WORKSTATION.WORKSTATION_ID | Restrict delete |
| SYS_C00914775 | CHARGE_HEADER.REVENUE_CENTER_ID | REVENUE_CENTER.REVENUE_CENTER_ID | Restrict delete |
| SYS_C00914777 | CHARGE_HEADER.PATIENT_LOCATION_ID | PATIENT_LOCATION.PATIENT_LOCATION_ID | Restrict delete |
| SYS_C00914786 | CHARGE_DETAIL.CHARGE_ID | CHARGE_HEADER.CHARGE_ID | Restrict delete |
| SYS_C00914787 | CHARGE_DETAIL.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00914788 | CHARGE_DETAIL.SUPPLY_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914795 | CHARGE_ISSUE.CHARGE_DTL_ID | CHARGE_DETAIL.CHARGE_DTL_ID | Restrict delete |
| SYS_C00914804 | REQUEST_QUEUE.CHARGE_DTL_ID | CHARGE_DETAIL.CHARGE_DTL_ID | Restrict delete |
| SYS_C00914805 | REQUEST_QUEUE.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00914810 | CHARGE_SUPPLY_LOCATION.CHARGE_ID | CHARGE_HEADER.CHARGE_ID | Restrict delete |
| SYS_C00914811 | CHARGE_SUPPLY_LOCATION.SUPPLY_LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914815 | POU_UOM.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00914822 | TRANS_ITEM_UOM.ITEM_ID | ITEM.ITEM_ID | Restrict delete |
| SYS_C00914837 | PRINTER_USER_MAP.PRINTER_ID | PRINTER.PRINTER_ID | Restrict delete |
| SYS_C00914838 | PRINTER_USER_MAP.USER_ID | USERS.USER_ID | Restrict delete |
| SYS_C00914839 | PRINTER_USER_MAP.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914850 | PATIENT_VISIT.PATIENT_ID | PATIENT.PATIENT_ID | Restrict delete |
| SYS_C00914851 | PATIENT_VISIT.PATIENT_LOCATION_ID | PATIENT_LOCATION.PATIENT_LOCATION_ID | Restrict delete |
| SYS_C00914852 | CHARGE_HEADER.PATIENT_VISIT_ID | PATIENT_VISIT.PATIENT_VISIT_ID | Restrict delete |
| SYS_C00914866 | LOCATION_SCHEDULE.SUPPLY_LOC_ID | LOCATION.LOCATION_ID | Restrict delete |
| SYS_C00914876 | LOCATION_SCHEDULED_DAYS.SCHEDULE_ID | LOCATION_SCHEDULE.SCHEDULE_ID | Restrict delete |
| SYS_C00914886 | PICKLIST_LINE.PICKLIST_ID | PICKLIST_HEADER.PICKLIST_ID | Restrict delete |
| SYS_C00914887 | PICKLIST_LINE.LOC_ITEM_ID | LOCATION_ITEM.LOCATION_ITEM_ID | Restrict delete |
| SYS_C00914891 | PICKLIST_LINE_DETAIL.PICKLIST_LINE_ID | PICKLIST_LINE.PICKLIST_LINE_ID | Restrict delete |
| SYS_C00914892 | PICKLIST_LINE_DETAIL.PICKED_BY | USERS.USER_ID | Restrict delete |
| USRPF_PFID_FK | USERPARFORM.LOCATION_ID | LOCATION.LOCATION_ID | Restrict delete |
| USRPF_USRNO_FK | USERPARFORM.USER_ID | USERS.USER_ID | Restrict delete |
Check Constraints:
| Table | Constraint Name | Constraint |
|---|---|---|
| PO_LINE | POL_CAN_BO_CK | CAN_BACK_ORD IN ('Y','N','B') |
| PO_LINE_RECEIPT_RECORD | POLRR_CAN_BO_CK | CAN_BACK_ORD IN ('Y','N','B') |