WebSphere Commerce database table: FOLDER

FOLDER

Holds information about folders. Folders are a generic implementation of a folder 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:

Name Type Description
FOLDER_ID BIGINT NOT NULL The unique ID of the folder.
STOREENT_ID INTEGER NOT NULL The ID of the store that owns the folder. A value of -1 indicates that the folder belongs to all stores.
MEMBER_ID BIGINT The ID of the member who owns this folder or NULL if this folder is not member specific.
PARENTFOLDER_ID BIGINT The unique ID of the folder which is the parent of a folder or NULL if this is a top level folder.
IDENTIFIER VARCHAR (256) NOT NULL The identifier of a folder. A folder's identifier must be unique within the same parent folder.
DESCRIPTION VARCHAR (256) The administrative description of the folder. This field is not language sensitive.
TYPE VARCHAR (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.
FIELD1 INTEGER Custom field 1.
FIELD2 VARCHAR (256) Custom field 2.
FIELD3 VARCHAR (256) Custom field 3.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
UP_IDENTIFIER VARCHAR (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:

Name Column Names Type
P_0009 FOLDER_ID Primary Key
I0001453 PARENTFOLDER_ID+TYPE+IDENTIFIER+STOREENT_ID+MEMBER_ID Unique Index
I0001454 STOREENT_ID+IDENTIFIER Non-Unique Index
IPF00033 UP_IDENTIFIER Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_3727 STOREENT_ID STOREENT STOREENT_ID No Action

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3729 FOLDER_ID FOLDERITEM FOLDER_ID Cascade

Related reference
Folder data model

Name	Type	Description
FOLDER_ID	BIGINT NOT NULL	The unique ID of the folder.
STOREENT_ID	INTEGER NOT NULL	The ID of the store that owns the folder. A value of -1 indicates that the folder belongs to all stores.
MEMBER_ID	BIGINT	The ID of the member who owns this folder or NULL if this folder is not member specific.
PARENTFOLDER_ID	BIGINT	The unique ID of the folder which is the parent of a folder or NULL if this is a top level folder.
IDENTIFIER	VARCHAR (256) NOT NULL	The identifier of a folder. A folder's identifier must be unique within the same parent folder.
DESCRIPTION	VARCHAR (256)	The administrative description of the folder. This field is not language sensitive.
TYPE	VARCHAR (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.
FIELD1	INTEGER	Custom field 1.
FIELD2	VARCHAR (256)	Custom field 2.
FIELD3	VARCHAR (256)	Custom field 3.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
UP_IDENTIFIER	VARCHAR (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.

Name	Column Names	Type
P_0009	FOLDER_ID	Primary Key
I0001453	PARENTFOLDER_ID+TYPE+IDENTIFIER+STOREENT_ID+MEMBER_ID	Unique Index
I0001454	STOREENT_ID+IDENTIFIER	Non-Unique Index
IPF00033	UP_IDENTIFIER	Non-Unique Index