ex2

Tables (4)

activity (Untitled3)

  • activityid (Key) — char(13) — Primary key — NOT NULL
  • description (Field) — text

class (Untitled2)

  • classid (Key) — char(13) — Primary key — NOT NULL
  • activityid (Key2) — char(13) — Foreign key → activity.activityid — NOT NULL
  • capacity (Field) — integer
  • classhour (Field2) — time
  • level (Field3) — char(3)

member (Untitled)

  • memberid (Key) — char(13) — Primary key — NOT NULL
  • ssn (Field) — char(13)
  • name (Field2) — char(10)
  • address (Field3) — text
  • age (Field4) — char(3)

member-class (Untitled4)

  • member-classid (Key) — char(13) — Primary key — NOT NULL
  • memberid (Key2) — char(13) — Foreign key → member.memberid — NOT NULL
  • classid (Key3) — char(13) — Foreign key → class.classid — NOT NULL
  • activityid (Key22) — char(13) — Foreign key → class.activityid — NOT NULL