PythonQ 248-8XX Bedienungsanleitung PDF herunterladen (Seite 246)

Chapter 12

cardnumber

varchar(16) I

YES I UNI I

NULL

surname

mediumtext I

NO I I

NULL

firstname

I text I

YES I

NULL

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 ]

1 2 ... 241 242 243 244 245 246 247 248 249 250 251 ... 298 299

Keine Kommentare

PythonQ 248-8XX Bedienungsanleitung Seite 246