인사관리_Smart_RAD_part2
테이블 (32)
allowance
- allowance_id — BIGINT — 기본 키 — NOT NULL — 수당 PK
- allowance_name — VARCHAR(100) — NOT NULL — 수당명
- taxable — BOOLEAN — NOT NULL — 과세여부
- fixed — BOOLEAN — NOT NULL — 고정여부
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
attendance
- attendance_id — BIGINT — 기본 키 — NOT NULL — 근태 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- work_date — DATE — NOT NULL
- check_in_time — TIME
- check_out_time — TIME
- work_minutes — INT
- overtime_minutes — INT
- night_work_minutes — INT
- late_minutes — INT
- early_leave_minutes — INT
- attendance_status_code — VARCHAR(30) — NOT NULL — PRESENT/LATE/ABSENT/LEAVE ...
- remark — VARCHAR(300)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
audit_log
- audit_log_id — BIGINT — 기본 키 — NOT NULL — 감사로그 PK
- actor_id — BIGINT — 외래 키 → employee.employee_id — 행위자(employee)
- action — VARCHAR(50) — NOT NULL — CREATE/UPDATE/APPROVE ...
- entity_type — VARCHAR(50)
- entity_id — BIGINT
- before_data — TEXT
- after_data — TEXT
- ip_address — VARCHAR(45)
- created_at — DATETIME — NOT NULL
common_code
- common_code_id — BIGINT — 기본 키 — NOT NULL — 공통코드 PK
- group_code — VARCHAR(50) — NOT NULL — 코드그룹
- code — VARCHAR(50) — NOT NULL — 코드값
- name — VARCHAR(100) — NOT NULL — 표시명
- sort_order — INT — NOT NULL
- parent_code — VARCHAR(50)
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
department
- department_id — BIGINT — 기본 키 — NOT NULL — 조직 PK
- department_name — VARCHAR(100) — NOT NULL — 조직명
- org_type — VARCHAR(20) — NOT NULL — ACADEMIC(학사)/ADMINISTRATIVE(행정)
- parent_department_id — BIGINT — 외래 키 → department.department_id — 상위조직(자기참조)
- headcount — INT — NOT NULL — 정원
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
document_sequence
- prefix — VARCHAR(10) — 기본 키 — NOT NULL
- seq_year — INT — 기본 키 — NOT NULL
- last_no — INT — NOT NULL
employee
- employee_id — BIGINT — 기본 키 — NOT NULL — 교직원 PK
- employee_no — VARCHAR(30) — NOT NULL — 사번
- department_id — BIGINT — 외래 키 → department.department_id — NOT NULL — 소속
- position_id — BIGINT — 외래 키 → position.position_id — NOT NULL — 직급
- employment_type_id — BIGINT — 외래 키 → employment_type.employment_type_id — NOT NULL — 임용구분
- name — VARCHAR(100) — NOT NULL — 성명
- staff_category — VARCHAR(20) — NOT NULL — FACULTY(교원)/STAFF(직원)
- email — VARCHAR(100) — NOT NULL — 로그인 ID
- password — VARCHAR(255) — NOT NULL — BCrypt
- role — VARCHAR(20) — NOT NULL — JWT 대표권한
- phone — VARCHAR(30)
- birth_date — DATE
- gender — VARCHAR(10)
- address — VARCHAR(255)
- emergency_contact — VARCHAR(50)
- hire_date — DATE — NOT NULL — 임용일
- resignation_date — DATE
- employee_status_code — VARCHAR(30) — NOT NULL — EMPLOYED/ON_LEAVE/RESIGNED
- bank_name — VARCHAR(100)
- account_number — VARCHAR(100)
- account_holder — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_allowance
- employee_allowance_id — BIGINT — 기본 키 — NOT NULL — 사원수당 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- allowance_id — BIGINT — 외래 키 → allowance.allowance_id — NOT NULL
- amount — DECIMAL(15, 2) — NOT NULL — 금액
- start_date — DATE
- end_date — DATE
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_appointment
- employee_appointment_id — BIGINT — 기본 키 — NOT NULL — 발령 PK
- document_number — VARCHAR(30) — NOT NULL — APT-2026-001
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL — 발령대상
- appointment_type — VARCHAR(50) — NOT NULL — HIRE/PROMOTION/TRANSFER/CONCURRENT
- appointment_date — DATE — NOT NULL
- effective_date — DATE — 발효일
- from_department_id — BIGINT — 외래 키 → department.department_id
- to_department_id — BIGINT — 외래 키 → department.department_id
- from_position_id — BIGINT — 외래 키 → position.position_id
- to_position_id — BIGINT — 외래 키 → position.position_id
- reason — VARCHAR(500)
- approval_status — VARCHAR(20) — NOT NULL — PENDING/APPROVED/REJECTED
- approver_id — BIGINT — 외래 키 → employee.employee_id
- approved_at — DATETIME
- registered_by — BIGINT — 외래 키 → employee.employee_id — NOT NULL — 등록자
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_career
- employee_career_id — BIGINT — 기본 키 — NOT NULL — 경력 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- company_name — VARCHAR(200) — NOT NULL — 기관/회사명
- department — VARCHAR(100) — 부서
- position — VARCHAR(100) — 직위
- job_description — VARCHAR(500) — 담당업무
- start_date — DATE — NOT NULL — 시작일
- end_date — DATE — 종료일
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_certificate
- employee_certificate_id — BIGINT — 기본 키 — NOT NULL — 자격증 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- name — VARCHAR(200) — NOT NULL — 자격증명
- issuer — VARCHAR(100) — 발급기관
- cert_number — VARCHAR(100) — 자격번호
- acquired_date — DATE — 취득일
- expiry_date — DATE — 만료일
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_certificate_issue
- employee_certificate_issue_id — BIGINT — 기본 키 — NOT NULL — 증명서발급 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- document_number — VARCHAR(30) — NOT NULL — CERT-2026-001
- certificate_type — VARCHAR(100) — NOT NULL — 재직/경력/급여 등
- application_date — DATE — NOT NULL
- purpose — VARCHAR(500)
- issue_status — VARCHAR(50) — NOT NULL — WAITING/ISSUED/REJECTED
- issued_at — DATETIME
- approval_status — VARCHAR(50) — NOT NULL — PENDING/APPROVED/REJECTED
- approver_id — BIGINT — 외래 키 → employee.employee_id
- approved_at — DATETIME
- memo — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_education
- employee_education_id — BIGINT — 기본 키 — NOT NULL — 학력 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- school_name — VARCHAR(200) — NOT NULL — 학교명
- major — VARCHAR(200) — 전공
- degree — VARCHAR(100) — 학위
- admission_date — DATE — 입학일
- graduation_date — DATE — 졸업일
- status — VARCHAR(50) — 졸업/재학/수료/중퇴
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_event_support
- employee_event_support_id — BIGINT — 기본 키 — NOT NULL — 경조비 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- document_number — VARCHAR(30) — NOT NULL — ES-2026-001
- event_type — VARCHAR(100) — NOT NULL — 결혼/출산/사망 등
- family_relation — VARCHAR(100)
- target_name — VARCHAR(100) — NOT NULL — 대상자
- application_date — DATE — NOT NULL
- event_date — DATE — NOT NULL
- requested_amount — DECIMAL(12, 0) — NOT NULL — 신청금액
- event_location — VARCHAR(255)
- bank_name — VARCHAR(100)
- account_number — VARCHAR(100)
- account_holder — VARCHAR(100)
- approval_status — VARCHAR(50) — NOT NULL — PENDING/APPROVED/REJECTED/PAID
- approver_id — BIGINT — 외래 키 → employee.employee_id
- approved_at — DATETIME
- memo — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_family
- employee_family_id — BIGINT — 기본 키 — NOT NULL — 가족 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- family_name — VARCHAR(100) — NOT NULL — 가족성명
- family_relation — VARCHAR(50) — NOT NULL — 관계(부/모/배우자 등)
- birth_date — DATE
- job — VARCHAR(100)
- living_together — BOOLEAN — 동거여부
- dependent — BOOLEAN — 부양여부
- disabled — BOOLEAN — 장애여부
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_language
- employee_language_id — BIGINT — 기본 키 — NOT NULL — 어학 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- language_name — VARCHAR(100) — NOT NULL — 언어
- reading_level — VARCHAR(50)
- writing_level — VARCHAR(50)
- speaking_level — VARCHAR(50)
- test_name — VARCHAR(100) — 시험명
- test_score — VARCHAR(100) — 점수
- issued_date — DATE
- issuer — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_leave_balance
- employee_leave_balance_id — BIGINT — 기본 키 — NOT NULL — 잔여휴가 PK
- leave_type_id — BIGINT — 외래 키 → leave_type.leave_type_id — NOT NULL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- year — INT — NOT NULL — 기준연도
- total_days — DECIMAL(5, 1) — NOT NULL — 부여일수
- used_days — DECIMAL(5, 1) — NOT NULL — 사용일수
- remain_days — DECIMAL(5, 1) — NOT NULL — 잔여일수
- expire_date — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_military
- employee_military_id — BIGINT — 기본 키 — NOT NULL — 병역 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- military_type — VARCHAR(100) — 군별
- military_rank — VARCHAR(100) — 계급
- discharge_type — VARCHAR(100) — 병역구분(만기/면제 등)
- enlistment_date — DATE
- discharge_date — DATE
- exemption_reason — VARCHAR(200) — 면제사유
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
employee_oauth
- employee_oauth_id — BIGINT — 기본 키 — NOT NULL — 소셜계정 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL — KAKAO/GOOGLE/NAVER
- provider_user_id — VARCHAR(100) — NOT NULL — 소셜 고유 ID
- provider_email — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
employee_role
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- role_id — BIGINT — 외래 키 → role.role_id — NOT NULL
employment_type
- employment_type_id — BIGINT — 기본 키 — NOT NULL — 임용구분 PK
- employment_type_name — VARCHAR(100) — NOT NULL — 임용구분명
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
file_attachment
- file_attachment_id — BIGINT — 기본 키 — NOT NULL — 첨부파일 PK
- ref_type — VARCHAR(50) — NOT NULL — 업무유형(APPOINTMENT/EVENT ...)
- ref_id — BIGINT — NOT NULL — 업무데이터 PK
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- extension — VARCHAR(20)
- content_type — VARCHAR(100)
- file_size — BIGINT — NOT NULL
- created_by — BIGINT
- created_at — DATETIME — NOT NULL
leave_policy
- leave_policy_id — BIGINT — 기본 키 — NOT NULL — 휴가정책 PK
- position_id — BIGINT — 외래 키 → position.position_id — 적용 직급(NULL=전체)
- annual_leave_days — DECIMAL(4, 1) — NOT NULL — 연차일수
- max_carry_over_days — DECIMAL(4, 1) — 이월한도
- half_day_allowed — BOOLEAN — 반차허용
- note — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
leave_request
- leave_request_id — BIGINT — 기본 키 — NOT NULL — 휴가신청 PK
- document_number — VARCHAR(30) — NOT NULL — LVE-2026-001
- leave_type_id — BIGINT — 외래 키 → leave_type.leave_type_id — NOT NULL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- leave_days — DECIMAL(4, 1) — NOT NULL
- reason — TEXT
- status — VARCHAR(30) — NOT NULL — PENDING/APPROVED/REJECTED
- approver_id — BIGINT — 외래 키 → employee.employee_id
- approved_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
leave_type
- leave_type_id — BIGINT — 기본 키 — NOT NULL — 휴가유형 PK
- leave_type_name — VARCHAR(100) — NOT NULL — 휴가유형명
- paid_yn — BOOLEAN — NOT NULL — 유급여부
- default_days — DECIMAL(4, 1) — 기본부여일수
- note — VARCHAR(255)
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
payroll
- payroll_id — BIGINT — 기본 키 — NOT NULL — 급여명세서 PK
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- payroll_year_month — VARCHAR(6) — NOT NULL — 급여년월(YYYYMM)
- payment_date — DATE — 지급일
- total_pay_amount — DECIMAL(15, 2) — NOT NULL — 지급총액
- total_deduction_amount — DECIMAL(15, 2) — NOT NULL — 공제총액
- real_pay_amount — DECIMAL(15, 2) — NOT NULL — 실지급액
- payroll_status_code — VARCHAR(30) — DRAFT/CONFIRMED/PAID
- employee_name_snapshot — VARCHAR(100) — 당시 성명 스냅샷
- department_name_snapshot — VARCHAR(100) — 당시 소속 스냅샷
- position_name_snapshot — VARCHAR(100) — 당시 직급 스냅샷
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
payroll_detail
- payroll_detail_id — BIGINT — 기본 키 — NOT NULL — 급여상세 PK
- payroll_id — BIGINT — 외래 키 → payroll.payroll_id — NOT NULL
- payroll_item_master_id — BIGINT — 외래 키 → payroll_item_master.payroll_item_master_id — NOT NULL
- item_name_snapshot — VARCHAR(100) — NOT NULL — 항목명 스냅샷
- item_type_code — VARCHAR(30) — NOT NULL — PAY/DEDUCT
- amount — DECIMAL(15, 2) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
payroll_item_master
- payroll_item_master_id — BIGINT — 기본 키 — NOT NULL — 급여항목 PK
- item_name — VARCHAR(100) — NOT NULL — 항목명
- item_type_code — VARCHAR(30) — NOT NULL — PAY(지급)/DEDUCT(공제)
- taxable — BOOLEAN — NOT NULL — 과세여부
- fixed — BOOLEAN — NOT NULL — 고정여부
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
permission
- permission_id — BIGINT — 기본 키 — NOT NULL — 권한 PK
- code — VARCHAR(80) — NOT NULL — EMPLOYEE_READ 등
- name — VARCHAR(80) — NOT NULL
- resource — VARCHAR(50)
- action — VARCHAR(30)
position
- position_id — BIGINT — 기본 키 — NOT NULL — 직급 PK
- position_name — VARCHAR(100) — NOT NULL — 직급명
- category — VARCHAR(20) — NOT NULL — FACULTY/STAFF/COMMON
- level — INT — NOT NULL — 직급 레벨
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
role
- role_id — BIGINT — 기본 키 — NOT NULL — 역할 PK
- code — VARCHAR(50) — NOT NULL — ROLE_ADMIN 등
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(200)
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_by — BIGINT
- updated_by — BIGINT
- version — BIGINT — NOT NULL
- deleted — BOOLEAN — NOT NULL
role_permission
- role_id — BIGINT — 외래 키 → role.role_id — NOT NULL
- permission_id — BIGINT — 외래 키 → permission.permission_id — NOT NULL