onlinelecture

Tables (4)

enrollment (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • student_id (Key2) — Foreign key → student.id — NOT NULL
  • lecture_id (Key3) — Foreign key → lecture.id — NOT NULL

instructor (CopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL

lecture (CopyOfUntitled)

  • id (Key) — Primary key — NOT NULL
  • instructor_id (Key2) — Foreign key → instructor.id — NOT NULL
  • name (Field)
  • price (Field2)
  • category (Field3)

student (Untitled)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)