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:

Name	Type	Description
ATTRDICTGRP_ID	BIGINT NOT NULL	The internal reference number of the attribute group.
IDENTIFIER	VARCHAR (254) NOT NULL	The external unique identifier for this attribute group.
ATTRDICT_ID	BIGINT NOT NULL	The internal reference number of the attribute dictionary.
STOREENT_ID	INTEGER NOT NULL	The reference number of the StoreEntity that owns this attribute dictionary attribute group.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if attribute dictionary group is marked for deletion. 0 Not marked for deletion 1 Marked for deletion
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	The display order of the attribute groups for a given attribute dictionary.
FIELD1	INTEGER	Customizable.
FIELD2	INTEGER	Customizable.
FIELD3	VARCHAR (254)	Customizable.
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
<SYSTEM-GENERATED>	ATTRDICTGRP_ID	Primary Key
I0001135	IDENTIFIER+ATTRDICT_ID	Unique Index
I0001187	STOREENT_ID	Non-Unique Index
I0001188	ATTRDICT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3506	ATTRDICT_ID	ATTRDICT	ATTRDICT_ID	Cascade
F_3511	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3512	ATTRDICTGRP_ID	ATTRDICTGRPDESC	ATTRDICTGRP_ID	Cascade
F_3513	ATTRDICTGRP_ID	ATTRDICTGRPREL	ATTRDICTGRP_PARENT	Cascade
F_3514	ATTRDICTGRP_ID	ATTRDICTGRPREL	ATTRDICTGRP_CHILD	Cascade
F_3564	ATTRDICTGRP_ID	ATTRDICTGRPATTRREL	ATTRDICTGRP_ID	Cascade