[Koha-bugs] [Bug 16170] New: Pseudo foreign key in Items

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16170

            Bug ID: 16170
           Summary: Pseudo foreign key in Items
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: gmcharlt at gmail.com
          Reporter: m.de.rooy at rijksmuseum.nl
        QA Contact: testopia at bugs.koha-community.org

While many of us would like to get rid of biblioitems, the current scheme
includes a biblioitemnumber and a biblionumber in Items. (Which is not so
great..)
But also note that biblionumber is NOT defined as a foreign key in Items,
although a belongs_to relation has been added to the DBIx scheme! This
inconsistency should be resolved.
The "remove biblioitem table" operation is a large one, but in the meantime we
better make biblionumber a regular FK not a pseudo one.

-- 
You are receiving this mail because:
You are watching all bug changes.