FOLDER

Holds information about folders. Folders are a generic implementation of a foldering concept that allow for any type of object to be organized into a hierarchy. The same object can be in multiple folders but a sub folder can only have a single parent.

Column Descriptions:

NameTypeDescription
FOLDER_IDBIGINT NOT NULLThe unique ID of the folder.
STOREENT_IDINTEGER NOT NULLThe ID of the store that owns the folder.
MEMBER_IDBIGINTThe ID of the member who owns this folder or NULL if this folder is not member specific.
PARENTFOLDER_IDBIGINTThe unique ID of the folder which is the parent of a folder or NULL if this is a top level folder.
IDENTIFIERVARCHAR (256) NOT NULLThe identifier of a folder. A folder's identifier must be unique within the same parent folder.
DESCRIPTIONVARCHAR (256)The administrative description of the folder. This field is not language sensitive.
TYPEVARCHAR (128)The type of folder. This field is used to identify which tool will use this folder. For example 'IBM_PromotionFolder' is used for folders in the Management Center Promotions tooling.
FIELD1INTEGERCustom field 1.
FIELD2VARCHAR (256)Custom field 2.
FIELD3VARCHAR (256)Custom field 3.
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.
UP_IDENTIFIERVARCHAR (256)The equivalent value of the IDENTIFIER 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.

Indexes:

NameColumn NamesType
P_0009FOLDER_IDPrimary Key
I0001453 PARENTFOLDER_ID+TYPE+IDENTIFIER+STOREENT_ID+MEMBER_IDUnique Index
I0001454STOREENT_ID+IDENTIFIERNon-Unique Index
IPF00033UP_IDENTIFIERNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3727STOREENT_IDSTOREENTSTOREENT_IDNo Action

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3729FOLDER_IDFOLDERITEMFOLDER_IDCascade