hr
Tables (18)
admin_log
- log_id — BIGINT — Primary key — NOT NULL
- action — VARCHAR(255)
- created_at — DATETIME
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
alarm
- notification_id — BIGINT — Primary key — NOT NULL
- message — TEXT
- type — VARCHAR(50)
- is_read — BOOLEAN
- created_at — DATETIME
- email_noti — BOOLEAN
- kakao_noti — BOOLEAN
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
app_career
- career_id — Primary key — NOT NULL
- company_name — VARCHAR(255)
- position — VARCHAR(100)
- start_date — DATE
- end_date — DATE
- responsibilities — TEXT
- resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
app_education
- edu_id — BIGINT — Primary key — NOT NULL
- school_name — VARCHAR(255)
- degree — VARCHAR(100)
- major — VARCHAR(100)
- admission_year — YEAR
- graduation_year — YEAR
- resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
application
- application_id — BIGINT — Primary key — NOT NULL
- status — VARCHAR(30)
- created_at — DATETIME
- resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
- position_id — BIGINT — Foreign key → job_position.position_id — NOT NULL
company
- company_id — BIGINT — Primary key — NOT NULL
- company_name — VARCHAR(255) — NOT NULL
- introduction — TEXT
- business_number — VARCHAR(50)
- office_phone — VARCHAR(50)
- office_address — VARCHAR(255)
- employee_count — INT
- logo_url — VARCHAR(255)
- annual_sales — BIGINT
- ceo_name — VARCHAR(100)
- homepage_url — VARCHAR(255)
- updated_at — DATETIME
- created_at — DATETIME
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
company_welfare
- welfare_id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → company.company_id — NOT NULL
- benefit_type — VARCHAR(50)
- benefit_name — VARCHAR(100)
- is_highlighted — BOOLEAN
- display_order — INT
- created_at — DATETIME
- updated_at — DATETIME
inquiry
- inquiry_id — BIGINT — Primary key — NOT NULL
- content — TEXT
- status — VARCHAR(30)
- created_at — DATETIME
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
interview
- interview_id — BIGINT — Primary key — NOT NULL
- schedule — DATETIME
- result — VARCHAR(50)
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- application_id — BIGINT — Foreign key → application.application_id — NOT NULL
job_position
- position_id — BIGINT — Primary key — NOT NULL
- position_name — VARCHAR(100) — NOT NULL
- job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL
job_posting
- job_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- requirements — TEXT
- deadline — DATE
- location — VARCHAR(255)
- salary_range — VARCHAR(100)
- created_at — DATETIME
- career_min_year — INT DEFAULT 0
- career_max_year — INT DEFAULT 0
- education_level — ENUM('고졸','학사','석사','박사')
- company_id — BIGINT — Foreign key → company.company_id — NOT NULL
job_posting_skill_map
- skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
- job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL
payment
- payment_id — BIGINT — Primary key — NOT NULL
- amount — DECIMAL(12,2) — NOT NULL
- service_type — VARCHAR(100)
- paid_at — DATETIME
- payment_method — VARCHAR(50)
- card_registered — BOOLEAN
- security_level — ENUM('BASIC','HIGH')
- registered_card_info — TEXT
- refund — VARCHAR(50)
- company_id — BIGINT — Foreign key → company.company_id — NOT NULL
resume
- resume_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255)
- experience — TEXT
- self_intro — TEXT
- birth_date — DATE
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
role
- role_id — BIGINT — Primary key — NOT NULL
- role_name — VARCHAR(50) — NOT NULL
skill
- skill_id — BIGINT — Primary key — NOT NULL
- skill_name — VARCHAR(100)
user_role
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- role_id — BIGINT — Foreign key → role.role_id — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- user_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30)
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone — VARCHAR(50)
- address — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME