아이스크림 로봇

테이블 (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