2023_webDB_ex3
Tables (7)
Untitled (CLIENT)
- Key (clientId) — int(5꙼̈) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(100)
- Field (phone) — int(11)
- Field (ssn) — char(13)
Untitled (SERVICEPROVIDER)
- Key (providerId) — int(100) — Primary key — NOT NULL
- Field (name) — char(100)
- Field (address) — char(100)
- Field (phone) — int(12)
- Field (grade) — float(3꙼̈)
- Field (memo) — LONGTEXT
- Field (type) — char(4꙼̈)
Untitled (SUBJECT)
- Key (subjectId) — int(1꙼̈0) — Primary key — NOT NULL
- Field (name) — char(3꙼̈0)
- Field (memo) — LONGTEXT
Untitled (SERVICE)
- Key (serviceId) — int(1000) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field (year) — int(4)
- Field (month) — int(2)
- Field (fee) — integer
- Key (subjectId) — int(1꙼̈0) — Foreign key → Untitled.Key — NOT NULL
Untitled (ENROLL)
- Key (sereId) — integer — Primary key — NOT NULL
- Field (grade) — char(2꙼̈)
- Field (review) — LONGTEXT
- Field (date) — date
- Key (serviceId) — int(1000) — Foreign key → Untitled.Key — NOT NULL
- Key (clientId) — int(5꙼̈) — Foreign key → Untitled.Key — NOT NULL
Untitled (NOTE)
- Key (noteId) — int — Primary key — NOT NULL
- Field (description) — text
- Key (serviceId) — int(1000) — Foreign key → Untitled.Key — NOT NULL