토착
테이블 (5)
restaurant
- restaurant_id — INT — 기본 키 — NOT NULL
- store_name — VARCHAR(50)
- adress — VARCHAR(255)
- category — VARCHAR(50)
- ranking — INT
spot
- spot_id — int — 기본 키 — NOT NULL
- spot_name — varchar(50)
- spot_adress — varchar(255)
- spot_category — varchar(50)
- classification — varchar(50)
- ranking — int
touristspot
- touristspot_id — INT — 기본 키 — NOT NULL
- spot_name — VARCHAR(50)
- adress — VARCHAR(255)
- category — VARCHAR(50)
- ranking — INT
user
- user_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(20)
- phone — VARCHAR(20)
- nickname — VARCHAR(20)
- age — INT
user_review
- user_id — INT — 외래 키 → user.user_id — NOT NULL