hr2

Tables (17)

ATSComment

  • CommentID — BIGINT
  • ApplicationID — BIGINT — NOT NULL
  • ManagerID — BIGINT — NOT NULL
  • Comment — TEXT — EX
  • CreatedAt — TIMESTAMP — NOT NULL

AdminUser

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

Alarm

  • AlarmID — BIGINT
  • UserType — VARCHAR(20) — NOT NULL
  • UserID — BIGINT — NOT NULL
  • Type — VARCHAR(50)
  • Payload — TEXT
  • SentAt — TIMESTAMP — NOT NULL

Applicant

  • ApplicantID — BIGINT
  • Name — VARCHAR(100) — NOT NULL
  • Email — VARCHAR(200) — NOT NULL
  • DOB — DATE
  • Phone — VARCHAR(20)
  • CreatedAt — TIMESTAMP — NOT NULL

ApplicantSkill

  • ApplicantID — BIGINT — Primary key — NOT NULL
  • SkillID — BIGINT — Primary key — NOT NULL

Application

  • ApplicationID — BIGINT
  • JobID — BIGINT — NOT NULL
  • ApplicantID — BIGINT — NOT NULL
  • Status — VARCHAR(50) — NOT NULL
  • AppliedAt — TIMESTAMP — NOT NULL

Career

  • CareerID — BIGINT
  • ApplicantID — BIGINT — NOT NULL
  • CompanyName — VARCHAR(200)
  • Position — VARCHAR(100)
  • StartDate — DATE
  • EndDate — DATE
  • Description — TEXT

Company

  • CompanyID — BIGINT
  • Name — VARCHAR(255) — NOT NULL
  • BusinessNumber — VARCHAR(50)
  • CreatedAt — TIMESTAMP — NOT NULL
  • UpdatedAt — TIMESTAMP — NOT NULL

CompanyProfile

  • CompanyProfileID — BIGINT
  • CompanyID — BIGINT — NOT NULL
  • LogoURL — VARCHAR(512)
  • EmployeeCount — INT
  • Revenue — BIGINT
  • Industry — VARCHAR(100)
  • Address — VARCHAR(255)
  • CEOName — VARCHAR(100)

Education

  • EducationID — BIGINT
  • ApplicantID — BIGINT — NOT NULL
  • School — VARCHAR(200)
  • Major — VARCHAR(100)
  • StartYear — INT
  • EndYear — INT

HRManager

  • ManagerID — BIGINT
  • CompanyID — BIGINT — NOT NULL
  • Name — VARCHAR(100) — NOT NULL
  • Email — VARCHAR(200) — NOT NULL
  • Role — VARCHAR(50)

JobPosting

  • JobID — BIGINT
  • CompanyID — BIGINT — NOT NULL
  • Title — VARCHAR(200) — NOT NULL
  • Description — TEXT
  • Requirements — TEXT
  • PostedAt — TIMESTAMP — NOT NULL
  • ClosesAt — TIMESTAMP

JobPostingSkill

  • JobID — BIGINT — Primary key — NOT NULL
  • SkillID — BIGINT — Primary key — NOT NULL

Menu

  • MenuID — BIGINT
  • Title — VARCHAR(100) — NOT NULL
  • ParentMenuID — BIGINT
  • URL — VARCHAR(255)
  • RequiredRole — VARCHAR(50)

Message

  • MessageID — BIGINT
  • 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

  • PaymentID — BIGINT
  • CompanyID — BIGINT — NOT NULL
  • Amount — DECIMAL(12,2)
  • Method — VARCHAR(50)
  • Status — VARCHAR(50)
  • CreatedAt — TIMESTAMP — NOT NULL

Skill

  • SkillID — BIGINT
  • Name — VARCHAR(100) — NOT NULL