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