Holds the relationships between folders and objects
in folders. The same object can be in different folders and there
will be one row in this table for each folder that object is
contained in.
Column Descriptions:
Name | Type | Description |
FOLDERITEM_ID | BIGINT NOT NULL | The unique ID of the relationship between a
folder and an object in a folder. |
FOLDER_ID | BIGINT NOT NULL | The unique ID of the folder this object is
contained in. |
REFERENCE_ID | BIGINT NOT NULL | The unique ID of the object this relationship is
pointing to. For example, if this object is pointing to a promotion
then then this field is the value of the px_promotion_id for that
promotion. |
FOLDERITEMTYPE | VARCHAR (128) NOT NULL | The name of the Logical noun which represents the
object being referenced. For example PromotionType if this
folderitem refers to a promotion. |
STOREENT_ID | INTEGER NOT NULL | The ID of the store which owns the object being
referenced. For example if a promotion is being referenced then
this field would be the store ID that owns that promotion. Note
that this field is NOT the store that owns the relationship. |
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. |
Indexes:
Name | Column Names | Type |
P_0010 | FOLDERITEM_ID | Primary Key |
I0001456 | FOLDER_ID+FOLDERITEMTYPE+REFERENCE_ID | Unique Index |
I0001455 | FOLDERITEMTYPE | Non-Unique Index |
I0001461 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3728 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_3729 | FOLDER_ID | FOLDER | FOLDER_ID | Cascade |