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: