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 — 구독 시작일