title

테이블 (3)

상품 (Untitled2)

  • id (PK) — int — 기본 키 — NOT NULL
  • name (P_name) — char
  • price (P_price) — int
  • stock (P_stock) — int

주문 (Untitled3)

  • id (order_id) — int — 기본 키 — NOT NULL
  • client_id — int — 외래 키 → 회원.id — NOT NULL
  • product_id (PK) — int — 외래 키 → 상품.id — NOT NULL
  • date (order_date) — int
  • quantity — int

회원 (client_number)

  • id (client_id) — int — 기본 키 — NOT NULL
  • name (client_name) — char
  • email (client_emali) — char
  • phone (client_phone) — int