SchemaSpy Analysis of lawprod.MSCM Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 18 12:10 CDT 2011
Database Type: Oracle - Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
ACCOUNT_DIST 3 5
ACTIVITY_LOG 1 11
ACTIVITY_TYPE 2 5
ADDRESS 1 10
APP_CONFIG 2 4
ASSEMBLY 3 7
ASSEMBLY_DECONTAM_VW 12
ATTRIBUTE 2 8
ATTRIBUTE_TYPE 2 11
ATTRIBUTE_VALUE_LIST 1 4
BATCH 1 1 6
BATCH_ITEMS 3 6
CARRIER_TRACKING_FORMAT 2 10
CASE_CART_HISTORY_VW 12
CASECART 1 1 4
CASECART_ASSEMBLY 3 3 7
CASECART_ASSEMBLY_LOG 3 8
CASECART_ITEMS 3 8
CHARGE_DETAIL 2 3 19
CHARGE_HEADER 2 3 13
CHARGE_ISSUE 1 7
CHARGE_SUPPLY_LOCATION 2 3
CODE 3
COLOR 2
COMPANY 11 1 13
CONFIGURATION 4
CONTENT_RESULT 4 8
CONTENT_RESULT_LOG 4 9
COUNTFORM 1 1 7
COUNTFORM_ITEMS 3 15
DECONTAM_DETAILS 6
DECONTAM_DETAILS_HELP 3
DECONTAMINATION_METHOD 1 2
DECONTAMINATION_UNIT 2 4
DEFAULT_REVENUE_CENTER 2 2
DEFAULT_SCHEDULE_TRACKER 2
DEFAULT_USER_LOCATION_TYPE 3 3
DELIVERY_EVENT 1 3 9
DELIVERY_EVENT_LINE 4 4
DELIVERY_TICKET 1 5 21
DELIVERY_UNIT 2 2 6
DISTRIB_LINE 15 3 23
DOCKLOG 1 3 6
DOCKLOG_LINE 1 3
ERROR_LOG 8
EVENT_DETAIL 2 29
EVENT_HEADER 1 1 22
EVENT_STATUS_RANK 2 3
FACILITY 2 7
ICAUDIT_TRACKER 1
INSTRUMENT_BY_LOCATION_VIEW 17
INSTRUMENT_HISTORY_VIEW 13
INSTRUMENT_ID_ASSEMBLY_VIEW 4
INSTRUMENT_TRACK 3 3 12
INSTRUMENT_TRACK_LOG 3 9
ITEM 10 2 21
ITEM_GROUP 3 2
ITEM_INFO_VIEW 3
ITEM_ON_TRAY_LIST_HELP 5
ITEMS_IN_TRAY_LISTS 17
LAWSON_BINGRPDTL 7
LAWSON_COMPANY 8
LAWSON_ICAUDIT 12
LAWSON_ICFREEZE 12
LAWSON_ICSELECT 4
LAWSON_ITEM 20
LAWSON_ITEM_GROUP 4
LAWSON_ITEMLOC 18
LAWSON_ITEMSRC 10
LAWSON_LOCATION 6
LAWSON_LOCATION_BIN 5
LAWSON_LOCATION_GROUP 5
LAWSON_LOCATION_ITEM_BIN 7
LAWSON_LOCATION_ITEM_COST 8
LAWSON_LOCATION_ITEM_LOT 10
LAWSON_LOCATION_ITEM_SERIAL 7
LAWSON_MFGR 6
LAWSON_PICKLIST 14
LAWSON_PICKLIST_LINE 14
LAWSON_PICKLIST_LINE_DETAIL 12
LAWSON_PO_CONFIG 6
LAWSON_PO_VENDOR 4
LAWSON_POLINE 11
LAWSON_POLINE_SRC 15
LAWSON_POLINESRC 13
LAWSON_REQUESTER 5
LAWSON_RQLOC 14
LAWSON_USER 12
LAWSON_VENDOR 6
LAWSON_VENDOR_CLASS 6
LAWSON_VENDOR_GROUP 4
LAWSON_VENDOR_GROUP_AP_COMPANY 4
LAWSON_VENDOR_GROUP_COMPANY 4
LOAD_CONTENT 3 8
LOAD_CONTENT_LOG 2 7
LOAD_RESULT 3 7
LOAD_RESULT_LOG 3 8
LOAD_STER 6 3 9
LOAD_TRACKING_INFO 14
LOAD_TRACKING_INFO_TRAY 28
LOC_GROUP_TYPE 1 1 7
LOCAL_ITEM_VW 15
LOCATION 52 2 12
LOCATION_APP_MAP_VW 2
LOCATION_BIN 2 1 4
LOCATION_GROUP 1 2
LOCATION_GROUP_DTLS 2 5
LOCATION_GROUP_HDR 2 1 7
LOCATION_ITEM 5 4 30
LOCATION_ITEM_BIN 3 6
LOCATION_ITEM_LOT 1 6
LOCATION_ITEM_SERIAL 1 4
LOCATION_SCHEDULE 1 1 6
LOCATION_SCHEDULED_DAYS 1 6
LOCATION_TYPE 2 1 4
LOCATION_TYPE_MAP 2 5
MANIFEST 2 1 5
MANIFEST_LINE 4 4
MFGR 1 1 12
MSCM9_LMGR 4
MSCM9_LMPR 3
MSCM9_TASK 23
MSCM9_TREG 2
NOTE 3 2 5
NOTE_TYPE 1 1 5
OBJECT_TYPE 1 2
OPERATOR_ACTIVITY_CYCLE_C 7
OPERATOR_ACTIVITY_PAR 10
OPERATOR_ACTIVITY_PFP 11
OPERATOR_ACTIVITY_POU 11
PATIENT 1 9
PATIENT_LOCATION 3 1 7
PATIENT_VISIT 1 2 11
PICK 2 9
PICK_ACTIVITY 12
PICKING_DETAILS 19
PICKLIST 1 4
PICKLIST_CARTSET_MAP_VW 2
PICKLIST_HEADER 2 2 20
PICKLIST_LINE 1 2 13
PICKLIST_LINE_DETAIL 2 18
PICKLIST_LOG 2 4
PO_HEADER 2 2 18
PO_LINE 3 2 29
PO_LINE_DEL 2 9
PO_LINE_RECEIPT 2 4
PO_LINE_RECEIPT_RECORD 3 16
PO_RECEIPT 2 3 18
PO_TRANSDTL 3 10
POU_UOM 1 4
PRINTER 3 2 17
PRINTER_LOCATION_MAP 2 2
PRINTER_PROTOCOL 1 2
PRINTER_USER_MAP 3 4
PROC_LOCATION 2 4
PROC_STAGE 1 2 5
PROC_STAGE_SETTING 4 2 9
PROCESS 3 1 6
RECEIPT_HEADER 1 5 15
RECEIPT_LINE 2 1 6
RECEIPT_LINE_DISTRIB 7 9
RECEIPT_LOG_VW 20
RECIPIENT 1 4
REPORT_SETTINGS 1 4
REPORT_SETTINGS_PARAMETER 1 5
REQUEST_QUEUE 2 8
REQUESTOR 1 1 4
REVENUE_CENTER 4 1 7
REVENUE_CENTER_ITEM 2 8
ROUTE 2 2 6
ROUTE_SOURCE_LOC 2 2
ROUTE_STOP 2 3
SEQUENCES 4
SERVICE 2
SETTING 1 6
SIGNATURE 1 3
STAGE 1 2
STER_LOAD_HISTORY_VW 5
STERILIZATION_TYPE 2 3
STERILIZER_EQUIPMENT 2 2 4
SYNC 1 7
TASK 2 24
TEST_PARAMETER_NAME 3
TL_GROUP 1 2 8
TL_ITEM 1 2 8
TRACKING_LABEL_SEQ 2
TRANS_ITEM_UOM 1 5
TRANSFER 1 6 18
TRANSFER_DETAILS_VW 12
TRANSFER_LOG 3 11
TRAY 5
TRAY_ACTIVITY_VW 8
TRAY_GROUP 1 2
TRAY_IN_LOCATION_VW 7
TRAY_INV_REP_VW 18
TRAY_INV_SERVICE_REP_VW 16
TRAY_LIST 1 3 24
TRAY_LIST_ASSEMBLY_TIME_VW 2
TRAY_LIST_CURRENT_VIEW 22
TRAY_LIST_CURRENT_VW 9
TRAY_LIST_ORMS_VW 7
TRAY_LIST_SUMMARY_VIEW 15
TRAY_ON_HOLD_VW 13
TRAY_ROTATION_TIME_VW 6
TRAY_USAGE 4
TRAYSET 7 2 18
TRAYSET_CURRENT_VW 17
TRAYSET_TRAY 19
TS_INST_TK_DATA 1 2 5
TS_INST_TK_EXCEPTION 1 7
TS_ITEM_EXCEPTION 10
TXN_TYPE 2
UI_PAGE_MAPPING 2 3
UI_PAGES 2 1 7
UOM 2
USER_FACILITY_MAP 2 2
USER_GROUP 2 2
USER_LOCATION_MAP 3 4
USER_ROLE 2 2
USERGROUP_USERROLE 2 2
USERPARFORM 2 2
USERS 32 17
USERS_USERGROUP 2 2
VENDOR 6 1 11
VENDOR_BUSINESS_RULES 2 2
VENDOR_CARRIER_MAP 2 4
VENDOR_CLASS 1 5
VENDOR_GROUP 3 4
VENDOR_GROUP_COMPANY 2 2
WORKSTATION 3 2 10
WORKSTATION_LOCATION_GROUP 2 5
WORKSTATION_PATIENT_LOCATION 2 5
WORKSTATION_PRINTER_MAP 1 2
WORKSTATION_SUPPLY_LOCATION 2 5
         
196 Tables     1,533  
38 Views     423