we have a Ruby on Rails app that we want to “reverse engineer” into TDM. Rails uses a convention where FK relationships have a suffix of _id. For example, in a case where an exam result has the student’s ID in it you will see that the “exam_result” table will have a column called “student_id”. In the Ruby on Rails world, you can then expect to see a “student” table with a PK called “ID”. All tables in our database have an integer ID column as a PK.
All of the relationships between the entities are described in the Rails Models so there is nothing in the database in terms of formal FK constraints.
My question is this – is there a way to have TDM automagically create relationships based on the aforementioned convention?
Thanks in advance,