Table: dbo.User_Client_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_client_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
client_KEY | int (4) | NOT NULL | A link to the Client table
user_interface_grid_column_KEY | int (4) | NOT NULL | A link to get the column key.
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_Client_Preference_Grid_Column_Screen_Option | user_client_preference_grid_column_screen_option_KEY |
Unique constraints
Name | Columns | Description
UK_User_Client_Preference_Grid_Column_Screen_Option$user_preference_KEY$client_KEY$user_interface_grid_column_KEY | user_preference_KEY, client_KEY, user_interface_grid_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_User_Client_Preference_Grid_Column_Screen_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_User_Client_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_Client_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |