Table: dbo.Printer_User_Preference
Table to store the users preferences for printers
Columns
NameTypeConstraintsDescription
printer_user_preference_KEYint (4)NOT NULL
user_preference_KEYint (4)NOT NULLForeign key references UserPreferenceKey.
print_job_type_KEYint (4)NOT NULLForeign Key to Print_Job_Type
printer_namenvarchar (520)NOT NULLDescription of the printer name.
printer_paper_sourcenvarchar (520)NOT NULLDescription of the selected printed paper source.
use_separator_pagebit (1)NOT NULLDoes user want a separator page?.
separator_paper_sourcenvarchar (520)NOT NULLDescription of second paper source if separator is selected.
Primary key
NameColumnsDescription
PK_Printer_User_Preferenceprinter_user_preference_KEY
Unique constraints
NameColumnsDescription
UK_Printer_User_Preference$user_preference_KEY$print_job_type_KEYuser_preference_KEY, print_job_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Printer_User_Preference__Print_Job_Type__print_job_type_KEYprint_job_type_KEYPrint_Job_Type (print_job_type_KEY)
FK_Printer_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram