CMFILE

Contains the list of all the files that are content managed along with additional meta data.

Column Descriptions:

NameTypeDescription
CMFILE_IDBIGINT NOT NULLA numeric identifier to uniquely distinguish the managed file.
CMFILEPATHVARCHAR (254) NOT NULLThe 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_FSSMALLINT NOT NULL DEFAULT 0Indicator to determine whether the current managed file has been promoted to the file system. Valid values are:
0
Not promoted
1
Promoted
2
Mark for delete from file system
UPLOAD_TIMESTAMPTIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMPThe timestamp when the managed file was uploaded to the system.
PROMOTE_TIMESTAMPTIMESTAMPThe timestamp when the file was promoted from the content management system to the actual file system.
ASSOCIATEDSMALLINT NOT NULL DEFAULT 0Indicator to determine whether the managed file is already associated with an attachment.
0
Not associated with an attachment
1
Associated with an attachment
STORAGE_TYPESMALLINT NOT NULL DEFAULT 0An indicator to determine whether the file is stored.
0
CMSMALLFILE
1
CMLARGEFILE
-1
Not stored at all, or stored in another content management system
CMFILEDIR_IDBIGINT NOT NULLThe unique identifier for the directory in which the managed file is stored.
FILESIZEBIGINT DEFAULT 0The size of the file.
PUBLISHEDSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use. This flag is used to indicated the managed file has been propagated into the production environment.
UP_CMFILEPATHVARCHAR (254)The equivalent value of the CMFILEPATH column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CMFILE_IDPrimary Key
I0000897CMFILEPATHUnique Index
I0000934CMFILEDIR_IDNon-Unique Index
IPF00024UP_CMFILEPATHNon-Unique Index