SchemaSpy - Table lawprod.MSCM.WORKSTATION_LOCATION_GROUP

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

WS_LOC_GROUP_ID

number

22

LOC_GROUP_ID

number

22

LOCATION_GROUP_HDR.LOC_GROUP_ID

SYS_C00914741 R

WORKSTATION_ID

number

22

WORKSTATION.WORKSTATION_ID

SYS_C00914742 R

CREATE_DATE

date

7

LAST_UPDATE_DATE

date

7

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
WS_LOC_GROUP_ID	Primary key	Asc	SYS_C00914740
LOC_GROUP_ID + WORKSTATION_ID	Must be unique	Asc/Asc	IDX_WS_LOC_GROUP