Table: dbo.Print_Job_Subtype
Table to store the sub output types for printers
Columns
NameTypeConstraintsDescription
print_job_subtype_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the sub output type.
print_job_type_KEYint (4)NOT NULLForeign key to the parent output type for this sub output type.
Primary key
NameColumnsDescription
PK_Print_Job_Subtypeprint_job_subtype_KEY
Unique constraints
NameColumnsDescription
UK_Print_Job_Subtype$description$print_job_type_KEYdescription, print_job_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Job_Subtype__Print_Job_Type__print_job_type_KEYprint_job_type_KEYPrint_Job_Type (print_job_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Processed_Tax_Form__Print_Job_Subtype__print_job_subtype_KEYprint_job_subtype_KEYProcessed_Tax_Form
FK_Printer_User_Preference_By_Subtype__Print_Job_Subtype__print_job_subtype_KEYprint_job_subtype_KEYPrinter_User_Preference_By_Subtype

Schema diagram