연말정산중도정산

테이블 (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