WebSphere Commerce database table: CMFILEDIR

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000931 CMFILEDIR_PARENT+IDENTIFIER Unique Index
SQL050212031213020 CMFILEDIR_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1157 CMFILEDIR_PARENT CMFILEDIR CMFILEDIR_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1188 CMFILEDIR_ID CMFILE CMFILEDIR_ID Cascade
F_1157 CMFILEDIR_PARENT CMFILEDIR CMFILEDIR_ID Cascade

Feedback