Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.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 Mon Jul 01 09:44 PDT 2013


Close relationships  within of separation: