lecture

Tables (4)

Lecture (Untitled2)

  • id (lecture_ID) — INTEGER — Primary key — NOT NULL
  • 강의명 (title) — TEXT
  • 강의코드 (code) — TEXT
  • id (professor_id) — INTEGER — Foreign key → Professor.id — NOT NULL

LectureStudent (Untitled4)

  • id (LectureStudent_ID) — INTEGER — Primary key — NOT NULL
  • 수강신청시간 (enrolled_at) — INTEGER
  • id (lecture_id) — INTEGER — Foreign key → Lecture.id — NOT NULL
  • id (user_id2) — INTEGER — Foreign key → Student.id — NOT NULL

Professor (Untitled)

  • id (professor_id) — INTEGER — Primary key — NOT NULL
  • 이름 (name) — TEXT
  • 이메일 (email) — TEXT

Student (Untitled3)

  • id (user_ID) — INTEGER — Primary key — NOT NULL
  • 이름 (name) — TEXT
  • 아이디 (student_id) — TEXT
  • id (user_id) — INTEGER — Foreign key → Lecture.id — NOT NULL