asdfasdf
Tables (7)
attraction_description
- content_id — int — Foreign key → attraction_info.content_id — NOT NULL
- homepage — varchar(100)
- overview — varchar(10000)
- telname — varchar(45)
attraction_detail
- content_id — int — Foreign key → 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 — Primary key — 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 — Foreign key → sido.sido_code
- gugun_code — int — Foreign key → gugun.gugun_code
- latitude — decimal(20,17)
- longitude — decimal(20,17)
- mlevel — varchar(2)
board
- article_no — int — Primary key — NOT NULL
- user_id — varchar(20)
- subject — varchar(20)
- content — varchar(100)
- hit — int
- register_time — datetime
gugun
- gugun_code — int — Primary key — NOT NULL
- sido_code — int — Foreign key → sido.sido_code — NOT NULL
- gugun_name — varchar(30)
members
- user_id — varchar(20) — Primary key — NOT NULL
- user_name — varchar(20) — NOT NULL
- user_pwd — varchar(40) — NOT NULL
- email_id — varchar(20)
- email_domain — varchar(20)
- join_date — datetime
sido
- sido_code — int — Primary key — NOT NULL
- sido_name — varchar(30)