Table: Custom_Field
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
custom_field_KEY | int | NOT NULL |
description | nvarchar (250) | NOT NULL | The 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_KEY | int | NOT NULL | Foreign key to specify what data type this column is.
length | int | NOT NULL | Length of character columns, precision of number columns, storage length of other types.
sort | int | NOT NULL | Sort order of this custom field when it is displayed. The fields should be sorted by position and description.
category | nvarchar (30) | NOT NULL |
table_information_KEY | int | NOT NULL | Main table that this custom field is associated with. See Custom_Value.table_information_KEY
custom_field_slot | int | NOT NULL | Which slot this field is in, used for sorting items by custom field columns.
scale | int | NOT NULL |

Primary key
Name | Columns | Description
PK_Custom_Field$custom_field_KEY | custom_field_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Custom_Field$custom_field_slot$table_information_KEY | custom_field_slot, table_information_KEY | The same [custom_field_slot] can only be used once per [table_information_KEY].
UK_Custom_Field$table_information_KEY$category$description | table_information_KEY, category, description | The same [description] can only be used once per [category] and [table_information_KEY]. Please choose a different value for [description].
Indexes
Name | Columns | Description
IX_Custom_Field$custom_field_type_KEY | custom_field_type_KEY | Index supports foreign key FK_Custom_Field__Custom_Field_Type__custom_field_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Custom_Field__Table_Information__table_information_KEY | table_information_KEY | Table_Information |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Custom_Grouping__Custom_Field__custom_field_KEY | custom_field_KEY | Custom_Grouping |
FK_Custom_Value__Custom_Field__custom_field_KEY | custom_field_KEY | Custom_Value | on delete cascade;
FK_User_Preference_Custom_Field_Column__Custom_Field__custom_field_KEY | custom_field_KEY | User_Preference_Custom_Field_Column | on delete cascade;