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