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