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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_User_Preference_Grid_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEY | user_interface_grid_column_KEY | User_Interface_Grid_Column (user_interface_grid_column_KEY) |
FK_User_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |