테이블 명세 보고서

테이블 (4)

customers

  • Key (customer_id) — not null — 기본 키 — NOT NULL
  • Field (name) — not null
  • Field (email) — not null
  • Field (password) — not null
  • Field (address) — not null
  • Field (phone_number) — not null

order_items (Untitled)

  • Key (product_id) — not null — 기본 키 — NOT NULL
  • Field (quantity) — not null
  • Field (price) — not null
  • Key (order_id) — not null — 외래 키 → orders.Key — NOT NULL

orders

  • Key (order_id) — not null — 기본 키 — NOT NULL
  • Field (order_date) — not null
  • Key (customer_id) — not null — 외래 키 → customers.Key — NOT NULL

products (Untitled2)

  • Field (name) — not null
  • Field (description)
  • Field (price) — not null
  • Key (product_id) — not null — 외래 키 → order_items.Key — NOT NULL