Skip to content

Latest commit

 

History

History
39 lines (34 loc) · 1.19 KB

README.md

File metadata and controls

39 lines (34 loc) · 1.19 KB
Raw

project-week-3

  1. Endpoints for Users
  • POST /register
  • POST /login
  1. Endpoints for Tutors
  • GET /general/tutor/:tutorId
  • GET /general/tutors
  • POST /protected/tutor/update
  • DELETE /protected/tutor/delete/:tutorId
  • PUT /protected/tutor/add
  1. Endpoints for Students
  • GET /general/student
  • GET /general/student/:studentId
  • POST /protected/student/update
  • DELETE /protected/student/delete/:studentId
  • PUT /protected/student/add
  1. Endpoints for Subjects
  • GET /general/subject/:subjectId
  • GET /general/subject
  • POST /protected/subject/update
  • DELETE /protected/tutor/delete/:subjectId
  • PUT /protected/subject/add
  1. Edpoints for Enrollments
  • GET/general/enrollment/:enrollmentId
  • GET/general/enrollments
  • GET/general/class
  • GET/general/tutor
  • PUT/protectedl/enrollment
  • POST/protected/enrollment/:enrollmentId
  • DELETE/protected/enrollment/:enrollmentId
  1. Adding constraints in table
  • alter table "students" add constraint fk_school_id foreign key (school_id) references schools(id);
  • alter table "enrollments" add constraint fk_student_id foreign key (student_id) references students(id);
  • alter table "enrollments" add constraint fk_tutor_id foreign key (tutor_id) references tutors(id);