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