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
NameTypeConstraintsDescription
user_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
user_interface_grid_column_KEYint (4)NOT NULLA link to get the column key.
sequence_numberint (4)NOT NULLUsed to set the order of columns in the corresponding grid.
is_visiblebit (1)NOT NULLUsed to show or hide a given column in the corresponding grid.
Primary key
NameColumnsDescription
PK_User_Preference_Grid_Column_Screen_Optionuser_preference_grid_column_screen_option_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_User_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_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram