Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.PICK
Pick Record Header

 Generated by
SchemaSpy
Legend: SourceForge.net
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
PICKSTATUS.ID 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 Sat Mar 01 08:31 PST 2014

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.