study3
Tables (6)
CLASS
- classID — char(10) — Primary key — NOT NULL
- time — time
- registerlimit — int(2) — NOT NULL
- memberID — char(10) — NOT NULL
- level — int(1) — NOT NULL
LEPORTS
- aerobics — char(10)
- yoga — char(10)
- swimming — char(10)
- leportsID — char(10) — NOT NULL
LEVEL
- level — int(1) — Primary key — NOT NULL
MEMBER
- memberID — char(10) — Primary key — NOT NULL
- name — char(10)
- address — char(30)
- age — char(10)
- level — int(1) — NOT NULL
PART
- leportsID — char(10) — Primary key — NOT NULL
- description — text
- classID — char(10) — NOT NULL
REGISTER
- registerlimit — int(2) — Primary key — NOT NULL
- registermember — int(2)