tt

Tables (4)

Lecture (강의)

  • id (lecture_id) — Long — Primary key — NOT NULL
  • teacher (teacher_id) — Long — Foreign key → teacher.id — NOT NULL
  • id (room_id) — Long — Foreign key → lecture_room.id — NOT NULL
  • lectureName (lecutre_name) — String
  • startDate (start_date) — Datetime
  • lectureTime (lecture_time) — String
  • lectureContent (lecture_content) — String
  • registerCount (register_count) — Long
  • totalEntryCount (total_entry_count) — int

lecture_register (강연신청 히스토리테이블)

  • id (lecture_id2) — Long — Foreign key → Lecture.id — NOT NULL
  • employeeNo (employee_no) — int — Foreign key → Lecture.id — NOT NULL

lecture_room (강연장)

  • id (room_id) — Long — Primary key — NOT NULL
  • roomName (room_name) — String
  • roomInfo (room_info) — String

teacher (강연자)

  • id (teacher_id) — Long — Primary key — NOT NULL
  • name — String