... | @@ -9,6 +9,7 @@ Their elements are listed as follow: |
... | @@ -9,6 +9,7 @@ Their elements are listed as follow: |
|
- s_teacher: uses **id** and **sn** as primary key and stores name, password, clazz_id and photo at the same time.
|
|
- s_teacher: uses **id** and **sn** as primary key and stores name, password, clazz_id and photo at the same time.
|
|
- s_course: uses **id** as primary key and **must stay the same as id in s_teacher**, and stores name, teacher_id, course_date, selected_num, max_num and info at the same time.
|
|
- s_course: uses **id** as primary key and **must stay the same as id in s_teacher**, and stores name, teacher_id, course_date, selected_num, max_num and info at the same time.
|
|
![Relationship](uploads/9c2bfd6dc06df7887c6845205e5dcb86/Relationship.png)
|
|
![Relationship](uploads/9c2bfd6dc06df7887c6845205e5dcb86/Relationship.png)
|
|
|
|
|
|
**Sprint4**
|
|
**Sprint4**
|
|
|
|
|
|
Set up a new table: s_attendance.
|
|
Set up a new table: s_attendance.
|
... | | ... | |