example 3
Tables (6)
Untitled (Client)
- Key (clientID) — int(10) — Primary key — NOT NULL
- Field (ID) — int(13)
- Field2 (name) — char(5)
- Field3 (address) — char(30)
- Field (tel) — int(11)
Untitled (Family)
- Key (familyID) — int(10) — Primary key — NOT NULL
- Field3 (ID) — int(13)
- Field (name) — char(5)
- Field (age) — int(3)
- Key (clientID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Service)
- Key (ServiceCode) — int(10) — Primary key — NOT NULL
- Field (title) — char(20)
- Field2 (description) — text
Untitled (Maching)
- Key (ServiceCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (clientID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (startDate) — date
Untitled (Agent)
- Key (agentID) — int(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field2 (address) — char(30)
- Field3 (tel) — int(11)
- Field (organization) — char(20)
Untitled (ServiceProvider)
- Key (ServiceCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (agentID) — int(10) — Foreign key → Untitled.Key — NOT NULL