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