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 @)
I was going to respond to Nicole's email regarding Tutorials (of which I'm interested) about the very subject of the Koha tables. First off, thank you for undertaking this project. Coming in fresh to the Koha realm about six months ago, one of the most frustrating things is to find what table to use and then trying to figure out what the fields in each table actually do. Unfortunately, I haven't had to touch the three tables that you listed below so I can't be of much help there. Regardless, thanks for your effort and I look forward to the results. David Birmingham Software Engineer P | T | F | S 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 301-654-8088, Ext 149 301-654-5789 (fax) dbirmingham@ptfs.com www.ptfs.com -----Original Message----- From: koha-devel-bounces@lists.koha.org [mailto:koha-devel-bounces@lists.koha.org] On Behalf Of Zeno Tajoli Sent: Thursday, July 09, 2009 11:49 AM To: koha-devel@lists.koha.org Subject: [Koha-devel] information about Koha tables 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
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
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
Kyle Hall (2009/07/09 13:47 -0400):
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.
Aren't the authoriez values kond of MARC related ? I mean, perhaps the categories defined in this table are only those which can appear in a MARC field, and since the road type has to do with users it is not bound to MRC fields and so it is legitimate to keep it outside of the table ? Just asking out of curiosity. Sébastien.
Hi, On Thu, Jul 9, 2009 at 1:13 PM, Sébastien Hinderer<Sebastien.Hinderer@snv.jussieu.fr> wrote:
Aren't the authoriez values kond of MARC related ? I mean, perhaps the categories defined in this table are only those which can appear in a MARC field, and since the road type has to do with users it is not bound to MRC fields and so it is legitimate to keep it outside of the table ?
Many authorized values are indeed related to MARC fields, but not all of them. The authorised_values table has evolved into a general mechanism for storing lists of values used in various contexts. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt
Galen Charlton (2009/07/09 14:58 -0500):
Many authorized values are indeed related to MARC fields, but not all of them. The authorised_values table has evolved into a general mechanism for storing lists of values used in various contexts.
OK. In that case the idea of merging the roadtypes table with the authorized_values table looks like a good one to me. Best wishes, Sébastien.
Hi, On Thu, Jul 9, 2009 at 12:47 PM, Kyle Hall<kyle.m.hall@gmail.com> wrote:
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.
I agree that moving the road type values to an authorized value list would be a (small) improvement. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt
participants (6)
-
Birmingham, David -
Galen Charlton -
Jesse -
Kyle Hall -
Sébastien Hinderer -
Zeno Tajoli