2023_HAN3
Tables (10)
Untitled (CLIENT)
- Key (clientID) — int(5) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(100)
- Field (phone) — int(11)
- Field (email) — char(100)
- Field (Ssn) — char(13)
Untitled (DEPENDANT)
- Key (dependantID) — int(5) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (phone) — int(11)
- Field (clientID) — int(5)
- Field (Ssn) — char(13)
- Key (clientID2) — int(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICEPROVIDER)
- Key (providerID) — int(100) — Primary key — NOT NULL
- Field (name) — char(100)
- Field (address) — char(100)
- Field (phone) — char(12)
- Field (grade) — float(3)
- Field (memo) — longtext
- Field (type)
Untitled (ENROLL)
- Key (screID) — integer — Primary key — NOT NULL
- Field (grade) — cher(2)
- Field (review) — longtext
- Field (clientid) — int(5)
- Field (date) — date
- Key (clientID) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceID) — int(1000) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceID) — int(1000) — Primary key — NOT NULL
- Field (name) — chae(3)
- Field2 (descripition) — text
- Field3 (year) — int(4)
- Field4 (month) — int(2)
- Field5 (fee) — integer
- Field6 (subjetID) — int(10)
- Field7 (projetID)
- Key — Foreign key → Untitled.Key — NOT NULL
- Key (providerID) — int(100) — Foreign key → Untitled.Key — NOT NULL
Untitled (SUBJET)
- Key — Primary key — NOT NULL
- Field2 (name) — char(30)
- Field (memo) — longtext
Untitled (NOTE)
- Key (noteID) — Primary key — NOT NULL
- Field (serviceID) — int(1000)
- Field2 (ceseription) — text
- Field3 (mangerID) — int(100)
- Field4 (clientID) — int((5)
- Key (clientID2) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceID2) — int(1000) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (SERVICE_MANAGER)
- Key (serviceID) — int(1000) — Primary key — NOT NULL
- Key (mangerID) — int(100) — Foreign key → Untitled3.Key — NOT NULL
- Key (serviceID2) — int(1000) — Foreign key → Untitled.Key — NOT NULL
- Field (manegerID)
Untitled3 (MANGER)
- Key (mangerID) — int(100) — Primary key — NOT NULL
- Field (nameID) — char(20)
- Field2 (phone) — char(20)
- Field3 (email) — char(30)
- Field4 (descripition) — text