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