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