[Koha] biblio vs. biblioitems

Chris Cormack chris at katipo.co.nz
Wed Dec 13 10:47:13 NZDT 2000


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 at katipo.co.nz
025 500 789                                    www.katipo.co.nz





More information about the Koha mailing list