ATG Commerce uses the following tables to store information about gift lists and wish lists:
dcs_giftlist
This table contains information about gift lists.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the gift list. | |
| VARCHAR(40) | NULL |
The ID of the user who owns the gift list. References | ||
| NUMERIC(1) | NOT NULL CHECK |
Specifies whether or not this gift list is public or private. | ||
| NUMERIC(1) | NOT NULL CHECK |
Specifies whether or not the gift list is published. | ||
| VARCHAR(64) | NULL |
The name of an event. | ||
| INT | NULL |
Enumerated type of events, for example, a birthday. | ||
| DATE | NULL |
The date on which the event took place. | ||
| VARCHAR(254) | NULL |
Comments associated with the gift list. | ||
| VARCHAR(254) | NULL |
A text description of the gift list. | ||
| VARCHAR(254) | NULL |
Any special instructions associated with the gift list. | ||
| DATE | NULL |
The date the gift list was created. | ||
| DATE | NULL |
The date the gift list was last modified. | ||
| VARCHAR(40) | NULL |
The ID of the shipping address of the user who owns the gift list. References |
dcs_giftinst
This table contains information about instructions associated with gifts.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the gift list. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | The identifier for the gift list instruction. | |
| VARCHAR(254) | NULL |
Any special instructions associated with the gift. |
dcs_giftitem
This table contains information about an item in a gift list.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of an item on the gift list. | |
| VARCHAR(40) | NULL |
The SKU ID. | ||
| VARCHAR(40) | NULL |
The product ID. | ||
| VARCHAR(254) | NULL |
The visible name of the item on the gift list. | ||
| VARCHAR(254) | NULL |
A short text description of the item on the gift list. | ||
| INT | NULL |
The number of items that the person creating the list would like to receive.. | ||
| INT | NUL |
The number of items that have already been purchased from the list. |
dcs_giftlist_item
This table stores a map of items for a given gift list.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the gift list. References | |
| INT | NOT NULL |
(primary key) | Used to order rows in this table. | |
| VARCHAR(40) | NOT NULL |
The ID associated with an item on the gift list. References |
dcs_user_wishlist
This table stores a map of gift lists created by a given user.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the user who owns the wish list. References | |
| VARCHAR(40) | NULL |
The ID of the user’s gift list. References |
dcs_user_giftlist
This table stores the map of other gift lists for which a user is currently shopping.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the user who owns the gift list. References | |
| INT | NOT NULL |
(primary key) | Used to order rows in this table. | |
| VARCHAR(40) | NULL |
The ID associated with the user’s gift list. |
dcs_user_otherlist
This table contains information about a user’s other list of items.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the user. References | |
| INT | NOT NULL |
(primary key) | Used to order rows in this table. | |
| VARCHAR(40) | NULL |
The ID associated with the user’s gift list. References |