2022913002ERD3
Tables (8)
CLIENT (Untitled2)
- Key — int(9) — Primary key — NOT NULL
- Field — char(20)
- Field2 — char(30)
- Field3 — char(12)
- Field4 — char(20)
DPENDENT (Untitled3)
- Key — int(9) — Primary key — NOT NULL
- Field — char(20)
- Field2 — char(30)
- Field3 — char(12)
- Field4 — char(20)
- Key (Key2) — int(9) — Foreign key → CLIENT.Key — NOT NULL
ENROLL (Untitled6)
- Key — integer — Primary key — NOT NULL
- Field — char(2)
- Field2 — LONGTEXT
- Field3 — date
- Key (Key2) — int(9) — Foreign key → CLIENT.Key — NOT NULL
- Key (Key3) — char(10) — Foreign key → SERVICE.Key — NOT NULL
MANAGER (Untitled)
- Key — int(10) — Primary key — NOT NULL
- Field — char(20)
- Field2 — char(30)
- Field3 — char(12)
- Field4 — char(20)
- Field5 — text
NOTE (Untitled9)
- Key — integer — Primary key — NOT NULL
- Field — text
- Key (Key2) — char(10) — Foreign key → SERVICE.Key — NOT NULL
SERVICE (Untitled5)
- Key — char(10) — Primary key — NOT NULL
- Field — text
- Field2 — date
- Key (Key2) — int(10) — Foreign key → SUBJECT.Key — NOT NULL
- Key (Key3) — int(100) — Foreign key → SERVICEPROVIDER.Key — NOT NULL
- Key (Key4) — int(10) — Foreign key → MANAGER.Key — NOT NULL
SERVICEPROVIDER (Untitled8)
- Key — int(100) — Primary key — NOT NULL
- Field — char(20)
- Field2 — char(30)
- Field3 — char(12)
- Field4 — LONGTEXT
- Field5 — char(4)
SUBJECT (Untitled7)
- Key — int(10) — Primary key — NOT NULL
- Field — char(20)
- Field2 — LONGTEXT