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