HR

테이블 (22)

ADMIN

  • AdminID — BIGINT — 기본 키 — NOT NULL
  • Username — VARCHAR(100) — NOT NULL
  • PasswordHash — VARCHAR(255) — NOT NULL
  • Role — VARCHAR(50)

ALARM

  • AlarmID — BIGINT — 기본 키 — NOT NULL
  • CompanyID — 외래 키 → COM INFO.CompanyID — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → APPLICANT INFO.ApplicantID — NOT NULL
  • UserType — VARCHAR(20) — NOT NULL
  • UserID — BIGINT — NOT NULL
  • Type — VARCHAR(50)
  • Payload — TEXT
  • SentAt — TIMESTAMP — NOT NULL

APPLICANT INFO

  • ApplicantID — BIGINT — 기본 키 — NOT NULL
  • Name — VARCHAR(100) — NOT NULL
  • Contact (Email) — VARCHAR(200) — NOT NULL
  • DOB (Date Of Birth) — DATE
  • Phone — VARCHAR(50) — NOT NULL
  • CreatedAt — TIMESTAMP — NOT NULL
  • TotalExperienceYears (Field) — INT
  • CurrentRole (Field2) — VARCHAR(100)

APPLICANT SKILL

  • ApplicantSkillID — BIGINT — 기본 키 — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → APPLICANT INFO.ApplicantID — NOT NULL
  • SkillID — BIGINT — 외래 키 → SKILL.SkillID — NOT NULL

APPLIED COMPANIES( + ATS COMMENT 포함) (APPLICANT TRACKING)

  • ApplicationID — BIGINT — 기본 키 — NOT NULL
  • JobID — BIGINT — 외래 키 → JOB POSTING.JobID — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → APPLICANT INFO.ApplicantID — NOT NULL
  • Status — VARCHAR(50) — NOT NULL
  • AppliedAt — TIMESTAMP — NOT NULL

ATS COMMENT

  • CommentID — BIGINT — 기본 키 — NOT NULL
  • ApplicationID — BIGINT — 외래 키 → APPLIED COMPANIES( + ATS COMMENT 포함).ApplicationID — NOT NULL
  • ManagerID — BIGINT — NOT NULL
  • Comment — TEXT — EX
  • CreatedAt — TIMESTAMP — NOT NULL

CAREER

  • CareerID — BIGINT — 기본 키 — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → APPLICANT INFO.ApplicantID — NOT NULL
  • CompanyName — VARCHAR(200)
  • Position — VARCHAR(100)
  • StartDate — DATE
  • EndDate — DATE
  • Description — TEXT

CAREER SKILL

  • CareerSkillID — BIGINT — 기본 키 — NOT NULL
  • ApplicantSkillID — BIGINT — 외래 키 → APPLICANT SKILL.ApplicantSkillID — NOT NULL
  • CareerID — BIGINT — 외래 키 → CAREER.CareerID — NOT NULL

COM INFO

  • CompanyID — 기본 키 — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • BusinessNumber — VARCHAR(50)
  • CreatedAt — TIMESTAMP — NOT NULL
  • UpdatedAt — TIMESTAMP — NOT NULL

COM PROF

  • CompanyProfileID — BIGINT — 기본 키 — NOT NULL
  • CompanyID — BIGINT — 외래 키 → COM INFO.CompanyID — NOT NULL
  • LogoURL — VARCHAR(512)
  • EmployeeCount — INT
  • Revenue — BIGINT
  • Industry — VARCHAR(100)
  • Address — VARCHAR(255)
  • CEOName — VARCHAR(100)

COMPANY USER AUTHORITY

  • CompanyUserAuthorityID (Key) — BIGINT — 기본 키 — NOT NULL
  • ManagerID — BIGINT — 외래 키 → HR MANAGER.ManagerID — NOT NULL
  • AdminID — BIGINT — 외래 키 → ADMIN.AdminID — NOT NULL
  • Role — VARCHAR(50) — NOT NULL
  • Field

EDUCATION

  • EducationID — BIGINT — 기본 키 — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → APPLICANT INFO.ApplicantID — NOT NULL
  • School — VARCHAR(200)
  • Major — VARCHAR(100)
  • StartYear — INT
  • EndYear — INT
  • DegreeLevel (Field) — ENUM('박사','석사','학사','준학사') — NOT NULL

HR MANAGER

  • ManagerID — BIGINT — 기본 키 — NOT NULL
  • CompanyID — BIGINT — 외래 키 → COM INFO.CompanyID — NOT NULL
  • Name — VARCHAR(100) — NOT NULL
  • Email — VARCHAR(200) — NOT NULL
  • Role — VARCHAR(50)

JOB POSTING

  • JobID — BIGINT — 기본 키 — NOT NULL
  • CompanyID — BIGINT — 외래 키 → COM INFO.CompanyID — NOT NULL
  • Title — VARCHAR(200) — NOT NULL
  • Description — TEXT
  • Requirements — TEXT
  • PostedAt — TIMESTAMP — NOT NULL
  • ClosesAt — TIMESTAMP

JOB POSTING SKILL

  • JobPostingSkillID — BIGINT — 기본 키 — NOT NULL
  • JobID — BIGINT — 외래 키 → JOB POSTING.CompanyID — NOT NULL
  • SkillID — BIGINT — 외래 키 → SKILL.SkillID — NOT NULL

MANAGE USERS

  • MaangeUsersID — BIGINT — 기본 키 — NOT NULL
  • AdminID — BIGINT — 외래 키 → ADMIN.AdminID — NOT NULL
  • UserType — ENUM('Company','Applicant') — NOT NULL
  • UserID — BIGINT — NOT NULL
  • OldStatusOldStatus — ENUM('Active','Suspended','Dormant','Deleted') — NOT NULL
  • NewStatus — ENUM('Active','Suspended','Dormant','Deleted') — NOT NULL
  • ChangedAt — TIMESATMP

MENU

  • MenuID — BIGINT — 기본 키 — NOT NULL
  • AdminID — BIGINT — 외래 키 → ADMIN.AdminID — NOT NULL
  • Title — VARCHAR(100) — NOT NULL
  • ParentMenuID — BIGINT
  • URL — VARCHAR(255)
  • RequiredRole — VARCHAR(50)

MESSAGE

  • MessageID — BIGINT — 기본 키 — NOT NULL
  • CompanyID — 외래 키 → COM INFO.CompanyID — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → APPLICANT INFO.ApplicantID — NOT NULL
  • FromUserType — VARCHAR(20) — NOT NULL
  • FromUserID — BIGINT — NOT NULL
  • ToUserType — VARCHAR(20) — NOT NULL
  • ToUserID — BIGINT — NOT NULL
  • Content — TEXT
  • SentAt — TIMESTAMP — NOT NULL

PAYMENT/SALES

  • PaymentID — BIGINT — 기본 키 — NOT NULL
  • CompanyID — BIGINT — 외래 키 → COM INFO.CompanyID — NOT NULL
  • Amount — DECIMAL(12,2)
  • Method — VARCHAR(50)
  • Status — VARCHAR(50)
  • CreatedAt — TIMESTAMP — NOT NULL

RESUME

  • ResumeID — BIGINT — 기본 키 — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → APPLICANT INFO.ApplicantID — NOT NULL
  • FilePath — VARCHAR(512)
  • UploadedAt — TIMESTAMP
  • Version — INT — NOT NULL

RESUME TRACKING

  • ResumeTrackingID — BIGINT — 기본 키 — NOT NULL
  • ResumeID — BIGINT — 외래 키 → RESUME.ResumeID — NOT NULL
  • ApplicationID — BIGINT — 외래 키 → APPLIED COMPANIES( + ATS COMMENT 포함).ApplicationID — NOT NULL
  • ApplicantID — BIGINT — 외래 키 → RESUME.ApplicantID — NOT NULL

SKILL

  • SkillID — BIGINT — 기본 키 — NOT NULL
  • Name — VARCHAR(100) — NOT NULL