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)