Table: dbo.Printer_User_Preference
Table to store the users preferences for printers
Columns
Name | Type | Constraints | Description
printer_user_preference_KEY | int (4) | NOT NULL |
user_preference_KEY | int (4) | NOT NULL | Foreign key references UserPreferenceKey.
print_job_type_KEY | int (4) | NOT NULL | Foreign Key to Print_Job_Type
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.
use_separator_page | bit (1) | NOT NULL | Does user want a separator page?.
separator_paper_source | nvarchar (520) | NOT NULL | Description of second paper source if separator is selected.

Primary key
Name | Columns | Description
PK_Printer_User_Preference | printer_user_preference_KEY |
Unique constraints
Name | Columns | Description
UK_Printer_User_Preference$user_preference_KEY$print_job_type_KEY | user_preference_KEY, print_job_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Printer_User_Preference__Print_Job_Type__print_job_type_KEY | print_job_type_KEY | Print_Job_Type (print_job_type_KEY) |
FK_Printer_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |