enjoytrip
Tables (14)
attraction_description
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- homepage (hompage) — VARCHAR(200)
- overview — VARCHAR(10000)
- telname — VARCHAR(45)
attraction_info
- content_id — INT — Primary key — NOT NULL
- sido_code (sido_code2) — INT — Foreign key → sido.sido_code — NOT NULL
- gugun_code (gugun_code2) — INT — Foreign key → gugun.gugun_code — NOT NULL
- content_type_id — INT
- title — VARCHAR(100)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(100)
- zipcode — VARCHAR(10)
- tel — VARCHAR(20)
- first_image — VARCHAR(200)
- latitude — DECIMAL(20, 17)
- longitude — DECIMAL(20, 17)
gugun
- gugun_code — INT — Primary key — NOT NULL
- sido_code — INT — Foreign key → sido.sido_code — NOT NULL
- gugun_name — VARCHAR(30)
hotplace
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- hotplace_name — VARCHAR(20)
- visit_date — VARCHAR(50)
- ctype — INT
- place_desc — VARCHAR(200)
hotplace_img
- id — INT — Primary key — NOT NULL
- hid — INT — Foreign key → hotplace.id — NOT NULL
- img_path — VARCHAR(200)
hotplace_recommend
- id — INT — Primary key — NOT NULL
- hotplace_id (hotplcae_id) — INT — Foreign key → hotplace.id — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- recommend_time — VARCHAR(20)
- valid — TINYINT(1)
notice
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- title — VARCHAR(30)
- content — VARCHAR(500)
- view_count — INT
- write_date — VARCHAR(20)
participate
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- plan_id — INT — Foreign key → trip_plan.id — NOT NULL
selected_trip_plan
- id — INT — Primary key — NOT NULL
- plan_id — INT — Foreign key → trip_plan.id — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
sido
- sido_code — INT — Primary key — NOT NULL
- sido_name — VARCHAR(30)
trip_plan
- id — INT — Primary key — NOT NULL
- plan_name — VARCHAR(50)
- start_date — DATETIME
- end_date — DATETIME
- plan_detail — VARCHAR(200)
trip_plan_places
- id — INT — Primary key — NOT NULL
- plan_id — INT — Foreign key → trip_plan.id — NOT NULL
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
trip_plan_reply
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- plan_id — INT — Foreign key → trip_plan.id — NOT NULL
- write_date — DATETIME
- content — VARCHAR(255)
- user_name — VARCHAR(20)
user
- id — INT — Primary key — NOT NULL
- sido_code — INT — Foreign key → sido.sido_code — NOT NULL
- gugun_code — INT — Foreign key → gugun.gugun_code — NOT NULL
- name — VARCHAR(20)
- email — VARCHAR(50)
- password — VARCHAR(200)
- legion_name — VARCHAR(10)
- city_name — VARCHAR(10)
- comment — VARCHAR(200)
- user_code — VARCHAR(10)
- profile_image — VARCHAR(10)
- role — VARCHAR(20)