2023_SLI_EX3
Tables (9)
ACTIVITY (DEPENDENT)
- ActCode (dependantID) — int(5) — Primary key — NOT NULL
- Field (depName) — char(20)
- Field (age) — text
- Key (clientS) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Field (phone) — int(11)
- Field (ssn) — char(13)
Untitled (SER_MANAGER)
- Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (managerID) — int(100) — Foreign key → Untitled.Key — NOT NULL
Untitled (SER_PROVIDER)
- 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 (description) — text
Untitled (ENROLL)
- Key — Primary key — NOT NULL
- Key (clientID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (grade) — char(2)
- Field (review) — LONGTEXT
- Field (date) — date
Untitled (SERVICE)
- Key (serviceCode) — int(100) — Primary key — NOT NULL
- Field (description) — text
- Key — Foreign key → Untitled.Key — NOT NULL
- Key (Key2) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — char(20)
- Field (year) — int(4)
- Field (month) — int(2)
- Field (fee) — integer
Untitled (NOTE)
- Key (noteID) — CHAR(100) — Primary key — NOT NULL
- Key (clientID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (serviceCode) — char(100) — Foreign key → Untitled.Key — NOT NULL
- Key (MANAGERid) — INT(100) — Foreign key → Untitled.Key — NOT NULL
- Field (DESCRIPTION) — TEXT
Untitled (SUBJECT)
- Key (subjectID) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
Untitled (MANAGER)
- Key (managerID) — int(100) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (phone) — int(11)
- Field (email) — char(100)
- Field (description) — text
Untitled2 (CLIENT)
- Key (clientID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (adress) — char(100)
- Field2 (phone) — int(11)
- Field (email) — char(100)
- Field (ssn) — char(13)