Stores all the information related to the file
process.
Column Descriptions:
Name | Type | Description |
PROCESSFILE_ID | BIGINT NOT NULL | Generated primary key. |
MEMBER_ID | BIGINT | The identifier of the user that uploaded the
file. |
PROPERTIES | VARCHAR (1000) | Some extra name value pairs such as the scheduler
job identifier and host name. |
STARTTIME | TIMESTAMP | The time the file upload process begins. |
ENDTIME | TIMESTAMP | The time the file upload process ends. |
STATUS | INTEGER | The status of the file upload. Valid values are
as follows: 0 = New, 1 = Processing, 2 = Complete, 3 = Failed, 4 =
Canceled. |
PROCESSINFO | CLOB (1000000) | The processing information such as the summary
report. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | PROCESSFILE_ID | Primary Key |
I0001311 | MEMBER_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3601 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_3603 | PROCESSFILE_ID | FILEPROCREL | PROCESSFILE_ID | Cascade |