rhkwp1
Tables (5)
Untitled (Client)
- Key (clientId) — char(13) — Primary key — NOT NULL
- Field (name) — char
- Field (address) — char
- Field (phone) — char(11)
- Key (dependentId2) — char(7) — Foreign key → Untitled.Key — NOT NULL
Untitled (Dependent)
- Key (dependentId) — char(7) — Primary key — NOT NULL
- Field (name) — char
- Field (age) — int
Untitled (Service)
- Key (serviceCode) — char(7) — Primary key — NOT NULL
- Field (description) — char(50)
Untitled (ServiceProvider)
- Key (provideId) — char(7) — Primary key — NOT NULL
- Field (name) — char
- Field (Address) — char
- Field (contact)
Untitled2 (Servicerecord)
- Key (clientId) — char(13) — Foreign key → Untitled.Key — NOT NULL
- Key (provideId) — char(7) — Foreign key → Untitled.Key — NOT NULL
- Field (serviceDate) — int
- Key (serviceCode) — char(7) — Foreign key → Untitled.Key — NOT NULL