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