ATG 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the credit card. | |
| VARCHAR(40) | NULL |
The credit card number. | ||
| VARCHAR(40) | NULL |
The type of the credit card. | ||
| VARCHAR(20) | NULL |
The month the credit card expires. | ||
| VARCHAR(20) | NULL |
The day of the month the credit card expires. | ||
| VARCHAR(20) | NULL |
The year the credit card expires. | ||
| VARCHAR(40) | NULL |
The billing address of the credit card. References |
dcs_user
This table contains information about a user’s credit card.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the user. References | |
| TINYINT | NULL CHECK |
Determines whether the user will allow partial shipment of an order. | ||
| VARCHAR(40) | NULL |
The Unique identifier associated with the user’s default credit card. References | ||
| VARCHAR(20) | NULL |
The user’s daytime phone number. | ||
| TINYINT | NULL CHECK |
Determines whether the user has chosen the express checkout option. | ||
| VARCHAR(256) | NULL |
The default mail carrier for the order. |
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 | |
---|---|---|---|
| VARCHAR(40) | NOT NULL | |
(primary key) | The unique identifier associated with the user. References | ||
| VARCHAR(42) | NOT NULL | |
(primary key) | The user’s chosen name for the credit card. | ||
| VARCHAR(40) | NOT NULL | |
The unique identifier associated with the credit card. References |