Vibe ERD v2.1

Tables (13)

answer_scores

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → interview_sessions.id — NOT NULL
  • turn — INT — NOT NULL
  • score — INT — NOT NULL
  • is_follow_up — BOOLEAN — NOT NULL
  • feedback — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

badges

  • id — BIGINT — Primary key — NOT NULL
  • stage — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • unlock_condition — VARCHAR(50) — NOT NULL

interview_sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
  • persona_config_id — BIGINT — Foreign key → persona_config.id — NOT NULL
  • selected_keyword — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

judgment_results

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → interview_sessions.id — NOT NULL
  • total_score — INT — NOT NULL
  • passed — BOOLEAN — NOT NULL
  • overall_feedback — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

messages

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → interview_sessions.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • turn — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

persona_config

  • id — BIGINT — Primary key — NOT NULL
  • level — INT — NOT NULL
  • tone — VARCHAR(20) — NOT NULL

questions

  • message_id — BIGINT — Foreign key → messages.id — NOT NULL
  • expected_answer — TEXT — NOT NULL

refresh_tokens

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

resume_file_cleanup_tasks

  • id — BIGINT — Primary key — NOT NULL
  • resume_id — BIGINT
  • s3_key — VARCHAR(255) — NOT NULL
  • s3_etag — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • attempt_count — INT — NOT NULL
  • last_attempt_at — TIMESTAMP

resumes

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — ENUM('RESUME', 'PORTFOLIO') — NOT NULL
  • s3_key — VARCHAR(255)
  • s3_etag — VARCHAR(255)
  • extracted_text — TEXT
  • parse_status — VARCHAR(20) — NOT NULL
  • file_hash — VARCHAR(64)
  • cache_expires_at — TIMESTAMP
  • last_uploaded_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • original_file_name — VARCHAR(255)
  • file_size — BIGINT

user_badges

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • badge_id — BIGINT — Foreign key → badges.id — NOT NULL
  • acquired_at — TIMESTAMP — NOT NULL

user_unlock_status

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • unlocked_level — INT — NOT NULL
  • progress_gauge — INT — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • google_id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • profile_image_key — VARCHAR(255)