언더라이터 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