Bug 249966 - Add composite primary keys support for many-to-many relationships
Summary: Add composite primary keys support for many-to-many relationships
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 2.4.0
Platform: Compiled Sources Linux
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-09-03 06:16 UTC by Max
Modified: 2014-12-03 01:49 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
relationship diagram of how I would like to see a composite key (16.34 KB, image/jpeg)
2010-09-03 06:16 UTC, Max 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Max 2010-09-03 06:16:44 UTC 
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
Comment 1 Jarosław Staniek 2010-09-03 21:42:21 UTC 
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
Comment 2 Jarosław Staniek 2010-09-03 21:52:22 UTC 
The idea for improvement is to create the helper table automatically but allow advanced users to alter it or create is by hand.
Comment 3 Jarosław Staniek 2012-02-23 23:04:04 UTC 
Relates to Bug #277435 - "Unable to create a primary key of more than one column"