tttt

Tables (3)

order_items

  • seq — BIGINT — Primary key — NOT NULL
  • order_id — BINARY(16) — Foreign key → orders.order_id — NOT NULL
  • product_id — BINARY(16) — Foreign key → products.product_id
  • category — VARCHAR(50) — NOT NULL
  • price — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6)
  • INDEX — (order_id)

orders

  • order_id — BINARY(16) — Primary key
  • email — VARCHAR(50) — NOT NULL
  • address — VARCHAR(200) — NOT NULL
  • postcode — VARCHAR(200) — NOT NULL
  • order_status — VARCHAR(50) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6)

products

  • product_id — BINARY(16) — Primary key
  • product_name — VARCHAR(20) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • price — BIGINT — NOT NULL
  • description — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6)