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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the credit card. |
| varchar(40) | not null | The credit card number. |
| varchar(40) | not 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 and price lists.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the user. References |
| tiny int | null | Determines whether the user will allow partial shipment of an order. Checks |
| varchar(40) | null | The Unique identifier associated with the user’s default credit card. References |
| varchar(20) | null | The user’s daytime phone number. |
| tiny int | null | Determines whether the user has chosen the express checkout option. Checks |
| varchar(256) | null | The default mail carrier for the order. |
| varchar(40) | null | The price list assigned to the user; reference to |
| varchar(40) | null | The sale price list assigned to the user; reference to |
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 | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the user. References |
| varchar (42) | not null | The user’s chosen name for the credit card. |
| varchar (40) | not null | The unique identifier associated with the credit card. References |