보험

테이블 (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