Table: Client_Financial_Data_Description | |||
Descriptions for Client_Financial_Data values | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
client_financial_data_description_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. unique key of this table |
description | nvarchar (100) | NOT NULL | unique description of this table |
financial_value_format | nvarchar (100) | NOT NULL | description of the format |
Primary key | |||
Name | Columns | Description | |
PK_Client_Financial_Data_Description$client_financial_data_description_KEY | client_financial_data_description_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Client_Financial_Data_Description$description$financial_value_format | description, financial_value_format | Description is unique by format. |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEY | client_financial_data_description_KEY | Client_Financial_Data |