metacrafter icon indicating copy to clipboard operation
metacrafter copied to clipboard

Add identification of databases primary and foreign table identifiers

Open ivbeg opened this issue 1 year ago • 0 comments

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:

  1. Identify if the table field is a primary key and has an auto_increment feature
  2. Mark this field as database generated id key

ivbeg avatar Aug 06 '22 11:08 ivbeg