It seems that it would make more sense to have the list of acceptable road types stored in the authorized_values table, rather than have a dedicated table for that purpose alone. I would say I prefer to simplify databases as much as possible. Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org ) 2009/7/9 Jesse <pianohacker@gmail.com>:
2009/7/9 Zeno Tajoli <tajoli@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@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
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel