Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CMSMALLFILE

Contains the physical bytes that makes up a particular managed file. This table contains only the contents of those files that are less then or equal to 32K and have a storage type of 0 in the CMFILE table.

Column Name Column Type Description
CMFILE_ID BIGINT NOT NULL The numeric identifier of the managed file.
CONTENT_WORKSPACE CHAR(25) The current workspace with which the file contents is associated.
CMFILE BLOB The physical bytes of the managed file.
CONTENT_OLD_WKSP CHAR(25) The previous workspace with which the file contents was associated.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000428 CMFILE_ID+CONTENT_WORKSPACE Unique Index

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search