Reference > Database > WebSphere Commerce database tables > F
WebSphere Commerce database table: FILEUPLOAD
This table contains the information of uploaded files.
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...
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 SQL100520030335050 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
_vcc_freeselect_bottom_