Contains the list of all the files that are content managed along with additional meta data.
Column Description(s):
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 as follows:
- 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000897 |
CMFILEPATH |
Unique Index |
SQL050212031212900 |
CMFILE_ID |
Primary Key |
I0000934 |
CMFILEDIR_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1188 |
CMFILEDIR_ID |
CMFILEDIR |
CMFILEDIR_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.