Table lawprod.MSCM.WORKSTATION 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
WORKSTATION_ID number 22
WORKSTATION_LOCATION_GROUP.WORKSTATION_ID SYS_C00914742 R
WORKSTATION_PATIENT_LOCATION.WORKSTATION_ID SYS_C00914735 R
WORKSTATION_SUPPLY_LOCATION.WORKSTATION_ID SYS_C00914728 R
HOSTNAME varchar2 256  √  null
COMPANY_NO number 4
COMPANY.COMPANY_NO SYS_C00914720 R
DESCRIPTION varchar2 50  √  null
IS_ACTIVE char 1
IDLE_TIME number 22  √  null
DEFAULT_REV_CTR_ID number 22  √  null
REVENUE_CENTER.REVENUE_CENTER_ID SYS_C00914721 R
CREATE_DATE date 7
LAST_UPDATE_DATE date 7  √  null
IDLE_GLOBAL char 1  √  'F'

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name Anomalies
WORKSTATION_ID Primary key Asc SYS_C00914717  
HOSTNAME Must be unique Asc SYS_C00914718 This unique column is also nullable
DESCRIPTION Must be unique Asc SYS_C00914719 This unique column is also nullable

Close relationships  within of separation: