introduction

Tables (7)

Company (기업)

  • company_id (id) — Long — Primary key — NOT NULL
  • name (이름) — String
  • industry (분야) — String
  • description (설명) — String
  • latest_info (최신정보) — String

Essay (자기소개서)

  • question_id (id2) — Long — Foreign key → Question.question_id — NOT NULL
  • member_id (id4) — Long — Foreign key → Member.member_id — NOT NULL
  • version (버전) — Integer

JobPosting (채용공고정보)

  • post_id (id) — Long — Primary key — NOT NULL
  • company_id (id2) — Long — Foreign key → Company.company_id — NOT NULL
  • job_title (직무명) — String
  • responsibilities (주요 업무) — String
  • qualifications (자격 요건) — String
  • preferred (우대 사항) — String
  • deadline (지원 마감일) — DateTime

Member (회원)

  • member_id (id) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • name (이름) — String
  • age (나이) — Integer
  • role (역할) — ENUM

Profile (회원 상세 정보)

  • member_id (id) — Long — Foreign key → Member.member_id — NOT NULL
  • education (학력) — String
  • experiences (이력) — String
  • skills (스킬) — String
  • awards (수상이력) — String

Question (자소서 문항)

  • question_id (id) — Long — Primary key — NOT NULL
  • post_id (id2) — Long — Foreign key → JobPosting.post_id — NOT NULL
  • question_text (문항) — String

TargetCompanies (관심기업)

  • member_id (id) — Long — Foreign key → Member.member_id — NOT NULL
  • company_id (id2) — Long — Foreign key → Company.company_id — NOT NULL
  • memo (메모) — String
  • Field