4 ms·
I think the author was talking about (not) using `id` as the column name, e.g. `user.user_id` instead of `user.id`
by andreareina 10y ago
I think the author was talking about (not) using `id` as the column name, e.g. `user.user_id` instead of `user.id`
- webbore 10y agoON second reading I think you are correct. I agree on this point then, as it helps when joining through a denormalized table that references multiple PK ids, ex: I think: user_id = role_id is more readable than the likely alternative: u.id = r.id
- NickNameNick 10y agoit also lets you use the join foo using(foo_id) syntax, which I quite like