Schéma de la base de donnée
Comme le code des sites Koha de Collecto contient des développements maisons, la base de données est composée de tables et de champs créés spécifiquement pour les besoins de ces développements. Ainsi, le schéma de la base de données des sites Collecto est légèrement différente que ce qu'on trouve dans le schéma de la communauté internationale. Voici donc la liste des tables provenant du code Collecto.
Valide pour 22.05
Liste des tables
| account_credit_types |
| account_credit_types_branches |
| account_debit_types |
| account_debit_types_branches |
| account_offsets |
| accountlines |
| action_logs |
| additional_contents |
| additional_field_values |
| additional_fields |
| advanced_editor_macros |
| alert |
| api_keys |
| aqbasket |
| aqbasketgroups |
| aqbasketusers |
| aqbooksellers |
| aqbudgetborrowers |
| aqbudgetperiods |
| aqbudgets |
| aqbudgets_planning |
| aqcontacts |
| aqcontract |
| aqinvoice_adjustments |
| aqinvoices |
| aqorder_users |
| aqorders |
| aqorders_claims |
| aqorders_items |
| aqorders_transfers |
| article_requests |
| audio_alerts |
| auth_header |
| auth_subfield_structure |
| auth_tag_structure |
| auth_types |
| authorised_value_categories |
| authorised_values |
| authorised_values_branches |
| background_jobs |
| biblio |
| biblio_framework |
| biblio_metadata |
| 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_relationships |
| borrowers |
| branch_transfer_limits |
| branches |
| branches_overdrive |
| branchtransfers |
| browser |
| business_hours |
| cash_register_actions |
| cash_registers |
| categories |
| categories_branches |
| circulation_rules |
| cities |
| class_sort_rules |
| class_sources |
| class_split_rules |
| club_enrollment_fields |
| club_enrollments |
| club_fields |
| club_holds |
| club_holds_to_patron_holds |
| club_template_enrollment_fields |
| club_template_fields |
| club_templates |
| clubs |
| collections |
| collections_tracking |
| columns_settings |
| course_instructors |
| course_items |
| course_reserves |
| courses |
| cover_images |
| creator_batches |
| creator_images |
| creator_layouts |
| creator_templates |
| currency |
| deletedbiblio |
| deletedbiblio_metadata |
| deletedbiblioitems |
| deletedborrowers |
| deleteditems |
| desks |
| discharges |
| edifact_ean |
| edifact_messages |
| export_format |
| hold_fill_targets |
| housebound_profile |
| housebound_role |
| housebound_visit |
| illcomments |
| illrequestattributes |
| illrequests |
| import_auths |
| import_batch_profiles |
| import_batches |
| import_biblios |
| import_items |
| import_record_matches |
| import_records |
| issues |
| item_circulation_alert_preferences |
| items |
| items_last_borrower |
| items_search_fields |
| itemtypes |
| itemtypes_branches |
| keyboard_shortcuts |
| kx_cached_linker_queries |
| kx_library_hours |
| kx_linked_authorities |
| kx_tmp_barcodes |
| kx_tmp_booksellers |
| kx_tmp_borrowers |
| kx_tmp_budgets |
| kx_tmp_cardnumbers |
| kx_tmp_elags |
| language_descriptions |
| language_rfc4646_to_iso639 |
| language_script_bidi |
| language_script_mapping |
| language_subtag_registry |
| lbo_ping |
| letter |
| library_groups |
| library_smtp_servers |
| linktracker |
| localization |
| marc_matchers |
| marc_modification_template_actions |
| marc_modification_templates |
| marc_overlay_rules |
| marc_subfield_structure |
| marc_tag_structure |
| matchchecks |
| matcher_matchpoints |
| matchpoint_component_norms |
| matchpoint_components |
| matchpoints |
| message_attributes |
| message_queue |
| message_transport_types |
| message_transports |
| messages |
| misc_files |
| need_merge_authorities |
| oai_sets |
| oai_sets_biblios |
| oai_sets_descriptions |
| oai_sets_mappings |
| oauth_access_tokens |
| old_issues |
| old_reserves |
| overduerules |
| overduerules_transport_types |
| patron_consent |
| patron_list_patrons |
| patron_lists |
| patronimage |
| pending_offline_operations |
| permissions |
| plugin_data |
| plugin_methods |
| pretnumerique_reserves |
| printers_profile |
| problem_reports |
| pseudonymized_borrower_attributes |
| pseudonymized_transactions |
| quotes |
| ratings |
| recalls |
| repeatable_holidays |
| reports_dictionary |
| reserves |
| reserves_recurring |
| return_claims |
| reviews |
| saved_reports |
| saved_sql |
| search_field |
| search_history |
| search_marc_map |
| search_marc_to_field |
| serial |
| serialitems |
| sessions |
| set_aside_recurrence |
| set_aside_recurrence_exceptions |
| set_asides |
| sms_providers |
| smtp_servers |
| social_data |
| special_holidays |
| statistics |
| stockrotationitems |
| stockrotationrotas |
| stockrotationstages |
| subscription |
| subscription_frequencies |
| subscription_numberpatterns |
| subscriptionhistory |
| subscriptionroutinglist |
| suggestions |
| systempreferences |
| tables_settings |
| tags |
| tags_all |
| tags_approval |
| tags_index |
| tmp_holdsqueue |
| transport_cost |
| uploaded_files |
| user_permissions |
| userflags |
| vendor_edi_accounts |
| virtualshelfcontents |
| virtualshelfshares |
| virtualshelves |
| z3950servers |
| zebraqueue |
Tables propres à Koha Collecto
business_hours
kx_cached_linker_queries
kx_library_hours
kx_linked_authorities
kx_tmp_barcodes
kx_tmp_booksellers
kx_tmp_borrowers
kx_tmp_budgets
kx_tmp_cardnumbers
kx_tmp_elags
lbo_ping
pretnumerique_reserves
reserves_recurring
set_aside_recurrence
set_aside_recurrence_exceptions
set_asides