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