임시

테이블 (10)

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)
  • INDEX — `attraction_to_content_type_id_fk_idx`
  • INDEX — `attraction_to_sido_code_fk_idx`
  • INDEX — `attraction_to_gugun_code_fk_idx`

file_info

  • id — INT — 기본 키 — NOT NULL
  • post_id — INT — 외래 키 → posting.post_id — NOT NULL
  • save_folder — VARCHAR(255) — NOT NULL
  • original_file — VARCHAR(255) — NOT NULL
  • save_file — VARCHAR(255) — NOT NULL
  • INDEX — `file_info_to_post_post_id_fk_idx`

gugun

  • gugun_code — INT — 기본 키 — NOT NULL
  • sido_code — INT — 외래 키 → sido.sido_code — NOT NULL
  • gugun_name — VARCHAR(30)
  • INDEX — `gugun_to_sido_sido_code_fk_idx`

members

  • user_id — VARCHAR(16) — 기본 키 — NOT NULL
  • user_name — VARCHAR(20) — NOT NULL
  • user_password — VARCHAR(64) — NOT NULL
  • grade — VARCHAR(10) — NOT NULL
  • registration_date — TIMESTAMP — NOT NULL

post_comments

  • comment_id — INT — 기본 키 — NOT NULL
  • post_id — INT — 외래 키 → posting.post_id — NOT NULL
  • user_id — VARCHAR(16) — 외래 키 → members.user_id — NOT NULL
  • comment — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — `post_comments_to_post_post_id_fk_idx`
  • INDEX — `post_comments_to_members_user_id_fk_idx`

posting

  • post_id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • user_id — VARCHAR(16) — 외래 키 → members.user_id — NOT NULL
  • sido_code — INT — 외래 키 → gugun.sido_code — NOT NULL
  • gugun_code — INT — 외래 키 → gugun.gugun_code — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • hit — INT — NOT NULL
  • INDEX — `posts_to_members_user_id_fk_idx`
  • INDEX — `posts_to_gugun_gugun_code_fk_idx`
  • INDEX — `posts_to_gugun_sido_code_fk_idx`

sido

  • sido_code — INT — 기본 키 — NOT NULL
  • sido_name — VARCHAR(30)

wishlist

  • wishlist_id — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(16) — 외래 키 → members.user_id — NOT NULL
  • content_id — INT — 외래 키 → attraction_info.content_id — NOT NULL
  • added_at — TIMESTAMP — NOT NULL
  • INDEX — `wishlist_to_members_user_id_fk_idx`
  • INDEX — `wishlist_to_attraction_info_content_id_fk_idx`