| Summary: | Add composite primary keys support for many-to-many relationships | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | Max <msjs08> |
| Component: | Tables | Assignee: | Kexi Bugs <kexi-bugs> |
| Status: | CONFIRMED --- | ||
| Severity: | wishlist | ||
| Priority: | NOR | ||
| Version: | 2.4.0 | ||
| Target Milestone: | --- | ||
| Platform: | Compiled Sources | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | relationship diagram of how I would like to see a composite key | ||
Thanks for the wish. Of course it's important. For SQLite this comment gives some insight that we can do it without hacks: http://www.mail-archive.com/sqlite-users@sqlite.org/msg31637.html The idea for improvement is to create the helper table automatically but allow advanced users to alter it or create is by hand. Relates to Bug #277435 - "Unable to create a primary key of more than one column" |
Created attachment 51256 [details] relationship diagram of how I would like to see a composite key Version: 2.2.1 (KOffice 2.2.1) (using KDE 4.3.5) OS: Linux Kexi needs to have the ability to deal with many to many relationships. In a 13 yr old nameless product on another OS that I believe kexi is trying to emulate, I was able to do this. Reproducible: Didn't try