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 |