add route reference to course and create related indexes on the courses table