id
(primary key)

varchar(40)

not null

The unique identifier associated with the credit card.

credit_card_number

varchar(40)

not null

The credit card number.

credit_card_type

varchar(40)

not 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).

user_id
(primary key)

varchar(40)

not null

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

allow_partial_ship

tiny int

null

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

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

tiny int

null

Determines whether the user has chosen the express checkout option. Checks express_checkout in (01).

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.

user_id
(primary key)

varchar (40)

not null

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

tag
(primary key)

varchar (42)

not null

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).