> For the complete documentation index, see [llms.txt](https://docs.ilsas.uniwa.gr/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ilsas.uniwa.gr/urungi/english/urungi-user-manual/8.-annexes.md).

# 8. Annexes

### 8.1 Memory Aid: The main Koha tables <a href="#h-81-memory-aid-the-main-koha-tables" id="h-81-memory-aid-the-main-koha-tables"></a>

The complete Koha schema for each version are available on the Koha community website: <https://schema.kohacommunity.org/>

#### 8.1.1 Patrons/Circulation <a href="#h-811-patronscirculation" id="h-811-patronscirculation"></a>

* ‘borrowers’ → Patrons
* ‘issues’ → current loans
* ‘old\_issues’ and ‘statistics’ → history of loans
* ‘reserves’ → reservations
* ‘old\_reserves’ → reservations history

#### 8.1.2 Catalog <a href="#h-812-catalog" id="h-812-catalog"></a>

***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

#### 8.1.3 Serials <a href="#h-813-serials" id="h-813-serials"></a>

* ‘subscription’ → list of subscription
* ‘serial’ → list of issues
* ‘serialitems’ → list of items when receiving an issue create an item

#### 8.1.4 Code labels <a href="#h-814-code-labels" id="h-814-code-labels"></a>

* ‘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.)

### 8.2 Classes for Themes <a href="#h-82-classes-for-themes" id="h-82-classes-for-themes"></a>

<figure><img src="/files/pB4hztmkx5dndmtJUzIA" alt="" width="563"><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ilsas.uniwa.gr/urungi/english/urungi-user-manual/8.-annexes.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.