Table: Custom_Value | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
custom_value_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
custom_field_KEY | int | NOT NULL | Key of the Custom field that this value is for. |
table_information_KEY | int | NOT NULL | Which table is the row indicated by [row_KEY] in. This is usually the same as table_information_KEY specified in Custom_Field, but it can be different if you are reusing the Custom Fields of a different type (for example the Project and Project Template tables share the same custom field). |
row_KEY | int | NOT NULL | Which row in the table indicated by [table_information_KEY]. |
custom_value | nvarchar (4000) | NOT NULL | A string representation of the actual value. |
custom_field_type_KEY | int | ||
custom_field_slot | int | ||
custom_value_as_checkbox | bit | ||
custom_value_as_number | decimal (25, 10) | ||
custom_value_as_date | datetime | ||
custom_value__staff_KEY | int | ||
custom_value__custom_grouping_KEY | int |
Primary key | |||
Name | Columns | Description | |
PK_Custom_Value$custom_value_KEY | custom_value_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Custom_Value$custom_field_KEY$table_information_KEY$row_KEY | custom_field_KEY, table_information_KEY, row_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Custom_Value$row_KEY$custom_field_KEY | row_KEY, custom_field_KEY | ||
IX_Custom_Value$table_information_KEY | table_information_KEY | Index supports foreign key FK_Custom_Value__Table_Information__table_information_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Custom_Value__Custom_Field__custom_field_KEY | custom_field_KEY | Custom_Field | on delete cascade; |
FK_Custom_Value__Table_Information__table_information_KEY | table_information_KEY | Table_Information |