eCommerce Database (ERD)

title {label: "E-commerce schema", size: "16"}

[Customer] {bgcolor: "#d0e0d0"}
  *customer_id {label: "int, not null"}
  name {label: "varchar, null"}
  email {label: "varchar, not null"}

[Product] {bgcolor: "#d0e0d0"}
  *product_id {label: "int, not null"}
  name {label: "varchar, not null"}
  price {label: "decimal, not null"}

[Order] {bgcolor: "#ececfc"}
  *order_id {label: "int, not null"}
  +customer_id {label: "int, not null"}
  order_date {label: "date, not null"}
  total {label: "decimal, null"}

[OrderItem] {bgcolor: "#ececfc"}
  *+order_id {label: "int, not null"}
  *+product_id {label: "int, not null"}
  quantity {label: "int, not null"}
  price {label: "decimal, not null"}

Customer 1--* Order
Order 1--* OrderItem
Product 1--* OrderItem