testsql_comments Database

Table / View	Children	Parents	Columns	Type	Comments
borrower_files	0	2	7	Table
marc_matchers	3	1	5	Table
marc_overlay_rules	0	0	8	Table
subscription_frequencies	1	0	6	Table
marc_subfield_structure	0	1	20	Table
linktracker	0	3	6	Table
creator_batches	0	3	8	Table
old_reserves	0	4	24	Table
import_records	4	1	14	Table
oai_sets_descriptions	0	1	2	Table
search_field	1	1	9	Table
items_search_fields	9	1	5	Table
borrower_debarments	0	1	8	Table
categories	10	0	23	Table
club_template_fields	1	1	5	Table
club_enrollment_fields	0	2	4	Table
discharges	0	1	4	Table
recalls	0	4	15	Table	Information related to recalls in Koha
additional_field_values	0	1	4	Table
matcher_matchpoints	0	2	2	Table
biblio_framework	2	0	2	Table
vendor_edi_accounts	1	2	20	Table
message_attributes	2	0	3	Table
saved_reports	0	0	4	Table
oai_sets	3	0	3	Table
need_merge_authorities	0	0	6	Table
tags	0	0	2	Table
branchtransfers	0	3	11	Table
advanced_editor_macros	0	1	5	Table
class_sources	4	2	5	Table
aqorder_users	0	2	2	Table
oai_sets_biblios	0	1	2	Table
club_holds	1	3	5	Table
aqbudgets_planning	0	1	7	Table
social_data	1	0	7	Table
language_subtag_registry	0	0	5	Table
zebraqueue	0	0	6	Table
creator_layouts	0	0	15	Table
language_descriptions	0	0	5	Table
messages	0	2	7	Table
borrower_relationships	0	2	4	Table
pseudonymized_transactions	1	2	24	Table
account_offsets	0	2	6	Table
background_jobs	0	0	11	Table
aqinvoice_adjustments	0	2	8	Table
action_logs	0	0	8	Table
serial	1	2	15	Table
aqcontract	1	1	6	Table
housebound_profile	1	1	8	Table
statistics	0	1	10	Table
tags_all	0	3	6	Table
tables_settings	0	0	5	Table
subscriptionhistory	0	2	8	Table
cash_register_actions	0	2	6	Table
illcomments	0	2	5	Table
printers_profile	0	0	10	Table
search_history	0	0	8	Table	Opac search history results
old_issues	0	3	18	Table
courses	2	1	11	Table
language_script_bidi	0	0	2	Table
quotes	0	0	4	Table
illrequestattributes	0	1	4	Table
borrower_message_transport_preferences	0	2	2	Table
deleteditems	0	1	45	Table
itemtypes	11	1	19	Table
library_smtp_servers	0	2	3	Table
import_batch_profiles	1	0	12	Table
alert	0	1	4	Table
borrower_password_recovery	0	0	3	Table
club_templates	3	1	9	Table
saved_sql	0	1	15	Table
account_credit_types_branches	0	2	2	Table
creator_templates	0	0	18	Table
search_marc_map	1	0	4	Table
additional_fields	1	1	6	Table
deletedborrowers	0	1	80	Table
import_auths	0	1	5	Table
aqbudgets	7	1	15	Table
language_script_mapping	0	0	2	Table
library_groups	1	2	11	Table
matchpoint_component_norms	0	1	3	Table
virtualshelfshares	0	2	5	Table
aqbasket	3	4	16	Table
authorised_values_branches	0	2	2	Table
patronimage	0	1	3	Table
authorised_value_categories	3	0	2	Table
borrower_attribute_types	4	1	13	Table
matchchecks	0	3	4	Table
tags_approval	2	1	5	Table
pending_offline_operations	0	0	8	Table
itemtypes_branches	0	2	2	Table
misc_files	0	1	8	Table
auth_tag_structure	0	1	7	Table
plugin_data	0	0	3	Table
patron_consent	0	1	5	Table
browser	0	0	5	Table
aqbasketusers	0	2	2	Table
aqbasketgroups	1	1	8	Table
illrequests	2	3	18	Table
item_circulation_alert_preferences	0	1	5	Table
class_sort_rules	1	0	3	Table
oauth_access_tokens	0	1	3	Table
course_items	1	5	20	Table
tmp_holdsqueue	0	3	15	Table
account_credit_types	2	0	6	Table
columns_settings	0	0	6	Table
user_permissions	0	3	3	Table
biblio_metadata	0	1	6	Table
housebound_visit	0	3	6	Table
club_holds_to_patron_holds	0	3	6	Table
tags_index	0	2	3	Table
subscriptionroutinglist	0	2	4	Table
branches_overdrive	0	1	2	Table
currency	4	0	8	Table
collections_tracking	0	1	3	Table
reports_dictionary	0	1	7	Table
patron_lists	1	2	4	Table
course_instructors	0	2	2	Table
import_items	0	1	7	Table
aqbudgetperiods	1	0	9	Table
branches	41	0	24	Table
reserves	1	6	24	Table
deletedbiblioitems	0	2	32	Table
sessions	0	0	2	Table
smtp_servers	1	0	9	Table
borrower_attributes	0	2	4	Table
desks	1	1	3	Table
categories_branches	0	2	2	Table
pseudonymized_borrower_attributes	0	2	4	Table
special_holidays	0	1	8	Table
uploaded_files	0	0	10	Table
club_fields	0	2	4	Table
deletedbiblio_metadata	0	1	6	Table
api_keys	1	1	5	Table
import_biblios	0	1	9	Table
authorised_values	2	1	6	Table
localization	0	0	5	Table
virtualshelves	2	1	10	Table
import_record_matches	0	1	4	Table
marc_tag_structure	0	0	10	Table
oai_sets_mappings	0	1	7	Table
systempreferences	0	0	5	Table
aqorders_items	0	1	3	Table
accountlines	3	7	19	Table
article_requests	0	5	22	Table
auth_subfield_structure	0	1	18	Table
matchpoint_components	1	1	7	Table
sms_providers	1	1	3	Table
cash_registers	2	1	7	Table
ratings	0	2	4	Table
plugin_methods	0	0	2	Table
message_queue	0	2	15	Table
return_claims	0	5	12	Table
stockrotationitems	0	2	4	Table
serialitems	0	2	2	Table
biblioitems	1	3	32	Table
edifact_messages	1	3	10	Table
class_split_rules	1	0	4	Table
stockrotationrotas	1	0	5	Table
export_format	0	0	11	Table	Used for CSV export
matchpoints	4	1	4	Table
branch_transfer_limits	0	1	5	Table
overduerules	1	1	12	Table
aqorders	5	7	49	Table
patron_list_patrons	0	2	3	Table
club_template_enrollment_fields	1	1	5	Table
subscription	4	4	44	Table
problem_reports	0	2	10	Table
aqorders_transfers	0	2	3	Table
items_last_borrower	0	2	4	Table
auth_header	0	1	9	Table
biblio	23	1	16	Table
audio_alerts	0	0	4	Table
overduerules_transport_types	0	2	4	Table
borrowers	66	3	80	Table
deletedbiblio	1	1	16	Table
repeatable_holidays	0	1	7	Table
letter	0	1	11	Table
permissions	2	1	3	Table
borrower_attribute_types_branches	0	2	2	Table
circulation_rules	0	3	6	Table
items	19	5	45	Table
marc_modification_template_actions	0	1	20	Table
cover_images	0	2	7	Table
search_marc_to_field	0	2	6	Table
clubs	3	2	9	Table
additional_contents	0	2	13	Table
borrower_message_preferences	1	3	6	Table
aqbooksellers	7	2	21	Table
borrower_modifications	0	1	71	Table
reviews	0	2	6	Table
aqcontacts	0	1	14	Table
collections	1	1	4	Table
suggestions	0	10	34	Table
creator_images	0	0	3	Table
message_transport_types	5	0	1	Table
hold_fill_targets	0	4	6	Table
edifact_ean	0	1	5	Table
club_enrollments	1	3	8	Table
course_reserves	0	2	6	Table
subscription_numberpatterns	1	0	23	Table
aqbudgetborrowers	0	2	2	Table
message_transports	0	2	6	Table
cities	0	0	5	Table
virtualshelfcontents	0	3	5	Table
userflags	1	0	4	Table
language_rfc4646_to_iso639	0	0	3	Table
account_debit_types_branches	0	2	2	Table
marc_modification_templates	1	0	2	Table
stockrotationstages	1	2	5	Table
keyboard_shortcuts	0	0	2	Table
import_batches	1	1	16	Table
aqorders_claims	0	1	3	Table
transport_cost	0	2	4	Table
auth_types	3	0	4	Table
z3950servers	0	0	18	Table
account_debit_types	2	0	7	Table
housebound_role	0	1	3	Table
issues	0	3	18	Table
aqinvoices	2	3	9	Table

borrower_files

0

2

7

0

Table

marc_matchers

3

1

5

0

Table