Table: dbo.Engagement_Tree_Column_Selector
stores the order of columns as well as which columns will be displayed.
Columns
NameTypeConstraintsDescription
engagement_tree_column_selector_KEYint (4)NOT NULLThe primary key.
engagement_tree_static_column_KEYint (4)Foreign key to engagement tree static column table. NULL means the column must reside in signoff type table.
signoff_type_KEYint (4)Foreign key to signoff type table. NULL means the column must reside in engagement tree static column table.
sequence_numberint (4)NOT NULLnumber from 1 to max number of columns.
is_visiblebit (1)NOT NULLtrue to display column and false to hide it.
engagement_workspace_tab_KEYint (4)NOT NULLForeign key to engagement workspace tab table.
engagement_view_classification_KEYint (4)NOT NULLA foreign key to the Engagement_View_Classification table, indicating what view this column this Engagement_Tree_Column_Selector row is for.
Primary key
NameColumnsDescription
PK_Engagement_Tree_Column_Selectorengagement_tree_column_selector_KEY
Unique constraints
NameColumnsDescription
UK_Engagement_Tree_Column_Selector$engagement_tree_static_column_KEY$signoff_type_KEY$engagement_workspace_tab_KEY$engagement_viengagement_tree_static_column_KEY, signoff_type_KEY, engagement_workspace_tab_KEY, engagement_view_classification_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Engagement_Tree_Column_Selector__Engagement_Tree_Static_Column__engagement_tree_static_column_KEYengagement_tree_static_column_KEYEngagement_Tree_Static_Column (engagement_tree_static_column_KEY)
FK_Engagement_Tree_Column_Selector__Engagement_View_Classification__engagement_view_classification_KEYengagement_view_classification_KEYEngagement_View_Classification (engagement_view_classification_KEY)
FK_Engagement_Tree_Column_Selector__Engagement_Workspace_Tab__engagement_workspace_tab_KEYengagement_workspace_tab_KEYEngagement_Workspace_Tab (engagement_workspace_tab_KEY)
FK_Engagement_Tree_Column_Selector__Signoff_Type__signoff_type_KEYsignoff_type_KEYSignoff_Type (signoff_type_KEY)

Schema diagram