2번 문제
테이블 (7)
Untitled (ACTIVITY)
- Key (name) — char(20) — 기본 키 — NOT NULL
- Field (code) — char(20)
- Field (explain) — text
Untitled (CLASS)
- Key (ID) — char(50) — 기본 키 — NOT NULL
- Field (activity code) — char(50)
- Field (time) — char(50)
- Field (contrnt) — text
- Key (name) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (name) — char(80) — 기본 키 — NOT NULL
- Field (address) — char(80)
- Field (age) — char(80)
- Field (phone) — char(80)
- Field (grade) — char(80)
Untitled (CLASS-MEMBER)
- Key (name) — char(80) — 외래 키 → Untitled.Key — NOT NULL
- Key (ID) — char(50) — 외래 키 → Untitled.Key — NOT NULL
Untitled (TIME)
- Key (start time) — char(50) — 기본 키 — NOT NULL
- Field (finish time) — char(50)
Untitled (CLASS-TIME)
- Key (ID) — char(50) — 외래 키 → Untitled.Key — NOT NULL
- Key (start time) — char(50) — 외래 키 → Untitled.Key — NOT NULL
message (MESSAGE)
- Key (personnel) — char(80) — 기본 키 — NOT NULL
- Field (linit personnel) — char(50)
- Field (registered personnel) — char(80)
- Key (name) — char(80) — 외래 키 → Untitled.Key — NOT NULL
- Key (ID) — char(50) — 외래 키 → Untitled.Key — NOT NULL