¶ 8.1 MEMORY AID: THE MAIN KOHA TABLES
The complete Koha schema for each version are available on the Koha community website: https://schema.kohacommunity.org/
- ‘borrowers’ → Patrons
- ‘issues’ → current loans
- ‘old_issues’ and ‘statistics’ → history of loans
- ‘reserves’ → reservations
- ‘old_reserves’ → reservations history
Authorities:
- ‘auth_header’ → authorities
- column: ‘authtypecode’ [CO, NP, SNC, etc.] ; see details of the settings on Koha Administration > Authority types
Bibliographic records:
warning! Bibliographic data are divided in 3 different tables
- ‘biblio’ → MARC fields selection → ; see details of the settings on Koha Administration > Koha links => MARC
- ‘biblioitems’ → selection of MARC fields ; see details of the settings on Koha Administration > Koha links => MARC
- ‘biblio_metadata’ → all MARC fields stored in MARCXML (‘ → metadata’ column corresponds to the bibliographic record)
- ‘deletedbiblio’ → list of deleted records
- ‘deletedbiblioitems’ → list of deleted records
- ‘deletedbiblio_metadata’ → list of deleted records
Items:
- ‘items’ → list of items, see details of the settings on Koha Administration > Koha links=> MARC
- ‘deleteditems’ → list of deleted items
- ‘subscription’ → list of subscription
- ‘serial’ → list of issues
- ‘serialitems’ → list of items when receiving an issue create an item
- ‘branches’ → sites (for the branches name)
- ‘itemtypes’ → loan types (for the name of the loan type)
- ‘categories’ → member categories (for the name of the member category)
- ‘authorised_values’ → authorised values lists (for the name of the locations, traps, collections, etc.)