Tables


SchemaSpy Analysis of koha_dev.koha_dev

Generated on Fri Dec 20 14:17 ART 2024

XML Representation
Insertion Order Deletion Order
TABLES 271
VIEWS 0
COLUMNS 2496
Constraints 371
Anomalies 53
Routines 0

Database Properties

Database Type: MariaDB - 10.11.6-MariaDB-0+deb12u1

Tables

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

Information related to recalls in Koha
discharges 0 1 4 0 Table
additional_field_values 0 1 4 0 Table
matcher_matchpoints 0 2 2 3 Table
ticket_updates 0 3 8 0 Table
biblio_framework 2 0 2 10 Table
vendor_edi_accounts 1 2 22 0 Table
message_attributes 2 0 3 10 Table
saved_reports 0 0 4 0 Table
oai_sets 3 0 3 0 Table
search_filters 0 1 6 0 Table
tags 0 0 2 0 Table
need_merge_authorities 0 0 6 0 Table
branchtransfers 0 3 11 0 Table
advanced_editor_macros 0 1 5 0 Table
curbside_pickup_opening_slots 0 1 7 0 Table
class_sources 4 2 5 6 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 221 Table
zebraqueue 0 0 6 0 Table
creator_layouts 0 0 17 4 Table
language_descriptions 0 0 5 655 Table
messages 0 2 8 0 Table
erm_eholdings_packages 2 2 9 0 Table
borrower_relationships 0 2 4 0 Table
pseudonymized_transactions 1 2 24 0 Table
erm_usage_databases 2 1 6 0 Table
background_jobs 0 0 12 8 Table
account_offsets 0 2 6 0 Table
aqinvoice_adjustments 0 2 8 0 Table
serial 1 2 15 0 Table
action_logs 0 0 11 2558 Table
housebound_profile 1 1 8 0 Table
aqcontract 1 1 6 0 Table
statistics 0 2 12 0 Table
tags_all 0 3 6 0 Table
tables_settings 0 0 5 0 Table
subscriptionhistory 0 2 8 0 Table
cash_register_actions 0 2 6 0 Table
illcomments 0 2 5 0 Table
search_history 0 0 8 4 Table

Opac search history results
printers_profile 0 0 10 5 Table
old_issues 0 3 18 0 Table
quotes 0 0 4 31 Table
courses 2 1 11 0 Table
language_script_bidi 0 0 2 2 Table
illrequestattributes 0 1 5 0 Table
deleteditems 0 1 48 0 Table
borrower_message_transport_preferences 0 2 2 0 Table
erm_eholdings_packages_agreements 0 2 2 0 Table
identity_provider_domains 0 3 9 0 Table
itemtypes 11 1 19 8 Table
library_smtp_servers 0 2 3 0 Table
library_hours 0 1 4 84 Table
import_batch_profiles 1 0 12 0 Table
saved_sql 0 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 5 Table
search_marc_map 1 0 4 486 Table
erm_usage_items 2 1 5 0 Table
item_bundles 0 2 2 0 Table
deletedborrowers 0 1 83 0 Table
additional_fields 1 1 7 0 Table
import_auths 0 1 5 0 Table
aqbudgets 7 1 15 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
preservation_processing_attributes 1 1 5 0 Table
language_script_mapping 0 0 2 3 Table
matchpoint_component_norms 0 1 3 3 Table
library_groups 1 2 13 0 Table
preservation_processing_attributes_items 0 2 4 0 Table
virtualshelfshares 0 2 5 0 Table
aqbasket 3 4 16 0 Table
authorised_values_branches 0 2 2 0 Table
patronimage 0 1 3 0 Table
borrower_attribute_types 5 1 15 0 Table
authorised_value_categories 3 0 3 63 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 1228 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 21 0 Table
item_circulation_alert_preferences 0 1 5 0 Table
identity_providers 1 0 8 0 Table
class_sort_rules 1 0 3 3 Table
aqbookseller_aliases 0 1 3 0 Table
oauth_access_tokens 0 1 3 577 Table
course_items 1 5 20 0 Table
erm_documents 0 3 11 0 Table
tmp_holdsqueue 0 3 16 0 Table
account_credit_types 2 0 6 11 Table
columns_settings 0 0 6 0 Table
user_permissions 0 3 3 0 Table
housebound_visit 0 3 6 0 Table
biblio_metadata 0 2 7 1509 Table
club_holds_to_patron_holds 0 3 6 0 Table
tags_index 0 2 3 0 Table
subscriptionroutinglist 0 2 4 0 Table
branches_overdrive 0 1 2 0 Table
currency 5 0 8 4 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 56095 Table
aqbudgetperiods 1 0 9 0 Table
branches 48 0 25 12 Table
reserves 1 7 25 0 Table
sessions 0 0 2 0 Table
deletedbiblioitems 0 2 32 0 Table
smtp_servers 1 0 10 0 Table
borrower_attributes 0 2 4 0 Table
desks 1 1 3 0 Table
categories_branches 0 2 2 0 Table
bookings 0 4 7 0 Table
special_holidays 0 1 8 0 Table
pseudonymized_borrower_attributes 0 2 4 0 Table
uploaded_files 0 0 10 5 Table
curbside_pickups 1 3 10 0 Table
deletedbiblio_metadata 0 2 7 0 Table
club_fields 0 2 4 0 Table
api_keys 1 1 5 3 Table
import_biblios 0 1 9 53715 Table
authorised_values 2 1 6 505 Table
erm_usage_platforms 2 1 3 0 Table
localization 0 1 5 0 Table
virtualshelves 2 1 11 0 Table
import_record_matches 0 1 4 0 Table
marc_tag_structure 0 0 10 3159 Table
oai_sets_mappings 0 1 7 0 Table
systempreferences 0 0 5 858 Table
aqorders_items 0 1 3 0 Table
accountlines 3 7 19 0 Table
article_requests 0 5 22 0 Table
tickets 1 4 11 0 Table
auth_subfield_structure 0 1 18 13280 Table
matchpoint_components 1 1 7 3 Table
sms_providers 1 1 3 0 Table
ratings 0 2 4 0 Table
cash_registers 2 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 0 5 12 0 Table
stockrotationitems 0 2 4 0 Table
serialitems 0 2 2 0 Table
edifact_messages 1 3 10 0 Table
biblioitems 1 3 32 1949 Table
item_group_items 0 2 3 0 Table
class_split_rules 1 0 4 3 Table
record_sources 2 0 3 0 Table
stockrotationrotas 1 0 5 0 Table
erm_eholdings_titles 1 2 27 0 Table
export_format 0 0 11 2 Table

Used for CSV export
matchpoints 4 1 4 3 Table
branch_transfer_limits 0 1 5 0 Table
erm_user_roles 0 3 5 0 Table
checkout_renewals 0 1 7 0 Table
overduerules 1 1 12 0 Table
aqorders 5 8 52 0 Table
patron_list_patrons 0 2 3 0 Table
club_template_enrollment_fields 1 1 5 0 Table
subscription 4 4 45 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 0 1 10 0 Table
biblio 28 1 16 1955 Table
audio_alerts 0 0 4 3 Table
overduerules_transport_types 0 2 4 0 Table
borrowers 79 3 83 86 Table
deletedbiblio 1 1 16 0 Table
repeatable_holidays 0 1 7 3 Table
letter 1 1 12 73 Table
permissions 2 1 3 150 Table
borrower_attribute_types_branches 0 2 2 0 Table
circulation_rules 0 3 6 30 Table
items 24 5 48 338 Table
marc_modification_template_actions 0 1 20 0 Table
search_marc_to_field 0 2 7 608 Table
cover_images 0 2 7 0 Table
clubs 3 2 9 0 Table
additional_contents_localizations 0 1 6 2 Table
aqbookseller_interfaces 0 2 9 0 Table
additional_contents 1 2 10 2 Table
borrower_message_preferences 1 3 6 350 Table
aqbooksellers 14 2 23 0 Table
borrower_modifications 0 1 74 0 Table
reviews 0 2 6 0 Table
aqcontacts 0 1 14 0 Table
suggestions 0 10 35 0 Table
collections 1 1 4 0 Table
creator_images 0 0 3 0 Table
erm_counter_logs 0 3 7 0 Table
illbatch_statuses 1 0 4 3 Table
message_transport_types 5 0 1 5 Table
hold_fill_targets 0 4 6 0 Table
edifact_ean 0 1 5 0 Table
club_enrollments 1 3 8 0 Table
course_reserves 0 2 6 0 Table
subscription_numberpatterns 1 0 23 4 Table
aqbudgetborrowers 0 2 2 0 Table
message_transports 0 2 6 41 Table
cities 0 0 5 0 Table
userflags 1 0 4 27 Table
virtualshelfcontents 0 3 4 0 Table
language_rfc4646_to_iso639 0 0 3 157 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
stockrotationstages 1 2 5 0 Table
marc_modification_templates 1 0 2 0 Table
keyboard_shortcuts 0 0 2 16 Table
import_batches 1 1 16 4 Table
aqorders_claims 0 1 3 0 Table
transport_cost 0 2 4 0 Table
auth_types 3 0 4 9 Table
z3950servers 0 0 18 4 Table
preservation_trains_items 1 3 6 0 Table
account_debit_types 2 0 8 16 Table
housebound_role 0 1 3 0 Table
issues 0 3 18 0 Table
aqinvoices 2 3 9 0 Table
curbside_pickup_policy 1 1 7 12 Table
erm_agreements 7 2 9 0 Table