웹DB_문제2
테이블 (9)
ACTIVITY
- Key (code) — int(10) — 기본 키 — NOT NULL
- Field (aName) — char(10)
- Field (description) — text
Untitled (CLASS)
- Key (cID) — int(10) — 기본 키 — NOT NULL
- Field (cCode) — int(10)
- Field (cMaxNum) — int(10)
- Field (cMem) — int(10)
- Field (cLevel) — char(10)
- Key (aCode) — int(10) — 외래 키 → ACTIVITY.Key — NOT NULL
- Key (lID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (mID) — int(10) — 기본 키 — NOT NULL
- Field (mName) — char(10)
- Field (mAdress) — char(20)
- Field (mAge) — int(3)
Untitled (CLASS_MEMBER)
- Key (cID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (mID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CLASS_TIMETABLE)
- Key (cID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (timetableID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (TIMETABLE)
- Key (timetableID) — int(10) — 기본 키 — NOT NULL
- Field (description) — text
- Key (dID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (tID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DAY)
- Key (dID) — int(10) — 기본 키 — NOT NULL
- Field (day) — char(10)
Untitled (TIME)
- Key (tID) — int(10) — 기본 키 — NOT NULL
- Field (time) — char(10)
Untitled (LOCATION)
- Key (lID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(20)