Table: Firm_Dashboard_Layout | |||
Columns | |||
Name | Type | Constraints | Description |
firm_dashboard_layout_KEY | int | NOT NULL | Artificial key column created to make this table more compatible with the DAL. |
firm_KEY | int | NOT NULL | Key to the Firm that these preferences are for. |
dashboard_layout_type_KEY | int | NOT NULL | The type of dashboard layout that this firm preference is referring to (Home, Client, Staff, etc). |
dashboard_layout_KEY | int | NOT NULL | Key to the dashboard layout that is to be used. |
Primary key | |||
Name | Columns | Description | |
PK_Firm_Dashboard_Layout$firm_dashboard_layout_KEY | firm_dashboard_layout_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Firm_Dashboard_Layout$dashboard_layout_type_KEY$dashboard_layout_KEY | dashboard_layout_type_KEY, dashboard_layout_KEY | Index supports foreign key FK_Firm_Dashboard_Layout__Dashboard_Layout__dashboard_layout_type_KEY__dashboard_layout_KEY | |
IX_Firm_Dashboard_Layout$firm_KEY | firm_KEY | Index supports foreign key FK_Firm_Dashboard_Layout__Firm__firm_KEY |