[Koha] Book info in database

[Christoffer Landtman]

I cannot seem to find any table with that name in the koha.mysql file...
Am i just stupid or looking in the wrong file? (version 1.2.2 btw) So
You mean that you support all the umpteen fields and subfields of the
MARC-standard?

well, have to continue investigating...=)

Thanks for the swift reply!

Mike Hansen wrote:
> Hello,
> 
> 	I will do what I can to try to answer your question. I am not sure what
> you mean specifically by book information, but here is, to the best of
> my knowledge, how Koha store the book info. in the database.  There are
> three major tables that hold book information:
> 	biblio:  This table holds the information about "works" such as the
> author, title, and copyright date.
> 	biblioitems: This table holds the information about various
> "manifestations" of works.  These would be things such as an ISBN
> number, year of publication, number of pages, etc.  Each biblioitem
> corresponds to one of the entries in the biblio table.
> 	items: This table contains information about an item (an actual
> physical copy of a biblio/biblioitem).  These are things such as price,
> barcode, branch, date last borrowed, etc.
> 	Now, it is when we get to the MARC stuff that I start getting a little
> uncomfortable (so Paul, if I say anything that is wrong, please correct
> me. Thanks).  In the marc_subfield_structure table are all of the
> subfields for various MARC tags.  There is a column for each of the
> subfields (kohafield) which serves as a link between the rows of biblio,
> biblioitems, and items and the MARC records.  The various functions that
> are deal with this process are found in C4/Biblio.pm.
> 	I hope this helps you out a bit.
> 
> Mike
> 	


-- 
  Christoffer Landtman
lanttis at homeharmony.fi
   www.homeharmony.fi