saraphina
Tables
apple_health_workouts
id, day, activity_type, hk_workout_activity_type, start_datetime, end_datetime, duration_seconds, active_calories, total_calories, distance_meters, source_name, source_bundle_id, device_name, metadata_json, raw_json, synced_at
12 rows
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
740 rows
omi_conversations
id, created_at, started_at, finished_at, title, overview, emoji, category, language, source, raw_json
1,203 rows
omi_transcript_segments
id, conversation_id, text, speaker_id, speaker_name, start_time, end_time
84,582 rows
oura_daily_activity
id, day, score, active_calories, steps, equivalent_walking_distance, total_calories, contributors, raw_json
171 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
146 rows
oura_daily_sleep
id, day, score, total_sleep_duration, deep_sleep, rem_sleep, light_sleep, efficiency, latency, restfulness, timing, contributors, raw_json
146 rows
oura_sleep_details
id, day, bedtime_start, bedtime_end, duration, total_sleep_duration, type, heart_rate, hrv, raw_json
263 rows
oura_workouts
id, day, activity, calories, distance, duration, intensity, start_datetime, end_datetime, raw_json
3 rows
sentiment_conversations
conversation_id, date, title, sentiment, score, emotions, emotional_arc, topics, relationship_quality, segment_count, raw_json
890 rows
sentiment_daily
date, avg_score, positive_pct, negative_pct, neutral_pct, dominant_emotions, emotional_arc, segment_count, raw_json
49 rows