Timeline for What is the correct name and significance of EAV table pivot?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 19, 2014 at 15:52 | comment | added | Vérace | Joe Celko here says that anyone coming across this design should "Find the moron that did this to you and kill him". No room for ambiguity there! His favoured synonym for EAV is MUCK (massively unified code key) for obvious reasons! Change it if you can. | |
| Feb 19, 2014 at 13:30 | comment | added | ypercubeᵀᴹ | EAV looks like heaven when one has to deal with this design :) | |
| Feb 19, 2014 at 12:21 | history | edited | Worse_Username | CC BY-SA 3.0 |
added 529 characters in body
|
| Feb 19, 2014 at 12:02 | answer | added | David Spillett | timeline score: 1 | |
| Feb 19, 2014 at 11:55 | comment | added | Colin 't Hart | See slides 14 & 15 on avoiding "numbers" in column names, while the coverage on EAV starts at slide 16. | |
| Feb 19, 2014 at 11:53 | comment | added | Colin 't Hart | Both of these structure are very bad anti-patterns, see slideshare.net/billkarwin/sql-antipatterns-strike-back where both the EAV and numbered columns anti-patterns are listed. | |
| Feb 19, 2014 at 11:53 | comment | added | Worse_Username | I am trying to find ways to make working with the table data and performing queries more comfortable. | |
| Feb 19, 2014 at 11:49 | review | First posts | |||
| Feb 19, 2014 at 16:01 | |||||
| Feb 19, 2014 at 11:47 | comment | added | Colin 't Hart | What are you trying to do? | |
| Feb 19, 2014 at 11:33 | history | asked | Worse_Username | CC BY-SA 3.0 |