골목골목 travel
테이블 (11)
attraction_info
- content_id — INT — 기본 키 — NOT NULL
- sido_code — INT — 외래 키 → sido.sido_code — NOT NULL
- title — VARCHAR(200)
- addr1 — VARCHAR(200)
- addr2 — VARCHAR(200)
- zipcode — VARCHAR(45)
- tel — VARCHAR(45)
- first_image — VARCHAR(200)
- first_image2 — VARCHAR(200)
- guguncol1 — VARCHAR(45)
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- overview — LONGTEXT
- content_type_id — INT — NOT NULL
- gugun_code — INT — 외래 키 → gugun.gugun_code — NOT NULL
- INDEX — `fk_gugun_sido1_idx`
- INDEX — `fk_attraction_info_gugun1_idx`
category
- cate_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(45)
gugun
- gugun_code — INT — 기본 키 — NOT NULL
- sido_code — INT — 외래 키 → sido.sido_code — NOT NULL
- gugun_name — VARCHAR(45)
- INDEX — `fk_attraction_info_sido_idx`
hotplace
- hotplace_id — INT — 기본 키 — NOT NULL
- title — VARCHAR(45) — NOT NULL
- longitude — DECIMAL(20,17)
- latitude — DECIMAL(20,17)
- user_id — INT — 외래 키 → member.idx
- overview — LONGTEXT — NOT NULL
- create_date — DATETIME
- views — INT
- location — VARCHAR(200)
- INDEX — `fk_hotplace_member1_idx`
hotplace_hashtag
- hashtag — VARCHAR(45) — 기본 키 — NOT NULL
- hotplace_id — INT — 외래 키 → hotplace.hotplace_id — NOT NULL
hotplace_img
- hotplace_id — INT — 외래 키 → hotplace.hotplace_id — NOT NULL
- img — VARCHAR(200)
- thumnail_img — VARCHAR(200)
hotplace_like
- user_id — INT — 외래 키 → member.idx — NOT NULL
- hotplace_id — INT — 외래 키 → hotplace.hotplace_id — NOT NULL
member
- idx — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(45) — NOT NULL
- email — VARCHAR(100)
- image — VARCHAR(200)
sido
- sido_code — INT — 기본 키 — NOT NULL
- sido_name — VARCHAR(50)
trip_plan
- plan_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → member.idx — NOT NULL
- title — VARCHAR(100) — NOT NULL
- create_date — DATETIME
- category_id — INT — 외래 키 → category.cate_id — NOT NULL
- INDEX — `fk_trip_plan_category1_idx`
trip_plan_place
- plan_id — INT — NOT NULL
- user_id — INT — NOT NULL
- order — INT — NOT NULL
- attraction_content_id — INT — NOT NULL
- commnet — VARCHAR(255)