2023_webDB_ex3
Tables (6)
ORGANIZATION (CLIENT)
- Key (memSsn) — char(13) — Primary key — NOT NULL
- Field (memName) — char(30)
- Field (memAddress) — char(50)
- Field (memTel) — char(30)
- Field (memAge) — int
Untitled (FAMILY)
- Key (famSsn) — char(13) — Primary key — NOT NULL
- Field (famName) — char(20)
- Field (famAge) — int
Untitled (SERVICE)
- Key (serviceId) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field (year) — int(4)
- Field (month) — int(2)
- Field (fee) — integer
Untitled (SERVICE_PROVIDER)
- Key (proCode) — char(30) — Primary key — NOT NULL
- Field (proName) — char(30)
- Field (proAddress) — char(50)
- Field (proTel) — char(30)
Untitled (GETTING_SERVICE)
Untitled (ENROLL)
- Key (sereId) — integer — Primary key — NOT NULL
- Field (grade) — char(3)
- Field (review) — LONGTEXT
- Field (date) — date
- Field