Table: Custom_Formula
Columns
NameTypeConstraintsDescription
custom_formula_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
owner_table_namenvarchar (128)NOT NULLName of the table that this custom formula is associated with.
descriptionnvarchar (250)NOT NULLDescription of the custom formula. The same description can only be used once per owner_table_name.
formulanvarchar (-1)NOT NULLThe custom formula.
custom_formula_data_type_KEYintNOT NULLForiegn key to specify what data type this custom formula is.
versionnvarchar (19)NOT NULLThe version of the custom formula.
Primary key
NameColumnsDescription
PK_Custom_Formula$custom_formula_KEYcustom_formula_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Custom_Formula$owner_table_name$descriptionowner_table_name, descriptionThe same description can only be used once per owner_table_name.
Indexes
NameColumnsDescription
IX_Custom_Formula$custom_formula_data_type_KEYcustom_formula_data_type_KEYIndex supports foreign key FK_Custom_Formula__Custom_Formula_Data_Type__custom_formula_data_type_KEY

Schema diagram