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)