Table lawprod.MSCM.USERS 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
USER_ID number 22
ACTIVITY_LOG.USER_ID Implied Constraint R
ASSEMBLY.USER_ID SYS_C00913969 R
ASSEMBLY_DECONTAM_VW.USER_ID Implied Constraint R
BATCH.USER_ID SYS_C00914068 R
CASECART_ASSEMBLY.USER_ID SYS_C00914091 R
CASECART_ASSEMBLY_LOG.USER_ID SYS_C00914101 R
CHARGE_HEADER.USER_ID Implied Constraint R
CONTENT_RESULT.RECORDED_BY SYS_C00914047 R
CONTENT_RESULT_LOG.USER_ID SYS_C00914062 R
DECONTAM_DETAILS_HELP.USER_ID Implied Constraint R
DEFAULT_REVENUE_CENTER.USER_ID SYS_C00914691 R
DEFAULT_USER_LOCATION_TYPE.USER_ID SYS_C00913529 R
DOCKLOG.USER_ID SYS_C00913763 R
EVENT_HEADER.USER_ID Implied Constraint R
INSTRUMENT_TRACK.USER_ID SYS_C00914184 R
INSTRUMENT_TRACK_LOG.USER_ID SYS_C00914192 R
LOAD_CONTENT.ADDED_BY SYS_C00914028 R
LOAD_CONTENT_LOG.USER_ID SYS_C00914051 R
LOAD_RESULT.RECORDED_BY SYS_C00914037 R
LOAD_RESULT_LOG.USER_ID SYS_C00914056 R
LOAD_STER.CREATED_BY SYS_C00914019 R
LOAD_TRACKING_INFO.USER_ID Implied Constraint R
LOAD_TRACKING_INFO_TRAY.USER_ID Implied Constraint R
MANIFEST.USER_ID SYS_C00913861 R
OPERATOR_ACTIVITY_CYCLE_C.USER_ID Implied Constraint R
OPERATOR_ACTIVITY_PAR.USER_ID Implied Constraint R
OPERATOR_ACTIVITY_PFP.USER_ID Implied Constraint R
OPERATOR_ACTIVITY_POU.USER_ID Implied Constraint R
PICK.USER_ID SYS_C00914127 R
PICK_ACTIVITY.USER_ID Implied Constraint R
PICKING_DETAILS.USER_ID Implied Constraint R
PICKLIST.USER_ID SYS_C00914117 R
PICKLIST_LINE_DETAIL.PICKED_BY SYS_C00914892 R
PICKLIST_LOG.USER_ID SYS_C00914512 R
PO_RECEIPT.RELEASED_BY SYS_C00914345 R
PRINTER_USER_MAP.USER_ID SYS_C00914838 R
RECEIPT_HEADER.USER_ID SYS_C00913779 R
RECEIPT_LOG_VW.USER_ID Implied Constraint R
REPORT_SETTINGS.USER_ID Implied Constraint R
SYNC.USER_ID SYS_C00913555 R
TRANSFER.USER_ID SYS_C00914136 R
TRANSFER_DETAILS_VW.USER_ID Implied Constraint R
TRAY_ACTIVITY_VW.USER_ID Implied Constraint R
TRAY_LIST.USER_ID SYS_C00913916 R
TRAY_LIST_CURRENT_VIEW.USER_ID Implied Constraint R
TRAYSET.USER_ID SYS_C00913953 R
TRAYSET_CURRENT_VW.USER_ID Implied Constraint R
TRAYSET_TRAY.USER_ID Implied Constraint R
USER_FACILITY_MAP.USER_ID SYS_C00914710 R
USER_LOCATION_MAP.USER_ID SYS_C00913535 R
USERPARFORM.USER_ID USRPF_USRNO_FK R
USERS_USERGROUP.USER_ID SYS_C00913387 R
NAME varchar2 80
FIRST_NAME varchar2 55  √  null
LAST_NAME varchar2 55  √  null
PASSWORD varchar2 1024  √  null
EMAIL varchar2 100  √  null
STATUS char 1  √  null
REQUESTER varchar2 10  √  null
EMPLOYEE_ID number 9  √  null
EXT_DATA_IND char 1
ADDED_TO_MSC char 1
GLOBAL_ROLE_IND char 1  √  null
CREATION_DT date 7
LAST_MODIFIED_DT date 7
ID_CONFLICT_DT date 7  √  null
SSOP varchar2 20  √  null
EMP_ID_VARCHAR varchar2 191  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
USER_ID Primary key Asc SYS_C00913385
NAME Must be unique Asc USER_NAME_UK

Close relationships  within of separation: