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