Table cart

web interface: stores a customers cart object

Column NameTypePropertiesDocu
cartidstring:32Primary-Key the cookie for this cart
timeoutint64when the cart expires
customeridint32NULL-able Foreign-Key=customer(customerid) ID of the customer connected to this cart.
invoiceaddressint64NULL-able Foreign-Key=address(addressid) If not null: the address the invoice goes to.
deliveryaddressint64NULL-able Foreign-Key=address(addressid) If not null: the address the delivery goes to. If null: assumed to be identical to invoiceaddress.
commenttextNULL-able customer comments during order process
shippingtypeint32NULL-able Foreign-Key=shipping(shipid) pointer to shipping type (none per default, programmatic default is in config)
couponidstring:32NULL-able Foreign-Key=coupon(couponid) If not null: the ID of the coupon that will be used for the order.