Table: Client_Financial_Data
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
client_financial_data_KEYintNOT NULL
client_KEYintNOT NULL
client_financial_data_description_KEYintNOT NULL
integration_application_KEYintNOT NULL
integration_application_yearintNOT NULL
tax_yearintNOT NULL
financial_valuedecimal (25, 6)
entry_datedatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Client_Financial_Data$client_KEY$client_financial_data_description_KEY$tax_yearclient_KEY, client_financial_data_description_KEY, tax_yearCLUSTERED
Unique constraints
NameColumnsDescription
UK_Client_Financial_Data$client_financial_data_KEYclient_financial_data_KEY
Indexes
NameColumnsDescription
IX_Client_Financial_Data$client_financial_data_description_KEYclient_financial_data_description_KEYIndex supports foreign key FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEY
IX_Client_Financial_Data$integration_application_KEYintegration_application_KEYIndex supports foreign key FK_Client_Financial_Data__Integration_Application__integration_application_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Financial_Data__Client__client_KEYclient_KEYClienton delete cascade;
FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEYclient_financial_data_description_KEYClient_Financial_Data_Description
FK_Client_Financial_Data__Integration_Application__integration_application_KEYintegration_application_KEYIntegration_Application

Schema diagram