SchemaSpy Analysis of testsql_comments Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jul 16 09:22 NZST 2018
Database Type: MySQL - 5.5.5-10.1.29-MariaDB-6+b1 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
account_offset_types 1 1 0
account_offsets 3 6 0
accountlines 2 2 17 0
action_logs 8 0 logs of actions taken in Koha (requires that the logs be turned on)
additional_field_values 1 4 0
additional_fields 1 6 0
alert 4 0
aqbasket 3 4 16 0 stores data about baskets in acquisitions
aqbasketgroups 1 1 8 0
aqbasketusers 2 2 0
aqbooksellers 7 2 26 0 information about the vendors listed in acquisitions
aqbudgetborrowers 2 2 0
aqbudgetperiods 9 0 information related to Budgets
aqbudgets 6 15 0 information related to Funds
aqbudgets_planning 1 7 0
aqcontacts 1 14 0
aqcontract 1 1 6 0
aqinvoices 1 3 9 0
aqorder_users 2 2 0 Mapping orders to patrons for notification sending
aqorders 4 6 49 0 information related to the basket line items
aqorders_items 1 3 0 information on items entered in the acquisitions process
aqorders_transfers 2 3 0
article_requests 4 17 0
audio_alerts 4 0
auth_header 9 0
auth_subfield_structure 1 17 0
auth_tag_structure 1 7 0
auth_types 2 4 0
authorised_value_categories 3 1 0
authorised_values 1 1 6 0 stores values for authorized values categories and values
authorised_values_branches 2 2 0 association table between authorised_values and branches
biblio 14 12 0 table that stores bibliographic information
biblio_framework 2 0 information about MARC frameworks
biblio_metadata 1 6 0
biblioimages 1 5 0 local cover images
biblioitems 1 1 32 0 information related to bibliographic records in Koha
borrower_attribute_types 2 11 0 definitions for custom patron fields known as extended patron attributes
borrower_attribute_types_branches 2 2 0 association table between borrower_attribute_types and branches
borrower_attributes 2 4 0 values of custom patron fields known as extended patron attributes linked to patrons/borrowers
borrower_debarments 1 8 0 tracks restrictions on the patron's record
borrower_files 1 7 0 files attached to the patron/borrower record
borrower_message_preferences 1 3 6 0
borrower_message_transport_preferences 2 2 0
borrower_modifications 69 0
borrower_password_recovery 3 0 holds information about password recovery attempts
borrower_sync 1 7 0
borrowers 40 3 74 0 this table includes information about your patrons/borrowers/members
branch_borrower_circ_rules 2 4 0 includes default circulation rules for patron categories found under "Checkout limit by patron category"
branch_item_rules 2 5 0 information entered in the circulation and fine rules under 'Holds policy by item type'
branch_transfer_limits 5 0
branchcategories 1 5 0 information related to library/branch groups
branches 27 22 0 information about your libraries or branches are stored here
branchrelations 2 2 0 this table links libraries/branches to groups
branchtransfers 3 7 0 information for items that are in transit between branches
browser 5 0
categories 5 17 0 this table shows information related to Koha patron categories
categories_branches 2 2 0 association table between categories and branches
cities 5 0 authorized values for cities/states/countries to choose when adding/editing a patron/borrower
class_sort_rules 1 3 0
class_sources 1 4 0
club_enrollment_fields 2 4 0
club_enrollments 1 3 8 0
club_fields 2 4 0
club_template_enrollment_fields 1 1 5 0
club_template_fields 1 1 5 0
club_templates 3 1 9 0
clubs 2 2 9 0
collections 1 4 0
collections_tracking 3 0
columns_settings 6 0
course_instructors 2 2 0
course_items 1 2 8 0
course_reserves 2 6 0
courses 2 11 0
creator_batches 3 7 0
creator_images 3 0
creator_layouts 15 0
creator_templates 18 0
currency 3 7 0
default_borrower_circ_rules 1 3 0 default checkout rules found under "Default checkout, hold and return policy"
default_branch_circ_rules 1 6 0
default_branch_item_rules 1 4 0
default_circ_rules 6 0
deletedbiblio 1 12 0 stores information about bibliographic records that have been deleted
deletedbiblio_metadata 1 6 0
deletedbiblioitems 32 0 information about bibliographic records that have been deleted
deletedborrowers 74 0 stores data related to the patrons/borrowers you have deleted
deleteditems 44 0
discharges 1 4 0
edifact_ean 1 5 0
edifact_messages 1 3 10 0
export_format 10 0 Used for CSV export
fieldmapping 5 0 koha to keyword mapping
hold_fill_targets 4 5 0
housebound_profile 1 1 8 0
housebound_role 1 3 0
housebound_visit 3 6 0
illrequestattributes 1 3 0
illrequests 1 2 16 0
import_auths 1 5 0
import_batches 1 15 0 information about batches of marc records that have been imported
import_biblios 1 9 0
import_items 1 7 0
import_record_matches 1 3 0 matches found when importing a batch of records
import_records 4 1 15 0
issues 2 15 0 information related to check outs or issues
issuingrules 33 0 circulation and fine rules
item_circulation_alert_preferences 5 0
items 12 4 44 0 holdings/item information
items_last_borrower 2 4 0
items_search_fields 1 5 0
itemtypes 4 13 0 defines the item types
language_descriptions 5 0
language_rfc4646_to_iso639 3 0
language_script_bidi 2 0
language_script_mapping 2 0
language_subtag_registry 5 0
letter 1 9 0 table for all notice templates in Koha
linktracker 6 0
localization 5 0
marc_matchers 3 5 0
marc_modification_template_actions 1 20 0
marc_modification_templates 1 2 0
marc_subfield_structure 1 18 0
marc_tag_structure 7 0
matchchecks 3 4 0
matcher_matchpoints 2 2 0
matchpoint_component_norms 1 3 0
matchpoint_components 1 1 7 0
matchpoints 4 1 4 0
message_attributes 2 3 0
message_queue 2 12 0
message_transport_types 5 1 0
message_transports 2 6 0
messages 1 7 0 circulation messages left via the patron's check out screen
misc_files 8 0 miscellaneous files attached to records from various tables
need_merge_authorities 6 0 keeping track of authority records still to be merged by merge_authority cron job
notifys 7 0
oai_sets 3 3 0
oai_sets_biblios 1 2 0
oai_sets_descriptions 1 2 0
oai_sets_mappings 1 5 0
old_issues 2 15 0 lists items that were checked out and have been returned
old_reserves 4 19 0 this table holds all holds/reserves that have been completed (either filled or cancelled)
opac_news 2 9 0 data from the news tool
overduerules 1 12 0 overdue notice status and triggers
overduerules_transport_types 2 4 0
patron_list_patrons 2 3 0
patron_lists 1 1 3 0
patronimage 1 3 0 information related to patron images
pending_offline_operations 8 0
permissions 2 1 3 0
plugin_data 3 0
printers 3 0
printers_profile 10 0
quotes 4 0 data for the quote of the day feature
ratings 2 4 0 information related to the star ratings in the OPAC
refund_lost_item_fee_rules 2 0 refund lost item fee rules tbale
repeatable_holidays 7 0 information for the days the library is closed
reports_dictionary 7 0 definitions (or snippets of SQL) stored for use in reports
reserves 5 19 0 information related to holds/reserves in Koha
reviews 2 6 0 patron opac comments
saved_reports 4 0
saved_sql 14 0 saved sql reports
search_field 1 4 0
search_history 8 0 Opac search history results
search_marc_map 1 4 0 patron's opac search history
search_marc_to_field 2 5 0
serial 1 15 0 issues related to subscriptions
serialitems 2 2 0
services_throttle 2 0
sessions 2 0
sms_providers 1 3 0
social_data 7 0
special_holidays 8 0 non repeatable holidays/library closings
statistics 13 0 information related to transactions (circulation and fines) in Koha
subscription 2 2 42 0 information related to the subscription
subscription_frequencies 1 6 0
subscription_numberpatterns 1 23 0
subscriptionhistory 8 0
subscriptionroutinglist 2 4 0 information related to the routing lists attached to subscriptions
suggestions 1 31 0 purchase suggestions
systempreferences 5 0 global system preferences
tags 2 0
tags_all 2 6 0 all of the tags
tags_approval 1 1 5 0 approved tags
tags_index 2 3 0 a weighted list of all tags and where they are used
tmp_holdsqueue 15 0
transport_cost 2 4 0
uploaded_files 10 0
user_permissions 3 3 0
userflags 1 4 0
vendor_edi_accounts 1 2 19 0
virtualshelfcontents 3 5 0 information about the titles in a list (or virtual shelf)
virtualshelfshares 2 5 0 shared private lists
virtualshelves 2 1 9 0 information about lists (or virtual shelves)
z3950servers 17 0 connection information for the Z39.50 targets used in cataloging
zebraqueue 6 0
           
198 Tables     1,827 0  
0 Views     0