ios-lab-up / smartup_api

UP API that connects to UPSite
3 stars 0 forks source link

Design Grades DB Table #12

Open luisced opened 1 year ago

luisced commented 1 year ago

Create DB Table

Once the #10 its ready, fill DB with the scrapped data, this table is a junction table in which we will relate student, group and all their grades.

Note: Remember to create a new SQL file following the numeric order

Table structure and insert examples

ID (primary key, ai) Student (foreign key) Subject (foreign key) Group (foreign key) Grade (decimal) Midterm (text)
1 1 1 1 9.2 Primer Parcial