PK/FK detection "by convention" as a fallback

[mevdschee]

To support PK and FK in MyISAM and views the key "detection" could fall back to "by convention", which requires you to name the PK "id" and the FK as the full table name followed by "_id".

[pottertech]

This works for me, so hope you can add it in at some point. I always have a PK of 'ID' on every table as I believe it to be a good practice when using hybrid data records.

[mevdschee]

Another method would be do define the pk and fk relationships in the config as proposed in #482.

[mevdschee]

Let's say a database has tables 'post' and 'user' and table 'post' has a field 'author_user_id' then we could use '_id' as a signal that it is a FK (always to field 'id') and the word before that should be the table that is referred to 'user', the first part is optional and is the name of the field (defaults to the table name).