wanted

Tables (4)

Company (회사)

  • company_id (회사_id) — Long — Primary key — NOT NULL
  • company_name (회사명) — varchar(100)
  • country (회사_국가) — varchar(100)
  • region (회사_지역) — varchar(100)

JobApplication (지원내역)

  • user_id (사용자_id) — Long — Foreign key → User.user_id — NOT NULL
  • job_posting_id (채용공고_id) — Long — Foreign key → JobPosting.job_posting_id — NOT NULL
  • created_at (등록일자) — LocalDateTime
  • updated_at (수정일자) — LocalDateTime
  • status (지원상태) — enum
  • notes (메모) — varchar(255)
  • resume (이력서) — varchar(255)

JobPosting (채용공고)

  • job_posting_id (채용공고_id) — Long — Primary key — NOT NULL
  • position_title (채용포지션) — varchar(255)
  • hiring_bonus (채용보상금) — int
  • job_description (채용내용) — varchar(255)
  • skills_required (사용기술) — varchar(255)
  • created_at (등록일자) — LocalDateTime
  • updated_at (수정일자) — LocalDateTime
  • company_id (회사_id) — Long — Foreign key → Company.company_id — NOT NULL

User (사용자)

  • user_id (사용자_id) — Long — Primary key — NOT NULL
  • username (사용자명) — varchar(255)
  • email (사용자_이메일) — varchar(255)
  • created_at (사용자_생성일자) — LocalDateTime
  • updated_at (사용자_수정일자) — LocalDateTime