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_