Regarding
[fix] support for multiple constraints between two tables when creating relations from foreign keys
I have used this now, and think a slight tweak is in order...
Right now, when one table has multiple keys back to another table, foreign key names are being created as integers e.g. company_to_address_1, company_to_address_2, company_to_address_3 etc. But wouldn't it make more sense to actually use the fk name or column name instead of incrementing an integer and munging?
By incrementing an integer and using that for a name, I am forced to delete the relationships that were created for me (and rename them) because I cannot easily refer to them programatically without referring to the relationship itself and figuring out what columns are in the relationship. If the column names or the actual fk name was used then names would be descriptive and could be referred to programatically easily.
"fk_company_to_address_2" makes no sense to me where as
"fk_company_to_address_bill_to" or "fk_company_to_address_ship_to" does.
Thanks.