3,5카페 키오스크
테이블 (5)
menu (Untitled2)
- Key (menu_seq) — not null — 기본 키 — NOT NULL
- Field (menu_name) — not null
- Field (menu_cost) — not null
- Field (menu_img) — null
menu_option (Untitled5)
- Key (menu_option_seq) — not null — 기본 키 — NOT NULL
- Key (menu_seq) — not null — 외래 키 → menu.Key — NOT NULL
- Key (option_key) — not null — 외래 키 → option.Key — NOT NULL
option (Untitled3)
- Key (option_key) — not null — 기본 키 — NOT NULL
- Field (option_name) — not null
- Field (option_code) — not null
order (Untitled4)
- Key (order_seq) — not null — 기본 키 — NOT NULL
- Key (menu_seq) — not null — 외래 키 → menu.Key — NOT NULL
- Field (order_temp) — not null
- Field (order_milk) — null
- Field (order_shot) — null
point (Untitled)
- Key (user_seq) — not null — 기본 키 — NOT NULL
- Key (order_seq) — not null — 외래 키 → order.Key — NOT NULL
- Key (menu_seq) — not null — 외래 키 → order.Key — NOT NULL
- Field (phone_num) — not null
- Field (point) — not null