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_datedatetimeNOT NULL
create_datedatetimeNOT NULL
owner_table_namenvarchar (128)NOT NULLName of the table that this custom formula is associated with.
descriptionnvarchar (50)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
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Formula__Custom_Formula_Data_Type__custom_formula_data_type_KEYcustom_formula_data_type_KEYCustom_Formula_Data_Type

Schema diagram