exercise2
Tables (4)
ACTIVITY (Untitled)
- activID (Key) — char(10) — Primary key — NOT NULL
- description (Field) — text
CLASS (Untitled2)
- classID (Key) — char(10) — Primary key — NOT NULL
- activID (Key2) — char(10) — Foreign key → ACTIVITY.activID — NOT NULL
- level (Field5) — int(5)
- people (Field3) — int(5)
- code (Field) — char(10)
- time (Field2) — int(3)
- capacity (Field4) — int(3)
- membID (Key3) — char(10) — Foreign key → MEMBER.membID — NOT NULL
CLASS-MEMBERTYPE (Untitled4)
- classID (Key2) — char(10) — Foreign key → CLASS.classID — NOT NULL
- membID (Key3) — char(10) — Foreign key → MEMBER.membID — NOT NULL
- activID (Key22) — char(10) — Foreign key → CLASS.activID — NOT NULL
MEMBER (Untitled3)
- membID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- age (Field3) — int(3)
- classID (Key2) — char(10) — Foreign key → CLASS.classID — NOT NULL
- activID (Key22) — char(10) — Foreign key → CLASS.activID — NOT NULL