delivery

Tables (4)

Food (메뉴)

  • Key (id) — bigint — Primary key — NOT NULL
  • FK (RESTAURANT_ID) — bigint — Foreign key → Restaurant.PK — NOT NULL
  • 음식이름 (name) — varchar
  • 음식가격 (price) — int

FoodOrder (Untitled)

  • PK (id) — bigint — Primary key — NOT NULL
  • FK (ORDERS_ID) — bigint — Foreign key → Order.PK — NOT NULL
  • PK (id22) — bigint — Foreign key → Order.FK — NOT NULL
  • 음식이름 (name) — varchar
  • 음식수량 (quantity) — int
  • 음식가격*음식수량 (price) — int

Order (주문서)

  • PK (id) — bigint — Primary key — NOT NULL
  • FK (RESTAURANT_ID) — bigint — Foreign key → Restaurant.PK — NOT NULL
  • 음식점이름 (name) — varchar
  • 총주문금액 (totalPrice) — int

Restaurant (음식점)

  • PK (id) — bigint — Primary key — NOT NULL
  • 매장이름 (name) — varchar
  • 최소주문금액 (minOrderPrice) — int
  • 배달료 (deliveryFee) — int