FILEPROCREL

The relationship between the uploaded file and process information

Column Descriptions:

NameTypeDescription
UPLOADFILE_IDBIGINT NOT NULLForeign key to the UPLOADFILE
PROCESSFILE_IDBIGINT NOT NULLForeign key to the PROCESSFILE
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>UPLOADFILE_ID+PROCESSFILE_IDPrimary Key
I0001312PROCESSFILE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3602UPLOADFILE_IDUPLOADFILEUPLOADFILE_IDCascade
F_3603PROCESSFILE_IDPROCESSFILEPROCESSFILE_IDCascade