| 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) | |