Introduction to the Koha Community
Hello everyone, I am Raghav Arora, a 3rd year undergrad student from India. I am currently working on a project on Reports Management and Decision Support System for my institute library that uses Koha as it's ILS. While working on the project, I am having certain doubts on the relationships between various tables in the koha database schema, and the purpose of some of the fields. I am joining the koha-devel mailing list as well, to understand the technical details of the database. Of the many doubts that I have, I do not understand the difference between the tables reserves and old_reserves. If I need to get a list of all the holds, for which the books are currently not available in the library, which table would I refer to? Regards *Raghav Arora* 3rd year, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 8474975691 Personal Email <raghavarora999@yahoo.in> | University Email <f20171016@pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031 India.
Of the many doubts that I have, I do not understand the difference between the tables reserves and old_reserves.
The 'reserves' table contains "active" holds. Holds which have not yet been fulfilled or canceled. When a hold has been fulfilled it is moved to the 'old_reserves' table for historical/reporting purposes. You would refer to 'old_reserves' if you were seeking statistics about holds processed in the past.
If I need to get a list of all the holds, for which the books are currently not available in the library, which table would I refer to?
Since you say "currently," that means the 'reserves' table. Note that a similar relationship exists between 'issues' and 'old_issues.' Similarly, 'borrowers' and 'deletedborrowers,' 'biblio' and 'deletedbiblio.' http://schema.koha-community.org/ -- Owen -- Web Developer Athens County Public Libraries https://www.myacpl.org
participants (2)
-
Owen Leonard -
RAGHAV ARORA