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