News for hackers. Stuff that matters.

A comment on Old, Good Database Design. Parent comment

Re:Old, Good Database Design by ludston on Monday September 14, 2020 @11:45PM (#24477688)
I'm interested in understanding what you mean. What is "OR" shaped data? Are you thinking of data like, "The staff member must have either a salary or an hourly rate"?

Typically I would see this modelled with two db columns, with a DB constraint indicating that only one of these can have a value.

[ Parent | on HN ]
Re:Old, Good Database Design by throwaway894345 on Tuesday September 15, 2020 @02:17AM (#24478362)
That’s generally what I’m talking about, and it works well enough for simple cases, but these sorts of solutions tend not to scale well and you give up type safety. Not the end of the world, just disappointing.
[ Parent | on HN ]