Tables


SchemaSpy Analysis of testsql_comments

Generated on Tue. Jun. 20 13:01 NZST 2023

XML Representation
Insertion Order Deletion Order
TABLES 249
VIEWS 0
COLUMNS 2320
Constraints 330
Anomalies 52
Routines 0

Database Properties

Database Type: MySQL - 5.5.5-10.3.38-MariaDB-0ubuntu0.20.04.1

Tables

Table / View Children Parents Columns Rows Type Comments
borrower_files 0 2 7 0 Table
marc_matchers 3 1 5 0 Table
marc_overlay_rules 0 0 8 0 Table
subscription_frequencies 1 0 6 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 5 25 0 Table
import_records 4 1 14 0 Table
erm_licenses 3 2 8 0 Table
oai_sets_descriptions 0 1 2 0 Table
search_field 1 1 9 0 Table
items_search_fields 16 1 5 0 Table
borrower_debarments 0 2 8 0 Table
erm_agreement_periods 0 1 6 0 Table
categories 12 0 24 0 Table
club_template_fields 1 1 5 0 Table
recalls 0 4 15 0 Table

Information related to recalls in Koha
club_enrollment_fields 0 2 4 0 Table
discharges 0 1 4 0 Table
additional_field_values 0 1 4 0 Table
matcher_matchpoints 0 2 2 0 Table
biblio_framework 2 0 2 0 Table
ticket_updates 0 2 6 0 Table
vendor_edi_accounts 1 2 20 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
tags 0 0 2 0 Table
need_merge_authorities 0 0 6 0 Table
branchtransfers 0 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
restriction_types 1 0 4 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
social_data 1 0 7 0 Table
zebraqueue 0 0 6 0 Table
language_subtag_registry 0 0 5 0 Table
language_descriptions 0 0 5 0 Table
creator_layouts 0 0 15 0 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
account_offsets 0 2 6 0 Table
background_jobs 0 0 12 0 Table
aqinvoice_adjustments 0 2 8 0 Table
action_logs 0 0 10 0 Table
serial 1 2 15 0 Table
housebound_profile 1 1 8 0 Table
statistics 0 2 12 0 Table
aqcontract 1 1 6 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 0 Table

Opac search history results
printers_profile 0 0 10 0 Table
old_issues 0 3 18 0 Table
courses 2 1 11 0 Table
quotes 0 0 4 0 Table
language_script_bidi 0 0 2 0 Table
illrequestattributes 0 1 4 0 Table
borrower_message_transport_preferences 0 2 2 0 Table
deleteditems 0 1 46 0 Table
erm_eholdings_packages_agreements 0 2 2 0 Table
identity_provider_domains 0 3 9 0 Table
itemtypes 11 1 19 0 Table
library_smtp_servers 0 2 3 0 Table
import_batch_profiles 1 0 12 0 Table
alert 0 1 4 0 Table
borrower_password_recovery 0 0 3 0 Table
saved_sql 0 1 15 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
item_bundles 0 2 2 0 Table
additional_fields 1 1 7 0 Table
deletedborrowers 0 1 82 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
language_script_mapping 0 0 2 0 Table
library_groups 1 2 12 0 Table
matchpoint_component_norms 0 1 3 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
authorised_value_categories 3 0 2 0 Table
borrower_attribute_types 4 1 13 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
browser 0 0 5 0 Table
aqbasketusers 0 2 2 0 Table
aqbasketgroups 1 1 8 0 Table
illrequests 2 4 20 0 Table
item_circulation_alert_preferences 0 1 5 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
identity_providers 1 0 8 0 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 0 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 1 6 0 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 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 44 0 23 0 Table
aqbudgetperiods 1 0 9 0 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
special_holidays 0 1 8 0 Table
pseudonymized_borrower_attributes 0 2 4 0 Table
uploaded_files 0 0 10 0 Table
curbside_pickups 1 3 10 0 Table
deletedbiblio_metadata 0 1 6 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 2 1 6 0 Table
localization 0 0 5 0 Table
virtualshelves 2 1 11 0 Table
import_record_matches 0 1 4 0 Table
oai_sets_mappings 0 1 7 0 Table
marc_tag_structure 0 0 10 0 Table
systempreferences 0 0 5 0 Table
aqorders_items 0 1 3 0 Table
accountlines 3 7 19 0 Table
article_requests 0 5 22 0 Table
tickets 1 3 8 0 Table
auth_subfield_structure 0 1 18 0 Table
matchpoint_components 1 1 7 0 Table
sms_providers 1 1 3 0 Table
cash_registers 2 1 7 0 Table
ratings 0 2 4 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 3 16 0 Table
stockrotationitems 0 2 4 0 Table
return_claims 0 5 12 0 Table
serialitems 0 2 2 0 Table
biblioitems 1 3 32 0 Table
edifact_messages 1 3 10 0 Table
class_split_rules 1 0 4 0 Table
item_group_items 0 2 3 0 Table
stockrotationrotas 1 0 5 0 Table
erm_eholdings_titles 1 2 27 0 Table
export_format 0 0 11 0 Table

Used for CSV export
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
overduerules 1 1 12 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 4 44 0 Table
problem_reports 0 2 10 0 Table
aqorders_transfers 0 2 3 0 Table
items_last_borrower 0 2 4 0 Table
auth_header 0 1 9 0 Table
biblio 27 1 16 0 Table
audio_alerts 0 0 4 0 Table
overduerules_transport_types 0 2 4 0 Table
borrowers 74 3 82 0 Table
deletedbiblio 1 1 16 0 Table
repeatable_holidays 0 1 7 0 Table
permissions 2 1 3 0 Table
letter 1 1 11 0 Table
borrower_attribute_types_branches 0 2 2 0 Table
circulation_rules 0 3 6 0 Table
items 22 5 46 0 Table
marc_modification_template_actions 0 1 20 0 Table
search_marc_to_field 0 2 6 0 Table
cover_images 0 2 7 0 Table
clubs 3 2 9 0 Table
aqbookseller_interfaces 0 2 9 0 Table
additional_contents 0 2 13 0 Table
borrower_message_preferences 1 3 6 0 Table
aqbooksellers 13 2 23 0 Table
borrower_modifications 0 1 73 0 Table
reviews 0 2 6 0 Table
aqcontacts 0 1 14 0 Table
collections 1 1 4 0 Table
suggestions 0 10 35 0 Table
creator_images 0 0 3 0 Table
message_transport_types 5 0 1 0 Table
hold_fill_targets 0 4 6 0 Table
edifact_ean 0 1 5 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
virtualshelfcontents 0 3 5 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
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 0 0 18 0 Table
auth_types 3 0 4 0 Table
account_debit_types 2 0 8 0 Table
issues 0 3 18 0 Table
housebound_role 0 1 3 0 Table
aqinvoices 2 3 9 0 Table
curbside_pickup_policy 1 1 7 0 Table
erm_agreements 7 2 9 0 Table