HR
Tables (19)
app_career
- career_id — BIGINT
- applicant_id — BIGINT — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- position — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- description — TEXT
app_education
- education_id — BIGINT
- applicant_id — BIGINT — NOT NULL
- school_name — VARCHAR(100) — NOT NULL
- major — VARCHAR(100) — NOT NULL
- degree — VARCHAR(50) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- gpa — DECIMAL(3,2)
app_skills
- app_skill_id — BIGINT
- applicant_id — BIGINT — NOT NULL
- skill_id — BIGINT — NOT NULL
- skill_level — VARCHAR(20) — NOT NULL
- years_of_exp — INT
applicant_info
- applicant_id — BIGINT
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- birth_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
applicant_tracking
- tracking_id — BIGINT
- application_id — BIGINT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- stage — VARCHAR(50) — NOT NULL
- updated_at — DATETIME — NOT NULL
- notes — TEXT
applied_companies
- application_id — BIGINT
- applicant_id — BIGINT — NOT NULL
- job_id — BIGINT — NOT NULL
- applied_date — DATETIME — NOT NULL
- status — VARCHAR(50) — NOT NULL
- resume_id — BIGINT
com_user_authority
- authority_id — BIGINT
- role_name — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
comp_info
- company_id — BIGINT
- business_number — VARCHAR(20) — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- industry — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
comp_prof
- profile_id — BIGINT
- company_id — BIGINT — NOT NULL
- company_size — VARCHAR(20) — NOT NULL
- description — TEXT — NOT NULL
- location — VARCHAR(200) — NOT NULL
- website — VARCHAR(255)
- logo_url — VARCHAR(500)
hr_managers
- manager_id — BIGINT
- company_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- position — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- department — VARCHAR(50)
- reports_to — BIGINT
job_posting
- job_id — BIGINT
- company_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- requirements — TEXT — NOT NULL
- position_type — VARCHAR(50) — NOT NULL
- salary_range — VARCHAR(100)
- location — VARCHAR(200) — NOT NULL
- posted_date — DATETIME — NOT NULL
- deadline — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
job_posting_skill
- job_skill_id — BIGINT
- job_id — BIGINT — NOT NULL
- skill_id — BIGINT — NOT NULL
- skill_level — VARCHAR(20) — NOT NULL
- is_required — BOOLEAN — NOT NULL
manage_users
- user_id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- authority_id — BIGINT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- last_login — DATETIME
menu
- menu_id — BIGINT
- menu_name — VARCHAR(100) — NOT NULL
- parent_menu_id — BIGINT
- menu_url — VARCHAR(255)
- menu_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
menu_authority
- menu_auth_id — BIGINT
- menu_id — BIGINT — NOT NULL
- authority_id — BIGINT — NOT NULL
- can_read — BOOLEAN — NOT NULL
- can_write — BOOLEAN — NOT NULL
- can_delete — BOOLEAN — NOT NULL
notifications
- notification_id — BIGINT
- user_type — VARCHAR(20) — NOT NULL
- user_id — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
resume_tracking
- resume_id — BIGINT
- applicant_id — BIGINT — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- uploaded_date — DATETIME — NOT NULL
- version — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
skills
- skill_id — BIGINT
- skill_name — VARCHAR(100) — NOT NULL
- skill_category — VARCHAR(50) — NOT NULL
- description — TEXT
subscriptions
- subscription_id — BIGINT
- company_id — BIGINT — NOT NULL
- plan_type — VARCHAR(50) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- status — VARCHAR(20) — NOT NULL