[Koha-bugs] [Bug 5377] Database fields too small for multiple ISBN and ISSN

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5377

--- Comment #1 from Galen Charlton <gmcharlt at gmail.com> 2010-11-24 19:05:30 UTC ---
A suggestion - rather than widening the field, if bibliographic fields need to
be stored outside of the MARC record for display, performance, or caching
reason, multiple values would be better handled by keeping them in a separate
table, something like:

biblio_attributes:
  biblionumber (foreign key)
  code (identifies the attribute, i.e., 'isbn', 'issn', etc.)
  seqno (sequence number, if needed)
  value

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.