Table: Custom_Value
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
custom_value_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
custom_field_KEYintNOT NULLKey of the Custom field that this value is for.
table_information_KEYintNOT NULLWhich 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_KEYintNOT NULLWhich row in the table indicated by [table_information_KEY].
custom_valuenvarchar (4000)NOT NULLA string representation of the actual value.
custom_field_type_KEYint
custom_field_slotint
custom_value_as_checkboxbit
custom_value_as_numberdecimal (25, 10)
custom_value_as_datedatetime
custom_value__staff_KEYint
custom_value__custom_grouping_KEYint
Primary key
NameColumnsDescription
PK_Custom_Value$custom_value_KEYcustom_value_KEY
Unique constraints
NameColumnsDescription
UK_Custom_Value$custom_field_KEY$table_information_KEY$row_KEYcustom_field_KEY, table_information_KEY, row_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Custom_Value$row_KEY$custom_field_KEYrow_KEY, custom_field_KEY
IX_Custom_Value$table_information_KEYtable_information_KEYIndex supports foreign key FK_Custom_Value__Table_Information__table_information_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Value__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Fieldon delete cascade;
FK_Custom_Value__Table_Information__table_information_KEYtable_information_KEYTable_Information

Schema diagram