Table: Client_Financial_Data | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
client_financial_data_KEY | int | NOT NULL | |
client_KEY | int | NOT NULL | |
client_financial_data_description_KEY | int | NOT NULL | |
integration_application_KEY | int | NOT NULL | |
integration_application_year | int | NOT NULL | |
tax_year | int | NOT NULL | |
financial_value | decimal (25, 6) | ||
entry_date | datetime | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Client_Financial_Data$client_KEY$client_financial_data_description_KEY$tax_year | client_KEY, client_financial_data_description_KEY, tax_year | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Client_Financial_Data$client_financial_data_KEY | client_financial_data_KEY | ||
Indexes | |||
Name | Columns | Description | |
IX_Client_Financial_Data$client_financial_data_description_KEY | client_financial_data_description_KEY | Index supports foreign key FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEY | |
IX_Client_Financial_Data$integration_application_KEY | integration_application_KEY | Index supports foreign key FK_Client_Financial_Data__Integration_Application__integration_application_KEY |