Tables


SchemaSpy Analysis of koha_main.koha_main

Generated on Tue Nov 03 09:06 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 303
VIEWS 0
COLUMNS 2765
Constraints 426
Anomalies 52
Routines 0

Database Properties

Database Type: MySQL - 10.11.19-MariaDB-ubu2204

Tables

Table / View Children Parents Columns Rows Type Comments
marc_matchers 4 0 5 0 Table
borrower_files 0 2 7 0 Table
subscription_frequencies 1 0 6 0 Table
marc_overlay_rules 0 0 8 0 Table
erm_default_usage_reports 0 0 3 0 Table
linktracker 0 3 6 0 Table
marc_subfield_structure 0 1 20 0 Table
creator_batches 0 3 8 0 Table
old_reserves 0 7 27 0 Table
import_records 4 1 14 0 Table
erm_licenses 3 2 8 0 Table
search_field 1 1 10 0 Table
oai_sets_descriptions 0 1 2 0 Table
items_search_fields 17 1 5 0 Table
borrower_debarments 1 2 8 0 Table
erm_usage_data_providers 8 0 16 0 Table
erm_usage_yus 0 5 12 0 Table
erm_agreement_periods 0 1 6 0 Table
categories 11 0 32 0 Table
club_template_fields 1 1 5 0 Table
recalls 1 4 15 0 Table

Information related to recalls in Koha
discharges 0 1 4 0 Table
club_enrollment_fields 0 2 4 0 Table
hold_groups_target_holds 0 2 2 0 Table
additional_field_values 0 1 5 0 Table
matcher_matchpoints 0 2 2 0 Table
biblio_framework 0 0 3 0 Table
ticket_updates 0 3 8 0 Table
sip_system_preference_overrides 0 0 3 0 Table
vendor_edi_accounts 1 3 16 0 Table
message_attributes 2 0 3 0 Table
saved_reports 0 0 4 0 Table
oai_sets 3 0 3 0 Table
search_filters 0 1 6 0 Table
need_merge_authorities 0 0 6 0 Table
tags 0 0 2 0 Table
branchtransfers 1 3 11 0 Table
class_sources 4 2 5 0 Table
curbside_pickup_opening_slots 0 1 7 0 Table
advanced_editor_macros 0 1 5 0 Table
preservation_processings 3 0 3 0 Table
aqbookseller_issues 0 1 6 0 Table
restriction_types 1 0 6 0 Table
aqorder_users 0 2 2 0 Table
oai_sets_biblios 0 1 2 0 Table
club_holds 1 3 5 0 Table
aqbudgets_planning 0 1 7 0 Table
erm_counter_files 1 1 6 0 Table
social_data 1 0 7 0 Table
language_subtag_registry 0 0 5 0 Table
zebraqueue 0 0 6 0 Table
creator_layouts 0 0 18 0 Table
language_descriptions 0 0 5 0 Table
messages 0 2 8 0 Table
erm_eholdings_packages 2 2 9 0 Table
borrower_relationships 0 2 4 0 Table
erm_usage_databases 2 1 6 0 Table
pseudonymized_transactions 1 2 24 0 Table
background_jobs 0 0 12 0 Table
account_offsets 0 2 6 0 Table
aqinvoice_adjustments 0 2 8 0 Table
action_logs 0 0 11 0 Table
serial 1 2 15 0 Table
file_transports 1 0 15 0 Table
housebound_profile 1 1 8 0 Table
aqcontract 1 1 6 0 Table
statistics 0 2 13 0 Table
tags_all 0 3 6 0 Table
tables_settings 0 0 7 0 Table
biblio_framework_marc_matcher 0 1 3 0 Table
subscriptionhistory 0 2 8 0 Table
cash_register_actions 0 2 6 0 Table
illcomments 0 2 5 0 Table
sip_account_custom_patron_fields 0 1 4 0 Table
library_closure_exceptions 0 1 5 0 Table
printers_profile 0 0 10 0 Table
search_history 0 0 8 0 Table

Opac search history results
old_issues 2 4 20 0 Table
quotes 0 0 4 0 Table
language_script_bidi 0 0 2 0 Table
courses 2 1 11 0 Table
illrequestattributes 0 1 5 0 Table
borrower_message_transport_preferences 0 2 2 0 Table
deleteditems 0 1 48 0 Table
erm_eholdings_packages_agreements 0 2 2 0 Table
identity_provider_domains 0 3 10 0 Table
itemtypes 13 1 21 0 Table
library_smtp_servers 0 2 3 0 Table
library_hours 0 1 4 0 Table
import_batch_profiles 1 0 12 0 Table
saved_sql 1 1 15 0 Table
borrower_password_recovery 0 0 3 0 Table
alert 0 1 4 0 Table
club_templates 3 1 9 0 Table
account_credit_types_branches 0 2 2 0 Table
creator_templates 0 0 18 0 Table
search_marc_map 1 0 4 0 Table
erm_usage_items 2 1 5 0 Table
item_bundles 0 2 2 0 Table
reports_branches 0 2 2 0 Table
additional_fields 1 1 8 0 Table
deletedborrowers 0 1 84 0 Table
import_auths 0 1 5 0 Table
aqbudgets 8 1 15 0 Table
sip_account_custom_item_fields 0 1 4 0 Table
item_editor_templates 0 1 5 0 Table
erm_agreement_relationships 0 2 4 0 Table
erm_agreement_licenses 0 2 7 0 Table
sip_accounts 7 2 40 0 Table
preservation_processing_attributes 1 1 5 0 Table
language_script_mapping 0 0 2 0 Table
library_groups 1 2 14 0 Table
matchpoint_component_norms 0 1 3 0 Table
preservation_processing_attributes_items 0 2 4 0 Table
virtualshelfshares 0 2 5 0 Table
aqbasket 3 4 16 0 Table
import_oai_biblios 0 1 7 0 Table
authorised_values_branches 0 2 2 0 Table
patronimage 0 1 3 0 Table
authorised_value_categories 3 0 3 0 Table
borrower_attribute_types 4 1 16 0 Table
matchchecks 0 3 4 0 Table
tags_approval 2 1 5 0 Table
pending_offline_operations 0 0 8 0 Table
itemtypes_branches 0 2 2 0 Table
misc_files 0 1 8 0 Table
auth_tag_structure 0 1 7 0 Table
plugin_data 0 0 3 0 Table
patron_consent 0 1 5 0 Table
illbatches 1 3 6 0 Table
browser 0 0 5 0 Table
aqbasketusers 0 2 2 0 Table
aqbasketgroups 1 1 8 0 Table
illrequests 2 5 22 0 Table
item_circulation_alert_preferences 0 1 5 0 Table
identity_providers 1 0 8 0 Table
class_sort_rules 1 0 3 0 Table
oauth_access_tokens 0 1 3 0 Table
aqbookseller_aliases 0 1 3 0 Table
course_items 1 5 20 0 Table
library_single_closures 0 1 5 0 Table
erm_documents 0 3 11 0 Table
library_repeating_closures 0 1 6 0 Table
tmp_holdsqueue 0 4 22 0 Table
columns_settings 0 0 6 0 Table
account_credit_types 2 0 6 0 Table
user_permissions 0 3 3 0 Table
sip_institutions 1 0 10 0 Table
housebound_visit 0 3 6 0 Table
biblio_metadata 1 2 7 0 Table
club_holds_to_patron_holds 0 3 6 0 Table
edifact_errors 0 1 6 0 Table
tags_index 0 2 3 0 Table
subscriptionroutinglist 0 2 4 0 Table
deletedauth_header 0 1 9 0 Table
branches_overdrive 0 1 2 0 Table
currency 5 0 9 0 Table
collections_tracking 0 1 3 0 Table
erm_eholdings_resources 0 3 7 0 Table
reports_dictionary 0 1 7 0 Table
patron_lists 1 2 4 0 Table
course_instructors 0 2 2 0 Table
import_items 0 1 7 0 Table
branches 54 0 25 0 Table
aqbudgetperiods 1 0 9 0 Table
reserves 4 8 27 0 Table
sessions 0 0 2 0 Table
deletedbiblioitems 0 2 32 0 Table
smtp_servers 1 0 10 0 Table
library_float_limits 0 2 3 0 Table
borrower_attributes 0 2 4 0 Table
desks 2 1 3 0 Table
categories_branches 0 2 2 0 Table
hold_groups 3 1 2 0 Table
bookings 2 4 11 0 Table
uploaded_files 0 0 10 0 Table
deletedbiblio_metadata 0 2 7 0 Table
curbside_pickups 1 3 10 0 Table
club_fields 0 2 4 0 Table
api_keys 1 1 5 0 Table
import_biblios 0 1 9 0 Table
authorised_values 1 1 6 0 Table
erm_usage_platforms 2 1 3 0 Table
localization 0 1 6 0 Table
virtualshelves 2 1 11 0 Table
import_record_matches 0 1 5 0 Table
oai_sets_mappings 0 1 7 0 Table
marc_tag_structure 0 0 10 0 Table
systempreferences 0 0 5 0 Table
marc_order_accounts 0 2 15 0 Table
aqorders_items 0 1 3 0 Table
accountlines 3 9 20 0 Table
article_requests 0 5 22 0 Table
tickets 1 4 11 0 Table
matchpoint_components 1 1 7 0 Table
auth_subfield_structure 0 1 18 0 Table
sms_providers 1 1 3 0 Table
ratings 0 2 4 0 Table
cash_registers 3 1 7 0 Table
erm_usage_mus 0 5 13 0 Table
item_groups 3 1 6 0 Table
plugin_methods 0 0 2 0 Table
hold_cancellation_requests 0 0 3 0 Table
message_queue 0 4 17 0 Table
return_claims 1 5 12 0 Table
iso18626_requesting_agencies 1 1 7 0 Table
stockrotationitems 0 2 4 0 Table
serialitems 0 2 2 0 Table
import_oai_authorities 0 1 7 0 Table
edifact_messages 2 3 10 0 Table
biblioitems 1 3 32 0 Table
class_split_rules 1 0 4 0 Table
item_group_items 0 2 3 0 Table
record_sources 2 0 4 0 Table
stockrotationrotas 1 0 5 0 Table
library_weekly_closures 0 1 5 0 Table
erm_eholdings_titles 1 2 27 0 Table
export_format 0 0 11 0 Table

Used for CSV export
sip_account_screen_msg_regexs 0 1 4 0 Table
matchpoints 4 1 4 0 Table
branch_transfer_limits 0 1 5 0 Table
erm_user_roles 0 3 5 0 Table
checkout_renewals 0 1 7 0 Table
z3950servers_branches 0 2 2 0 Table
aqorders 5 8 53 0 Table
patron_list_patrons 0 2 3 0 Table
club_template_enrollment_fields 1 1 5 0 Table
subscription 4 5 46 0 Table
patron_account_links 0 1 4 0 Table
problem_reports 0 2 10 0 Table
erm_usage_titles 2 1 12 0 Table
aqorders_transfers 0 2 3 0 Table
items_last_borrower 0 2 4 0 Table
auth_header 1 1 9 0 Table
biblio 30 0 17 0 Table
audio_alerts 0 0 4 0 Table
borrowers 86 3 84 0 Table
iso18626_requests 1 4 12 0 Table
deletedbiblio 1 0 17 0 Table
letter 1 1 12 0 Table
permissions 2 1 3 0 Table
borrower_attribute_types_branches 0 2 2 0 Table
circulation_rules 0 3 6 0 Table
items 26 5 48 0 Table
marc_modification_template_actions 0 1 27 0 Table
search_marc_to_field 0 2 7 0 Table
cover_images 0 2 7 0 Table
item_lists 2 2 7 0 Table
clubs 3 2 9 0 Table
additional_contents_localizations 0 1 6 0 Table
aqbookseller_interfaces 0 2 9 0 Table
sip_account_sort_bin_mappings 0 1 3 0 Table
additional_contents 1 2 10 0 Table
iso18626_messages 0 1 5 0 Table
item_list_contents 0 2 3 0 Table
borrower_message_preferences 1 3 6 0 Table
aqbooksellers 16 2 24 0 Table
borrower_modifications 0 1 75 0 Table
reviews 0 2 6 0 Table
aqcontacts 0 1 15 0 Table
collections 1 1 4 0 Table
suggestions 0 10 35 0 Table
creator_images 0 0 3 0 Table
checkins 0 10 15 0 Table
erm_counter_logs 0 3 7 0 Table
message_transport_types 4 0 1 0 Table
illbatch_statuses 1 0 4 0 Table
hold_fill_targets 0 4 7 0 Table
oai_servers 0 0 7 0 Table
edifact_ean 0 1 5 0 Table
biblio_metadata_errors 0 1 7 0 Table
course_reserves 0 2 6 0 Table
club_enrollments 1 3 8 0 Table
subscription_numberpatterns 1 0 23 0 Table
aqbudgetborrowers 0 2 2 0 Table
message_transports 0 2 6 0 Table
cities 0 0 5 0 Table
sip_account_patron_attributes 0 1 4 0 Table
item_list_shares 0 2 4 0 Table
virtualshelfcontents 0 3 4 0 Table
userflags 1 0 4 0 Table
language_rfc4646_to_iso639 0 0 3 0 Table
account_debit_types_branches 0 2 2 0 Table
curbside_pickup_issues 0 1 4 0 Table
preservation_trains 1 1 9 0 Table
marc_modification_templates 1 0 2 0 Table
stockrotationstages 1 2 5 0 Table
keyboard_shortcuts 0 0 2 0 Table
import_batches 1 1 16 0 Table
aqorders_claims 0 1 3 0 Table
transport_cost 0 2 4 0 Table
z3950servers 1 0 18 0 Table
auth_types 4 0 4 0 Table
preservation_trains_items 1 3 6 0 Table
account_debit_types 2 0 8 0 Table
issues 2 4 20 0 Table
housebound_role 0 1 3 0 Table
pseudonymized_metadata_values 0 1 5 0 Table
aqinvoices 2 3 9 0 Table
curbside_pickup_policy 1 1 7 0 Table
sip_account_item_fields 0 1 4 0 Table
sip_account_system_preference_overrides 0 1 4 0 Table
erm_agreements 7 2 9 0 Table