[umbrello] [Bug 479199] New: Enhancement Request - ERM Composite Keys

[sproggit]

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-devel at kde.org
          Reporter: sad_bunny at 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 the assignee for the bug.