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 Description(s):
Column NameColumn TypeDescription
CMFILE_ID BIGINT NOT NULL The numeric identifier of the managed file.
CONTENT_WORKSPACE CHAR(25) NOT NULL 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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031214820 CMFILE_ID+CONTENT_WORKSPACE Primary Key

Feedback