Table: Custom_Field
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
custom_field_KEYintNOT NULL
descriptionnvarchar (250)NOT NULLThe decription of this custom field as it would appear in the user interface. The same description can only be used once per table_information_KEY.
custom_field_type_KEYintNOT NULLForeign key to specify what data type this column is.
lengthintNOT NULLLength of character columns, precision of number columns, storage length of other types.
sortintNOT NULLSort order of this custom field when it is displayed. The fields should be sorted by position and description.
categorynvarchar (30)NOT NULL
table_information_KEYintNOT NULLMain table that this custom field is associated with. See Custom_Value.table_information_KEY
custom_field_slotintNOT NULLWhich slot this field is in, used for sorting items by custom field columns.
scaleintNOT NULL
Primary key
NameColumnsDescription
PK_Custom_Field$custom_field_KEYcustom_field_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Custom_Field$custom_field_slot$table_information_KEYcustom_field_slot, table_information_KEYThe same [custom_field_slot] can only be used once per [table_information_KEY].
UK_Custom_Field$table_information_KEY$category$descriptiontable_information_KEY, category, descriptionThe same [description] can only be used once per [category] and [table_information_KEY]. Please choose a different value for [description].
Indexes
NameColumnsDescription
IX_Custom_Field$custom_field_type_KEYcustom_field_type_KEYIndex supports foreign key FK_Custom_Field__Custom_Field_Type__custom_field_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Field__Table_Information__table_information_KEYtable_information_KEYTable_Information
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Custom_Grouping__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Grouping
FK_Custom_Value__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Valueon delete cascade;
FK_User_Preference_Custom_Field_Column__Custom_Field__custom_field_KEYcustom_field_KEYUser_Preference_Custom_Field_Columnon delete cascade;

Schema diagram