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