lab3

테이블 (3)

Untitled (Product)

  • Key (product_no) — INTEGER — 기본 키 — NOT NULL
  • Field (product_name) — VARCHAR(30) — NOT NULL
  • Field (unit_price) — INTEGER — NOT NULL
  • Field (description) — VARCHAR(30)
  • Field (category_no) — INTEGER

Untitled (customer)

  • Key (customer_no) — INTEGER — 기본 키 — NOT NULL
  • Field (customer_name) — VARCHAR(30)
  • Field (email) — VARCHAR(30)
  • Field (password) — VARCHAR(30)

카테고리 (Category)

  • Key (category_no) — INTEGER — 기본 키 — NOT NULL
  • Field (category_name) — VARCHAR(30) — NOT NULL