final_project
Tables (5)
CODEZIP (Untitled5)
- code (Key) — Primary key — NOT NULL
- text (Field)
FOOD_INFO (Untitled3)
- food (Key) — Primary key — NOT NULL
- info (Field)
- ingredients (Field2)
- taboo (Field3)
RESTAURANT_INFO (restaurnat_info)
- id — int — Primary key — NOT NULL
- food — varchar(255) — Foreign key → FOOD_INFO.food — NOT NULL
- store_name — varchar
- addr — varchar
- tel — varchar
- x — float
- y — float
REVIEW_RANK (Untitled2)
- id (Key) — Primary key — NOT NULL
- res_id (Key2) — Foreign key → RESTAURANT_INFO.id — NOT NULL
- code (Key3) — Foreign key → CODEZIP.code — NOT NULL
- cnt (Field3)
REVIEW_VISITOR (visitor_review)
- id — Primary key — NOT NULL
- id (res_id) — int — Foreign key → RESTAURANT_INFO.id — NOT NULL
- visitor_review — varchar