Oracle ATG Web 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 | Description |
---|---|---|---|
| varchar(40) | not null | 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 | Specifies whether or not this gift list is public or private. Checks |
| numeric(1) | not null | Specifies whether or not the gift list is published. Checks |
| 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 |
| varchar(40) | null | ID of the site on which the gift list was created. Used by the multisite feature. |
dcs_giftinst
This table contains information about instructions associated with gifts.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the gift list. References |
| varchar(42) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | 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 | null | The number of items that have already been purchased from the list. |
| varchar(40) | null | ID of the site with which the item is associated, if any. |
dcs_giftlist_item
This table stores a map of items for a given gift list.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the gift list. References |
| int | not null | Used to order rows in this table. |
| varchar(40) | not null | The ID associated with an item on the gift list. References |
| varchar(40) | null | ID of the site on which the gift list was created. Used by the multisite feature. |
dcs_user_wishlist
This table stores a map of gift lists created by a given user.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the user who owns the gift list. References |
| int | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the user. References |
| int | not null | Used to order rows in this table. |
| varchar(40) | null | The ID associated with the user’s gift list. References |