| 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 |
|
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 |