Contains the list of all the files that are content
managed along with additional meta data.
Column Descriptions:
| Name | Type | Description |
| CMFILE_ID | BIGINT NOT NULL | A numeric identifier to uniquely distinguish 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
- 2
- Mark for delete from file system
|
| 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.
- 0
- Not associated with an attachment
- 1
- Associated with an attachment
|
| STORAGE_TYPE | SMALLINT NOT NULL DEFAULT 0 | An 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_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 HCL internal use. This flag is used
to indicated the managed file has been propagated into the
production environment. |
| UP_CMFILEPATH | VARCHAR (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. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | CMFILE_ID | Primary Key |
| I0000897 | CMFILEPATH | Unique Index |
| I0000934 | CMFILEDIR_ID | Non-Unique Index |
| IPF00024 | UP_CMFILEPATH | Non-Unique Index |