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

id
(primary key)

varchar(40)

not null

The unique identifier associated with the gift list.

owner_id

varchar(40)

null

The ID of the user who owns the gift list. References dps_user(id).

is_public

numeric(1)

not null

Specifies whether or not this gift list is public or private. Checks is_public in (0,1).

is_published

numeric(1)

not null

Specifies whether or not the gift list is published. Checks is_published in (0,1).

event_name

varchar(64)

null

The name of an event.

event_type

int

null

Enumerated type of events, for example, a birthday.

event_date

date

null

The date on which the event took place.

comments

varchar(254)

null

Comments associated with the gift list.

descriptions

varchar(254)

null

A text description of the gift list.

instructions

varchar(254)

null

Any special instructions associated with the gift list.

creation_date

date

null

The date the gift list was created.

last_modified

date

null

The date the gift list was last modified.

shipping_addr_id

varchar(40)

null

The ID of the shipping address of the user who owns the gift list. References dps_contact_info(id).

site_id

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

giftlist_id
(primary key)

varchar(40)

not null

The unique identifier associated with the gift list. References dcs_giftlist(id).

tag
(primary key)

varchar(42)

not null

The identifier for the gift list instruction.

special_inst

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

id
(primary key)

varchar(40)

not null

The unique identifier of an item on the gift list.

catalog_ref_id

varchar(40)

null

The SKU ID.

product_id

varchar(40)

null

The product ID.

display_name

varchar(254)

null

The visible name of the item on the gift list.

description

varchar(254)

null

A short text description of the item on the gift list.

quantity_desired

int

null

The number of items that the person creating the list would like to receive..

quantity_purchased

int

null

The number of items that have already been purchased from the list.

site_id

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

giftlist_id
(primary key)

varchar(40)

not null

The unique identifier associated with the gift list. References dcs_giftlist (id).

sequence_num
(primary key)

int

not null

Used to order rows in this table.

giftitem_id

varchar(40)

not null

The ID associated with an item on the gift list. References dcs_giftitem(id).

site_id

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

user_id
(primary key)

varchar(40)

not null

The unique identifier associated with the user who owns the wish list. References dps_user(id).

giftlist_id

varchar(40)

null

The ID of the user’s gift list. References dcs_giftlist(id).

dcs_user_giftlist

This table stores the map of other gift lists for which a user is currently shopping.

Column

Data Type

Constraint

Description

user_id
(primary key)

varchar(40)

not null

The unique identifier associated with the user who owns the gift list. References dps_user(id).

sequence_num
(primary key)

int

not null

Used to order rows in this table.

giftlist_id

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

user_id
(primary key)

varchar(40)

not null

The unique identifier associated with the user. References dps_user(id).

sequence_num
(primary key)

int

not null

Used to order rows in this table.

giftlist_id

varchar(40)

null

The ID associated with the user’s gift list. References dcs_giftlist(id).


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices