baemin

Tables (9)

Address (Untitled2)

  • address_id — Primary key — NOT NULL
  • user_id — Foreign key → Users.user_id — NOT NULL
  • addressName — NOT NULL
  • detailAddress — NOT NULL
  • isDefault — NOT NULL

Category (Untitled3)

  • category_id — Primary key — NOT NULL
  • name — NOT NULL

Favorite (Untitled7)

  • favorite_id — Primary key — NOT NULL
  • user_id — Foreign key → Users.user_id — NOT NULL
  • restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL

Menu

  • menu_id — Primary key — NOT NULL
  • restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
  • name — NOT NULL
  • description — NOT NULL
  • price — NOT NULL

Order (Untitled5)

  • order_id — Primary key — NOT NULL
  • user_id — Foreign key → Users.user_id — NOT NULL
  • restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
  • status — NOT NULL
  • totalPrice — NOT NULL
  • orderTime — NOT NULL

OrderItem (Untitled6)

  • item_id — Primary key — NOT NULL
  • menu_id — Foreign key → Menu.menu_id — NOT NULL
  • order_id — Foreign key → Order.order_id — NOT NULL
  • price — NOT NULL

Restaurant (Untitled4)

  • restaurant_id — Primary key — NOT NULL
  • category_id — Foreign key → Category.category_id — NOT NULL
  • name — NOT NULL
  • description
  • rating — NOT NULL
  • reviewCount — NOT NULL
  • deliveryFee — NOT NULL
  • minOrderAmount — NOT NULL

Review (Untitled8)

  • review_id — Primary key — NOT NULL
  • user_id — Foreign key → Users.user_id — NOT NULL
  • restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
  • order_id — Foreign key → Order.order_id — NOT NULL
  • rating
  • content
  • owner_reply

Users (Untitled)

  • user_id — Primary key — NOT NULL
  • email — NOT NULL
  • password — NOT NULL
  • name — NOT NULL
  • phoneNumber — NOT NULL
  • birth — NOT NULL