2 과제
테이블 (7)
ACTIVITY
- Key (activity_name) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — text
Untitled (CLASS)
- Key (class) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Key (activity_name) — char(30) — 외래 키 → ACTIVITY.Key — NOT NULL
Untitled (MWMBER)
- Key (memberID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field
Untitled (REGISTER)
- Key — 기본 키 — NOT NULL
- Key (class) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (memberID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MEMBER_LOCATION)
- Key (memberID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CLASS_ LOCATION)
- Key (class) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CLASS_DAY)
- Key (class) — char(30) — 외래 키 → Untitled.Key — NOT NULL