수강신청 시스템(민주)

테이블 (3)

Course (course)

  • CourseID (courseid) — Int — 기본 키 — NOT NULL
  • CourseName (coursename) — VARCHAR(255)
  • Class_Time (class_time)
  • Classroom (classroom) — VARCHAR(255)

Members (members)

  • MemberID (memberid) — Int — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)
  • Email (email) — VARCHAR — NOT NULL

Wishlist (wishlist)

  • WishlistID (wishlistid) — Int — 기본 키 — NOT NULL
  • MemberID (memberid) — Int
  • CourseID (courseid) — Int
  • Priority (priority) — Int