SchemaSpy - Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.PICK

Pick Record Header

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

ID

integer

10

PICKITEM.PICKID

INTEG_980 R

DATECREATED

timestamp

19

√

null

NUM

varchar

35

TYPEID

integer

10

√

10

PICKTYPE.ID

INTEG_1056 R

STATUSID

integer

10

√

10

INTEG_1057 R

DATELASTMODIFIED

timestamp

19

√

null

DATESTARTED

timestamp

19

√

null

DATEFINISHED

timestamp

19

√

null

DATESCHEDULED

timestamp

19

√

null

USERID

integer

10

√

1

SYSUSER.ID

INTEG_1058 R

PRIORITY

integer

10

30

PRIORITY.ID

INTEG_1060 R

LOCATIONGROUPID

integer

10

LOCATIONGROUP.ID

INTEG_1062 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
NUM	Must be unique	Asc	INTEG_1055
DATECREATED	Performance	Asc	PICKDATECREATED
DATEFINISHED	Performance	Asc	PICKDATEFINISHED
DATESCHEDULED	Performance	Asc	PICKDATESCHEDULED
DATESTARTED	Performance	Asc	PICKDATESTARTED
LOCATIONGROUPID	Performance	Asc	PICKLOCATIONGROUPID
NUM	Performance	Asc	PICKNUMINDX
PRIORITY	Performance	Asc	PICKPRIORITY
STATUSID	Performance	Asc	PICKSTATUSINDX
TYPEID	Performance	Asc	PICKTYPEINDX
USERID	Performance	Asc	PICKUSERID
TYPEID	Performance	Asc	RDB$FOREIGN516
STATUSID	Performance	Asc	RDB$FOREIGN517
USERID	Performance	Asc	RDB$FOREIGN518
PRIORITY	Performance	Asc	RDB$FOREIGN519
LOCATIONGROUPID	Performance	Asc	RDB$FOREIGN520
ID	Must be unique	Asc	RDB$PRIMARY273