ATTRDICTGRP

Table used to store attribute dictionary attribute groups. These groups are a convenience mechanism used during administration of the attribute dictionary and when assigning attribute dictionary attributes to catalog entries or catalog groups. Attributes can belong to zero or more attribute groups.

Column Descriptions:

NameTypeDescription
ATTRDICTGRP_IDBIGINT NOT NULLThe internal reference number of the attribute group.
IDENTIFIERVARCHAR (254) NOT NULLThe external unique identifier for this attribute group.
ATTRDICT_IDBIGINT NOT NULLThe internal reference number of the attribute dictionary.
STOREENT_IDINTEGER NOT NULLThe reference number of the StoreEntity that owns this attribute dictionary attribute group.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if attribute dictionary group is marked for deletion.
0
Not marked for deletion
1
Marked for deletion
SEQUENCEDOUBLE NOT NULL DEFAULT 0The display order of the attribute groups for a given attribute dictionary.
FIELD1INTEGERCustomizable.
FIELD2INTEGERCustomizable.
FIELD3VARCHAR (254)Customizable.
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
<SYSTEM-GENERATED>ATTRDICTGRP_IDPrimary Key
I0001135IDENTIFIER+ATTRDICT_IDUnique Index
I0001187STOREENT_IDNon-Unique Index
I0001188ATTRDICT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3506ATTRDICT_IDATTRDICTATTRDICT_IDCascade
F_3511STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3512ATTRDICTGRP_IDATTRDICTGRPDESCATTRDICTGRP_IDCascade
F_3513ATTRDICTGRP_IDATTRDICTGRPRELATTRDICTGRP_PARENTCascade
F_3514ATTRDICTGRP_IDATTRDICTGRPRELATTRDICTGRP_CHILDCascade
F_3564ATTRDICTGRP_IDATTRDICTGRPATTRRELATTRDICTGRP_IDCascade