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:
| 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. |
| 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 |