Table: Custom_Field
Columns
Name | Type | Constraints | Description
custom_field_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
description | nvarchar (30) | 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 source_table.
custom_field_type_KEY | int | NOT NULL | Foriegn 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.
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
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

Primary key
Name | Columns | Description
PK_Custom_Field$custom_field_KEY | custom_field_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Custom_Field$table_information_KEY$category$description | table_information_KEY, category, 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__Custom_Field_Type__custom_field_type_KEY | custom_field_type_KEY | Custom_Field_Type |
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;