Table: dbo.Print_Job
This table contains an entry for each job submitted to the check/invoice/form printing engine. This table's primary key is used to uniquely identify a given print job.
Columns
NameTypeConstraintsDescription
print_job_KEYint (4)NOT NULLPrimary key.
staff_KEYint (4)NOT NULLForeign key to the user that submitted the print job.
submit_datedatetime (8, 3)NOT NULLThe date/time when the print job was submitted.
client_KEYint (4)NOT NULLForeign key to table Client to identify the client for a print job.
Primary key
NameColumnsDescription
PK_Print_Jobprint_job_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Job__Client__client_KEYclient_KEYClient (client_KEY)
FK_Print_Job__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Reprintable_Print_Job__Print_Job__print_job_KEYprint_job_KEYReprintable_Print_Job
FK_Netclient_File_Log__Print_Job__print_job_KEYprint_job_KEYNetclient_File_Log

Schema diagram