4 ms·
I disagree with this style point, and I think the author implicitly acknowledges that `id` should be the standard identifier, because further down he points out
by jawns 10y ago
I disagree with this style point, and I think the author implicitly acknowledges that `id` should be the standard identifier, because further down he points out that the `_id` suffix should be used for columns that make reference to that identifier.
- jbverschoor 10y agoNo he doesn't. In an example he actually uses the following: ON s2.mentor_id = s1.staff_num staff_num is the primary key To me this isan anti pattern because: - a primary should (can) never change; - composite primary keys are only useful (save space) in very large datasets It also conflicts with his pattern: uniform suffix _id