Table: Firm_Dashboard_Layout
Columns
NameTypeConstraintsDescription
firm_dashboard_layout_KEYintNOT NULLArtificial key column created to make this table more compatible with the DAL.
firm_KEYintNOT NULLKey to the Firm that these preferences are for.
dashboard_layout_type_KEYintNOT NULLThe type of dashboard layout that this firm preference is referring to (Home, Client, Staff, etc).
dashboard_layout_KEYintNOT NULLKey to the dashboard layout that is to be used.
Primary key
NameColumnsDescription
PK_Firm_Dashboard_Layout$firm_dashboard_layout_KEYfirm_dashboard_layout_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Firm_Dashboard_Layout$dashboard_layout_type_KEY$dashboard_layout_KEYdashboard_layout_type_KEY, dashboard_layout_KEYIndex supports foreign key FK_Firm_Dashboard_Layout__Dashboard_Layout__dashboard_layout_type_KEY__dashboard_layout_KEY
IX_Firm_Dashboard_Layout$firm_KEYfirm_KEYIndex supports foreign key FK_Firm_Dashboard_Layout__Firm__firm_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Dashboard_Layout__Dashboard_Layout__dashboard_layout_KEYdashboard_layout_KEYDashboard_Layout
FK_Firm_Dashboard_Layout__Dashboard_Layout__dashboard_layout_type_KEY__dashboard_layout_KEYdashboard_layout_type_KEY, dashboard_layout_KEYDashboard_Layout
FK_Firm_Dashboard_Layout__Firm__firm_KEYfirm_KEYFirm

Schema diagram