관통
테이블 (7)
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)
board
- article_no — int — 기본 키 — NOT NULL
- user_id — varchar(16) — 외래 키 → members.user_id — NOT NULL
- subject — varchar(100)
- content — varchar(2000)
- hit — int
- register_time — timestamp — NOT NULL
- modify_time — timestamp
- board_type — int — 1 = 공지사항 2 = 자유게시판
gugun
- gugun_code — int — 기본 키 — NOT NULL
- sido_code — int — 외래 키 → sido.sido_code — NOT NULL
- gugun_name — varchar(30)
members
- user_id — varchar(16) — 기본 키 — NOT NULL
- user_name — varchar(20) — NOT NULL
- user_password — varchar(16) — NOT NULL
- email — varchar(100)
sido
- sido_code — int — 기본 키 — NOT NULL
- sido_name — varchar(30)