edb
Tables (6)
MEMBER
- id — int
- name — varchar(45) — NOT NULL
- email — varchar(45) — NOT NULL
- age — int
- nationality — varchar(50)
- gender — varchar(10)
- phone — varchar(20) — NOT NULL
- password — varchar(200) — NOT NULL
REGION
- id — int
- region — varchar(45) — NOT NULL
- visitor_count — int — NOT NULL
- convenience_store_count — int
- cafe_count — int
- area — float — NOT NULL
- tourist_attraction_count — int
- hospital_count — int
- bus_stop_count — int
- accommodation_count — int
RESTAURANT
- id — int
- restaurant_name — varchar(100) — NOT NULL
- region — varchar(45) — NOT NULL
- address — varchar(200) — NOT NULL
- category — varchar(50) — NOT NULL
- visitor_count — int — NOT NULL
TOURIST_ATTRACTION
- id — int
- tourist_attraction_name — varchar(100) — NOT NULL
- region — varchar(45) — NOT NULL
- address — varchar(200) — NOT NULL
- category — varchar(45)
- sub_category — varchar(45) — NOT NULL
- tourist_attraction_url — varchar(200) — NOT NULL
- visitor_count — int
- natural_affinity_score — float
- kid_friendly_score — float
TRANSPORTATION_INFO
- id — int
- region — varchar(45) — NOT NULL
- transportation_type — varchar(45) — NOT NULL
- transportation_time — int — NOT NULL
- transportation_cost — int — NOT NULL
TRAVEL_OPTION
- id — int
- travel_purpose — varchar(255)
- crowd_preference — int
- has_child — int
- member_id — int
- preference_for_nature — int
- travel_days — int