MyERD

Tables (6)

feedback_reports

  • id — INT
  • session_id — INT — NOT NULL
  • total_score — INT
  • strengths — TEXT
  • weaknesses — TEXT
  • suggestions — TEXT
  • report_json — JSON
  • created_at — DATETIME

interview_questions

  • id — INT
  • company_name — VARCHAR(100) — NOT NULL
  • job_position — VARCHAR(100)
  • question_text — TEXT — NOT NULL
  • question_type — ENUM('인성', '기술', '경험')
  • level — TINYINT
  • created_at — DATETIME

interview_sessions

  • id — INT
  • user_id — INT — NOT NULL
  • session_uuid — VARCHAR(64) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME

user_answers

  • id — INT
  • session_id — INT — NOT NULL
  • question_id — INT — NOT NULL
  • audio_path — VARCHAR(255)
  • transcription — TEXT
  • created_at — DATETIME

users

  • id — INT
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • interest_company — VARCHAR(100)
  • created_at — DATETIME

voice_analysis_results

  • id — INT
  • answer_id — INT — NOT NULL
  • pronunciation_score — TINYINT
  • emotion — VARCHAR(30)
  • speed_wpm — INT
  • filler_count — INT
  • pitch_variation — VARCHAR(30)