[DATABASE] Make routes a separate table

tuvarna-coursework / transport-system-management

2 stars 2 forks source link

Closed MaximilianGeorgiev closed 3 years ago

MaximilianGeorgiev commented 3 years ago

Routes must be a separate table because routes are hardcoded before hand (as per requirement) and the Trip will make use of foreign keys.

A route will have: route_id route_departurelocation_id(FK) route_arrivallocation_id(FK)

A route can have many middle points that's why another table is needed: RouteAttachment route_id(FK) route_attachmentlocation_id(FK)

MaximilianGeorgiev commented 3 years ago

resolved with #9eff58d