ㅁㄴㅇㄹ
Tables (5)
GeneratedResults
- result_id — INT — Primary key
- search_id — INT — Foreign key → SearchHistory.search_id
- generated_text — CLOB
- generated_date — TIMESTAMP
Restaurants
- restaurant_id — INT — Primary key
- name — VARCHAR2(100)
- description — CLOB
- category — VARCHAR2(50)
- location — VARCHAR2(255)
Reviews
- review_id — INT — Primary key
- user_id — INT — Foreign key → Users.user_id
- restaurant_id — INT — Foreign key → Restaurants.restaurant_id
- rating — FLOAT
- comment — CLOB
- review_date — TIMESTAMP
SearchHistory
- search_id — INT — Primary key
- user_id — INT — Foreign key → Users.user_id
- search_query — VARCHAR2(255)
- search_date — TIMESTAMP
Users
- user_id — INT — Primary key
- name — VARCHAR2(100)
- email — VARCHAR2(100)
- password — VARCHAR2(255)
- signup_date — TIMESTAMP