nds ERD

Tables (11)

categories (카테고리)

  • id — SERIAL — Primary key
  • name (카테고리이름) — VARCHAR(100) — NOT NULL

chat_message_logs (채팅_로그)

  • id (채팅입력id) — String — NOT NULL
  • session_id (세션id) — String
  • user_id (사용자id) — String
  • role (역할) — String
  • message (입력) — String
  • metadata — Json
  • created_at — Date — NOT NULL

festival_categories (축제별_카테고리)

  • id — SERIAL — Primary key
  • festival_id (축제id) — SERIAL — Foreign key → festivals.id
  • category_id (카테고리id) — SERIAL — Foreign key → categories.id

festival_embeddings (축제_임베딩)

  • festival_id (축제id) — SERIAL — Foreign key → festivals.id
  • embedding — vector(1536)
  • created_at — TIMESTAMP

festivals (축제)

  • id (축제id) — SERIAL — Primary key
  • festival_name (축제명) — VARCHAR(255)
  • location (장소) — VARCHAR(255)
  • start_date (시작일) — DATE
  • end_date (종료일) — DATE
  • description (설명) — TEXT
  • host_org (주최기관) — VARCHAR(255)
  • sponsor_org (후원기관) — VARCHAR(255)
  • supporter_org (지원기관) — VARCHAR(255)
  • phone (전화번호) — VARCHAR(100)
  • homepage_url (홈페이지 url) — TEXT
  • related_info (관련정보) — TEXT
  • road_address (도로명주소) — TEXT
  • parcel_address (지번주소) — TEXT
  • latitude (위도) — DOUBLE
  • longitude (경도) — DOUBLE
  • reference_date (계약일) — DATE
  • provider_code (관할코드) — VARCHAR(50)
  • provider_name (관할지명) — VARCHAR(255)
  • created_at (생성일) — TIMESTAMP

recommendation_logs (추천 로그)

  • id (추천응답id) — String — NOT NULL
  • user_id (사용자id) — String
  • query (실행쿼리) — String
  • input_context (채팅입력) — Json
  • retrieved_festivals (반환된 축제 목록) — Json
  • final_recommendations (최종 추천) — Json
  • model_used (사용모델) — String
  • embedding_model (사용임베딩모델) — String
  • latency_ms (응답시간) — Integer
  • created_at (생성일) — Date — NOT NULL

system_error_logs (시스템_에러_로그)

  • _id (에러로그id) — String — NOT NULL
  • service_name (서비스명) — String
  • error_message (에러메세지) — String
  • stack_trace — String
  • metadata — Json
  • created_at (생성일) — Date — NOT NULL

user_action_logs (사용자_행동_로그)

  • _id (행동로그id) — String — NOT NULL
  • user_id (사용자id) — String
  • action_type (행동유형) — String
  • metadata — Json
  • created_at (생성일) — Date — NOT NULL

user_category_preferences (사용자_카테고리 선호)

  • id — SERIAL — Primary key
  • user_id (사용자id) — SERIAL — Foreign key → user_preferences.user_id
  • category_id (카테고리id) — SERIAL — Foreign key → categories.id

user_preferences (사용자_선호)

  • user_id (사용자id) — SERIAL — Foreign key → users.id
  • prefer_indoor (선호_실내) — BOOLEAN
  • prefer_outdoor (선호_실외) — BOOLEAN
  • max_distance_km (최대거리) — DOUBLE
  • prefer_free (무료선호여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP

users (사용자)

  • id (사용자id) — SERIAL — Primary key
  • username (사용자명) — VARCHAR(255) — NOT NULL
  • email (이메일) — VARCHAR(255)
  • age (나이) — INTEGER
  • gender (성별) — VARCHAR(20)
  • created_at (생성일) — TIMESTAMP