인사관리
테이블 (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)