연습문제2번
테이블 (5)
Untitled (CLASS)
- Key (serialnumber) — char(10) — 기본 키 — NOT NULL
- Field (time) — char(10)
- Field (max) — char(3)
- Field (currentmember) — char(3)
- Field (name) — char(10) — 외래 키 → Untitled.Field
Untitled (MEMBER)
- Field (name) — char(10) — 기본 키
- Field (adress) — text
- Field (age) — char(2)
Untitled (LEVEL)
- Field (name) — char(10) — 외래 키 → Untitled.Field
- Key (serialnumber) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (ACTIVITY)
- Key (code) — char(4) — 기본 키 — NOT NULL
- Field (explain) — text
- Field (yoga) — char(10)
- Field (aerobic) — char(10)
- Field (swim) — char(10)
- Field
- Key (serialnumber) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (ENROLL)
- Field (name) — char(10) — 외래 키 → Untitled.Field
- Key (serialnumber) — char(10) — 외래 키 → Untitled.Key — NOT NULL