| 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 | ||