News for hackers. Stuff that matters.
Re:Best Practices for Data Modeling by kbd on Tuesday October 29, 2019 @12:12PM (#21388780)
> All id's are named ID or id.

From someone who's done a lot of data modeling, imo this is not good advice. I recommend naming your IDs "{table}_id". Then it's extremely clear what it refers to when it's used as a foreign key, and you can join naturally using SQL's 'using' statement as it's intended to be used.

There are no comments on this comment yet.