WebSphere Commerce database table: FILEUPLOAD

This table contains the information of uploaded files.

Column Descriptions
Column Name Column Type Description
FILEUPLOAD_ID BIGINT NOT NULL Generated key.
MEMBER_ID BIGINT The ID of the member who uploads the file.
STORE_ID INTEGER The store to which the uploaded file belongs.
SCCJOBREFNUM BIGINT The scheduler job which processes the file.
FILEPATH VARCHAR(254) NOT NULL The directory path of the file to be uploaded.
FILENAME VARCHAR(254) The name of the file to be uploaded.
FILESIZE BIGINT The size of the file to be uploaded.
FILETYPE CHAR(50) Reserved for IBM internal use.
FILEENCODING VARCHAR(128) The file encoding. For example, UTF8, ISO8859-1, and so on.
UPLOADTIME TIMESTAMP Time when the file uploaded.
HOSTNAME CHAR(50) The host name the file is uploaded to. It is used by the scheduler in the horizontal cloning environment, only the scheduler on this machine will process the uploaded file.
VERSION INTEGER NOT NULL The version of uploaded file. The same file can be uploaded more than once.
STATUS INTEGER NOT NULL DEFAULT 0 The file process status. Valid values are as follows:
0 = New,
1 = Processing,
2 = Processed,
3 = Failed,
4 = Cancelled.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000295 FILEPATH+VERSION Unique Index
SQL060903235158110 FILEUPLOAD_ID Primary Key
I0000296 STORE_ID Non-Unique Index
I0000571 SCCJOBREFNUM Non-Unique Index
I0000572 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_984 MEMBER_ID MEMBER MEMBER_ID Cascade
F_985 SCCJOBREFNUM SCHCONFIG SCCJOBREFNUM Cascade
F_986 STORE_ID STORE STORE_ID Cascade
Related reference