Käytössä on Kohan version 17.05 päälle tehty Suomi-versio 17.06.00.001.
Tietokantakuvaukset versiosta 17.05 ovat täällä http://schema.koha-community.org/17_05/.
Tietokantataulut
Alla taulukko, jossa ovat tietokantataulujen nimet ja paikallisten lisätaulujen nimet
| 17.05 version taulut | Paikalliset lisätaulut |
| accountlines | |
| accountoffsets | |
| action_logs | |
| action_logs_cache | |
| additional_field_values | |
| additional_fields | |
| alert | |
| api_keys | |
| aqbasket | |
| aqbasketgroups | |
| aqbasketusers | |
| aqbooksellers | |
| aqbudgetborrowers | |
| aqbudgetperiods | |
| aqbudgets | |
| aqbudgets_planning | |
| aqcontacts | |
| aqcontract | |
| aqinvoices | |
| aqorder_users | |
| aqorders | |
| aqorders_items | |
| aqorders_transfers | |
| article_requests | |
| atomicupdates | |
| audio_alerts | |
| auth_header | |
| auth_subfield_structure | |
| auth_tag_structure | |
| auth_types | |
| authorised_value_categories | |
| authorised_values | |
| authorised_values_branches | |
| batch_overlay_diff | |
| batch_overlay_diff_header | |
| batch_overlay_reports | |
| biblio | |
| biblio_data_elements | |
| biblio_framework | |
| biblio_metadata | |
| biblioimages | |
| biblioitems | |
| borrower_attribute_types | |
| borrower_attribute_types_branches | |
| borrower_attributes | |
| borrower_debarments | |
| borrower_files | |
| borrower_message_preferences | |
| borrower_message_transport_preferences | |
| borrower_modifications | |
| borrower_password_recovery | |
| borrower_permissions | |
| borrower_ss_blocks | |
| borrower_sync | |
| borrowers | |
| branch_borrower_circ_rules | |
| branch_item_rules | |
| branch_transfer_limits | |
| branchcategories | |
| branches | |
| branchrelations | |
| branchtransfers | |
| browser | |
| categories | |
| categories_branches | |
| cities | |
| class_sort_rules | |
| class_sources | |
| club_enrollment_fields | |
| club_enrollments | |
| club_fields | |
| club_template_enrollment_fields | |
| club_template_fields | |
| club_templates | |
| clubs | |
| collections | |
| collections_tracking | |
| columns_settings | |
| course_instructors | |
| course_items | |
| course_reserves | |
| courses | |
| creator_batches | |
| creator_images | |
| creator_layouts | |
| creator_templates | |
| currency | |
| default_borrower_circ_rules | |
| default_branch_circ_rules | |
| default_branch_item_rules | |
| default_circ_rules | |
| deletedbiblio | |
| deletedbiblio_metadata | |
| deletedbiblioitems | |
| deletedborrowers | |
| deleteditems | |
| discharges | |
| edifact_ean | |
| edifact_messages | |
| export_format | |
| fieldmapping | |
| floating_matrix | |
| hold_fill_targets | |
| holdings | |
| holdings_metadata | |
| housebound_profile | |
| housebound_role | |
| housebound_visit | |
| import_auths | |
| import_batches | |
| import_biblios | |
| import_items | |
| import_record_matches | |
| import_records | |
| issues | |
| issuingrules | |
| item_circulation_alert_preferences | |
| items | |
| items_last_borrower | |
| items_search_fields | |
| itemtypes | |
| label_sheets | |
| language_descriptions | |
| language_rfc4646_to_iso639 | |
| language_script_bidi | |
| language_script_mapping | |
| language_subtag_registry | |
| letter | |
| linktracker | |
| localization | |
| marc_matchers | |
| marc_modification_template_actions | |
| marc_modification_templates | |
| marc_subfield_structure | |
| marc_tag_structure | |
| matchchecks | |
| matcher_matchpoints | |
| matchpoint_component_norms | |
| matchpoint_components | |
| matchpoints | |
| message_attributes | |
| message_queue | |
| message_queue_items | |
| message_transport_types | |
| message_transports | |
| messages | |
| misc_files | |
| need_merge_authorities | |
| notifys | |
| oai_sets | |
| oai_sets_biblios | |
| oai_sets_descriptions | |
| oai_sets_mappings | |
| old_issues | |
| old_reserves | |
| opac_news | |
| overdue_calendar_exceptions | |
| overdue_calendar_weekdays | |
| overduebills | |
| overduerules | |
| overduerules_transport_types | |
| patron_list_patrons | |
| patron_lists | |
| patronimage | |
| payments_transactions | |
| payments_transactions_accountlines | |
| pending_offline_operations | |
| permission_modules | |
| permissions | |
| plugin_data | |
| printers | |
| printers_profile | |
| quotes | |
| ratings | |
| refund_lost_item_fee_rules | |
| repeatable_holidays | |
| reports_dictionary | |
| reserves | |
| reviews | |
| saved_reports | |
| saved_sql | |
| search_field | |
| search_history | |
| search_marc_map | |
| search_marc_to_field | |
| serial | |
| serialitems | |
| services_throttle | |
| sessions | |
| sms_providers | |
| social_data | |
| special_holidays | |
| statistics | |
| subscription | |
| subscription_frequencies | |
| subscription_numberpatterns | |
| subscriptionhistory | |
| subscriptionroutinglist | |
| suggestions | |
| systempreferences | |
| tags | |
| tags_all | |
| tags_approval | |
| tags_index | |
| tmp_holdsqueue | |
| transport_cost | |
| uploaded_files | |
| vendor_edi_accounts | |
| vetuma_transaction | |
| vetuma_transaction_accountlines_link | |
| virtualshelfcontents | |
| virtualshelfshares | |
| virtualshelves | |
| z3950servers | |
| zebraqueue | |
Lisätietoja tauluista ja kentistä
Lainaukseen liittyviä tauluja:
issues – sisältää nykyiset voimassaolevat lainat
old_issues – sisältää palautetut lainat
statistics – sisältää lainatapahtumat
Lisäksi lainatapahtumia voi tarkastella action_logs -taulusta, jos Kohan systeemiasetuksissa on lokitukset asetettu päälle
Tietoja lainaukseen liittyvistä kentistä:
items.issues – kenttään päivittyy niteen kokonaislainamäärä ja se on konvertoitunut Voyagerista
items.datelastborrowed – kenttään tallentuu niteen viimeisin lainapäivämäärä ja se on konvertoitunut Voyagerista
accountlines - sisältää asiakkaiden maksut
accountlines.amountoutstanding - sisältää maksurivistä jäljellä olevan maksettavan summan
Varauksen perustaulut:
reserves - sisältää voimassaolevat varaukset
old_reserves - sisältää noudetut tai perutut varaukset