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)