Reference > Database > WebSphere Commerce database tables > U


WebSphere Commerce database table: UPLOADFILE

Stores all the information related to an uploaded file.

Column Name Column Type Description
UPLOADFILE_ID BIGINT NOT NULL The unique identifier of the uploaded file.
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 The content of the file.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030704700 UPLOADFILE_ID Primary Key
I0001308 UPLOADTYPE+STORE_ID+OBJECTID Non-Unique Index
I0001309 MEMBER_ID Non-Unique Index
I0001310 STORE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3599 MEMBER_ID MEMBER MEMBER_ID Cascade
F_3600 STORE_ID STORE STORE_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_3602 UPLOADFILE_ID FILEPROCREL UPLOADFILE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search