Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMFILE
Contains the list of all the files that are content managed along with additional meta data.
Column Name Column Type Description CMFILE_ID BIGINT NOT NULL A numeric identifier to unique distiquish the managed file. CMFILEPATH VARCHAR(254) NOT NULL The full path name of the file. This includes the current and parent directories the file resides in along with the actual file name. For example: /storeA/images/image.gif PROMOTE_FS SMALLINT NOT NULL DEFAULT 0 Indicator to determine whether the current managed file has been promoted to the file system. Valid values are...
- 0 = not promoted
- 1 = promoted
UPLOAD_TIMESTAMP TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP The timestamp when the managed file was uploaded to the system. PROMOTE_TIMESTAMP TIMESTAMP The timestamp when the file was promoted from the content management system to the actual file system. ASSOCIATED SMALLINT NOT NULL DEFAULT 0 Indicator to determine whether the managed file is already associated with an attachment. STORAGE_TYPE SMALLINT NOT NULL DEFAULT 0 An indicator to determine whether the file is stored. Depending on the value, the file may be stored in either CMSMALLFILE (0), CMLARGEFILE (1), not stored at all (-1) or someother content management system. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use. CMFILEDIR_ID BIGINT NOT NULL The unique identifier for the directory in which the managed file is stored. FILESIZE BIGINT DEFAULT 0 The size of the file. PUBLISHED SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use. This flag is used to indicated the managed file has been propagated into the production server.
Indexes Index Name Indexed Column Names Index Type I0000897 CMFILEPATH Unique Index SQL100520030315800 CMFILE_ID Primary Key I0000934 CMFILEDIR_ID Non-Unique Index _vcc_freeselect_bottom_