The benefits of having an _id" suffix in names of foreign keys

General Tech Learning Aids/Tools 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Learning Aids/Tools related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

It seems like the "_id" suffix is quite common in names of foreign keys. I wonder about the reasons behind this.

What are the benefits of posts(id, user_id, title, text) over the simpler posts(id, user, title, text)?

profilepic.png
manpreet 2 years ago

This is very much opinion based, but I'd say it more accurately describes the contents of the column. 1902010 is not a user, it's a user ID. Calling it user would be as wrong as calling your titlecolumn title_id.


0 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.