Table: dbo.Custom_Grouping
Columns
NameTypeConstraintsDescription
custom_grouping_KEYint (4)NOT NULLDatabase assigned primary key for this table.
custom_field_KEYint (4)NOT NULLKey to a Custom Field.
custom_grouping_idnvarchar (22)NOT NULLUser defined identifier (unique).
descriptionnvarchar (60)NOT NULLUser defined description.
custom_grouping_id_sortablevarchar (48)NOT NULLA representation of the custom_grouping_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of custom_grouping_id.
Primary key
NameColumnsDescription
PK_Custom_Groupingcustom_grouping_KEY
Unique constraints
NameColumnsDescription
UK_Custom_Grouping$custom_field_KEY$custom_grouping_idcustom_field_KEY, custom_grouping_id
UK_Custom_Grouping$custom_field_KEY$custom_grouping_id_sortablecustom_field_KEY, custom_grouping_id_sortable
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Grouping__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Field (custom_field_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Custom_Value__Custom_Grouping__custom_grouping_KEYcustom_grouping_KEYCustom_Value

Schema diagram