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