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)