DeliveryHub

Tables (6)

Menu

  • id (menu_id) — bigint — Primary key — NOT NULL
  • restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
  • name — varchar(50)
  • description — varchar(255)
  • price — int
  • created_at — datetime
  • updated_at — datetime

Order

  • id (order_id) — bigint — Primary key — NOT NULL
  • customer_id (user_id) — bigint — Foreign key → User.id — NOT NULL
  • restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
  • status — varchar(50)
  • total_price — int
  • created_at — datetime
  • updated_at — datetime
  • location — varchar(50

OrderItem

  • id (item_id) — bigint — Primary key — NOT NULL
  • order_id — bigint — Foreign key → Order.id — NOT NULL
  • menu_id — bigint — Foreign key → Menu.id — NOT NULL
  • quantity — int
  • price — int

Restaurant

  • id (restaurant_id) — bigint — Primary key — NOT NULL
  • owner id (user_id) — bigint — Foreign key → User.id — NOT NULL
  • name — varchar(50)
  • location — varchar(50)
  • created_at — datetime
  • updated_at — datetime

Review

  • id (review_id) — bigint — Primary key — NOT NULL
  • user id (user_id) — bigint — Foreign key → User.id — NOT NULL
  • restaurant id (restaurant_id) — bigint — Foreign key → Restaurant.id — NOT NULL
  • title — varchar(50)
  • content — text
  • rate — int

User

  • id (user_id) — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • role — varchar(50)
  • email — varchar(50)
  • password — varchar(16)
  • created_at — datetime
  • updated_at — datetime