Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.CUSTOMFIELD
Maintains a list of Custom Fields and their Relationship to Modules

 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
CUSTOMDECIMAL.CUSTOMFIELDID INTEG_1039 R
CUSTOMINTEGER.CUSTOMFIELDID INTEG_1033 R
CUSTOMSET.CUSTOMFIELDID INTEG_1044 R
CUSTOMTIMESTAMP.CUSTOMFIELDID INTEG_1027 R
CUSTOMVARCHAR.CUSTOMFIELDID INTEG_1021 R
CUSTOMVARCHARLONG.CUSTOMFIELDID INTEG_4 R
NAME varchar 41
DESCRIPTION varchar 256  √  null
SORTORDER integer 10 1
CUSTOMFIELDTYPEID integer 10
CUSTOMFIELDTYPE.ID INTEG_1013 R
TABLEID integer 10
TABLEREFERENCE.TABLEID INTEG_1015 R
LISTID integer 10  √  null
CUSTOMLIST.ID INTEG_1016 R
REQUIRED smallint 5  √  0
ACTIVEFLAG smallint 5  √  1

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
LISTID Performance Asc CUSTOMFIELDLISTID
TABLEID Performance Asc CUSTOMFIELDTABLEID_IDX
NAME + TABLEID Must be unique Asc/Asc RDB$500
CUSTOMFIELDTYPEID Performance Asc RDB$FOREIGN497
TABLEID Performance Asc RDB$FOREIGN498
LISTID Performance Asc RDB$FOREIGN499
ID Must be unique Asc RDB$PRIMARY496


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.