HirecareRay
Tables (18)
companies
- company_id — BIGINT — Primary key — NOT NULL
- company_name — VARCHAR(255) — NOT NULL
- industry — VARCHAR(255)
- employee_count — INT
- company_summary — LONGTEXT
- talent_profile — LONGTEXT
- vision — LONGTEXT
- monthly_view_count — INT
- bookmark_count — INT
- created_at — DATETIME
company_analyses
- analysis_id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- financial_analysis — LONGTEXT
- swot_analysis — LONGTEXT
- growth_potential — LONGTEXT
- industry_status — LONGTEXT
- competitor_analysis — LONGTEXT
- jobplanet_review_summary — LONGTEXT
- updated_at — DATETIME
company_bookmarks
- bookmark_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- created_at — DATETIME
- UNIQUE(user_id, — company_id)
company_news
- news_id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- title — VARCHAR(500)
- content — LONGTEXT
- source_url — VARCHAR(1000)
- published_at — DATETIME
cover_letters
- cover_letter_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255)
- content — LONGTEXT
- created_at — DATETIME
interview_questions
- question_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → interview_sessions.session_id — NOT NULL
- question_type — ENUM('COMPANY','JOB','COMMON')
- question_text — LONGTEXT
- answer_text — LONGTEXT
interview_results
- result_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → interview_sessions.session_id — NOT NULL
- facial_feedback — LONGTEXT
- voice_feedback — LONGTEXT
- answer_feedback — LONGTEXT
- strengths — TEXT
- weaknesses — TEXT
- improvements — TEXT
- improvement_methods — TEXT
- replay_url — VARCHAR(1000)
- created_at — DATETIME
interview_sessions
- session_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id
- job_posting_id — BIGINT — Foreign key → job_postings.job_posting_id
- interview_duration — INT
- started_at — DATETIME
- ended_at — DATETIME
job_bookmarks
- bookmark_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- job_posting_id — BIGINT — Foreign key → job_postings.job_posting_id — NOT NULL
- created_at — DATETIME
- UNIQUE(user_id, — job_posting_id)
job_postings
- job_posting_id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- title — VARCHAR(500)
- department — VARCHAR(255)
- position_name — VARCHAR(255)
- description — LONGTEXT
- required_skills — TEXT
- deadline — DATE
- created_at — DATETIME
portfolios
- portfolio_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- url — VARCHAR(1000)
- created_at — DATETIME
projects
- project_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255)
- description — LONGTEXT
- start_date — DATE
- end_date — DATE
resumes
- resume_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255)
- content — LONGTEXT
- created_at — DATETIME
similar_companies
- id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- similar_company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- similarity_score — DECIMAL(5,2)
user_company_matches
- match_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
- match_score — DECIMAL(5,2)
- strengths — TEXT
- weaknesses — TEXT
- improvements — TEXT
user_profiles
- profile_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- summary — TEXT
- strengths — TEXT
- weaknesses — TEXT
- improvements — TEXT
- created_at — DATETIME
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- profile_image_url — VARCHAR(500)
- created_at — DATETIME
- updated_at — DATETIME
view_histories
- history_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- company_id — BIGINT — Foreign key → companies.company_id
- job_posting_id — BIGINT — Foreign key → job_postings.job_posting_id
- viewed_at — DATETIME