분산2

테이블 (17)

Accident

  • Key (accidentID) — INT — 기본 키 — NOT NULL
  • Field (accidentDate) — VARCHAR(20)
  • Field (accidentLocation) — VARCHAR(40)
  • Field (accidentType) — VARCHAR(20)
  • Field (carInformation) — VARCHAR(40)
  • Field (carNumber) — INT
  • Key (CustomerID) — INT — 외래 키 → Customer.Key — NOT NULL

Compensation

  • Key (compensatinoID) — INT — 기본 키 — NOT NULL
  • Key (accidentID) — INT — 외래 키 → Accident.Key — NOT NULL
  • Field (InsuranceAmoubt) — INT
  • Field (employeeOpinion) — VARCHAR(20)
  • Field (lossAmount) — INT
  • Field (billReason) — VARCHAR(40)

Contract

  • Key (contractID) — INT — 기본 키 — NOT NULL
  • Field (concludedDAte) — VARCHAR(40)
  • Field (concludedEID) — INT
  • Field (contractStatus) — VARCHAR(20)
  • Field (createdDate) — VARCHAR(20)
  • Field (evaluation) — VARCHAR(20)
  • Field (expirationDate) — VARCHAR(20)
  • Field (isConcluded) — boolean
  • Field (isPassUW) — boolean
  • Field (monthlyPremium) — INT
  • Field (nonPaymentPeriod) — INT
  • Field (renewalStatus) — boolean
  • Field (resurrectionDate) — VARCHAR(20)
  • Field (resurrectionReason) — VARCHAR(50)
  • Field (underwritingEID) — INT
  • Key (CustomerID) — INT — 외래 키 → Customer.Key — NOT NULL
  • EmployeeId (EmployeeID) — Int — 외래 키 → Employee.EmployeeId — NOT NULL
  • Key (insuranceID) — INT — 외래 키 → Insurance.Key — NOT NULL

Counsel

  • Key (counselID) — INT — 기본 키 — NOT NULL
  • Field (counselDetail) — VARCHAR(100)
  • Field (content) — VARCHAR(100)
  • Field (dateOfcounsel) — VARCHAR(20)
  • Field (insuranceType) — VARCHAR(20)
  • Field (statusOfCounsel) — Boolean
  • Field (timeOfCounsel) — VARCHAR(20)
  • EmployeeId (EmployeeID) — Int — 외래 키 → Employee.EmployeeId — NOT NULL
  • CustomerID — INT — 외래 키 → Customer.Key — NOT NULL

Customer

  • Key (CustomerID) — INT — 기본 키 — NOT NULL
  • Field (CustomerPW) — VARCHAR(40)
  • Field (email) — VARCHAR(40)
  • Field (gender) — VARCHAR(10)
  • Field (height) — INT
  • Field (job) — VARCHAR(20)
  • Field (name) — VARCHAR(40)
  • Field (phone) — VARCHAR(20)
  • Field (weight) — INT
  • Field (age) — INT
  • Field (account) — VARCHAR(30)
  • Field (address) — VARCHAR(40)
  • Field (brithDate) — VARCHAR(20)

Employee

  • EmployeeId (EmployeeID) — Int — 기본 키 — NOT NULL
  • Field (EmployeePW) — VARCHAR(80)
  • Field (gender) — VARCHAR(10)
  • Field (name) — VARCHAR(40)
  • Field (phone) — VARCHAR(20)
  • Field (type) — VARCHAR(20)
  • Field (email) — VARCHAR(40)
  • Field

Insurance

  • Key (insuranceID) — INT — 기본 키 — NOT NULL
  • Field (insuranceName) — VARCHAR(40)
  • Field (category) — VARCHAR(20)
  • Field (insuranceRate) — INT
  • Field (minimumPeriod) — INT
  • Field (minimumPremium) — INT
  • Field (notice) — VARCHAR(80)
  • Field (processOfcompensation) — VARCHAR(40)
  • Field (processOfSubscription) — VARCHAR(40)
  • Field (specialProvisionDescription) — VARCHAR(40)
  • Field (rateOfdiscount) — DOUBLE
  • Field (specialProvisionName) — VARCHAR(20)
  • Field (guaranteeName) — VARCHAR(20)
  • Field (maxCoverage) — INT
  • Field (guaranteeDescription) — VARCHAR(40)
  • Key (CarID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (CancelHealthID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (TravelID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (HouseFireID) — INT — 외래 키 → Untitled.Key — NOT NULL

Payment (Untitled)

  • PaymenyId (Key) — INT — 기본 키 — NOT NULL
  • amount (Field) — INT
  • dataOfPayment (Field2) — String
  • dueDateOfPayment (Field3) — INT
  • CustomerID — INT — 외래 키 → Customer.Key — NOT NULL
  • ContractID (contractID) — INT — 외래 키 → Contract.Key — NOT NULL

PaymentInfo

  • Key (PaymentInfoID) — INT — 기본 키 — NOT NULL
  • Key (contractID) — INT — 외래 키 → Contract.Key — NOT NULL
  • Field (paymenyType) — VARCHAR(20)
  • Field (fixedMonthlyPaymentDate) — VARCHAR(20)
  • Field (fixedMonthlyPayment) — INT

Untitled (Car)

  • Key (CarID) — INT — 기본 키 — NOT NULL
  • Field (priceOfCar) — INT
  • Field (model) — VARCHAR(40)
  • Field (hasBlackBox) — BOOLEAN
  • Field (VIN) — VARCHAR(40)

Untitled (CancerHealth)

  • Key (CancelHealthID) — INT — 기본 키 — NOT NULL
  • Field (CanecerType) — VARCHAR(20)

Untitled (InternationalTravel)

  • Key (TravelID) — INT — 기본 키 — NOT NULL
  • Field (TravelCountry) — VARCHAR(40)
  • Field (travlePeriod) — INT

Untitled (HouseFire)

  • Key (HouseFireID) — INT — 기본 키 — NOT NULL
  • Field (HouseFireType) — VARCHAR(20)
  • Field (priceOfHouse) — INT

Untitled (MedicalHistory)

  • Key (MedicalHistoryID) — INT — 기본 키 — NOT NULL
  • Field (curePeriod) — VARCHAR(20)
  • Field (disaeseName) — VARCHAR(20)
  • Field (isCured) — Boolean
  • Key (CustomerID) — INT — 외래 키 → Customer.Key — NOT NULL

Untitled (BANK)

  • Key (bankID) — INT — 기본 키 — NOT NULL
  • Field (payerName) — VARCHAR(40)
  • Field (payerPhoneNum) — VARCHAR(20)
  • Key (PaymentInfoID) — INT — 외래 키 → PaymentInfo.Key — NOT NULL

Untitled (Automatic)

  • Key (automaticID) — INT — 기본 키 — NOT NULL
  • Field (accountNum) — VARCHAR(40)
  • Field (applicantName) — VARCHAR(40)
  • Field (applicantRRN) — VARCHAR(40)
  • Field (paymentCompanyName) — VARCHAR(20)
  • Field (relationshipToApplicant) — VARCHAR(20)
  • Key (PaymentInfoID) — INT — 외래 키 → PaymentInfo.Key — NOT NULL

Untitled (CARD)

  • Key (cardID) — INT — 기본 키 — NOT NULL
  • Field (cardNum) — VARCHAR(20)
  • Field (cvcNum) — VARCHAR(10)
  • Field (password) — VARCHAR(20)
  • Key (PaymentInfoID) — INT — 외래 키 → PaymentInfo.Key — NOT NULL