4 ms·
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
by jbverschoor 10y ago
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