Football Schema for SQLite seems to miss any Foreign Keys? about sport.db HOT 2 OPEN

Thanks for reporting the missing foreign key constraints. In ActiveRecord-generated (SQL) schemas foreign keys use the table name + id convention, thus, in the example above country_id is the foreign key to the country table / relation. All primary keys are always called id.

From the reddit thread: Enforced foreign key constraints are missing for historic reasons and yes, more need to get added (starting with Rails 6+ there's now support for foreign key constraints for SQLite in ActiveRecord). I'm happy to update the schema, see https://github.com/sportdb/sport.db/blob/master/sportdb-models/lib/sportdb/schema.rb but unfortunately this will take some weeks (as this also requires an upgrade of minimum required ruby version and more).

from sport.db.

Yes, I suspected that adding the actual migrations for the foreign keys would be the smaller part of the work. Feel free to come back at me once the groundwork is done, in general I would be thrilled to provide these datasets as a possible learning resource for teachers and children.

from sport.db.