Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ATTRDICTGRPREL

Defines the relationships between attribute dictionary attribute groups. An attribute dictionary attribute group can have only one parent group.

Column Name Column Type Description
ATTRDICTGRP_PARENT BIGINT NOT NULL The internal reference number of the parent attribute group.
ATTRDICTGRP_CHILD BIGINT NOT NULL The internal reference number of the child attribute group.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0001137 ATTRDICTGRP_CHILD Unique Index
SQL100520030259660 ATTRDICTGRP_PARENT+ATTRDICTGRP_CHILD Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3513 ATTRDICTGRP_PARENT ATTRDICTGRP ATTRDICTGRP_ID Cascade
F_3514 ATTRDICTGRP_CHILD ATTRDICTGRP ATTRDICTGRP_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search