SchemaSpy - Table lawprod.MSCM.DOCKLOG

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

DOCKLOG_ID

number

20

DOCKLOG_LINE.DOCKLOG_ID

SYS_C00913766 R

RECV_LOCATION_ID

number

22

LOCATION.LOCATION_ID

SYS_C00913762 R

USER_ID

number

22

USERS.USER_ID

SYS_C00913763 R

CREATE_DT

date

7

√

null

COUNT

number

6

√

null

CARRIER_VENDOR_SYSTEM_ID

number

22

√

null

VENDOR.VENDOR_SYSTEM_ID

SYS_C00914248 R

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
DOCKLOG_ID	Primary key	Asc	SYS_C00913760
RECV_LOCATION_ID + CREATE_DT	Performance	Asc/Asc	DL_LOCIDCRDT_IDX