When generating the database from the schema, there are effectively no explicit foreign keys. Almost all relationships are set only in the rails app. Related to #529. Actual vs (roughly) expected: <img width="400" alt="image" src="https://github.com/ABTech/tracker/assets/66567994/4027af5d-0a5b-4fc3-87dc-27948c81998b"> <img width="400" alt="image" src="https://github.com/ABTech/tracker/assets/66567994/b6fad89d-c3d9-4e81-ab57-2ebb15b5f987">