HungryNow

Tables (5)

Category

  • cat_id — Primary key — NOT NULL
  • name

Region

  • Key (region_id) — Primary key — NOT NULL
  • Field (name)

Restaurant

  • rest_id — Primary key — NOT NULL
  • name (naem)
  • address
  • budget
  • wifi (category_id)
  • category_id (wifi)
  • cat_id — Foreign key → Category.cat_id — NOT NULL
  • Key (region_id) — Foreign key → Region.Key — NOT NULL

SearchHistory

  • history_id — int — Primary key — PK
  • location
  • keyword
  • filter_options (filter_opt)

Untitled (SearchHistory_Restaurant)

  • history_id — Foreign key → SearchHistory.history_id — NOT NULL
  • rest_id — Foreign key → Restaurant.rest_id — NOT NULL