키오스크
테이블 (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)