Table: Custom_Formula
Columns
Name | Type | Constraints | Description
custom_formula_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
owner_table_name | nvarchar (128) | NOT NULL | Name of the table that this custom formula is associated with.
description | nvarchar (50) | NOT NULL | Description of the custom formula. The same description can only be used once per owner_table_name.
formula | nvarchar (-1) | NOT NULL | The custom formula.
custom_formula_data_type_KEY | int | NOT NULL | Foriegn key to specify what data type this custom formula is.
version | nvarchar (19) | NOT NULL | The version of the custom formula.

Primary key
Name | Columns | Description
PK_Custom_Formula$custom_formula_KEY | custom_formula_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Custom_Formula__owner_table_name__description | owner_table_name, description | The same description can only be used once per owner_table_name.
Indexes
Name | Columns | Description
IX_Custom_Formula$custom_formula_data_type_KEY | custom_formula_data_type_KEY | Index supports foreign key FK_Custom_Formula__Custom_Formula_Data_Type__custom_formula_data_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Custom_Formula__Custom_Formula_Data_Type__custom_formula_data_type_KEY | custom_formula_data_type_KEY | Custom_Formula_Data_Type |