SchemaSpy - Table lawprod.MSCM.USER_LOCATION_MAP

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

USERS.USER_ID

SYS_C00913535 R

LOCATION_ID

number

22

√

null

LOCATION.LOCATION_ID

SYS_C00913536 R

COMPANY_NO

number

4

COMPANY.COMPANY_NO

SYS_C00913537 R

COMPANY_ROLE_IND

varchar2

1

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
USER_ID + LOCATION_ID + COMPANY_NO	Must be unique	Asc/Asc/Asc	USR_LOC_MAP_UK
COMPANY_NO	Performance	Asc	USRLOCMAP_COMPNO_IDX