Table: Custom_Fieldview
Columns
NameTypeConstraintsDescription
custom_fieldview_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
custom_fieldview_type_KEYintNOT NULLKey of an existing of the the Custom Fieldview Type.
descriptionnvarchar (250)NOT NULLUser defined description (unique per custom_fieldview_type_KEY).
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Custom_Fieldview$custom_fieldview_KEYcustom_fieldview_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Custom_Fieldview$custom_fieldview_type_KEY$descriptioncustom_fieldview_type_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Fieldview__Custom_Fieldview_Type__custom_fieldview_type_KEYcustom_fieldview_type_KEYCustom_Fieldview_Type

Schema diagram