project

Tables (4)

Student (학생)

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

Subject (특강)

  • 특강id (subject_id) — Primary key — NOT NULL
  • title (제목)
  • people (최대인원)
  • stime (시작시간)
  • classroom (강의실)
  • 강사id (teacher_id) — Foreign key → Teacher.강사id — NOT NULL

Teacher (강사)

  • 강사id (teacher_id) — Primary key — NOT NULL
  • 이름 (name)

mapping (매핑테이블)

  • id (mapping_id) — Primary key — NOT NULL
  • 특강id (subject_id) — Foreign key → Subject.특강id — NOT NULL
  • 전화번호 (phone) — Foreign key → Student.전화번호 — NOT NULL