ERD 연습문제2 답
테이블 (4)
Untitled (ACTIVITIES)
- Key (actCode) — int(6) — 기본 키 — NOT NULL
- Field (actName) — text(20)
- Field (description) — text
Untitled (CLASS)
- Key (classNo) — int(6) — 기본 키 — NOT NULL
- Field (operating hours) — char(10)
- Field (limeted number of person) — int(2)
- Field (resisterd number of person) — int(2)
- Key (actCode) — int(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (memberID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (age) — int(3)
- Field (phone) — int(20)
Untitled (Registration)
- Key (registID) — int(10) — 기본 키 — NOT NULL
- Field (Level) — text
- Key (classNo) — int(6) — 외래 키 → Untitled.Key — NOT NULL
- Key (memberID) — int(10) — 외래 키 → Untitled.Key — NOT NULL