ATG Commerce Programming Guide

id

VARCHAR(40)

NOT NULL

(primary key)

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 CHECK (is_public in (0,1))

Specifies whether or not this gift list is public or private.

is_published

NUMERIC(1)

NOT NULL CHECK (is_published in (0,1))

Specifies whether or not the gift list is published.

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)

giftlist_id

VARCHAR(40)

NOT NULL

(primary key)

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

tag

VARCHAR(42)

NOT NULL

(primary key)

The identifier for the gift list instruction.

special_inst

VARCHAR(254)

NULL

Any special instructions associated with the gift.

id

VARCHAR(40)

NOT NULL

(primary key)

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

NUL

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

giftlist_id

VARCHAR(40)

NOT NULL

(primary key)

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

sequence_num

INT

NOT NULL

(primary key)

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)

user_id

VARCHAR(40)

NOT NULL

(primary key)

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)

user_id

VARCHAR(40)

NOT NULL

(primary key)

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

sequence_num

INT

NOT NULL

(primary key)

Used to order rows in this table.

giftlist_id

VARCHAR(40)

NULL

The ID associated with the user’s gift list.

user_id

VARCHAR(40)

NOT NULL

(primary key)

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

sequence_num

INT

NOT NULL

(primary key)

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)