metacrafter
metacrafter copied to clipboard
Add identification of databases primary and foreign table identifiers
Some fields of databases are just incremental unique identifiers generated by the database engine. They can't be linked with any external identifier databases and are used only locally by databases.
There is a need to detect such fields as database-generated integer IDs.
Common names of such IDs are id
or <object name/table name>_id
The way to implement:
- Identify if the table field is a primary key and has an auto_increment feature
- Mark this field as database generated id key