CMFILEDIR

Reserved for HCL internal use. This table contains directory structures for the content managed files.

Column Descriptions:

NameTypeDescription
CMFILEDIR_IDBIGINT NOT NULLA numeric identifier to uniquely distinguish the managed file directory.
CMFILEDIR_PARENTBIGINTThe parent directory ID of the content managed file directory. Foreign key to CMFILEDIR table.
IDENTIFIERVARCHAR (100) NOT NULLThe directory identifier. The string which uniquely identify the directory under the same parent directory. This is the same as the DISPLAYNAME except that all characters are in lower case.
DISPLAYNAMEVARCHAR (100) NOT NULLThe directory display name. The directory name which can be used to display to the user.
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>CMFILEDIR_IDPrimary Key
I0000931CMFILEDIR_PARENT+IDENTIFIERUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1157CMFILEDIR_PARENTCMFILEDIRCMFILEDIR_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1157CMFILEDIR_IDCMFILEDIRCMFILEDIR_PARENTCascade