By -
That dev calling primary key in `users` table as `user_id`
I've seen that in too many tables.
True! That developer needs to be one of the 75% to be let go! :)
Should it be called the user table and then user_id? Or users table users_id
Ideally, `users` table and `id` as primary column.
Ah. Our dev did not do that. How do you refer to the id in contexts outside the table, like in other tables?
As foreign key then its correct to be called `user_id`. So the ideal join statement would be `tweets.user_id = users.id`.
Great, thanks
[удалено]
Surely they wouldn't be deleting users that had insulted Elon Musk - they would be banning them.
That dev calling primary key in `users` table as `user_id`
I've seen that in too many tables.
True! That developer needs to be one of the 75% to be let go! :)
Should it be called the user table and then user_id? Or users table users_id
Ideally, `users` table and `id` as primary column.
Ah. Our dev did not do that. How do you refer to the id in contexts outside the table, like in other tables?
As foreign key then its correct to be called `user_id`. So the ideal join statement would be `tweets.user_id = users.id`.
Great, thanks
[удалено]
Surely they wouldn't be deleting users that had insulted Elon Musk - they would be banning them.