asd
Tables (14)
Accident
- id — int — Primary key — NOT NULL
- contractId — int — Foreign key → Contract.id — 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 — Foreign key → Accident.id — NOT NULL
- compensation — int — NOT NULL
Contract
- id — int — Primary key — NOT NULL
- customerInfoId — int — Foreign key → CustomerInfo.id — NOT NULL
- customerId — varchar(100) — Foreign key → Customer.id — NOT NULL
- insuranceId — int — Foreign key → Insurance.id — NOT NULL
- saleEmployeeId — 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
- customerId — varchar(100) — Foreign key → Customer.id — 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 — Foreign key → CalculationFormula.id — 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
- contractId — int — Foreign key → Contract.id — NOT NULL
- cardNumber — varchar(100) — NOT NULL
Sale
- id — int — Primary key — NOT NULL
- saleEmployeeId — varchar(100) — Foreign key → Employee.id — NOT NULL
- customerId — varchar(100) — Foreign key → Customer.id — NOT NULL
- insuranceId — int — Foreign key → Insurance.id — 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