EXPO
Tables (9)
ai_feedbacks
- feedback_id — SERIAL — Primary key — NOT NULL
- session_id — INT — Foreign key → sessions.session_id — NOT NULL
- feedback_category — VARCHAR(30) — NOT NULL
- commentary — TEXT — NOT NULL
- sentence_template — TEXT
- created_at — TIMESTAMP
coaching_logs
- log_id — SERIAL — Primary key — NOT NULL
- session_id — INT — Foreign key → sessions.session_id — NOT NULL
- turn_number — INT — NOT NULL
- timestamp_seconds — INT — NOT NULL
- log_type — VARCHAR(20) — NOT NULL
- message — TEXT — NOT NULL
consent_logs
- consent_id — SERIAL — Primary key — NOT NULL
- user_id — VARCHAR(64) — Foreign key → users.user_id — NOT NULL
- consent_type — VARCHAR(50) — NOT NULL
- is_agreed — BOOLEAN — NOT NULL
- purpose — TEXT — NOT NULL
- retention_period — VARCHAR(50) — NOT NULL
- policy_version — VARCHAR(20) — NOT NULL
- action_date — TIMESTAMP
organizations
- organization_id — VARCHAR(50) — Primary key — NOT NULL
- organization_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
session_details
- detail_id — SERIAL — Primary key — NOT NULL
- session_id — INT — Foreign key → sessions.session_id — NOT NULL
- stt_full_text — TEXT
- risky_expression_count — INT
- evasive_expression_count — INT
- follow_up_questions — JSONB
- speech_rate — FLOAT
- silence_ratio — FLOAT
- voice_energy — FLOAT
- gaze_front_ratio — FLOAT
- shoulder_tilt_avg — FLOAT
- upper_body_movement — FLOAT
session_raw_files
- session_id — INT — Foreign key → sessions.session_id — NOT NULL
- audio_file_path — VARCHAR(255)
- video_capture_path — VARCHAR(255)
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
sessions
- session_id — SERIAL — Primary key — NOT NULL
- user_id — VARCHAR(64) — Foreign key → users.user_id — NOT NULL
- scenario_name — VARCHAR(50) — NOT NULL
- difficulty — VARCHAR(20) — NOT NULL
- total_duration_seconds — INT — NOT NULL
- total_turns — INT — NOT NULL
- final_score — INT — NOT NULL
- response_fit_score — INT — NOT NULL
- voice_fit_score — INT — NOT NULL
- eye_fit_score — INT — NOT NULL
- posture_fit_score — INT — NOT NULL
- created_at — TIMESTAMP
system_logs
- sys_log_id — SERIAL — Primary key — NOT NULL
- device_id — VARCHAR(50) — NOT NULL
- organization_id — VARCHAR(50)
- stt_latency_ms — INT
- vision_latency_ms — INT
- status_code — VARCHAR(20)
- error_message — TEXT
- created_at — TIMESTAMP
users
- user_id — VARCHAR(64) — Primary key — NOT NULL
- organization_id — VARCHAR(50) — Foreign key → organizations.organization_id — NOT NULL
- created_at — TIMESTAMP