wrewt
Tables (4)
DEPENDENT
- Key (depenID) — char(13) — Primary key — NOT NULL
- Field (depenName) — char(30)
- Field2 (birthDate) — date
- Key (clientID) — char(13) — Foreign key → Untitled3.Key — NOT NULL
- Key (serviceCode) — char(10) — Foreign key → Untitled3.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceCode) — char(10) — Primary key — NOT NULL
- Field (description) — text
- Field (date) — date
- Key (proID) — char(13) — Foreign key → Untitled4.Key — NOT NULL
- Key2 (proName) — char(20) — Foreign key → Untitled4.Key2 — NOT NULL
Untitled3 (FEMALE-CLIENT)
- Key (clientID) — char(13) — Primary key — NOT NULL
- Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (clientNane) — char(20)
- Field (clientAddress) — char(30)
- Field (clientPhone) — char(11)
Untitled4 (SERVICE-PROVIDER)
- Key (proID) — char(13) — Primary key — NOT NULL
- Key2 (proName) — char(20) — Primary key — NOT NULL
- Field (proAddress) — char(30)
- Field (proPhone) — char(11)