[Koha-devel] information about Koha tables

[Jesse]

2009/7/9 Zeno Tajoli <tajoli at cilea.it>

> Hi to all,
>
> as you know I and Matteo Romanello we are working on a documentation
> about Mysql tables of Koha.
>
> We have problems and dubts about 3 tables:
>
> account_offsets
> service_throttle
> roadtype
>
> Could you send to the list a brief description of those three tables ?
>
> Thank you very much
> Bye
>
> Zeno Tajoli
>
> Zeno Tajoli
> CILEA - Segrate (MI)
> tajoliAT_SPAM_no_prendiATcilea.it
> (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>

accountoffsets is an old, obsolete table that was used to track payments and
increases in fines in the accountlines table. Parts of Koha still update it,
but its information is not displayed anywhere.

roadtype (modifiable through Administration -> Road Types) is a list of
acceptable road types (like Drive, Court, Street, Place, etc.), to prevent
staff from entering this part of an address incorrectly.

services_throttle is used to keep a daily counter of how much a given
external content service has been used, and is reset through a cronjob. It
is used by the XISBN service, because that service is only free if you use
it less than 500 times a day.

-- 
Jesse Weaver
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20090709/b5bd98fb/attachment-0003.htm>