quiz

Tables (5)

course (courses)

  • id (Key) — UUID — Primary key — NOT NULL
  • instructor_id (Key2) — uuid — Foreign key → instructor.id — NOT NULL

instructor (instructors)

  • id (Key) — UUID — Primary key — NOT NULL

prerequisite (prerequisites)

  • prerequisite_course_id (Key2) — UUID — Foreign key → course.id — NOT NULL
  • course_id (Key) — UUID — Foreign key → course.id — NOT NULL

student (students)

  • id (Key) — UUID — Primary key — NOT NULL
  • research_instructor (Key2) — UUID — Foreign key → instructor.id — NOT NULL

student_course (student_courses)

  • term (Key3) — VARCHAR(3) — Primary key — NOT NULL
  • course_id (Key2) — UUID — Foreign key → course.id — NOT NULL
  • student_id (Key) — UUID — Foreign key → student.id — NOT NULL