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 | |||
Name | Type | Constraints | Description |
print_job_KEY | int (4) | NOT NULL | Primary key. |
staff_KEY | int (4) | NOT NULL | Foreign key to the user that submitted the print job. |
submit_date | datetime (8, 3) | NOT NULL | The date/time when the print job was submitted. |
client_KEY | int (4) | NOT NULL | Foreign key to table Client to identify the client for a print job. |
Primary key | |||
Name | Columns | Description | |
PK_Print_Job | print_job_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Print_Job__Client__client_KEY | client_KEY | Client (client_KEY) | |
FK_Print_Job__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Reprintable_Print_Job__Print_Job__print_job_KEY | print_job_KEY | Reprintable_Print_Job | |
FK_Netclient_File_Log__Print_Job__print_job_KEY | print_job_KEY | Netclient_File_Log |