과제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)