Its value uniquely identifies a shopping cart record.
??? cart_id is a CHAR(32) value that uniquely identifies a visitor??™s shopping cart (as opposed to just one
shopping cart record).
??? product_id references the ID of an existing product.
CHAPTER 12 ?– CREATING YOUR OWN SHOPPING CART 366
??? attributes is a varying character field that stores the attributes that were selected by the visitor when
adding the product to the shopping cart. A possible value of this field can be, for example, "Color/Size:
White/XL".
??? quantity stores the product quantity in the shopping cart.
??? buy_now is a Boolean field with the default value of true that supports the ???Save for later??? feature. When
the customer checks out, only the products that have this value set to true are added to the order, whereas
the ???Save for later??? products remain in the shopping cart.
??? added_on is a date field that is populated with the date the product was added to the cart. This value is
used to calculate the age of a shopping cart, which gives us the ability to delete old shopping carts from the
database.
The value of the first field, item_id, is calculated every time a new record is created in the table. No surprises
here??”you have worked with AUTO_INCREMENT columns before.
The value of cart_id represents the ID of the shopping cart. This value is calculated by the business tier each
time a new shopping cart is created.
Pages:
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474