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