I have the following tables:
* courses
* prerequisites
* corequisites
The table "courses" has general data about school courses.
The table "prerequisites" has data about courses that must already have been taken for a certain course.
The table "corequisites" has data about courses that must be taken at the same time that another course.
This means that a course might have zero or more "prerequisites" and zero or more "corequisites" and both point to "courses".
The image below show what I think should be done.
I will very much appreciate any feedback about my approach.
![](/media/maillist_attaches/pgsql-novice/2018/03/28/CAAY=A7-BnHPUH09k_JA68zSTNeKCuqJmfJY3vj5j0c-7c=1-HA@mail.gmail.com/image.png)
Best regards,
Jorge Maldonado