Lecture

Tables (5)

Lecture

  • lecture_id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — VARCHAR(1000)
  • date — TIMESTAMP — NOT NULL
  • max_participants — INT
  • version — INT

LectureApplication

  • application_id — INT — Primary key — NOT NULL
  • application_time — TIMESTAMP
  • status — VARCHAR(20)
  • lecture_id — INT — Foreign key → Lecture.lecture_id — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL

LectureSeats

    Untitled

      User

      • user_id — INT — Primary key — NOT NULL
      • user_name — VARCHAR(255) — NOT NULL
      • email — VARCHAR(255) — NOT NULL