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)