EmotiPlace

Tables (6)

auth (회원)

  • UserID (user_id) — SERIAL — Primary key
  • Emai (email) — VARCHAR(255) — NOT NULL
  • Nickname (nickname) — VARCHAR(50)
  • PasswordHash (password_hash) — VARCHAR(255) — NOT NULL
  • CreatedAt (created_at) — TIMESTAMP

persona (페르소나)

  • PersonaID (persona_id) — SERIAL — Primary key
  • Name (name) — VARCHAR(50) — NOT NULL
  • SystemPrompt (system_prompt) — TEXT — NOT NULL
  • ToneKeywords (tone_keywords) — TEXT
  • ForbiddenWords (forbidden_words) — TEXT
  • CreatedAt (created_at) — TIMESTAMP

place (장소)

  • PlaceID (place_id) — SERIAL — Primary key
  • Name (name) — VARCHAR(200) — NOT NULL
  • Category (category) — VARCHAR(50)
  • Address (address) — TEXT
  • Latitude (lat) — DOUBLE — NOT NULL
  • Longitude (lng) — DOUBLE — NOT NULL
  • OperatingHours (operating_hours) — JSONB
  • AtmosphereText (atmosphere_text) — TEXT
  • MaxGroupSize (max_group_size) — INT
  • IsOutdoor (is_outdoor) — BOOLEAN
  • UpdatedAt (updated_at) — TIMESTAMP

psych_reference (심리학 문헌)

  • ReferenceID (ref_id) — SERIAL — Primary key
  • Theory (theory) — VARCHAR(50) — NOT NULL
  • SourceText (source_text) — TEXT — NOT NULL
  • EmotionTags (emotion_tags) — TEXT
  • EnvironmentRecommendation (environment_recommendation) — TEXT

recommendation (추천 이력)

  • RecommendationID (rec_id) — INT — Primary key
  • SessionID (session_id) — UUID — Foreign key → session.SessionID
  • PlaceID (place_id) — INT — Foreign key → place.PlaceID
  • SemanticSimilarity (semantic_similarity) — FLOAT
  • PersonaReason (persona_reason) — TEXT
  • Psychological Recommendation (psych_rationale) — TEXT
  • CreatedAt (created_at) — TIMESTAMP

session (세션)

  • SessionID (session_id) — UUID — Primary key
  • UserID (user_id) — SERIAL — Foreign key → auth.UserID
  • PersonaID (persona_id) — INT — Foreign key → persona.PersonaID
  • Title (title) — VARCHAR(100)
  • ConversationHistory (conversation_history) — JSONB
  • EmotionScores (emotion_scores) — JSONB
  • EnvironmentQuery (environment_query) — TEXT
  • CreatedAt (created_at) — TIMESTAMP
  • ExpiresAt (expires_at) — TIMESTAMP — NOT NULL
  • MessageCount (messgae_count) — INTEGER