WebSphere Commerce database table: CMFILEDIR

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

Column Descriptions

Column Name	Column Type	Description
CMFILEDIR_ID	BIGINT NOT NULL	A numeric identifier to uniquely distiquish the managed file directory.
CMFILEDIR_PARENT	BIGINT	The parent directory ID of the content managed file directory. Foreign key to CMFILEDIR table.
IDENTIFIER	VARCHAR(100) NOT NULL	The 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.
DISPLAYNAME	VARCHAR(100) NOT NULL	The directory display name. The directory name which can be used to display to the user.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000931	CMFILEDIR_PARENT+IDENTIFIER	Unique Index
SQL060903235142350	CMFILEDIR_ID	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1157	CMFILEDIR_PARENT	CMFILEDIR	CMFILEDIR_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_1157	CMFILEDIR_PARENT	CMFILEDIR	CMFILEDIR_ID	Cascade