배달DB

테이블 (4)

음식(FOOD) (Untitled2)

  • MENU_ID (id) — int — 기본 키 — NOT NULL
  • NAME (name) — varchar
  • PRICE (price) — int
  • RESTAURANT_ID (restaurant) — int — 외래 키 → 음식점(RESTAURANT).RESTAURANT_ID — NOT NULL

음식점(RESTAURANT) (Untitled)

  • RESTAURANT_ID (id) — int — 기본 키 — NOT NULL
  • NAME (name) — varchar
  • MIN_ORDER_PRICE (minOrderPrice) — int
  • DELIVERY_FEE (deliveryFee) — int

주문(ORDER) (Untitled3)

  • ORDER_ID (id) — int — 기본 키 — NOT NULL
  • TOTAL_PRICE (totalPrice) — int
  • RESTAURANT_ID (restaurantId) — int — 외래 키 → 음식점(RESTAURANT).RESTAURANT_ID — NOT NULL

주문음식(ORDER_FOOD) (Untitled4)

  • ORDER_MENU_ID (id) — int — 기본 키 — NOT NULL
  • QUANTITY (quantity) — int
  • PRICE (price) — int
  • ORDER_ID (orderId) — int — 외래 키 → 주문(ORDER).ORDER_ID — NOT NULL
  • MENU_ID (menuId) — int — 외래 키 → 음식(FOOD).MENU_ID — NOT NULL