Timeline for What's the best way to handle a "union" in a relational database?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 16, 2017 at 3:22 | comment | added | gardenhead | Hm actually, it sounds like you're talking about a many-to-one relationship from A to X. I want the other way: one-to-many. | |
| Jul 15, 2017 at 19:18 | comment | added | gardenhead | ah, that is interesting, I've never considered that approach. All the foreign keys I've used have always been to primary key, unique columns. | |
| Jul 15, 2017 at 13:30 | comment | added | John Wu | No problem. The solution will still work, but you can't use xid as the primary key on A, B, C, or D is all. | |
| Jul 15, 2017 at 1:42 | comment | added | gardenhead | I want a one-to-many relationship from A to X, not one-to-one. | |
| Jul 14, 2017 at 20:34 | history | answered | John Wu | CC BY-SA 3.0 |