언더라이터 9/5
테이블 (3)
home_fire_insurance_plan
- id — bigint — 기본 키 — NOT NULL
- insurance_plan_id — bigint — 외래 키 → insurance_plan.id — NOT NULL
- uuid — varchar(36) — NOT NULL
- building_ledger_id — bigint — NOT NULL
- house_feature_id — bigint — NOT NULL
- plan_snapshot — json
- created_at — timestamp — NOT NULL
insurance_contract
- id — bigint — 기본 키
- uuid — varchar(36) — NOT NULL
- parent_contract_id — bigint
- user_id — bigint — NOT NULL
- name — varchar(100)
- status — varchar(50) — NOT NULL
- contract_number — varchar(100)
- start_date — timestamp
- end_date — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
insurance_plan
- id — bigint — 기본 키
- insurance_contract_id — bigint — 외래 키 → insurance_contract.id
- uuid — varchar(36) — NOT NULL
- status — varchar(50) — NOT NULL
- insurance_period_type — varchar(20) — NOT NULL
- insurance_period_value — int — NOT NULL
- payment_period_type — varchar(20) — NOT NULL
- payment_period_value — int — NOT NULL
- version — int — NOT NULL
- user_id — bigint
- insurance_contract_id (insurance_contract_id.) — bigint
- insurance_company_type — varchar(100) — NOT NULL
- insurance_product_type — varchar(100) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL