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
User
- user_id — INT — Primary key — NOT NULL
- user_name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL