lecture

Tables (4)

Lecture (강의)

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

LectureStudent (강의학생)

  • id (LectureStudent_id) — INTEGER — Primary key — NOT NULL
  • 시간 (enrolled_at) — DATETIME — NOT NULL
  • id (lecture_id) — INTEGER — Foreign key → Lecture.id — NOT NULL
  • id (student_id) — INTEGER — Foreign key → Student.id — NOT NULL

Professor (교수)

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

Student (학생)

  • id (student_id) — INTEGER — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(20) — NOT NULL
  • 학번 (studentid) — INTEGER — NOT NULL