search

mbarre / schemacrawler-additional-lints

Some additionnal lints for Schemacrawler
Other
12 stars 7 forks source link

new lint > default pk name (sys...) #76

Open adriens opened 7 years ago

adriens commented 7 years ago

Check that pk have real names and not system defines names :

instead of sys_c0012237 it should be a custom name that tells more about objects.

it also means that the dev/dba have properly reviewed pk.

adriens commented 7 years ago

http://www.vertabelo.com/blog/technical-articles/naming-conventions-in-database-modeling

adriens commented 7 years ago

http://stackoverflow.com/questions/6695079/what-is-the-naming-convention-for-primary-key-column

adriens commented 7 years ago

I've just discovered that : https://en.wikipedia.org/wiki/ISO/IEC_11179

adriens commented 7 years ago

https://launchbylunch.com/posts/2014/Feb/16/sql-naming-conventions/