Table: dbo.Print_Job_Type
Table to store the output types for printers
Columns
NameTypeConstraintsDescription
print_job_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the output type.
Primary key
NameColumnsDescription
PK_Print_Job_Typeprint_job_type_KEY
Unique constraints
NameColumnsDescription
UK_Print_Job_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Print_Job_Subtype__Print_Job_Type__print_job_type_KEYprint_job_type_KEYPrint_Job_Subtype
FK_Printer_User_Preference__Print_Job_Type__print_job_type_KEYprint_job_type_KEYPrinter_User_Preference
FK_Print_Destination_User_Preference__Print_Job_Type__print_job_type_KEYprint_job_type_KEYPrint_Destination_User_Preference

Schema diagram