HWP2(10_06)

Tables (4)

Activity (Untitled)

  • ActCode (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text

Class (Untitled2)

  • classID (Key) — integer — Primary key — NOT NULL
  • Classname (Field) — char(30)
  • Time (Field2) — integer
  • ActCode (Key2) — char(10) — Foreign key → Activity.ActCode — NOT NULL
  • level (Field3) — char(2)

ENROLL (Untitled4)

  • ClassID (Key) — integer — Foreign key → Class.classID — NOT NULL
  • MemberID (Key2) — integer — Foreign key → Membership.MemberID — NOT NULL

Membership (Untitled3)

  • MemberID (Key) — integer — Primary key — NOT NULL
  • Name (Field) — char(20)
  • Address (Field2) — char(20)
  • Age (Field3) — integer