saraphina
Tables
conversation_insights
conversation_id, date, title, relationship_type, participants, topics, arc_start, arc_mid, arc_end, energy_direction, jake_role, key_moment, needs_expressed, connection_quality, emotional_keywords, analyzed_at, prompt_tokens, completion_tokens
648 rows
omi_conversations
id, created_at, started_at, finished_at, title, overview, emoji, category, language, source, raw_json
1,037 rows
omi_transcript_segments
id, conversation_id, text, speaker_id, speaker_name, start_time, end_time
75,810 rows
oura_daily_activity
id, day, score, active_calories, steps, equivalent_walking_distance, total_calories, contributors, raw_json
111 rows
oura_daily_readiness
id, day, score, temperature_deviation, activity_balance, body_temperature, hrv_balance, recovery_index, resting_heart_rate, sleep_balance, contributors, raw_json
90 rows
oura_daily_sleep
id, day, score, total_sleep_duration, deep_sleep, rem_sleep, light_sleep, efficiency, latency, restfulness, timing, contributors, raw_json
90 rows
oura_sleep_details
id, day, bedtime_start, bedtime_end, duration, total_sleep_duration, type, heart_rate, hrv, raw_json
176 rows
oura_workouts
id, day, activity, calories, distance, duration, intensity, start_datetime, end_datetime, raw_json
2 rows
sentiment_conversations
conversation_id, date, title, sentiment, score, emotions, emotional_arc, topics, relationship_quality, segment_count, raw_json
736 rows
sentiment_daily
date, avg_score, positive_pct, negative_pct, neutral_pct, dominant_emotions, emotional_arc, segment_count, raw_json
49 rows