| It’s come to my attention that what seems an obvious and useful database design pattern — 1:1 relations between tables by having a shared primary key — is hardly discussed or used. It would seem to be a very simple pattern, and useful to avoid storing nulls or for groups of fields that tend to be used together. Thoughts? Is there some downside I can’t see? |
