#8 is https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80... and it’s one upside is that it’s very flexible and it’s downside is literally everything else. If you can be 100% certain that all of the destination value types are the same then it can have compressibility benefits.

▲

sgarland 11 hours ago | parent [-]

I have no idea why you’ve been downvoted, as you accurately described EAV. I’m a DBRE who cares deeply about schema design, FWIW.

	▲	frollogaston 11 hours ago \| parent [-]
		Idk, the comment is right. It is EAV. I've done a little bit of that when needed.