exercise 4
Tables (6)
research (연구)
- researchid (Key) — Primary key — NOT NULL
- teacherid (Key2) — Foreign key → teacher.teacherid — NOT NULL
- researchname (Field)
- email (Field2)
- memo (Field3)
teacher (강사)
- teacherid (Key) — Primary key — NOT NULL
- teachername (Field)
- teacherssn (Field2)
- address (Field3)
- phone (Field4)
- email (Field5)
teaching team (교육팀)
- teamid (Key) — Primary key — NOT NULL
- teacherid (Key2) — Foreign key → teacher.teacherid — NOT NULL
- phone (Field)
- email (Field2)
technology course (강좌)
- subjectid (Key) — Primary key — NOT NULL
- teamid (Key2) — Foreign key → teaching team.teamid — NOT NULL
- teacherid (Key22) — Foreign key → teaching team.teacherid — NOT NULL
- subjectname (Field)
- phone (Field2)
trainee (교육생)
- traineeid (Key) — Primary key — NOT NULL
- traineename (Field)
- traineessn (Field2)
- address (Field3)
- phone (Field4)
- email (Field5)
- teacherid (Key2) — Foreign key → teacher.teacherid — NOT NULL
training session (세션)
- sessionid (Key) — Primary key — NOT NULL
- score (Field)
- subjectid (Key3) — Foreign key → technology course.subjectid — NOT NULL
- traineeid (Key2) — Foreign key → trainee.traineeid — NOT NULL
- teamid (Key22) — Foreign key → technology course.teamid — NOT NULL
- teacherid (Key222) — Foreign key → technology course.teacherid — NOT NULL