test

Tables (4)

course (수강신청)

  • id (Key) — INT — Primary key — NOT NULL
  • special_lecture_id (특강 아이디) — INT — Foreign key → special_lecture.id — NOT NULL
  • student_phone (학생 전화번호) — VARCHAR(255) — Foreign key → student.phone — NOT NULL

instructor (강사)

  • id (아이디) — VARCHAR(255) — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)

special_lecture (특강)

  • id (아이디) — INT — Primary key — NOT NULL
  • lecture_room (강의실) — VARCHAR(255)
  • max_people (최대인원) — INT
  • special_lecture_date (강의날짜) — DATE
  • start_time (강의시간) — TIME
  • title (강의명) — VARCHAR(100)
  • instructor_id (강사 아이디) — VARCHAR(255) — Foreign key → instructor.id — NOT NULL

student (학생)

  • phone (전화번호) — VARCHAR(255) — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)