Oracle ATG Web Commerce uses the following table to store information about shopping cart events:
dcs_cart_event
This table contains information about a shopping cart event, either adding or removing an item.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | Describes whether this event was an add to the cart, or a remove from the cart. |
| date | null | Date and time the item was added or removed from the cart. |
| varchar (40) | null | The order ID associated with the given shopping cart. |
| varchar (40) | null | The SKU ID of the item that was added or removed. |
| integer | null | The quantity of the item that was added or removed. |
| number(19,7) | null | The total price of the item(s) added or removed. |
| varchar (40) | null | The profile ID of the user associated with the request when this message is sent in the context of an HTTP request. |
| varchar (100) | null | The current session ID associated with the request when this message is sent in the context of an HTTP request. |
| varchar (100) | null | The parent session ID. This ID may be different from the request’s current session ID on application servers that use a separate session ID for each Web application. |