E-commerce database schemas

What a E-commerce schema usually contains

Orders are the awkward part of an e-commerce schema: a line item has to remember the price it was bought at, not the price the product carries now. These templates keep products, variants, carts and orders separate so history survives a price change.