https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40808
--- Comment #1 from Martin Renvoize (ashimema) <[email protected]> --- Created attachment 186436 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=186436&action=edit Bug 40808: Add accountline_links table for polymorphic hold-fee linking This patch introduces a new polymorphic linking system to replace the growing number of nullable foreign key fields in the accountlines table. Database changes: - New accountline_links table with optimized indexes - Supports linking account lines to holds, checkouts, article requests, etc. - Uses clean link_type naming (hold, checkout, article_request) - Migrates existing issue_id and old_issue_id links during upgrade - Includes database triggers for referential integrity Benefits: - Eliminates nullable FK field bloat in accountlines - Infinitely extensible for new entity types - Enables one-to-many relationships (one fee can link to multiple entities) - Better performance with covering indexes -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
