PROCESSFILE

Stores all the information related to the file process.

Column Descriptions:

NameTypeDescription
PROCESSFILE_IDBIGINT NOT NULLGenerated primary key.
MEMBER_IDBIGINTThe identifier of the user that uploaded the file.
PROPERTIESVARCHAR (1000)Some extra name value pairs such as the scheduler job identifier and host name.
STARTTIMETIMESTAMPThe time the file upload process begins.
ENDTIMETIMESTAMPThe time the file upload process ends.
STATUSINTEGERThe status of the file upload. Valid values are as follows: 0 = New, 1 = Processing, 2 = Complete, 3 = Failed, 4 = Canceled.
PROCESSINFOCLOB (1000000)The processing information such as the summary report.
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>PROCESSFILE_IDPrimary Key
I0001311MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3601MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3603PROCESSFILE_IDFILEPROCRELPROCESSFILE_IDCascade