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; |