FILEUPLOAD

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

Column Descriptions:

NameTypeDescription
FILEUPLOAD_IDBIGINT NOT NULLGenerated key.
MEMBER_IDBIGINTThe ID of the member who uploads the file.
STORE_IDINTEGERThe store to which the uploaded file belongs.
SCCJOBREFNUMBIGINTThe scheduler job which processes the file.
FILEPATHVARCHAR (254) NOT NULLThe directory path of the file to be uploaded.
FILENAMEVARCHAR (254)The name of the file to be uploaded.
FILESIZEBIGINTThe size of the file to be uploaded.
FILETYPECHAR (50)The file type. Currently we only support CSV file type.
FILEENCODINGVARCHAR (128)The file encoding. For example, UTF8, ISO8859-1, and so on.
UPLOADTIMETIMESTAMPTime when the file uploaded.
HOSTNAMECHAR (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.
VERSIONINTEGER NOT NULLThe version of uploaded file. The same file can be uploaded more than once.
STATUSINTEGER NOT NULL DEFAULT 0The file process status. Valid values are as follows: 0 = New, 1 = Processing, 2 = Processed, 3 = Failed, 4 = Canceled.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>FILEUPLOAD_IDPrimary Key
I0000295FILEPATH+VERSIONUnique Index
I0000296STORE_IDNon-Unique Index
I0000571SCCJOBREFNUMNon-Unique Index
I0000572MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_984MEMBER_IDMEMBERMEMBER_IDCascade
F_985SCCJOBREFNUMSCHCONFIGSCCJOBREFNUMCascade
F_986STORE_IDSTORESTORE_IDCascade