Timeline for How can I improve my table design for different types of an entity?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 3, 2013 at 13:18 | comment | added | ypercubeᵀᴹ | Are there any DBMS that allow this weird FKs to multiple tables? About the one-column limitation you are wrong, MySQL allows multi-column FKs. | |
| Apr 3, 2013 at 13:04 | comment | added | benathon | I misspoke. I probably should have used the term "dynamic foreign key constraint" ie where an Id must exist in one of four tables depending on the value of an enum. (MySql doesn't like this, it limits foreign keys to a single table, and only with one column at a time) Because this type of hypothetical relationship involves two columns instead of one, my brain went to "dual" | |
| Apr 3, 2013 at 6:15 | comment | added | ypercubeᵀᴹ | What is a "dual foreign key constraint"? | |
| Apr 3, 2013 at 2:45 | review | First posts | |||
| Apr 3, 2013 at 6:28 | |||||
| Apr 3, 2013 at 2:30 | history | answered | benathon | CC BY-SA 3.0 |