여행계획
테이블 (5)
attraction_description
- content_id — INT — 외래 키 → attraction_info.content_id — NOT NULL
- homepage — VARCHAR(100)
- overview — VARCHAR(10000)
- telname — VARCHAR(45)
attraction_detail
- content_id — INT — 외래 키 → attraction_info.content_id — NOT NULL
- 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 — 기본 키 — NOT NULL
- 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 — 외래 키 → sido.sido_code
- gugun_code — INT — 외래 키 → gugun.gugun_code
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- mlevel — VARCHAR(2)
- INDEX — `attraction_to_content_type_id_fk_idx`
- INDEX — `attraction_to_sido_code_fk_idx`
- INDEX — `attraction_to_gugun_code_fk_idx`
gugun
- gugun_code — INT — 기본 키 — NOT NULL
- sido_code — INT — 외래 키 → sido.sido_code — NOT NULL
- gugun_name — VARCHAR(30)
- INDEX — `gugun_to_sido_sido_code_fk_idx`
sido
- sido_code — INT — 기본 키 — NOT NULL
- sido_name — VARCHAR(30)