User manual

Chapter 12
cardnumber
I
varchar(16) I
YES I UNI I
NULL
surname
I
mediumtext I
NO I I
NULL
I
firstname
I text I
YES I
NULL
I
An overview of important Koha tables
Here is a quick overview of some of the important tables in Koha, categorized
by function.
Cataloguing
The following three tables are key Cataloguing related tables:
b ib 1 i o:
Contains bibliographic data such as title or author.
biblioitems:
Also contains bibliographic data; there is one -to -one
correspondence between records in
biblio
and biblioitems
tables.
This table stores the MARC record in the field
marcxml
items: Contains holdings records.
Circulation
Here is a listing of important circulation- related tables:
issues: Contains current checkouts
old issues:
Contains items that have been checked in
reserves: Contains open hold requests
oid_reserves: Contains hold requests that are cancelled or fulfilled
Patrons
Here are two key patrons- related tables:
borrowers: Contains patron records
accountlines:
Contains data on patrons fines and other dues
[ 231 ]