[Koha] biblio vs. biblioitems
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?
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.
This has one biblio, 3 biblioitems, and 4 items.
Hope this helps to explain it
Chris Cormack Katipo Communications
Programmer/Sys Admin chris at katipo.co.nz
025 500 789 www.katipo.co.nz
More information about the Koha