Insurance

Tables (14)

Accident

  • id — int — Primary key — NOT NULL
  • contract_id — int — Foreign key → Contract.id — NOT NULL
  • calculationFormulaId — int — Foreign key → Contract.calculationFormulaId — NOT NULL
  • date — timestamp
  • location — varchar(100)
  • cause — varchar(100)
  • content — varchar(100)
  • damage — bigint
  • accountNumber — varchar(100)
  • status — varchar(100)

CalculationFormula

  • id — int — Primary key — NOT NULL
  • name — varchar(100)
  • riskLevelAccordingToPillarType — blob
  • riskLevelAccordingToRoofType — blob
  • riskLevelAccordingToOutwallType — blob
  • multiplierForMinCompensation — int
  • multiplierForMaxCompensation — int
  • multiplierForPayment — int

Compensation

  • id — int — Primary key — NOT NULL
  • accidentId — int — Foreign key → Accident.id — NOT NULL
  • calculationFormulaId — int — Foreign key → Accident.calculationFormulaId — NOT NULL
  • compensation — int

Contract

  • id — int — Primary key — NOT NULL
  • customer_info_id — int — Foreign key → CustomerInfo.id — NOT NULL
  • customer_id — varchar(100) — Foreign key → Customer.id — NOT NULL
  • saleEmployee_id — varchar(100) — Foreign key → Employee.id — NOT NULL
  • insurance_id — int — Foreign key → Insurance.id — NOT NULL
  • calculationFormulaId — int — Foreign key → Insurance.calculationFormulaId — NOT NULL
  • term — int
  • startDate — timestamp
  • expirationDate — timestamp
  • paymentFee — int
  • paymentCycle — int
  • paymentDeadline — timestamp
  • compensation — int
  • contractStatus — varchar(100)

Customer

  • id — varchar(100) — Primary key — NOT NULL
  • password — varchar(100)
  • name — varchar(100)
  • email — varchar(100)
  • phoneNumber — bigint
  • address — varchar(100)
  • hasHome — boolean
  • hasWorkplace — boolean

CustomerInfo

  • id — int — Primary key — NOT NULL
  • customer_id — varchar(100)
  • squareMeter — int
  • pillarType — varchar(100)
  • roofType — varchar(100)
  • outwallType — varchar(100)

Employee

  • id — varchar(100) — Primary key — NOT NULL
  • password — varchar(100)
  • department — varchar(100)
  • name — varchar(100)
  • email — varchar(100)
  • phoneNumber — bigint
  • rank — varchar(100)

HomeCustomerInfo

  • id — int — Foreign key → CustomerInfo.id — NOT NULL
  • houseType — varchar(100)
  • residenceType — varchar(100)

HomeFormula

  • id — int — Foreign key → CalculationFormula.id — NOT NULL
  • riskLevelAccordingToResidenceType — blob
  • riskLevelAccordingToHouseType — blob
  • riskLevelAccordingToSquareMeter — blob
  • riskLevelAccordingToCompensation — blob

Insurance

  • id — int — Primary key — NOT NULL
  • calculationFormulaId — int — Foreign key → CalculationFormula.id — NOT NULL
  • name — varchar(100)
  • type — varchar(100)
  • target — varchar(100)
  • compensationCondition — varchar(100)
  • notCompensationCondition — varchar(100)
  • status — varchar(100)

Pay

  • id — int — Primary key — NOT NULL
  • contract_id — int — Foreign key → Contract.id — NOT NULL
  • cardNumber — varchar(100)

Sale

  • id — int — Primary key — NOT NULL
  • customerId — varchar(100) — Foreign key → Customer.id — NOT NULL
  • saleEmployee_id — varchar(100) — Foreign key → Employee.id — NOT NULL
  • insuranceId — int
  • message — varchar(100)

WorkplaceCustomerInfo

  • id — int — Foreign key → CustomerInfo.id — NOT NULL
  • usage — varchar(100)
  • floor — int

WorkplaceFormula

  • id — int — Foreign key → CalculationFormula.id — NOT NULL
  • riskLevelAccordingToUsage — blob
  • riskLevelAccordingToFloor — blob
  • riskLevelAccordingToSquareFeet — blob
  • riskLevelAccordingToCompensation — blob