User manual

Customizing Koha Software
Administration
Administrative setting and data are stored in the following tables:
libraries:
Libraries participating in the system
itemtypes:
Item types are used in circulation rules
categories:
Patron categories
issuingrules:
Circulation and fine rules
systempreferences:
Global system preferences
aqbookfund:
Funds, budgets are created under funds
aqbudget:
Budgets under each fund
Serials
Serials data is captured in the following tables:
subscription:
Subscription information such as frequency, numbering
pattern, start and end dates
subscript ionhistory:
Table that tracks missing and received issues
serial:
Table connecting bibliographic records and subscriptions
serialitems:
Items under a serial record
Acquisitions
Acquisitions- related data is captured under these tables:
agbasket:
Contains order baskets
aqbooksellers:
Table containing vendor records
aqorders:
Contains orders within a basket
agorderdeiivery:
Contains records of shipments received
aqorderbreakdown:
Contains information on budget utilization
against each order
Koha's database structure
Here is a useful diagram of the database structure including key tables, their
columns, and relationships between the tables:
http: / /wiki. koha -community. org /wiki /File:Kohastructure.png.
[ 232 ]