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_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
owner_table_name | nvarchar (128) | NOT NULL | Name of the table that this custom formula is associated with. |
description | nvarchar (250) | 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 |