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