Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: 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 Name Column 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 a business account is marked for deletion. Valid values are... 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001135 IDENTIFIER+ATTRDICT_ID Unique Index SQL100520030259200 ATTRDICTGRP_ID Primary Key I0001187 STOREENT_ID Non-Unique Index I0001188 ATTRDICT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3506 ATTRDICT_ID ATTRDICT ATTRDICT_ID Cascade F_3511 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3564 ATTRDICTGRP_ID ATTRDICTGRPATTRREL ATTRDICTGRP_ID Cascade F_3512 ATTRDICTGRP_ID ATTRDICTGRPDESC ATTRDICTGRP_ID Cascade F_3514 ATTRDICTGRP_CHILD ATTRDICTGRPREL ATTRDICTGRP_ID Cascade F_3513 ATTRDICTGRP_PARENT ATTRDICTGRPREL ATTRDICTGRP_ID Cascade _vcc_freeselect_bottom_