BonVoyageW
Tables (10)
Untitled (route_detail)
- route_detail_id — int — Primary key — NOT NULL
- route_id — int — Foreign key → route.route_id — NOT NULL
- Field (route_content) — text
attraction_description
- content_id (content_id2) — 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_notice (board)
- article_no — int — Primary key — NOT NULL
- title — varchar(255)
- date — date
- content — text
- hit — int
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
gugun
- gugun_code — int — Primary key — NOT NULL
- sido_code — int — Foreign key → sido.sido_code — NOT NULL
- gugun_name — varchar(30)
review
- review_id — int — Primary key — NOT NULL
- review_content — varchar(255)
- write_date — datetime
- location — varchar(100)
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- content_id (content_id2) — int — Foreign key → attraction_info.content_id — NOT NULL
route
- route_id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → users.user_id — NOT NULL
- Field (route_seq) — int
sido
- sido_code — int — Primary key — NOT NULL
- sido_name — varchar(30)
users
- user_id — varchar(20) — Primary key — NOT NULL
- user_pwd — varchar(20)
- email — varchar(20)
- name — varchar(20)
- birth — date
- phone — text
- question — text
- answer — text
- authorization — varchar(20)