enjoy_trip
테이블 (9)
attraction_description
- content_id — INT
- homepage — VARCHAR(100)
- overview — VARCHAR(10000)
- telname — VARCHAR(45)
attraction_detail
- content_id — INT
- cat1 — VARCHAR(3)
- cat2 — VARCHAR(5)
- cat3 — VARCHAR(9)
- created_time — VARCHAR(14)
- modified_time — VARCHAR(14)
- booktour — VARCHAR(5)
attraction_info
- content_id — INT
- content_type_id — INT
- title — VARCHAR(100)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(50)
- zipcode — VARCHAR(50)
- tel — VARCHAR(50)
- first_image — VARCHAR(200)
- first_image2 — VARCHAR(200)
- readcount — INT
- sido_code — INT
- gugun_code — INT
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- mlevel — VARCHAR(2)
gugun
- gugun_code — INT
- gugun_name — VARCHAR(30)
- sido_code — INT
planner_sub
- plan_sub_id — INT
- plan_no — INT
- content_id — VARCHAR(255)
sido
- sido_code — INT
- sido_name — VARCHAR(30)
게시글 (article)
- article_no — INT
- member_id — VARCHAR(255) — NOT NULL
- subject — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- hit — INT
- register_time — DATETIME
여행 계획 (planner)
- plan_no — INT
- member_id — VARCHAR(255) — NOT NULL
- plantitle — VARCHAR(255) — NOT NULL
- schedule — varchar(255)
- transport — varchar(255)
- register_time — DATETIME
회원 (member)
- id — INT
- member_name — VARCHAR(255) — NOT NULL
- member_id — VARCHAR(255) — NOT NULL
- member_pwd — VARCHAR(255) — NOT NULL
- member_email — VARCHAR(255) — NOT NULL
- member_status — INT — NOT NULL