자동차 보험회사 고객관리

테이블 (10)

accident_record

  • accident_id — BIGINT
  • vehicle_id — BIGINT — 외래 키 → vehicle.vehicle_id
  • accident_datetime — DATETIME
  • accident_description — TEXT

company

  • company_id — BIGINT
  • company_name — VARCHAR(100)

company_insurance_product

  • company_product_id — BIGINT
  • company_id — BIGINT — 외래 키 → company.company_id
  • product_id — BIGINT — 외래 키 → insurance_product.product_id
  • sale_name — VARCHAR(100)
  • sale_status — VARCHAR(20)
  • min_risk_level — INTEGER
  • max_risk_level — INTEGER
  • allowed_vehicle_grade — VARCHAR(20)

customer

  • customer_id — BIGINT
  • customer_name — VARCHAR(100)
  • customer_type — VARCHAR(20)

employee_customer

  • customer_id — BIGINT — 외래 키 → customer.customer_id
  • company_name — VARCHAR(100)

insurance_product

  • product_id — BIGINT
  • product_name — VARCHAR(100)
  • description — TEXT

insurance_subscription

  • subscription_id — BIGINT
  • customer_id — BIGINT — 외래 키 → customer.customer_id
  • vehicle_id — BIGINT — 외래 키 → vehicle.vehicle_id
  • company_product_id — BIGINT — 외래 키 → company_insurance_product.company_product_id
  • subscription_status — VARCHAR(20)

occupation

  • occupation_id — BIGINT
  • occupation_name — VARCHAR(100)
  • risk_level — INTEGER

self_employed_customer

  • customer_id — BIGINT — 외래 키 → customer.customer_id
  • occupation_id — BIGINT — 외래 키 → occupation.occupation_id

vehicle

  • vehicle_id — BIGINT
  • registration_no — VARCHAR(30)
  • customer_id — BIGINT — 외래 키 → customer.customer_id
  • manufacture_year — INTEGER
  • vehicle_usage — VARCHAR(30)
  • weekly_distance — INTEGER
  • vehicle_grade — VARCHAR(20)