ex_2
Tables (3)
ACTIVITY (Untitled)
- ActivityCode (Key) — char(10) — Primary key — NOT NULL
- ActivityDescript (Field) — text
- ClassNumber (Field2) — char(10)
- ClassNumber (Key2) — char(10) — Foreign key → CLASS.ClassNumber — NOT NULL
CLASS (Untitled2)
- ClassNumber (Key) — char(10) — Primary key — NOT NULL
- ActivityCode (Field) — char(10)
- OperationTime (Field2) — time
- EnrollmentLimit (Field3) — 30
- ClassLevel (Field4) — char(1)
- MemberId (Key2) — char(10) — Foreign key → MEMEBER.MemberId — NOT NULL
- ActivityCode (Key3) — char(10) — Foreign key → ACTIVITY.ActivityCode — NOT NULL
MEMEBER (Untitled5)
- MemberId (Key) — char(10) — Primary key — NOT NULL
- ClassNumber (Field) — char(10)
- MemberName (Field2) — char(20)
- MemberAddress (Field3) — char(30)
- MemberAge (Field4) — char(2)
- ClassLevel (Field5) — char(1)
- ClassNumber (Key2) — char(10) — Foreign key → CLASS.ClassNumber — NOT NULL