인사관리

테이블 (16)

approval

  • approval_id — BIGINT — 기본 키
  • document_type — VARCHAR(50)
  • document_id — BIGINT
  • requester_employee_id — BIGINT — 외래 키 → employee.employee_id
  • approval_status — VARCHAR(30)
  • approved_at — DATETIME
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

attendance

  • attendance_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • work_date — DATE — NOT NULL
  • check_in_time — DATETIME
  • check_out_time — DATETIME
  • work_minutes — INT
  • late_minutes — INT
  • early_leave_minutes — INT
  • overtime_minutes — INT
  • night_work_minutes — INT
  • attendance_status — VARCHAR(30)
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

delivery_team

  • delivery_team_id — BIGINT — 기본 키
  • team_name — VARCHAR(100) — NOT NULL
  • district_name — VARCHAR(100)
  • leader_employee_id — BIGINT — 외래 키 → employee.employee_id
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

department

  • department_id — BIGINT — 기본 키
  • department_name — VARCHAR(100) — NOT NULL

driver_profile

  • driver_profile_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • delivery_team_id — BIGINT — 외래 키 → delivery_team.delivery_team_id
  • vehicle_id — BIGINT — 외래 키 → vehicle.vehicle_id
  • driver_license_type — VARCHAR(50)
  • driver_license_no — VARCHAR(100)
  • license_expire_date — DATE
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id
  • delivery_team_id (delivery_team_id2) — BIGINT — 외래 키 → delivery_team.delivery_team_id
  • vehicle_id (vehicle_id2) — BIGINT — 외래 키 → vehicle.vehicle_id

employee

  • employee_id — BIGINT — 기본 키
  • employee_no — VARCHAR(30) — NOT NULL
  • department_id — BIGINT — 외래 키 → department.department_id
  • name — VARCHAR(100) — NOT NULL
  • position_name — VARCHAR(50)
  • employment_type — VARCHAR(50)
  • phone — VARCHAR(30)
  • email — VARCHAR(100)
  • address — VARCHAR(255)
  • hire_date — DATE
  • resignation_date — DATE
  • employee_status — VARCHAR(30)
  • department_id (department_id2) — BIGINT — 외래 키 → department.department_id

employee_appointment

  • employee_appointment_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • appointment_type — VARCHAR(50)
  • appointment_date — DATE
  • from_department_name — VARCHAR(100)
  • to_department_name — VARCHAR(100)
  • from_position_name — VARCHAR(50)
  • to_position_name — VARCHAR(50)
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

employee_career

  • employee_career_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • company_name — VARCHAR(100)
  • join_date — DATE
  • leave_date — DATE
  • position_name — VARCHAR(50)
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

employee_education

  • employee_education_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • school_name — VARCHAR(100)
  • major — VARCHAR(100)
  • degree_name — VARCHAR(50)
  • enter_date — DATE
  • graduate_date — DATE
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

employee_license

  • employee_license_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • license_name — VARCHAR(100)
  • organization_name — VARCHAR(100)
  • issue_date — DATE
  • expire_date — DATE
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

employee_military

  • employee_military_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • military_type — VARCHAR(50)
  • enlist_date — DATE
  • discharge_date — DATE
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

leave_balance

  • leave_balance_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • standard_year — VARCHAR(4)
  • generated_days — DECIMAL(5,2)
  • used_days — DECIMAL(5,2)
  • remain_days — DECIMAL(5,2)
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

leave_request

  • leave_request_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • leave_type — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE
  • leave_days — DECIMAL(5,2)
  • approval_status — VARCHAR(30)
  • reason — VARCHAR(500)
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

payroll

  • payroll_id — BIGINT — 기본 키
  • employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
  • payroll_year_month — VARCHAR(6)
  • total_pay_amount — DECIMAL(15,2)
  • total_deduction_amount — DECIMAL(15,2)
  • real_pay_amount — DECIMAL(15,2)
  • payment_date — DATE
  • department_id (department_id2) — BIGINT — 외래 키 → employee.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → employee.employee_id

payroll_item

  • payroll_item_id — BIGINT — 기본 키
  • payroll_id — BIGINT — 외래 키 → payroll.payroll_id — NOT NULL
  • item_name — VARCHAR(100)
  • item_type — VARCHAR(30)
  • amount — DECIMAL(15,2)
  • department_id (department_id2) — BIGINT — 외래 키 → payroll.department_id
  • employee_id (employee_id2) — BIGINT — 외래 키 → payroll.employee_id
  • payroll_id (payroll_id2) — BIGINT — 외래 키 → payroll.payroll_id

vehicle

  • vehicle_id — BIGINT — 기본 키
  • vehicle_number — VARCHAR(50) — NOT NULL
  • vehicle_type — VARCHAR(50)
  • vehicle_status — VARCHAR(30)