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