TEST

Tables (4)

FoodOrder (상세주문)

  • ID (foodOrder_id) — Long — Primary key — NOT NULL
  • 음식id (food_id) — Long — Foreign key → Foods.음식id — NOT NULL
  • 주문id (order_id) — Long — Foreign key → Order.주문id — NOT NULL
  • 주문수량 (quantity) — Int
  • 주문음식가격 (price) — Int

Foods (음식)

  • 음식id (food_id) — Long — Primary key — NOT NULL
  • 식당id (restaurant_id) — Long — Foreign key → Restaurant.식당id — NOT NULL
  • 음식이름 (foodName) — String
  • 가격 (foodPrice) — Int

Order (주문)

  • 주문id (order_id) — Long — Primary key — NOT NULL
  • 식당id (restaurant_id) — Long — Foreign key → Restaurant.식당id — NOT NULL
  • 총가격 (total_price) — Int

Restaurant (식당)

  • 식당id (restaurant_id) — Long — Primary key — NOT NULL
  • 식당이름 (name) — String
  • 최소주문가격 (minOrderPrice) — Int
  • 기본 배달비 (deliveryFee) — Int