Shopping

Tables (3)

CUSTOMER

  • customer_id — VARCHAR(36) — Primary key
  • name — VARCHAR(255)
  • email — VARCHAR(255)
  • address — VARCHAR(255)

ORDER

  • order_id — VARCHAR(36) — Primary key
  • order_date — DATETIME
  • quantity — INT
  • customer_id — VARCHAR(36) — Foreign key → CUSTOMER.customer_id
  • product_id — VARCHAR(36) — Foreign key → PRODUCT.product_id

PRODUCT

  • product_id — VARCHAR(36) — Primary key
  • name — VARCHAR(255)
  • category — VARCHAR(255)
  • price — DECIMAL(10, 2)