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