과제2
테이블 (4)
ACTIVITY (Activity)
- ACTIVITYID (ActivityID) — INT — 기본 키 — NOT NULL
- ACTIVITYNAME (ActivityName) — VARCHAR(100) — NOT NULL
- DESCRIPTION (Description) — TEXT
COURSE (Course)
- COURSEID (CourseID) — INT — 기본 키 — NOT NULL
- SCHEDULE (schedule) — Datetime
- MAXPARTICIPANTS (MaxParticipants) — INT
- CURRENTPARTICIPANTS (CurrentParticipants) — INT
- ACTIVITYID (ActivityID) — INT — 외래 키 → ACTIVITY.ACTIVITYID — NOT NULL
MEMBER (Member)
- MEMBERID (MemberID) — INT — 기본 키 — NOT NULL
- MEMBERNAME (memberName) — VARCHAR(100)
- ADDRESS (address) — VARCHAR(255)
- AGE (age) — INT
REGISTRATION (Registration)
- RegistrationID — INT — 기본 키 — NOT NULL
- COURSEID (CourseID) — INT — 외래 키 → COURSE.COURSEID — NOT NULL
- MEMBERID (MemberID) — INT — 외래 키 → MEMBER.MEMBERID — NOT NULL
- Field (DifficultyLevel) — VARCHAR(255)