Re:SQL style guide
by jbverschoor on Sunday October 09, 2016 @02:34PM
(#12672594)
No 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
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