insurance

Tables (9)

complaint (Untitled7)

  • customerID — int — Foreign key → customer.id — NOT NULL
  • employeeID (empolyeeID) — int — Foreign key → employee.id — NOT NULL
  • customerInfo — string
  • dated (date) — string
  • department — string
  • details — string
  • title — string

constract (Untitled4)

  • customerID — int — Foreign key → customer.id — NOT NULL
  • insuranceID — int — Foreign key → insurance.id — NOT NULL

customer (Untitled)

  • id — int — Primary key — NOT NULL
  • password — string
  • customerNumber — int
  • name — string
  • age — int
  • account — string
  • gender — string
  • address — string
  • phonNumber (phoneNumber) — string
  • job — string
  • email — string
  • birthdate — string
  • creditRating — string
  • abroad — strnig
  • consractStatus (constractStatus) — string
  • crime — string
  • disease — string
  • drink — boolean
  • drive — string
  • identityNum — string
  • military — boolean

employee (Untitled3)

  • id — int — Primary key — NOT NULL
  • accountNum — string
  • department — string
  • email — string
  • employeeID — string
  • HP — string
  • name — string
  • position — string

hold (Untitled8)

  • customerID — int — Foreign key → underwriting.customerID — NOT NULL

insurance (Untitled2)

  • id — int — Primary key — NOT NULL
  • name — string
  • description — string
  • premium — string
  • coverage — string
  • term — string
  • maxAge — string
  • exclusionse (exclusions) — string

refusal (Untitled6)

  • customerID — int — Foreign key → underwriting.customerID — NOT NULL

request (Untitled9)

  • id — int — Primary key — NOT NULL
  • customerID — int — Foreign key → customer.id — NOT NULL
  • accidentInfo — string
  • beneficiaryInfo — string
  • bill — string
  • memberInfo — string
  • SSN — string

underwriting (Untitled5)

  • customerID — int — Foreign key → customer.id — NOT NULL