커피 키오스크 제어 Sys
테이블 (6)
Order_Item
- order_item_id — INT — 기본 키 — NOT NULL
- order_id — INT — 외래 키 → order.order_id — NOT NULL
- Product_id — INT — 외래 키 → Product.Product_id — NOT NULL
- quantity — INT — NOT NULL
Product
- Product_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(45) — NOT NULL
- info — VARCHAR(45)
- price — INT — NOT NULL
- category_seq — INT — 외래 키 → category.category_seq — NOT NULL
- INDEX — `fk_item_category1_idx`
category
- category_seq — INT — 기본 키 — NOT NULL
- name — VARCHAR(45) — NOT NULL
order
- order_id — INT — 기본 키 — NOT NULL
- user_seq — INT — 외래 키 → user.user_seq — NOT NULL
- order_date — DATE
- total_price — INT
- status — INT
- order_method_id — INT — 외래 키 → order_method.order_method_id — NOT NULL
order_method
- order_method_id — INT — 기본 키 — NOT NULL
- point_rate — INT — NOT NULL
user
- user_seq — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(45) — NOT NULL
- name — VARCHAR(45) — NOT NULL
- pw — VARCHAR(45) — NOT NULL
- membership_level — INT — NOT NULL
- point — INT — NOT NULL