키오스크

테이블 (3)

Buy (구매 로그)

  • user_id (foreign_key) — int — 외래 키 → User.user_id
  • product_id (auto_increment2) — int — 외래 키 → Product.product_id — NOT NULL
  • quantity (Field) — int

Product (상품)

  • product_id (auto_increment) — int — 기본 키 — NOT NULL
  • product_name (Field3) — varchar2(20)
  • price (Field4) — int

User (유저)

  • user_id (auto_increment) — int — 기본 키
  • email (Field2) — varchar2(50)
  • password (Field3) — varchar2(50)