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

Foreign keys
Name | Columns | Referenced table | Description
FK_Firm_Dashboard_Layout__Dashboard_Layout__dashboard_layout_KEY | dashboard_layout_KEY | Dashboard_Layout |
FK_Firm_Dashboard_Layout__Dashboard_Layout__dashboard_layout_type_KEY__dashboard_layout_KEY | dashboard_layout_type_KEY, dashboard_layout_KEY | Dashboard_Layout |
FK_Firm_Dashboard_Layout__Firm__firm_KEY | firm_KEY | Firm |