I think that...Biblionumber is given only for records, so biblioitems holds all the entries of the records. One record can be of one itemtype, so books, cd/dvd, reference all are entered in the biblioitems.

But the items table holds the list of items in a record. That's why unless you add an item in the record, it doesnot show in the items table. Moreover, items can be itemtypes other than the parent record.

I think this is what you wanted to know. And this is what I think it is.

Thank you.

On Mon, Mar 22, 2010 at 5:18 AM, MusabG <musab@live.com> wrote:

hello,

I'm trying to understand the purpose of the following tables and how they
communicate :

1. Biblio
2. BiblioItems
3. Items

It's confusing, because first I though BiblioItems table is for books only,
but when i added a CD/DVD item it was entered in the BiblioItems.

but not added to the items table until I add another Item within this
CD/DVD..

Can anyone clarify how they work together

Regards,
musab
--
View this message in context: http://old.nabble.com/Biblio%2C-BiblioItems-and-Items-tp27985565p27985565.html
Sent from the Koha - Dev mailing list archive at Nabble.com.

_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel



-- 
Nitesh Rijal
BE IT
rijal.it@gmail.com
http://niteshrijal.com.np
http://facebook.com/openrijal
http://twitter.com/openrijal
+9779841458173