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 |