This table stores personalization attributes for
gift registry and wish list items, such as monogramming.
Column Descriptions:
Name | Type | Description |
PERATTR_ID | VARCHAR (64) NOT NULL | Refers to a monogramming attribute or other
attributes. |
GIFTITEM_ID | BIGINT NOT NULL | Refers to the item requiring
personalization. |
OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
VALUE | VARCHAR (64) | The value of the attribute. It is up to the user
of this value to interpret its type and meaning. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | GIFTITEM_ID+PERATTR_ID | Primary Key |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
GRA_CONSTRAINT4 | GIFTITEM_ID | GRGFTITM | GIFTITEM_ID | Cascade |