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:

NameTypeDescription
FOLDERITEM_IDBIGINT NOT NULLThe unique ID of the relationship between a folder and an object in a folder.
FOLDER_IDBIGINT NOT NULLThe unique ID of the folder this object is contained in.
REFERENCE_IDBIGINT NOT NULLThe 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.
FOLDERITEMTYPEVARCHAR (128) NOT NULLThe name of the Logical noun which represents the object being referenced. For example PromotionType if this folderitem refers to a promotion.
STOREENT_IDINTEGER NOT NULLThe 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.
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.

Indexes:

NameColumn NamesType
P_0010FOLDERITEM_IDPrimary Key
I0001456FOLDER_ID+FOLDERITEMTYPE+REFERENCE_IDUnique Index
I0001455FOLDERITEMTYPENon-Unique Index
I0001461STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3728STOREENT_IDSTOREENTSTOREENT_IDCascade
F_3729FOLDER_IDFOLDERFOLDER_IDCascade