인사관리_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