Exercise 2-3_DB
Tables (9)
Untitled (ACTIVITY)
- Key (ActivityID) — int — Primary key — NOT NULL
- Field (name) — char
- Field (description) — text
Untitled (CLASS)
- Key (classID) — char(10) — Primary key — NOT NULL
- Key (ActivityID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (schedule) — char
- Field (level) — char(1)
- Field (capacity) — int
- Field (currentCount) — int
- Field2 (teacherName) — char
Untitled (MEMBER)
- Key (memberID) — int — Primary key — NOT NULL
- Field (name) — char
- Field (address) — char
- Field (birthDate) — int
- Field (phone) — char (11)
- Field (gender)
- Field (joinDate)
Untitled (REGISTRATION)
- Key (classID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ActivityID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (memberID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (payment)
- Field (attendance)
Untitled (CLIENT)
- Key (clientID) — int — Primary key — NOT NULL
- Field (ssn) — int
- Field (name) — char
- Field (address) — char
- Field (phone) — int
Untitled (DEPENDENT)
- Key (dependentID) — int — Primary key — NOT NULL
- Field (ssn) — int
- Field (name) — char
- Field (age) — int
- Field (gender) — char
- Key (clientID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceID) — int — Primary key — NOT NULL
- Field (serviceName) — char
- Field (serviceType) — char
- Field (description) — text
Untitled (PROVIDER)
- Key (providerID) — int — Primary key — NOT NULL
- Field (name) — char
- Field (address) — char
- Field (phone) — int(11)
- Field (affiliation) — char
Untitled (CLIENT_SERVICE)
- Key (serviceID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (clientID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (providerID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (serviceDate) — date