Table: dbo.Printer_User_Preference_By_Subtype
Table to store the user preferences for printers of print job subtypes. The user preferences for printers of main types like W-2s, Reports, Checks, Invoices, and 1099s are still stored in the Printer_User_Preference table, but any subtypes to these main types, like the W-2 Preprinted W-3, can have a printer that overrides the main printer, and that is what we store in this table.
Columns
NameTypeConstraintsDescription
printer_user_preference_by_subtype_KEYint (4)NOT NULLPrimary key.
user_preference_KEYint (4)NOT NULLForeign key references UserPreferenceKey.
print_job_subtype_KEYint (4)NOT NULLForeign Key to Print_Job_Subtype
printer_namenvarchar (520)NOT NULLDescription of the printer name.
printer_paper_sourcenvarchar (520)NOT NULLDescription of the selected printed paper source.
Primary key
NameColumnsDescription
PK_Printer_User_Preference_By_Subtypeprinter_user_preference_by_subtype_KEY
Unique constraints
NameColumnsDescription
UK_Printer_User_Preference_By_Subtype$user_preference_KEY$print_job_subtype_KEYuser_preference_KEY, print_job_subtype_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Printer_User_Preference_By_Subtype__Print_Job_Subtype__print_job_subtype_KEYprint_job_subtype_KEYPrint_Job_Subtype (print_job_subtype_KEY)
FK_Printer_User_Preference_By_Subtype__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram