Table: dbo.Client_Consolidation_Grouping_Type
This table will hold values for the client consolidating grouping type
Columns
NameTypeConstraintsDescription
client_consolidation_grouping_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (40)NOT NULLThe type of groupings supported when consolidating a client
Primary key
NameColumnsDescription
PK_Client_Consolidation_Grouping_Typeclient_consolidation_grouping_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Consolidation_Option__Client_Consolidation_Grouping_Type__client_consolidation_grouping_type_KEYclient_consolidation_grouping_type_KEYClient_Consolidation_Option
FK_Client_Consolidation_Option__Client_Consolidation_Grouping_Type__used_previously__client_consolidation_grouping_type_KEYused_previously__client_consolidation_grouping_type_KEYClient_Consolidation_Option
FK_Custom_Excel_Grid__Client_Consolidation_Grouping_Type__client_consolidation_grouping_type_KEYclient_consolidation_grouping_type_KEYCustom_Excel_Grid

Schema diagram