erd
Tables (15)
analysis_report
- id (PK) — bigint — Primary key — NOT NULL
- total_score (Field) — float
- alignment_score (Field7) — float
- best_moment (Field4) — text
- worst_moment (Field8) — text
- mentor_feedback (Field2) — text
- report_status (Field3) — enum
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- mentee_id (FK2) — bigint — Foreign key → session_participant.id — NOT NULL
- session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL
interview_answer
- id (PK) — bigint — Primary key — NOT NULL
- stt_text (Field) — text
- answer_start (Field2) — timestamp
- answer_end (Field3) — timestamp
- ai_score (Field4) — float
- mentor_score (Field7) — float
- gap (Field8) — float
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL
- question_id (FK3) — bigint — Foreign key → interview_question.id — NOT NULL
- mentee_id (FK2) — bigint — Foreign key → user.id — NOT NULL
interview_question
- id (PK) — bigint — Primary key — NOT NULL
- content (Field) — string
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL
interview_session
- id (PK) — bigint — Primary key — NOT NULL
- job_category (Field) — string
- status (Field2) — enum
- started_at (Field3) — timestamp
- ended_at (Field4) — timestamp
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- mentor_id (FK) — bigint — Foreign key → user.id — NOT NULL
job_posting
- id (PK) — bigint — Primary key — NOT NULL
- company (Field) — string
- job_category (Field2) — string
- raw_text (Field3) — text
- url (Field4) — string
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL
job_skill
- id (PK) — bigint — Primary key — NOT NULL
- skill_name (Field) — string
- skill_type (Field2) — enum
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- job_posting_id (FK) — bigint — Foreign key → job_posting.id — NOT NULL
mentor_availability
- id (PK) — bigint — Primary key — NOT NULL
- day_of_week (Field) — enum
- time_slot (Field2) — string
- slot_type (Field3) — enum
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- user_id (FK) — bigint — Foreign key → user.id — NOT NULL
resume
- id (PK) — bigint — Primary key — NOT NULL
- content (Field) — text
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL
resume_skill
- id (PK) — bigint — Primary key — NOT NULL
- skill_name (Field) — string
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- resume_id (FK) — bigint — Foreign key → resume.id — NOT NULL
script_segment
- id (PK) — bigint — Primary key — NOT NULL
- segment_text (Field) — text
- segment_type (Field2) — enum
- start_offset (Field3) — int
- end_offset (Field4) — int
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- answer_id (FK) — bigint — Foreign key → interview_answer.id — NOT NULL
session_participant
- id (PK) — bigint — Primary key — NOT NULL
- answer_status (Field) — enum
- joined_at (Field2) — timestamp
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- user_id (FK2) — bigint — Foreign key → user.id — NOT NULL
- session_id (FK) — bigint — Foreign key → interview_session.id — NOT NULL
speech_analysis
- id (PK) — bigint — Primary key — NOT NULL
- wpm (Field) — float
- dead_air_count (Field3) — int
- is_star_s (Field4) — boolean
- is_star_t (Field7) — boolean
- is_star_a (Field8) — boolean
- is_star_r (Field9) — boolean
- star_ratio (Field10) — float
- answer_duration_sec (Field2) — int
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- answer_id (FK) — bigint — Foreign key → interview_answer.id — NOT NULL
tag
- id (PK) — bigint — Primary key — NOT NULL
- name (Field) — string
- category (Field2) — enum
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
user
- id (PK) — bigint — Primary key — NOT NULL
- name (Field) — string
- email (Field2) — string
- password (Field3) — string
- role (Field4) — enum
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
user_tag
- id (PK) — bigint — Primary key — NOT NULL
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- tag_id (FK) — bigint — Foreign key → tag.id — NOT NULL
- user_id (FK2) — bigint — Foreign key → user.id — NOT NULL