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