Table: Client_Financial_Data_Description
Descriptions for Client_Financial_Data values
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
client_financial_data_description_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. unique key of this table
descriptionnvarchar (100)NOT NULLunique description of this table
financial_value_formatnvarchar (100)NOT NULLdescription of the format
Primary key
NameColumnsDescription
PK_Client_Financial_Data_Description$client_financial_data_description_KEYclient_financial_data_description_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Client_Financial_Data_Description$description$financial_value_formatdescription, financial_value_formatDescription is unique by format.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEYclient_financial_data_description_KEYClient_Financial_Data

Schema diagram