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 |