Bracelet Shop ER diagram models a complete e-commerce database with User, Product, ProductVariant, and ProductAccessory entities supporting customizable jewelry sales. Data flows from Users through Cart and Order entities, with CartItem and OrderItem managing variant selection, accessories, and pricing snapshots at purchase time. The schema enforces referential integrity via foreign keys and supports user engagement through Review and Favorite tables, enabling personalized shopping experiences. Fork this diagram on Diagrams.so to customize for your bracelet or jewelry storefront, adjust accessory relationships, or extend with inventory management features. The price_snapshot pattern in OrderItem demonstrates best practice for capturing historical pricing at transaction time, protecting revenue reporting from future product price changes.