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