Table: dbo.Engagement_Tree_Column_Selector
stores the order of columns as well as which columns will be displayed.
Columns
Name | Type | Constraints | Description
engagement_tree_column_selector_KEY | int (4) | NOT NULL | The primary key.
engagement_tree_static_column_KEY | int (4) |  | Foreign key to engagement tree static column table. NULL means the column must reside in signoff type table.
signoff_type_KEY | int (4) |  | Foreign key to signoff type table. NULL means the column must reside in engagement tree static column table.
sequence_number | int (4) | NOT NULL | number from 1 to max number of columns.
is_visible | bit (1) | NOT NULL | true to display column and false to hide it.
engagement_workspace_tab_KEY | int (4) | NOT NULL | Foreign key to engagement workspace tab table.
engagement_view_classification_KEY | int (4) | NOT NULL | A foreign key to the Engagement_View_Classification table, indicating what view this column this Engagement_Tree_Column_Selector row is for.

Primary key
Name | Columns | Description
PK_Engagement_Tree_Column_Selector | engagement_tree_column_selector_KEY |
Unique constraints
Name | Columns | Description
UK_Engagement_Tree_Column_Selector$engagement_tree_static_column_KEY$signoff_type_KEY$engagement_workspace_tab_KEY$engagement_vi | engagement_tree_static_column_KEY, signoff_type_KEY, engagement_workspace_tab_KEY, engagement_view_classification_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Engagement_Tree_Column_Selector__Engagement_Tree_Static_Column__engagement_tree_static_column_KEY | engagement_tree_static_column_KEY | Engagement_Tree_Static_Column (engagement_tree_static_column_KEY) |
FK_Engagement_Tree_Column_Selector__Engagement_View_Classification__engagement_view_classification_KEY | engagement_view_classification_KEY | Engagement_View_Classification (engagement_view_classification_KEY) |
FK_Engagement_Tree_Column_Selector__Engagement_Workspace_Tab__engagement_workspace_tab_KEY | engagement_workspace_tab_KEY | Engagement_Workspace_Tab (engagement_workspace_tab_KEY) |
FK_Engagement_Tree_Column_Selector__Signoff_Type__signoff_type_KEY | signoff_type_KEY | Signoff_Type (signoff_type_KEY) |