ERD Exercise2
Tables (4)
Untitled (레포츠 활동)
- 레포츠 활동명 — char(10) — Primary key — NOT NULL
- 각 레포츠 code — int(10)
- 각 레포츠 explanation — text
Untitled (CLASS)
- ClassName — char(10) — Primary key — NOT NULL
- ClassNumber — int(10)
- ClassCode — int(10)
- 운영시간 — time
- 수용인원 — int
- 등록인원(현재) — int
- 레포츠 활동명 — char(10) — Foreign key → Untitled.레포츠 활동명 — NOT NULL
- Field (ClassLevel) — char(3)
Untitled (MEMBER)
- MemberID — int(10) — Primary key — NOT NULL
- MemberName — char(6)
- MemberAddress — char(20)
- MemberAge — int
Untitled (ENROLL)
- ClassName — char(10) — Foreign key → Untitled.ClassName — NOT NULL
- MemberID — int(10) — Foreign key → Untitled.MemberID — NOT NULL