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
NameTypeConstraintsDescription
user_client_preference_grid_column_screen_option_KEYint (4)NOT NULLPrimary key.
user_preference_KEYint (4)NOT NULLA link to the User_Preference table to get the staff_KEY
client_KEYint (4)NOT NULLA link to the Client table
user_interface_grid_column_KEYint (4)NOT NULLA link to get the column key.
is_visiblebit (1)NOT NULLUsed to show or hide a given column in the corresponding grid.
Primary key
NameColumnsDescription
PK_User_Client_Preference_Grid_Column_Screen_Optionuser_client_preference_grid_column_screen_option_KEY
Unique constraints
NameColumnsDescription
UK_User_Client_Preference_Grid_Column_Screen_Option$user_preference_KEY$client_KEY$user_interface_grid_column_KEYuser_preference_KEY, client_KEY, user_interface_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Client_Preference_Grid_Column_Screen_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_User_Client_Preference_Grid_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEYuser_interface_grid_column_KEYUser_Interface_Grid_Column (user_interface_grid_column_KEY)
FK_User_Client_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram