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
Name | Type | Constraints | Description
printer_user_preference_by_subtype_KEY | int (4) | NOT NULL | Primary key.
user_preference_KEY | int (4) | NOT NULL | Foreign key references UserPreferenceKey.
print_job_subtype_KEY | int (4) | NOT NULL | Foreign Key to Print_Job_Subtype
printer_name | nvarchar (520) | NOT NULL | Description of the printer name.
printer_paper_source | nvarchar (520) | NOT NULL | Description of the selected printed paper source.

Primary key
Name | Columns | Description
PK_Printer_User_Preference_By_Subtype | printer_user_preference_by_subtype_KEY |
Unique constraints
Name | Columns | Description
UK_Printer_User_Preference_By_Subtype$user_preference_KEY$print_job_subtype_KEY | user_preference_KEY, print_job_subtype_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Printer_User_Preference_By_Subtype__Print_Job_Subtype__print_job_subtype_KEY | print_job_subtype_KEY | Print_Job_Subtype (print_job_subtype_KEY) |
FK_Printer_User_Preference_By_Subtype__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |