Unpopular opinion… I think? I hate that most folks use id
for the primary key in a table. Every foreign key reference will be ${table_name}_id
and the amount of extra little thinking to write out joins drives me nuts. Just always use ${table_name}_id
.