연말정산중도정산
테이블 (9)
deduction_credit_card
- card_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- dependent_id — BIGINT — 외래 키 → dependent.dependent_id
- amt_credit_card — NUMERIC(15, 0)
- amt_debit_card — NUMERIC(15, 0) — 직불/체크카드
- amt_cash_receipt — NUMERIC(15, 0)
- amt_traditional_market — NUMERIC(15, 0) — 전통시장
- amt_public_transport — NUMERIC(15, 0)
- amt_culture — NUMERIC(15, 0)
- amt_fitness_center — NUMERIC(15, 0) — 2025
- created_at — TIMESTAMP
deduction_donation
- donation_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- dependent_id — BIGINT — 외래 키 → dependent.dependent_id
- donation_type — VARCHAR(20)
- business_name — VARCHAR(100)
- business_reg_no — VARCHAR(20)
- amt_donation — NUMERIC(15, 0)
- donation_year — VARCHAR(4)
- created_at — TIMESTAMP
deduction_education
- education_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- dependent_id — BIGINT — 외래 키 → dependent.dependent_id
- school_type — VARCHAR(20)
- amt_paid — NUMERIC(15, 0)
- amt_scholarship — NUMERIC(15, 0)
- amt_loan_repayment — NUMERIC(15, 0) — 학자금
- created_at — TIMESTAMP
deduction_medical
- medical_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- dependent_id — BIGINT — 외래 키 → dependent.dependent_id
- business_name — VARCHAR(100)
- business_reg_no — VARCHAR(20)
- amt_paid — NUMERIC(15, 0) — NOT NULL
- amt_silson_insurance — NUMERIC(15, 0)
- medical_type — VARCHAR(20) — NOT NULL — 의료비
- created_at — TIMESTAMP
deduction_monthly_rent
- rent_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- lessor_name — VARCHAR(50)
- lessor_rrn — VARCHAR(255)
- house_type — VARCHAR(20)
- house_area — NUMERIC(5, 2)
- address_road — VARCHAR(255)
- contract_start — DATE
- contract_end — DATE
- amt_annual_rent — NUMERIC(15, 0)
- amt_deduction_target — NUMERIC(15, 0) — 공제
- created_at — TIMESTAMP
dependent
- dependent_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL — 근로자
- name — VARCHAR(50) — NOT NULL
- rrn — VARCHAR(255) — NOT NULL
- relationship_code — VARCHAR(20) — NOT NULL — 관계
- is_disabled — BOOLEAN — 장애인
- disability_type — VARCHAR(20) — 장애
- is_foreigner — BOOLEAN
- is_basic_deduction_target — BOOLEAN — 기본공제
- is_women_deduction_target — BOOLEAN — 부녀자공제
- is_single_parent_target — BOOLEAN — 한부모공제
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
employee
- employee_id — BIGSERIAL
- user_id — VARCHAR(50) — NOT NULL — 시스템
- name — VARCHAR(50) — NOT NULL — 근로자
- rrn — VARCHAR(255) — NOT NULL — 주민등록번호
- email — VARCHAR(100)
- hire_date — DATE — NOT NULL — 입사일
- resign_date — DATE — 퇴사일
- is_head_of_household — BOOLEAN — 세대주
- nationality — VARCHAR(20) — 국적
- sme_reduction_type — VARCHAR(20) — 중소기업
- sme_period_start — DATE — 감면
- sme_period_end — DATE — 감면
- sme_rate — NUMERIC(3, 2) — 감면율
- marriage_date — DATE — 2025
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
income_record
- income_record_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- business_reg_no — VARCHAR(20)
- period_start — DATE — 근무
- period_end — DATE — 근무
- amt_total_salary — NUMERIC(15, 0) — 총
- amt_bonus — NUMERIC(15, 0)
- amt_recognized_bonus — NUMERIC(15, 0)
- amt_taxable_employee_discount — NUMERIC(15, 0) — 2025
- amt_tax_free_meal — NUMERIC(15, 0) — 비과세
- amt_tax_free_childcare — NUMERIC(15, 0) — 비과세
- json_other_tax_free_items — JSONB — 기타
- amt_paid_income_tax — NUMERIC(15, 0) — 기납부
- amt_paid_local_tax — NUMERIC(15, 0)
- is_current_workplace — BOOLEAN — 현근무지
- created_at — TIMESTAMP
tax_settlement
- settlement_id — BIGSERIAL
- employee_id — BIGINT — 외래 키 → employee.employee_id — NOT NULL
- tax_year — INTEGER — NOT NULL
- settlement_type — VARCHAR(20) — NOT NULL
- target_period_start — DATE — NOT NULL — 정산
- target_period_end — DATE — NOT NULL — 정산
- amt_determined_tax — NUMERIC(15, 0) — 결정세액
- amt_final_settlement — NUMERIC(15, 0) — 차감징수세액
- json_calculation_details — JSONB — 상세
- is_finalized — BOOLEAN — 정산
- finalized_at — TIMESTAMP
- is_receipt_issued — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP