SchemaSpy - Table lawprod.MSCM.PICKLIST_LOG

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

PICKLIST_ID

number

20

PICKLIST_HEADER.PICKLIST_ID

SYS_C00914511 R

USER_ID

number

22

USERS.USER_ID

SYS_C00914512 R

ACTIVITY

char

1

ACTIVITY_DATE

date

7

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
PICKLIST_ID + USER_ID	Primary key	Asc/Asc	SYS_C00914510
PICKLIST_ID + USER_ID + ACTIVITY	Must be unique	Asc/Asc/Asc	PL_LOG_IDX