llll

Tables (23)

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 — 콘텐츠 북마크 시
  • theme_id — BIGINT — Foreign key → theme.theme_id — 테마 북마크 시
  • created_at — DATETIME

category

  • category_id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(20) — ERA / PERSON / EVENT
  • name — VARCHAR(100)
  • parent_id — BIGINT — Foreign key → category.category_id — self, nullable
  • image_url — VARCHAR(500)
  • years — VARCHAR(100) — 왕조 존속 기간 텍스트 (예: 1392-1897)
  • description — VARCHAR(500) — 한 줄 설명

category_fact

  • category_fact_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • fact_text — VARCHAR(300) — 주요 역사 사실
  • fact_order — INT — 노출 순서

content

  • content_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200)
  • summary — VARCHAR(500)
  • story_body — TEXT — 팩트체크 서사 본문
  • thumbnail_url — VARCHAR(500)
  • view_count — INT — 조회수
  • rating — DECIMAL(2, 1) — 콘텐츠 평점 (예: 4.5)
  • created_at — DATETIME — 최신순 정렬용

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
  • name — VARCHAR(100) — 캐릭터명
  • actor_name — VARCHAR(100) — 배우명
  • is_historical — BOOLEAN — 실존인물 여부

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 — 각색 내용
  • check_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 — 스토리텔링 본문
  • section_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)
  • is_shared — BOOLEAN — 커뮤니티 노출
  • travel_date — DATETIME
  • description — VARCHAR(500) — 공유 루트 설명
  • region — VARCHAR(100) — 여행 지역
  • duration_label — VARCHAR(50) — 소요일정 텍스트 (예: 당일치기)

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
  • visit_order — INT — 방문 순서
  • status — VARCHAR(20) — PENDING / CONFIRMED / CHANGED
  • to_next_distance_m — INT
  • to_next_duration_min — INT
  • memo — VARCHAR(300)

itinerary_tag

  • itinerary_tag_id — BIGINT — Primary key — NOT NULL
  • itinerary_id — BIGINT — Foreign key → itinerary.itinerary_id — NOT NULL
  • tag_name — VARCHAR(50)

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 — VARCHAR(20) — 역사 관광지/ 식당 / 카페 /기타 관광지
  • description — VARCHAR(500)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • address — VARCHAR(300)
  • opening_hours — VARCHAR(200)
  • kakao_place_id — VARCHAR(50) — 갱신용
  • city — VARCHAR(50) — 관련 장소 태그(도시명) 표시용
  • fee — VARCHAR(100) — 요금 정보 텍스트

place_category

  • place_id — BIGINT — Foreign key → place.place_id — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL

place_image

  • place_image_id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → place.place_id — NOT NULL
  • image_url — VARCHAR(500)
  • is_primary — BOOLEAN — 목록 카드용 대표 썸네일 여부

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
  • like_count — INT — review_like 집계 캐시(선택)

review_like

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

theme

  • theme_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200)
  • subtitle — VARCHAR(200)
  • description — VARCHAR(500)
  • story — TEXT — 역사 스토리 강조 박스 본문
  • cover_image_url — VARCHAR(500)
  • duration — VARCHAR(50) — 소요 일정 (예: 1박2일)
  • created_at — DATETIME

theme_place

  • theme_id — BIGINT — Foreign key → theme.theme_id — NOT NULL
  • place_id — BIGINT — Foreign key → place.place_id — NOT NULL
  • visit_order — INT — 추천 코스 순서
  • tip — VARCHAR(300) — Tip 박스 내용
  • duration_label — VARCHAR(50) — 소요시간 텍스트

theme_tag

  • theme_tag_id — BIGINT — Primary key — NOT NULL
  • theme_id — BIGINT — Foreign key → theme.theme_id — NOT NULL
  • tag_name — VARCHAR(50)

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)
  • avatar_url — VARCHAR(500) — 프로필 이미지
  • bio — VARCHAR(300) — 소개글
  • birth_date — DATE
  • provider — VARCHAR(20) — LOCAL / KAKAO
  • provider_uid — VARCHAR(100) — 소셜 로그인 식별자
  • agreed_to_terms — BOOLEAN — 이용약관 동의 여부
  • agreed_at — DATETIME — 약관 동의 시각
  • dark_mode — BOOLEAN
  • language — VARCHAR(10)
  • notification_enabled — BOOLEAN
  • created_at — DATETIME