asdf

Tables (19)

bookmark

  • bookmark_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — 콘텐츠 북마크 시 사용 (nullable)
  • category_id — BIGINT — Foreign key → category.category_id — 테마 북마크 시 사용 (nullable)

category

  • category_id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(20) — ERA / PERSON / EVENT / THEME
  • name — VARCHAR(100)
  • subtitle — VARCHAR(200) — 테마 부제목
  • description — VARCHAR(500) — 왕조 한 줄 설명 / 테마 설명
  • period_label — VARCHAR(100) — 왕조 기간 표시 (예: 1392~1897)
  • duration_label — VARCHAR(50) — 테마 소요 일정
  • story — TEXT — 테마 역사 스토리 강조 박스 본문
  • tags — VARCHAR(300) — 테마 태그, 콤마구분
  • parent_id — BIGINT — self, nullable
  • image_url — VARCHAR(500)

category_fact

  • category_fact_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • fact — VARCHAR(300) — 왕조 주요 역사 사실
  • sort_order — INT

category_place

  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • place_id — BIGINT — Foreign key → place.place_id — NOT NULL
  • recommend_order — INT — 추천(코스) 순서
  • tip — VARCHAR(300) — 코스 Tip 박스 내용
  • duration_label — VARCHAR(50) — 장소별 소요시간 라벨

content

  • content_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200)
  • summary — VARCHAR(500)
  • story_intro — VARCHAR(500) — 역사 이야기 intro 텍스트
  • story_body — TEXT — 팩트체크 서사 본문
  • view_count — BIGINT — 조회수 (인기순 정렬/배지)
  • thumbnail_url — VARCHAR(500)

content_category

  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL

content_character

  • content_character_id — BIGINT — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • character_name — VARCHAR(100) — 등장인물 이름
  • actor_name — VARCHAR(100) — 배우명
  • is_historical — BOOLEAN — 실존 인물 여부
  • sort_order — INT

content_fact_check

  • content_fact_check_id — BIGINT — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • topic — VARCHAR(200) — 팩트체크 주제
  • fact — TEXT — 실제 사실 내용
  • fiction — TEXT — 각색/허구 내용
  • sort_order — INT

content_media

  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • media_id — BIGINT — Foreign key → media.media_id — NOT NULL

content_place

  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • place_id — BIGINT — Foreign key → place.place_id — NOT NULL
  • recommend_order — INT — 추천 순서

content_story_section

  • content_story_section_id — BIGINT — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — NOT NULL
  • keyword — VARCHAR(100) — 섹션 소제목
  • body — TEXT — 섹션 본문
  • sort_order — INT

itinerary

  • itinerary_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • content_id — BIGINT — Foreign key → content.content_id — nullable, 추천 출처
  • source_itinerary_id — BIGINT — Foreign key → itinerary.itinerary_id — nullable, 복사 출처
  • title — VARCHAR(200)
  • description — VARCHAR(500) — 커뮤니티 공유 시 루트 설명
  • is_shared — BOOLEAN — 커뮤니티 노출
  • travel_date — DATETIME

itinerary_place

  • itinerary_place_id — BIGINT — Primary key — NOT NULL
  • itinerary_id — BIGINT — Foreign key → itinerary.itinerary_id — NOT NULL
  • place_id — BIGINT — Foreign key → place.place_id — NOT NULL
  • day_number — INT — 여행 일차 (1일차=1, 2일차=2 ...)
  • visit_order — INT — 해당 일차 내 방문 순서
  • status — VARCHAR(20) — UNCONFIRMED / CONFIRMED / CHANGED
  • to_next_distance_m — INT
  • to_next_duration_min — INT
  • memo — VARCHAR(300)

media

  • media_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200)
  • type — VARCHAR(20) — DRAMA / MOVIE / DOCUMENTARY
  • release_year — INT

place

  • place_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200)
  • category — ENUM('역사관광지', '식당', '카페', '기타관광지') — 카테고리별 일정 추천(식당N·카페N·관광지N)을 위해 자유텍스트 대신 고정값 사용
  • description — VARCHAR(500)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • address — VARCHAR(300)
  • region — VARCHAR(50) — 도시/지역명
  • opening_hours — VARCHAR(200)
  • fee_info — VARCHAR(200) — 요금 정보
  • kakao_place_id — VARCHAR(50) — 갱신용

place_image

  • place_image_id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → place.place_id — NOT NULL
  • image_url — VARCHAR(500)

review

  • review_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • itinerary_id — BIGINT — Foreign key → itinerary.itinerary_id — NOT NULL
  • rating — INT — 1-5
  • content — TEXT
  • created_at — DATETIME

review_like

  • review_id — BIGINT — Foreign key → review.review_id — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50)
  • nickname — VARCHAR(50)
  • email — VARCHAR(255)
  • birth_date — DATE — 생년월일
  • avatar_url — VARCHAR(500) — 프로필 이미지
  • bio — VARCHAR(300) — 소개글
  • agreed_to_terms — BOOLEAN — 이용약관 동의 여부
  • dark_mode — BOOLEAN — 다크모드 사용 여부
  • oauth_provider — VARCHAR(20) — 소셜로그인 제공자 (KAKAO 등), 카카오만 지원하므로 1:1
  • oauth_id — VARCHAR(100) — 소셜로그인 측 고유 식별자
  • created_at — DATETIME