보험
테이블 (14)
Untitled (Customer)
- Key (id) — varchar(100) — 기본 키 — NOT NULL
- Field (password) — varchar(100) — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (email) — varchar(100) — NOT NULL
- Field (phoneNumber) — bigint — NOT NULL
- Field (address) — varchar(100) — NOT NULL
- Field (hasHome) — boolean — NOT NULL
- Field (hasWorkplace) — boolean — NOT NULL
Untitled (Employee)
- Key (id) — varchar(100) — 기본 키 — NOT NULL
- Field (password) — varchar(100) — NOT NULL
- Field (department) — varchar(100) — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (email) — varchar(100) — NOT NULL
- Field (phoneNumber) — bigint — NOT NULL
- Field (rank) — varchar(100) — NOT NULL
Untitled (Insurance)
- Key (id) — int — 기본 키 — NOT NULL
- Key (calculationFormulaId) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (type) — varchar(100) — NOT NULL
- Field (target) — varchar(100) — NOT NULL
- Field (compensationCondition) — varchar(100) — NOT NULL
- Field (notCompensationCondition) — varchar(100) — NOT NULL
- Field (status) — varchar(100) — NOT NULL
Untitled (CalculationFormula)
- Key (id) — int — 기본 키 — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (riskLevelAccordingToPillarType) — blob — NOT NULL
- Field (riskLevelAccordingToRoofType) — blob — NOT NULL
- Field (riskLevelAccordingToOutwallType) — blob — NOT NULL
- Field (multiplierForMinCompensation) — int — NOT NULL
- Field (multiplierForMaxCompensation) — int — NOT NULL
- Field (multiplierForPayment) — int — NOT NULL
Untitled (HomeFormula)
- Key (id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (riskLevelAccordingToResidenceType) — blob — NOT NULL
- Field (riskLevelAccordingToHouseType) — blob — NOT NULL
- Field (riskLevelAccordingToSquareMeter) — blob — NOT NULL
- Field (riskLevelAccordingToCompensation) — blob — NOT NULL
Untitled (WorkplaceFormula)
- Key (id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (riskLevelAccordingToUsage) — blob — NOT NULL
- Field (riskLevelAccordingToFloor) — blob — NOT NULL
- Field (riskLevelAccordingToSquareFeet) — blob — NOT NULL
- Field (riskLevelAccordingToCompensation) — blob — NOT NULL
Untitled (Contract)
- Key (id) — int — 기본 키 — NOT NULL
- Key (customerInfoId) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (customerId) — varchar(100) — 외래 키 → Untitled.Key — NOT NULL
- Key (insuranceId) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (saleEmployeeId) — varchar(100) — 외래 키 → Untitled.Key
- Field (term) — int — NOT NULL
- Field (startDate) — timestamp
- Field (expirationDate) — timestamp
- Field (paymentFee) — int — NOT NULL
- Field (paymentCycle) — int — NOT NULL
- Field (paymentDeadline) — timestamp
- Field (compensation) — int — NOT NULL
- Field (contractStatus) — varchar(100) — NOT NULL
Untitled (CustomerInfo)
- Key (id) — int — 기본 키 — NOT NULL
- Key (customerId) — varchar(100) — 외래 키 → Untitled.Key — NOT NULL
- Field (squareMeter) — int — NOT NULL
- Field (pillarType) — varchar(100) — NOT NULL
- Field (roofType) — varchar(100) — NOT NULL
- Field (outwallType) — varchar(100) — NOT NULL
Untitled (HomeCustomerInfo)
- Key (id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (houseType) — varchar(100) — NOT NULL
- Field (residenceType) — varchar(100) — NOT NULL
Untitled (WorkplaceCustomerInfo)
- Key (id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (usage) — varchar(100) — NOT NULL
- Field (floor) — int — NOT NULL
Untitled (Accident)
- Key (id) — int — 기본 키 — NOT NULL
- Key (contractId) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (date) — timestamp — NOT NULL
- Field (location) — varchar(100) — NOT NULL
- Field (cause) — varchar(100) — NOT NULL
- Field (content) — varchar(100) — NOT NULL
- Field (damage) — bigint — NOT NULL
- Field (accountNumber) — varchar(100) — NOT NULL
- Field (stauts) — varchar(100) — NOT NULL
Untitled (Compensation)
- Key (id) — int — 기본 키 — NOT NULL
- Key (accidentId) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (compensation) — int — NOT NULL
Untitled (Pay)
- Key (id) — int — 기본 키 — NOT NULL
- Key (contractId) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (cardNumber) — varchar(100) — NOT NULL
Untitled (Sale)
- Key (id) — int — 기본 키 — NOT NULL
- Key (saleEmployeeId) — varchar(100) — 외래 키 → Untitled.Key — NOT NULL
- Key (customerId) — varchar(100) — 외래 키 → Untitled.Key — NOT NULL
- Key (insuranceId) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (message) — varchar(100) — NOT NULL