Oracle ATG Web Commerce uses the following tables to store information about commerce users:

dps_credit_card

This table contains information that describes a credit card.

Column

Data Type

Constraint

id

VARCHAR(40)

NOT NULL

(primary key)

The unique identifier associated with the credit card.

credit_card_number

VARCHAR(40)

NULL

The credit card number.

credit_card_type

VARCHAR(40)

NULL

The type of the credit card.

expiration_month

VARCHAR(20)

NULL

The month the credit card expires.

exp_day_of_month

VARCHAR(20)

NULL

The day of the month the credit card expires.

expiration_year

VARCHAR(20)

NULL

The year the credit card expires.

billing_addr

VARCHAR(40)

NULL

The billing address of the credit card. References dps_contact_info(id)

dcs_user

This table contains information about a user’s credit card and price lists.

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

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

allow_partial_ship

TINYINT

NULL CHECK (allow_partial_ship in (01))

Determines whether the user will allow partial shipment of an order.

default_creditcard

VARCHAR(40)

NULL

The Unique identifier associated with the user’s default credit card. References dps_credit_card(id)

daytime_phone_num

VARCHAR(20)

NULL

The user’s daytime phone number.

express_checkout

TINYINT

NULL CHECK(express_checkout in (01))

Determines whether the user has chosen the express checkout option.

default_carrier

VARCHAR(256)

NULL

The default mail carrier for the order.

price_list

VARCHAR(40)

NULL

The price list assigned to the user; reference to  dcs_price_list.price_list_id.

sale_price_list

VARCHAR(40)

NULL

The sale price list assigned to the user; reference to  dcs_price_list.price_list_id.

dps_usr_creditcard

This table models a java.util.Map object. It allows a user to store a collection of named credit cards.

Column

Data Type

Constraint

 

user_id

VARCHAR(40)

NOT NULL

(primary key)

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

 

tag

VARCHAR(42)

NOT NULL

(primary key)

The user’s chosen name for the credit card.

 

credit_card_id

VARCHAR(40)

NOT NULL

The unique identifier associated with the credit card. References dps_credit_card(id)