exercise3
Tables (5)
CUSTOMER (Untitled)
- ID (Key) — int(13) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — int(11)
FAMILY (Untitled2)
- ID (Key) — int(13) — Primary key — NOT NULL
- name (Field) — char(10)
- phone (Field2) — int(11)
PROVIDER (Untitled4)
- ssn (Key) — int(8) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — int(11)
- code (Key2) — int(10) — Foreign key → SERVICE.code — NOT NULL
SERVICE (Untitled3)
- code (Key) — int(10) — Primary key — NOT NULL
- explanation (Field) — char(50)
- ID (Key2) — int(13) — Foreign key → CUSTOMER.ID — NOT NULL
- serviceDate (Field2) — date