FILEUPLOAD

This table contains the information of uploaded files for the catalog import feature in HCL Commerce Accelerator.

Column Descriptions:

Name	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)	The file type. Currently we only support CSV file type.
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 = Canceled.
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>	FILEUPLOAD_ID	Primary Key
I0000295	FILEPATH+VERSION	Unique Index
I0000296	STORE_ID	Non-Unique Index
I0000571	SCCJOBREFNUM	Non-Unique Index
I0000572	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_984	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_985	SCCJOBREFNUM	SCHCONFIG	SCCJOBREFNUM	Cascade
F_986	STORE_ID	STORE	STORE_ID	Cascade