undefined | Better HN

0 pointszo17y ago0 comments

I think he's referring to using "[Table]ID" as the primary key on [Table]?

So now you have to join with the Person table on Person.PersonID from your local column PersonID. I much prefer the other way around: Table.ID with foreign keys being "TableID".

0 comments

slobotron7y ago

I find "[Table]ID" to be bit more readable in joins. I.e.

    SELECT * FROM table1 INNER JOIN table2 USING (table1_id);

    SELECT * FROM table1 INNER JOIN table2 ON (table2.table1_id = table1.id);

j / k navigate · click thread line to collapse