Table: dbo.User_Screen_Option
The table used to store UI control states on system screens.
Columns
NameTypeConstraintsDescription
user_screen_option_KEYint (4)NOT NULLPrimary key.
user_preference_KEYint (4)NOT NULLForeign key into the User_Preference table.
user_interface_screen_KEYint (4)NOT NULLForeign key into the User_Screen table.
show_inactivebit (1)NOT NULLStores whether or not the include inactive checkbox was marked.
Primary key
NameColumnsDescription
PK_User_Screen_Optionuser_screen_option_KEY
Unique constraints
NameColumnsDescription
UK_User_Screen_Option$user_preference_KEY$user_interface_screen_KEYuser_preference_KEY, user_interface_screen_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Screen_Option__User_Interface_Screen__user_interface_screen_KEYuser_interface_screen_KEYUser_Interface_Screen (user_interface_screen_KEY)
FK_User_Screen_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram