Table: dbo.User_Preference_Grid_Column_Screen_Option | |||
This table holds links to the customised columns and the grids they belong to (if the user customised order and visibility of columns in a given grid). | |||
Columns | |||
Name | Type | Constraints | Description |
user_preference_grid_column_screen_option_KEY | int (4) | NOT NULL | Primary key. |
user_preference_KEY | int (4) | NOT NULL | A link to the User_Preference table to get the staff_KEY |
user_interface_grid_column_KEY | int (4) | NOT NULL | A link to get the column key. |
sequence_number | int (4) | NOT NULL | Used to set the order of columns in the corresponding grid. |
is_visible | bit (1) | NOT NULL | Used to show or hide a given column in the corresponding grid. |
Primary key | |||
Name | Columns | Description | |
PK_User_Preference_Grid_Column_Screen_Option | user_preference_grid_column_screen_option_KEY |