zzzzzz

Tables (14)

Accident

  • id — int — Primary key — NOT NULL
  • contract_id — int — NOT NULL
  • date — timestamp — NOT NULL
  • location — varchar(100) — NOT NULL
  • cause — varchar(100) — NOT NULL
  • content — varchar(100) — NOT NULL
  • damage — bigint — NOT NULL
  • accountNumber — varchar(100) — NOT NULL
  • stauts — varchar(100) — NOT NULL

CalculationFormula

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

Compensation

  • id — int — Primary key — NOT NULL
  • accidentId — int — NOT NULL
  • compensation — int — NOT NULL

Contract

  • id — int — Primary key — NOT NULL
  • customer_info_id — int — NOT NULL
  • customer_id — varchar(100) — NOT NULL
  • insurance_id — int — NOT NULL
  • saleEmployee_id — varchar(100)
  • term — int — NOT NULL
  • startDate — timestamp
  • expirationDate — timestamp
  • paymentFee — int — NOT NULL
  • paymentCycle — int — NOT NULL
  • paymentDeadline — timestamp
  • compensation — int — NOT NULL
  • contractStatus — varchar(100) — NOT NULL

Customer

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

CustomerInfo

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

Employee

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

HomeCustomerInfo

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

HomeFormula

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

Insurance

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

Pay

  • id — int — Primary key — NOT NULL
  • contract_id — int — NOT NULL
  • cardNumber — varchar(100) — NOT NULL

Sale

  • id — int — Primary key — NOT NULL
  • saleEmployee_id — varchar(100) — NOT NULL
  • customerId — varchar(100) — NOT NULL
  • insuranceId — int — NOT NULL
  • message — varchar(100) — NOT NULL

WorkplaceCustomerInfo

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

WorkplaceFormula

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