hr2

Tables (22)

ADMIN

  • admin_id — VARCHAR(50)
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • role — ENUM('SUPER_ADMIN', 'ADMIN', 'MANAGER')
  • is_active — BOOLEAN
  • last_login — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_username
  • INDEX — idx_role

ALARM

  • alarm_id — VARCHAR(50)
  • user_id — VARCHAR(50) — NOT NULL — 수신자 ID
  • user_type — ENUM('COMPANY', 'APPLICANT', 'HR', 'ADMIN') — NOT NULL
  • alarm_type — ENUM('EMAIL', 'KAKAOTALK', 'SMS', 'PUSH') — NOT NULL
  • category — ENUM('APPLICATION', 'PAYMENT', 'SYSTEM', 'MARKETING') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • is_read — BOOLEAN
  • sent_at — TIMESTAMP
  • read_at — TIMESTAMP
  • created_at — TIMESTAMP
  • INDEX — idx_user_alarm
  • INDEX — idx_alarm_type

APPLICANT

  • applicant_id — VARCHAR(50)
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • address — TEXT
  • birth_date — DATE
  • gender — ENUM('M', 'F', 'OTHER')
  • password — VARCHAR(255) — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_email
  • INDEX — idx_name

APPLICANT_TRACKING

  • application_id — VARCHAR(50)
  • job_id — VARCHAR(50) — NOT NULL
  • applicant_id — VARCHAR(50) — NOT NULL
  • status — ENUM('APPLIED', 'REVIEWING', 'INTERVIEW_SCHEDULED', 'INTERVIEWED', 'ACCEPTED', 'REJECTED')
  • cover_letter — TEXT — 자기소개서
  • resume_url — VARCHAR(255) — 이력서 URL
  • applied_at — TIMESTAMP
  • reviewed_at — TIMESTAMP
  • feedback — TEXT — 피드백
  • interview_date — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_job_status
  • INDEX — idx_applicant_status
  • INDEX — idx_applied_at

APPLIED_COMPANIES

  • applied_id — VARCHAR(50)
  • applicant_id — VARCHAR(50) — NOT NULL
  • company_id — VARCHAR(50) — NOT NULL
  • applied_at — TIMESTAMP
  • status — ENUM('INTERESTED', 'APPLIED', 'INTERVIEWING', 'OFFERED', 'REJECTED', 'WITHDRAWN')
  • INDEX — idx_applicant_company
  • INDEX — idx_company_applicant

CAREER

  • career_id — VARCHAR(50)
  • applicant_id — VARCHAR(50) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL — 직장명
  • position — VARCHAR(100) — 직책
  • job_description — TEXT — 담당업무
  • start_date — DATE — NOT NULL — 입사일
  • end_date — DATE — 퇴사일
  • current_job — BOOLEAN — 현재 직장 여부
  • salary — DECIMAL(10, 0) — 급여
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_applicant_career
  • INDEX — idx_company_name

COM_INFO

  • company_id — VARCHAR(50)
  • company_name — VARCHAR(100) — NOT NULL — 회사명
  • representative_name — VARCHAR(50) — NOT NULL — 대표자 성함
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_company_name
  • INDEX — idx_email

COM_PROF

  • company_id — VARCHAR(50)
  • logo_url — VARCHAR(255) — 로고 URL
  • employee_count — INT — 직원수
  • revenue — DECIMAL(15, 2) — 매출
  • business_items — TEXT — 비즈니스 품목
  • address — TEXT — 주소
  • description — TEXT — 회사 설명
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_employee_count

COM_USER_AUTHORITY

  • authority_id — VARCHAR(50)
  • company_id — VARCHAR(50) — NOT NULL
  • hr_id — VARCHAR(50) — NOT NULL
  • menu_id — VARCHAR(50) — NOT NULL
  • can_read — BOOLEAN
  • can_write — BOOLEAN
  • can_delete — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_hr_authority

EDUCATION

  • education_id — VARCHAR(50)
  • applicant_id — VARCHAR(50) — NOT NULL
  • school_name — VARCHAR(100) — NOT NULL — 학교명
  • major — VARCHAR(100) — 전공
  • degree — ENUM('HIGH_SCHOOL', 'ASSOCIATE', 'BACHELOR', 'MASTER', 'DOCTORATE') — 학위
  • admission_date — DATE — 입학연도
  • graduation_date — DATE — 졸업연도
  • status — ENUM('GRADUATED', 'ATTENDING', 'DROPPED_OUT')
  • gpa — DECIMAL(3, 2) — 학점
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_applicant_education

HR_MANAGERS

  • hr_id — VARCHAR(50)
  • company_id — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • role — ENUM('ADMIN', 'MANAGER', 'HR1', 'HR2', 'HR3')
  • position — VARCHAR(50) — 직책
  • password — VARCHAR(255) — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_company_hr
  • INDEX — idx_email

JOB_POSTING

  • job_id — VARCHAR(50)
  • company_id — VARCHAR(50) — NOT NULL
  • hr_id — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL — 공고 제목
  • description — TEXT — 공고 상세내용
  • position — VARCHAR(100) — 모집 직무
  • salary_min — DECIMAL(10, 0) — 최소 급여
  • salary_max — DECIMAL(10, 0) — 최대 급여
  • location — VARCHAR(200) — 근무지
  • employment_type — ENUM('FULL_TIME', 'PART_TIME', 'CONTRACT', 'INTERNSHIP')
  • deadline — DATE — 마감일
  • status — ENUM('DRAFT', 'ACTIVE', 'CLOSED', 'EXPIRED')
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_company_status
  • INDEX — idx_position
  • INDEX — idx_location
  • INDEX — idx_deadline

JOB_POSTING_SKILL

  • job_skill_id — VARCHAR(50)
  • job_id — VARCHAR(50) — NOT NULL
  • skill_name — VARCHAR(100) — NOT NULL
  • skill_level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED', 'EXPERT')
  • required — BOOLEAN — 필수 여부
  • created_at — TIMESTAMP
  • INDEX — idx_job_skill
  • INDEX — idx_skill_name

MANAGE_USERS

  • user_mgmt_id — VARCHAR(50)
  • admin_id — VARCHAR(50) — NOT NULL
  • target_user_id — VARCHAR(50) — NOT NULL
  • target_user_type — ENUM('COMPANY', 'APPLICANT', 'HR') — NOT NULL
  • action — ENUM('CREATE', 'UPDATE', 'DELETE', 'SUSPEND', 'ACTIVATE') — NOT NULL
  • reason — TEXT
  • action_date — TIMESTAMP
  • created_at — TIMESTAMP
  • INDEX — idx_admin_action
  • INDEX — idx_target_user

MENU

  • menu_id — VARCHAR(50)
  • menu_name — VARCHAR(100) — NOT NULL
  • menu_code — VARCHAR(50) — NOT NULL
  • parent_menu_id — VARCHAR(50)
  • menu_url — VARCHAR(200)
  • icon — VARCHAR(50)
  • sort_order — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_parent_menu
  • INDEX — idx_menu_code

MESSAGE

  • message_id — VARCHAR(50)
  • sender_id — VARCHAR(50) — NOT NULL
  • receiver_id — VARCHAR(50) — NOT NULL
  • sender_type — ENUM('COMPANY', 'APPLICANT', 'HR', 'ADMIN') — NOT NULL
  • receiver_type — ENUM('COMPANY', 'APPLICANT', 'HR', 'ADMIN') — NOT NULL
  • subject — VARCHAR(200) — NOT NULL
  • content — TEXT
  • is_read — BOOLEAN
  • sent_at — TIMESTAMP
  • read_at — TIMESTAMP
  • parent_message_id — VARCHAR(50) — 답장인 경우 원본 메시지 ID
  • created_at — TIMESTAMP
  • INDEX — idx_receiver_message
  • INDEX — idx_sender_message
  • INDEX — idx_conversation

PAYMENT

  • payment_id — VARCHAR(50)
  • company_id — VARCHAR(50) — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_method — ENUM('CARD', 'BANK_TRANSFER', 'VIRTUAL_ACCOUNT') — NOT NULL
  • card_info — VARCHAR(100) — 카드 정보 (마스킹)
  • status — ENUM('PENDING', 'COMPLETED', 'FAILED', 'CANCELLED', 'REFUNDED')
  • payment_date — TIMESTAMP
  • transaction_id — VARCHAR(100) — 거래 ID
  • service_type — ENUM('JOB_POSTING', 'PREMIUM', 'HEADHUNTING') — NOT NULL
  • refund_amount — DECIMAL(10, 2)
  • created_at — TIMESTAMP
  • INDEX — idx_company_payment
  • INDEX — idx_transaction_id
  • INDEX — idx_status

PAYMENT_METHOD

  • method_id — VARCHAR(50)
  • company_id — VARCHAR(50) — NOT NULL
  • card_number_masked — VARCHAR(20) — 마스킹된 카드번호
  • card_type — ENUM('VISA', 'MASTERCARD', 'AMEX', 'JCB', 'UNION_PAY') — 카드 종류
  • card_name — VARCHAR(50) — 카드명
  • expiry_date — CHAR(4) — MMYY 형식
  • is_default — BOOLEAN
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_company_method

PAYMENT_SALES

  • sales_id — VARCHAR(50)
  • company_id — VARCHAR(50) — NOT NULL
  • payment_id — VARCHAR(50) — NOT NULL
  • sales_date — DATE — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • service_type — ENUM('JOB_POSTING', 'PREMIUM', 'HEADHUNTING') — NOT NULL
  • commission_rate — DECIMAL(5, 2) — 수수료율(%)
  • commission_amount — DECIMAL(10, 2) — 수수료
  • net_amount — DECIMAL(10, 2) — NOT NULL — 순매출
  • description — TEXT
  • created_at — TIMESTAMP
  • INDEX — idx_sales_date
  • INDEX — idx_company_sales
  • INDEX — idx_service_type

RESUME_TRACKING

  • resume_id — VARCHAR(50)
  • applicant_id — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL — 이력서 제목
  • content — TEXT — 이력서 내용
  • file_url — VARCHAR(255) — 파일 URL
  • file_type — ENUM('PDF', 'DOC', 'DOCX', 'HWP') — 파일 형식
  • is_default — BOOLEAN — 기본 이력서 여부
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_applicant_resume

SKILL

  • skill_id — VARCHAR(50)
  • applicant_id — VARCHAR(50) — NOT NULL
  • skill_name — VARCHAR(100) — NOT NULL
  • skill_level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED', 'EXPERT')
  • experience_years — INT — 경험 년수
  • certification — VARCHAR(200) — 자격증
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_applicant_skill
  • INDEX — idx_skill_name

기업 (COMPANY)

  • company_id — VARCHAR(50)
  • business_number — VARCHAR(20) — NOT NULL — 사업자등록번호
  • status — ENUM('ACTIVE', 'INACTIVE', 'SUSPENDED')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_business_number
  • INDEX — idx_status — 기업 기본 정보'; CREATE TABLE COM_INFO ( company_id VARCHAR(50) PRIMARY KE
  • company_name — VARCHAR(100) — NOT NULL — 회사명
  • representative_name — VARCHAR(50) — NOT NULL — 대표자 성함
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_company_name
  • INDEX — idx_email