3주차 연습문제2_김자언
테이블 (4)
Untitled (ACTIVITIES)
- Key (aCode) — char(10) — 기본 키 — NOT NULL
- Field (name) — char10)
- Field (description) — text
Untitled (CLASS)
- Key (cID) — char(15) — 기본 키 — NOT NULL
- Field (runninghour) — int(3)
- Field (limitedpersonnel) — int(2)
- Field (currentpersonnel) — int(2)
- Field (level) — int(1)
Untitled (MEMBER)
- Key (mID) — char(15) — 기본 키 — NOT NULL
- Field (address) — text
- Field (age) — int(3)
- Field (name) — char(10)
- Key (level) — int(1) — 외래 키 → Untitled.Key — NOT NULL
- Key (aCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (cID) — char(15) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CLASS_REGISTERED)
- Key (level) — int(1) — 기본 키 — NOT NULL
- Key (aCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (cID) — char(15) — 외래 키 → Untitled.Key — NOT NULL