FOLDERITEM

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