관통

테이블 (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)