UPLOADFILE

Stores all the information related to an uploaded file.

Column Descriptions:

Name	Type	Description
UPLOADFILE_ID	BIGINT NOT NULL	Generated primary key.
MEMBER_ID	BIGINT	The identifier of the user that uploaded the file.
STORE_ID	INTEGER	The store to which the uploaded file belongs.
OBJECTID	VARCHAR (64)	The identifier of the object associated with the uploaded file.
UPLOADTYPE	VARCHAR (32)	The type of upload such as CatalogImport.
PROPERTIES	VARCHAR (1000)	Some extra name value pairs such as catalogId and workspace related context data.
UPLOADTIME	TIMESTAMP	The time the file is uploaded to the server.
FILEPATH	VARCHAR (254)	The full path of the uploaded file on the server.
FILENAME	VARCHAR (254)	The name of the file uploaded.
FILESIZE	BIGINT	The size of the uploaded file in bytes.
FILEENCODING	VARCHAR (128)	The file encoding such as UTF8 and ISO8859-1.
FILECONTENT	BLOB (300000000)	The content of the file.
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>	UPLOADFILE_ID	Primary Key
I0001308	UPLOADTYPE+STORE_ID+OBJECTID	Non-Unique Index
I0001309	MEMBER_ID	Non-Unique Index
I0001310	STORE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3599	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_3600	STORE_ID	STORE	STORE_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3602	UPLOADFILE_ID	FILEPROCREL	UPLOADFILE_ID	Cascade