Table: dbo.Netclient_File_Log
Columns
NameTypeConstraintsDescription
netclient_file_log_KEYint (4)NOT NULLPrimary key; log of NetClient data files
client_KEYint (4)NOT NULLForeign key; Client associated with the data file
creation__staff_KEYint (4)NOT NULLForeign key; Staff id of the user who created the file
creation_datedatetime (8, 3)NOT NULLDate and time the data file was created
transmit_datedatetime (8, 3)Date and time the file was successfully transmitted to NetClient
descriptionnvarchar (100)NOT NULLDescription the user sees in NetClient
file_namenvarchar (100)NOT NULLName of the file
netclient_file_log_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
checkbook_KEYint (4)Client checkbook associated with the data file.
print_job_KEYint (4)Foreign key to the print job that created the Net Client PDF file.
Primary key
NameColumnsDescription
PK_Netclient_File_Lognetclient_file_log_KEY
Unique constraints
NameColumnsDescription
UK_Netclient_File_Log$file_namefile_name
UK_Netclient_File_Log$netclient_file_log_guidnetclient_file_log_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Netclient_File_Log__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Netclient_File_Log__Client__client_KEYclient_KEYClient (client_KEY)
FK_Netclient_File_Log__Print_Job__print_job_KEYprint_job_KEYPrint_Job (print_job_KEY)
FK_Netclient_File_Log__Staff__creation__staff_KEYcreation__staff_KEYStaff (staff_KEY)

Schema diagram