Table: dbo.Netclient_File_Log
Columns
Name | Type | Constraints | Description
netclient_file_log_KEY | int (4) | NOT NULL | Primary key; log of NetClient data files
client_KEY | int (4) | NOT NULL | Foreign key; Client associated with the data file
creation__staff_KEY | int (4) | NOT NULL | Foreign key; Staff id of the user who created the file
creation_date | datetime (8, 3) | NOT NULL | Date and time the data file was created
transmit_date | datetime (8, 3) |  | Date and time the file was successfully transmitted to NetClient
description | nvarchar (100) | NOT NULL | Description the user sees in NetClient
file_name | nvarchar (100) | NOT NULL | Name of the file
netclient_file_log_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row
checkbook_KEY | int (4) |  | Client checkbook associated with the data file.
print_job_KEY | int (4) |  | Foreign key to the print job that created the Net Client PDF file.

Primary key
Name | Columns | Description
PK_Netclient_File_Log | netclient_file_log_KEY |
Unique constraints
Name | Columns | Description
UK_Netclient_File_Log$file_name | file_name |
UK_Netclient_File_Log$netclient_file_log_guid | netclient_file_log_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Netclient_File_Log__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Netclient_File_Log__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Netclient_File_Log__Print_Job__print_job_KEY | print_job_KEY | Print_Job (print_job_KEY) |
FK_Netclient_File_Log__Staff__creation__staff_KEY | creation__staff_KEY | Staff (staff_KEY) |