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