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