12312312
Tables (5)
GeneratedResults
- result_id — INT — NOT NULL
- search_id — INT — NOT NULL
- generated_text — TEXT
- generated_date — TIMESTAMP
Restaurants
- restaurant_id — INT — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- category — VARCHAR(50)
- location — VARCHAR(255)
Reviews
- review_id — INT — NOT NULL
- user_id — INT — NOT NULL
- restaurant_id — INT — NOT NULL
- rating — FLOAT
- comment — TEXT
- review_date — TIMESTAMP
SearchHistory
- search_id — INT — NOT NULL
- user_id — INT — NOT NULL
- search_query — VARCHAR(255)
- search_date — TIMESTAMP
Users
- user_id — INT — NOT NULL
- name — VARCHAR(100)
- email — VARCHAR(100)
- password — VARCHAR(255)
- signup_date — TIMESTAMP