Exercixe2
Tables (4)
Class (Untitled2)
- classCode (Key) — char(5) — Primary key — NOT NULL
- className (Field) — char(20)
- startTime (Field2) — time
- finishTime (Field3) — time
- fixedNumber (Field5) — char(2)
- currentNumber (Field6) — char(2)
- memberId (Key2) — char(5) — Foreign key → Member.memberId — NOT NULL
- activityCode (Key3) — char(5) — Foreign key → Lesports.activityCode — NOT NULL
Lesports (Untitled3)
- activityCode (Key) — char(5) — Primary key — NOT NULL
- activityName (Field) — char(30)
- description (Field2) — text
Level (Untitled4)
- activityLevel (Key) — char(1) — Primary key — NOT NULL
- memberId (Key2) — char(5) — Foreign key → Member.memberId — NOT NULL
- activityCode (Key3) — char(5) — Foreign key → Lesports.activityCode — NOT NULL
Member (Untitled)
- memberId (Key) — char(5) — Primary key — NOT NULL
- memberName (Field) — char(30)
- memberAge (Field2) — char(3)
- memberAddress (Field3) — text