아이스크림 로봇
테이블 (5)
Caricature (caricature)
- Caricature Id (caricature_id) — int — 기본 키 — NOT NULL
- Order Id (order_id) — int — 외래 키 → Order.Order Id — NOT NULL
- Image (image) — image
- Created At (created_at) — datetime
Flavor (flavor)
- Flavor Id (flavor_id) — int — 기본 키 — NOT NULL
- Name (name) — char(50)
- Price (price) — int
Order (order)
- Order Id (order_id) — int — 기본 키 — NOT NULL
- Flavor Id (flavor_id2) — int — 외래 키 → Flavor.Flavor Id — NOT NULL
- Selected Caricature (selected_caricature) — boolean
- Total Price (total_price) — int
- Created At (created_at) — datetime
Order Topping (order_topping)
- Order Topping Id (order_topping_id) — int — 기본 키 — NOT NULL
- Order Id (order_id) — int — 외래 키 → Order.Order Id — NOT NULL
- Topping Id (topping_id) — int — 외래 키 → Topping.Topping Id — NOT NULL
Topping (topping)
- Topping Id (topping_id) — int — 기본 키 — NOT NULL
- Name (name) — char(50)
- Price (price) — int