restaurant

Tables (7)

menu

  • menu_id — int — Primary key — NOT NULL
  • menu_name — text — NOT NULL
  • price — int — NOT NULL

order_menu

  • or_me_id — int — Primary key — NOT NULL
  • order_id — int — Foreign key → orders.order_id — NOT NULL
  • menu_id — int — Foreign key → menu.menu_id — NOT NULL

orders

  • order_id — int — Primary key — NOT NULL
  • ordered_at — datetime — NOT NULL
  • delivery_status — text — NOT NULL
  • total_price — int — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL
  • rest_id — int — Foreign key → restaurant.rest_id — NOT NULL

rest_menu

  • re_me_id — int — Primary key — NOT NULL
  • rest_id — int — Foreign key → restaurant.rest_id — NOT NULL
  • menu_id — int — Foreign key → menu.menu_id — NOT NULL

restaurant

  • rest_id — int — Primary key — NOT NULL
  • rest_name — text — NOT NULL
  • address — text — NOT NULL
  • phone — text — NOT NULL
  • category — text — NOT NULL

review

  • review_id — int — Primary key — NOT NULL
  • content — text — NOT NULL
  • rating — int — NOT NULL
  • order_id — int — Foreign key → orders.order_id — NOT NULL

users

  • user_id — int — Primary key — NOT NULL
  • email — text — NOT NULL
  • name — text — NOT NULL
  • phone — text — NOT NULL