임시
테이블 (10)
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`
file_info
- id — INT — 기본 키 — NOT NULL
- post_id — INT — 외래 키 → posting.post_id — NOT NULL
- save_folder — VARCHAR(255) — NOT NULL
- original_file — VARCHAR(255) — NOT NULL
- save_file — VARCHAR(255) — NOT NULL
- INDEX — `file_info_to_post_post_id_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`
members
- user_id — VARCHAR(16) — 기본 키 — NOT NULL
- user_name — VARCHAR(20) — NOT NULL
- user_password — VARCHAR(64) — NOT NULL
- grade — VARCHAR(10) — NOT NULL
- registration_date — TIMESTAMP — NOT NULL
post_comments
- comment_id — INT — 기본 키 — NOT NULL
- post_id — INT — 외래 키 → posting.post_id — NOT NULL
- user_id — VARCHAR(16) — 외래 키 → members.user_id — NOT NULL
- comment — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- INDEX — `post_comments_to_post_post_id_fk_idx`
- INDEX — `post_comments_to_members_user_id_fk_idx`
posting
- post_id — INT — 기본 키 — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- user_id — VARCHAR(16) — 외래 키 → members.user_id — NOT NULL
- sido_code — INT — 외래 키 → gugun.sido_code — NOT NULL
- gugun_code — INT — 외래 키 → gugun.gugun_code — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- hit — INT — NOT NULL
- INDEX — `posts_to_members_user_id_fk_idx`
- INDEX — `posts_to_gugun_gugun_code_fk_idx`
- INDEX — `posts_to_gugun_sido_code_fk_idx`
sido
- sido_code — INT — 기본 키 — NOT NULL
- sido_name — VARCHAR(30)
wishlist
- wishlist_id — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(16) — 외래 키 → members.user_id — NOT NULL
- content_id — INT — 외래 키 → attraction_info.content_id — NOT NULL
- added_at — TIMESTAMP — NOT NULL
- INDEX — `wishlist_to_members_user_id_fk_idx`
- INDEX — `wishlist_to_attraction_info_content_id_fk_idx`