[Koha-bugs] [Bug 35451] New: Add tablename field to additional_field_values

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

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

            Bug ID: 35451
           Summary: Add tablename field to additional_field_values
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: martin.renvoize at ptfs-europe.com
        QA Contact: testopia at bugs.koha-community.org

Currently we rely on a subquery in the additional_field_values relationships
we're adding in various places.

For performance and code clarity it would be sensible to add a tablename field
to the additional_field_values table to denote which table the value is
pertaining to.. we could index this too.

This would allow us to drop the subquery and use an indexed field instead
during joins.

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