Practice
Tables (5)
Customer (고객)
- id (고객 id) — BIGINT — Primary key — NOT NULL
FoodCourt (음식코너)
- id (코너 id) — BIGINT — Primary key — NOT NULL
- name (코너명) — VARCHAR(100)
Menu (메뉴)
- id (메뉴 id) — BIGINT — Primary key — NOT NULL
- id (코너 id) — BIGINT — Foreign key → FoodCourt.id — NOT NULL
- name (메뉴명) — VARCHAR(100)
- price (메뉴 가격) — INT
MenuOrder (메뉴 - 주문)
- id (메뉴 - 주문 id) — BIGINT — Primary key — NOT NULL
- orderId (주문 id) — BIGINT — Foreign key → Order.id — NOT NULL
- menuId (메뉴 id) — BIGINT — Foreign key → Menu.id — NOT NULL
- quantity (수량) — INT
Order (주문)
- id (주문 id) — BIGINT — Primary key — NOT NULL
- userId (고객 id) — BIGINT — Foreign key → Customer.id — NOT NULL
- price (금액) — INT