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