https://bugs.kde.org/show_bug.cgi?id=479199
Bug ID: 479199
Summary: Enhancement Request - ERM Composite Keys
Classification: Applications
Product: umbrello
Version: 2.30.3 (KDE releases 19.12.3)
Platform: Mint (Debian based)
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: general
Assignee: umbrello-de...@kde.org
Reporter: sad_bu...@hotmail.com
Target Milestone: ---
SUMMARY
***
Apologies - I looked for a route to submit an enhancement request but didn't
see one: using this as the next best thing...
Umbrello does not presently have a mechanism to express the existence of
composite keys, for example when creating a logical association between two
data elements via a link table... The link table would hold fields for the
foreign keys of each of the two tables being linked... along with a unique,
auto-incrementing primary key. To prevent a scenario in which additional
connections are made between the same pair of referenced records, a composite
key can be created in the link table by combining both of the foreign keys.
It is currently possible to set a Foreign Key entity constraint to a data
element, but it is not possible to combine two columns in to a composite key.
***
STEPS TO REPRODUCE
1. Create 3 tables
2. In the 3rd table, create Foreign Key fields linking to the Primary Keys of
the 1st and 2nd Tables, respectively
3. Try and fail to annotate that the two Foreign Keys in the 3rd [link] table
should be treated as a unique [composite] key, to allow the database to prevent
creation of duplicate links.
OBSERVED RESULT
EXPECTED RESULT
It is not possible to express composite keys in Umbrello
SOFTWARE/OS VERSIONS
Windows:
macOS:
Linux/KDE Plasma:
(available in About System)
KDE Plasma Version:
KDE Frameworks Version:
Qt Version:
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
