What is the correct id or id_table?

Question

SQL

question in the title.
where are the naming conventions?

Answer 1

There are no naming rules. There are agreements within the team and the project. The simplest principle is the identifier inside the table - id, foreign keys - tableNameId or id_tableName.

Answer 2

off the bat. Google found out that id is an antipattern
stackoverflow.com/questions/208580/naming-of-id-co...
www.amazon.com/s/ref=nb_sb_ss_i_1_5?url=search-ali...

Answer 3

In fact, nowhere. Use names that are easy to understand.
For example, when working with many tables: category, user, product, the names will be more convenient for understanding: cid, uid, pid, respectively.
In short, the master-master.

Answer 4

rsdn.ru/article/db/sqlnames.xml