Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PROCESSFILE
Stores all the information related to the file process.
Column Name Column Type Description PROCESSFILE_ID BIGINT NOT NULL The unique identifier of the uploaded file. 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... 0 = New, 1 = Processing, 2 = Complete, 3 = Failed, 4 = Cancelled. PROCESSINFO CLOB The processing information such as the summary report. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030704560 PROCESSFILE_ID Primary Key I0001311 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3601 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3603 PROCESSFILE_ID FILEPROCREL PROCESSFILE_ID Cascade _vcc_freeselect_bottom_