tutor avatar project

Tables (17)

coach_feedback

  • id — UUID
  • session_id — UUID — Foreign key → session_runs.id — NOT NULL
  • turn_id — UUID — Foreign key → session_turns.id
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • feedback_type — TEXT — NOT NULL
  • feedback_text — TEXT — NOT NULL
  • evidence_json — JSONB — NOT NULL
  • rewrite_example — TEXT
  • rubric_scores — JSONB — NOT NULL
  • model_name — TEXT
  • prompt_version — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

document_chunks

  • id — UUID
  • document_id — UUID — Foreign key → uploaded_documents.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • chunk_index — INT — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • heading — TEXT
  • page_no — INT
  • slide_no — INT
  • section_name — TEXT
  • token_count — INT
  • source_type — TEXT — NOT NULL
  • metadata_json — JSONB — NOT NULL
  • embedding — VECTOR(1024)
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(document_id, — chunk_index)

feedback_votes

  • id — UUID
  • feedback_id — UUID — Foreign key → coach_feedback.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • vote — TEXT — NOT NULL
  • comment_text — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(feedback_id, — user_id)

generated_questions

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • session_id — UUID
  • turn_index — INT
  • mode — TEXT — NOT NULL
  • question_text — TEXT — NOT NULL
  • source_json — JSONB — NOT NULL
  • difficulty — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

inference_traces

  • id — UUID
  • session_id — UUID — Foreign key → session_runs.id
  • turn_id — UUID — Foreign key → session_turns.id
  • component — TEXT — NOT NULL
  • model_name — TEXT
  • input_tokens — INT
  • output_tokens — INT
  • latency_ms — INT
  • status — TEXT — NOT NULL
  • trace_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

learner_profiles

  • user_id — UUID — Foreign key → users.id
  • target_role — TEXT
  • target_company — TEXT
  • practice_mode_default — TEXT
  • difficulty_default — TEXT
  • time_limit_sec — INT
  • voice_style — TEXT
  • avatar_id — TEXT
  • privacy_recording_opt_in — BOOLEAN — NOT NULL
  • personalization_enabled — BOOLEAN — NOT NULL
  • profile_json — JSONB — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

memory_items

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • memory_type — TEXT — NOT NULL
  • scope — TEXT — NOT NULL
  • content_text — TEXT — NOT NULL
  • confidence — NUMERIC(4,3)
  • source_session_id — UUID — Foreign key → session_runs.id
  • source_turn_id — UUID — Foreign key → session_turns.id
  • accepted_by_user — BOOLEAN
  • metadata_json — JSONB — NOT NULL
  • embedding — VECTOR(1024)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

model_versions

  • id — UUID
  • component — TEXT — NOT NULL
  • model_name — TEXT — NOT NULL
  • version_tag — TEXT
  • config_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

prompt_versions

  • id — UUID
  • prompt_name — TEXT — NOT NULL
  • version_tag — TEXT — NOT NULL
  • template_text — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(prompt_name, — version_tag)

realtime_signal_frames

  • id — BIGSERIAL
  • session_id — UUID — Foreign key → session_runs.id — NOT NULL
  • turn_id — UUID — Foreign key → session_turns.id
  • ts_ms — BIGINT — NOT NULL
  • source — TEXT — NOT NULL
  • metrics_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

report_snapshots

  • id — UUID
  • session_id — UUID — Foreign key → session_runs.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • overall_scores — JSONB — NOT NULL
  • trend_scores — JSONB — NOT NULL
  • strengths_json — JSONB — NOT NULL
  • weaknesses_json — JSONB — NOT NULL
  • next_actions_json — JSONB — NOT NULL
  • report_markdown — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

scenario_templates

  • id — UUID
  • scenario_type — TEXT — NOT NULL
  • role_target — TEXT
  • difficulty — TEXT
  • title — TEXT — NOT NULL
  • prompt_template — TEXT — NOT NULL
  • rubric_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

session_runs

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • mode — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • target_role — TEXT
  • target_company — TEXT
  • scenario_config — JSONB — NOT NULL
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

session_turns

  • id — UUID
  • session_id — UUID — Foreign key → session_runs.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • turn_index — INT — NOT NULL
  • question_id — UUID — Foreign key → generated_questions.id
  • question_text — TEXT
  • transcript_final — TEXT
  • transcript_word_count — INT
  • turn_started_at — TIMESTAMPTZ
  • turn_ended_at — TIMESTAMPTZ
  • latency_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • UNIQUE(session_id, — turn_index)

turn_signal_summaries

  • turn_id — UUID — Foreign key → session_turns.id
  • audio_metrics — JSONB — NOT NULL
  • vision_metrics — JSONB — NOT NULL
  • summary_metrics — JSONB — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

uploaded_documents

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • file_name — TEXT — NOT NULL
  • file_type — TEXT — NOT NULL
  • doc_type — TEXT — NOT NULL
  • object_key — TEXT — NOT NULL
  • mime_type — TEXT
  • language — TEXT
  • metadata_json — JSONB — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID
  • email — TEXT
  • display_name — TEXT
  • preferred_language — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL