Why is there a biblio table and a biblioitems table? Is there a one-to-one correspondence between items in the two tables, linked by the biblionumber fields? If this is the case, what is the purpose of the biblioitemnumber field? Steve.
On Tue, 12 Dec 2000, Tonnesen Steve wrote:
Why is there a biblio table and a biblioitems table? Is there a one-to-one correspondence between items in the two tables, linked by the biblionumber fields? If this is the case, what is the purpose of the biblioitemnumber field?
Hi Steve There is a one to many relationship between biblio and biblioitems. One biblio can have many biblioitems, which in turn can have many items. So the way it works, is that a biblio has data like title, author, subject attached to it. A biblioitem has data like ISBN number, Dewey number, Class Then an item has purely item specific data, like last seen, accessiondate, replacement price etc. For example http://hlt.katipo.co.nz/cgi-bin/koha/detail.pl?type=intra&bib=1461&title=David%20Copperfield David Copperfield, This has one biblio, 3 biblioitems, and 4 items. Hope this helps to explain it Chris -- Chris Cormack Katipo Communications Programmer/Sys Admin chris@katipo.co.nz 025 500 789 www.katipo.co.nz
Hi again Chris has already answered, but I'll just add the rationale - which was that biblio describes the intellectual property. So author title, copyright date. Then any copies we have of this piece of copyright, whether a large print edition, or a hardback or paperback is attached to the biblio with the ISBN, publishing info, location in the biblioitem record. If we've got two large print copies, they'll share one Biblioitem record, and each copy will have its own item record.
Why is there a biblio table and a biblioitems table? Is there a one-to-one correspondence between items in the two tables, linked by the biblionumber fields? If this is the case, what is the purpose of the biblioitemnumber field?
Rosalie
participants (3)
-
Chris Cormack -
Rosalie Blake -
Tonnesen Steve