JHTrip

여행 계획을 세우고 서로의 여행경로를 공유하는 웹 사이트로, 사용자들이 여행 일정을 작성하고 공유할 수 있는 웹 페이지

테이블 (16)

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`

board

  • no — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(255) — 외래 키 → members.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • hit — INT
  • created_at — TIMESTAMP
  • INDEX — `board_user_id_fk_idx`

comments

  • id — INT — 기본 키 — NOT NULL
  • board_no — INT — 외래 키 → board.no — NOT NULL
  • user_id — VARCHAR(255) — 외래 키 → members.id — NOT NULL
  • comment — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — `comments_board_no_fk_idx`
  • INDEX — `comments_user_id_fk_idx`

file_info

  • idx — INT — 기본 키 — NOT NULL
  • board_no — INT — 외래 키 → board.no
  • save_folder — VARCHAR(45)
  • original_file — VARCHAR(50)
  • save_file — TEXT

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

  • id — VARCHAR(50) — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • pass — TEXT — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • profile_uri — VARCHAR(255)

notice

  • no — INT — 기본 키 — NOT NULL
  • user_Id — VARCHAR(255) — 외래 키 → members.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • hit — INT
  • created_at — TIMESTAMP
  • INDEX — `talk_user_id_fk_idx`

plan

  • id — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(255) — 외래 키 → members.id — NOT NULL
  • plan_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • hit — INT
  • created_at — TIMESTAMP
  • share_status — TINYINT(1) — NOT NULL

reset_tokens

  • id — INT
  • token — VARCHAR(100)
  • expiry — TIMESTAMP
  • user_id — VARCHAR(50) — 외래 키 → members.id — NOT NULL

route_plan

  • id — INT — 기본 키 — NOT NULL
  • plan_id — INT — 외래 키 → plan.id — NOT NULL
  • sequence — INT
  • content_id — INT — 외래 키 → attraction_info.content_id — NOT NULL

search_terms

  • id — INT
  • content_id — INT — NOT NULL
  • searched_at — TIMESTAMP

security

  • user_id — VARCHAR(255) — 외래 키 → members.id — NOT NULL
  • salt — TEXT — NOT NULL
  • iteration — INT — NOT NULL
  • algo — VARCHAR(45)

sido

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

swear

  • word — VARCHAR(500) — NOT NULL