example

Tables (6)

annual_contrib (연간 납입액 관리)

  • annual_contrib_id (annual_contrib_idd) — INT — Primary key — NOT NULL
  • pension_id — INT — Foreign key → retirement_pension.pension_id — NOT NULL
  • irp_personal_amt — DECIMAL(15,2)
  • dc_personal_amt — DECIMAL(15,2)
  • total_personal_amt — DECIMAL(15,2)
  • contrib_year — INT

irp_registry (irp 관리)

  • irp_registry_id — INT — Primary key — NOT NULL
  • pension_id — INT — Foreign key → retirement_pension.pension_id — NOT NULL

pension_db (db형)

  • db_id — INT — Primary key — NOT NULL
  • pension_id — INT — Foreign key → retirement_pension.pension_id — NOT NULL
  • income_avg_3m — DECIMAL(15,2)
  • working_years — INT

pension_dc (dc 형)

  • dc_id — INT — Primary key — NOT NULL
  • pension_id — INT — Foreign key → retirement_pension.pension_id — NOT NULL
  • balance — DECIMAL(15,2)
  • company_contrib — DECIMAL(15,2)
  • personal_contrib — DECIMAL(15,2)
  • contrib_year — INT
  • rate_of_return — DECIMAL(5,2)

pension_irp (irp형)

  • irp_id — INT — Primary key — NOT NULL
  • irp_registry_id — INT — Foreign key → irp_registry.irp_registry_id — NOT NULL
  • pension_id — INT — Foreign key → irp_registry.pension_id — NOT NULL
  • balance — DECIMAL(15,2)
  • personal_contrib — DECIMAL(15,2)
  • contrib_year — INT
  • total_personal_contrib — DECIMAL(15,2)
  • rate_of_return — DECIMAL(5,2)

retirement_pension (연금)

  • pension_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • updated_at — DATETIME