분산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