DB

Tables (18)

companies

  • company_id — INT
  • company_name — VARCHAR(255) — NOT NULL — 회사명
  • company_logo_url — VARCHAR(2048) — 회사 로고 이미지 URL

email_history

  • history_id — INT
  • user_id — INT — NOT NULL — FK: users.user_id
  • posting_id — INT — NOT NULL — FK: job_postings.posting_id
  • sent_at — TIMESTAMP — 발송 시간

employment_types

  • employment_type_id — INT
  • type_name — VARCHAR(100) — NOT NULL — 고용 형태 (e.g., 정규직, 계약직, 인턴)

job_postings

  • posting_id — INT
  • company_id — INT — NOT NULL — FK: companies.company_id
  • posting_title — VARCHAR(255) — NOT NULL — 공고명
  • job_description — TEXT — 수행 업무
  • apply_url — VARCHAR(2048) — 지원 링크
  • min_career_years — INT — 최소 경력 조건
  • max_career_years — INT — 최대 경력 조건 (없을 경우 NULL)
  • required_education — VARCHAR(100) — 학력 조건
  • is_specialist_available — BOOLEAN — 전문연구요원 가능 여부
  • required_major — VARCHAR(255) — 전공 조건
  • deadline — DATE — 서류 마감일
  • crawled_at — TIMESTAMP — 데이터 크롤링 시간

job_roles

  • job_role_id — INT
  • role_name — VARCHAR(100) — NOT NULL — 직무명 (e.g., 백엔드 개발자, 데이터 분석가)

locations

  • location_id — INT
  • location_name — VARCHAR(100) — NOT NULL — 근무 지역명 (e.g., 서울, 부산, 원격)

posting_employment_types

  • posting_id — INT — Primary key — NOT NULL — FK: job_postings.posting_id
  • employment_type_id — INT — Primary key — NOT NULL — FK: employment_types.employment_type_id

posting_job_roles

  • posting_id — INT — Primary key — NOT NULL — FK: job_postings.posting_id
  • job_role_id — INT — Primary key — NOT NULL — FK: job_roles.job_role_id

posting_locations

  • posting_id — INT — Primary key — NOT NULL — FK: job_postings.posting_id
  • location_id — INT — Primary key — NOT NULL — FK: locations.location_id

posting_skills

  • posting_id — INT — Primary key — NOT NULL — FK: job_postings.posting_id
  • skill_id — INT — Primary key — NOT NULL — FK: skills.skill_id

skills

  • skill_id — INT
  • skill_name — VARCHAR(100) — NOT NULL — 스킬명 (e.g., Java, Python, SQL)

unsubscribed_users

  • unsubscribe_id — INT
  • email — VARCHAR(255) — NOT NULL — 구독 해지한 사용자의 이메일
  • reason — TEXT — 구독 해지 사유
  • unsubscribed_at — TIMESTAMP — 구독 해지일

user_desired_companies

  • user_id — INT — Primary key — NOT NULL — FK: users.user_id
  • company_id — INT — Primary key — NOT NULL — FK: companies.company_id

user_desired_employment_types

  • user_id — INT — Primary key — NOT NULL — FK: users.user_id
  • employment_type_id — INT — Primary key — NOT NULL — FK: employment_types.employment_type_id

user_desired_job_roles

  • user_id — INT — Primary key — NOT NULL — FK: users.user_id
  • job_role_id — INT — Primary key — NOT NULL — FK: job_roles.job_role_id

user_desired_locations

  • user_id — INT — Primary key — NOT NULL — FK: users.user_id
  • location_id — INT — Primary key — NOT NULL — FK: locations.location_id

user_skills

  • user_id — INT — Primary key — NOT NULL — FK: users.user_id
  • skill_id — INT — Primary key — NOT NULL — FK: skills.skill_id

users

  • user_id — INT
  • email — VARCHAR(255) — NOT NULL — 이메일 주소
  • gender — VARCHAR(10) — 성별
  • birth_year — INT — 출생 연도
  • career_years — INT — 경력 연차 (신입은 0)
  • education_level — VARCHAR(50) — 최종 학력
  • major — VARCHAR(100) — 전공
  • is_specialist_candidate — BOOLEAN — 전문연구요원 해당 여부
  • subscribed_at — TIMESTAMP — 구독 시작일