DB_Insurance

Tables (4)

Claim (Untitled3)

  • claim_id (PK) — Primary key — NOT NULL
  • claim_date (Field)
  • claim_amount (Field2)
  • claim_status (Field3)
  • cust_id (FK) — Foreign key → Untitled.cust_id — NOT NULL

Cntt (Untitled2)

  • cntt_id (PK) — Primary key — NOT NULL
  • policy_type (Field3)
  • policy_start (Field4)
  • policy_end (Field5)
  • premium_amount (Field)
  • cust_id (FK) — Foreign key → Untitled.cust_id — NOT NULL

Fraud (Untitled4)

  • fraud_id (PK) — Primary key — NOT NULL
  • fraud_score (Field)
  • is_fraud (Field2)
  • cust_id (FK1) — Foreign key → Untitled.cust_id — NOT NULL
  • claim_id (FK2) — Foreign key → Claim.claim_id — NOT NULL

Untitled

  • cust_id (PK) — Primary key — NOT NULL
  • siu_cust_yn (Field)
  • sex (Field2)
  • age (Field3)
  • resi_cost (Field4)
  • resi_type_code (Field5)
  • fp_career (Field6)
  • cust_rgst (Field7)
  • ctpr (Field8)
  • occp_grp_1 (Field9)
  • occp_grp_2 (Field10)
  • totalprem (Field11)
  • mincrdt (Field12)
  • maxcrdt (Field13)