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