| SchemaSpy Analysis of testsql_comments | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue May 15 13:04 NZST 2012 | |
| Database Type: MySQL - 5.5.22-0ubuntu1 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| accountlines | 2 | 15 | 0 | ||
| accountoffsets | 1 | 5 | 0 | ||
| action_logs | 7 | 0 | |||
| alert | 4 | 0 | |||
| aqbasket | 1 | 3 | 11 | 0 | |
| aqbasketgroups | 1 | 1 | 8 | 0 | |
| aqbooksellers | 3 | 2 | 33 | 0 | information about the vendors listed in acquisitions |
| aqbudgetperiods | 9 | 0 | |||
| aqbudgets | 1 | 15 | 0 | ||
| aqbudgets_planning | 1 | 7 | 0 | ||
| aqcontract | 1 | 1 | 6 | 0 | |
| aqorderdelivery | 5 | 0 | |||
| aqorders | 2 | 35 | 0 | ||
| aqorders_items | 3 | 0 | |||
| auth_header | 9 | 0 | |||
| auth_subfield_structure | 16 | 0 | |||
| auth_tag_structure | 1 | 7 | 0 | ||
| auth_types | 1 | 4 | 0 | ||
| authorised_values | 6 | 0 | stores values for authorized values categories and values | ||
| biblio | 9 | 12 | 0 | table that stores bibliographic information | |
| biblio_framework | 2 | 0 | |||
| biblioimages | 1 | 5 | 0 | ||
| biblioitems | 1 | 1 | 32 | 0 | information related to bibliographic records in Koha |
| borrower_attribute_types | 1 | 11 | 0 | definitions for custom patron fields known as extended patron attributes | |
| borrower_attributes | 2 | 4 | 0 | values of custom patron fields known as extended patron attributes linked to patrons/borrowers | |
| borrower_message_preferences | 1 | 3 | 6 | 0 | |
| borrower_message_transport_preferences | 2 | 2 | 0 | ||
| borrowers | 19 | 2 | 67 | 0 | this table includes information about your patrons/borrowers/members |
| branch_borrower_circ_rules | 2 | 3 | 0 | ||
| branch_item_rules | 2 | 4 | 0 | ||
| branch_transfer_limits | 5 | 0 | |||
| branchcategories | 1 | 4 | 0 | information related to library/branch groups | |
| branches | 11 | 18 | 0 | information about your libraries or branches are stored here | |
| branchrelations | 2 | 2 | 0 | this table links libraries/branches to groups | |
| branchtransfers | 3 | 6 | 0 | ||
| browser | 5 | 0 | |||
| categories | 4 | 14 | 0 | this table shows information related to Koha patron categories | |
| 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 | ||
| collections | 4 | 0 | |||
| collections_tracking | 3 | 0 | |||
| creator_batches | 3 | 7 | 0 | ||
| creator_images | 3 | 0 | |||
| creator_layouts | 14 | 0 | |||
| creator_templates | 18 | 0 | |||
| currency | 2 | 5 | 0 | ||
| default_borrower_circ_rules | 1 | 2 | 0 | ||
| default_branch_circ_rules | 1 | 4 | 0 | ||
| default_branch_item_rules | 1 | 3 | 0 | ||
| default_circ_rules | 4 | 0 | |||
| deletedbiblio | 12 | 0 | stores information about bibliographic records that have been deleted | ||
| deletedbiblioitems | 32 | 0 | information about bibliographic records that have been deleted | ||
| deletedborrowers | 67 | 0 | stores data related to the patrons/borrowers you have deleted | ||
| deleteditems | 40 | 0 | |||
| ethnicity | 2 | 0 | |||
| export_format | 8 | 0 | Used for CSV export | ||
| fieldmapping | 5 | 0 | koha to keyword mapping | ||
| hold_fill_targets | 4 | 5 | 0 | ||
| import_batches | 1 | 14 | 0 | ||
| import_biblios | 1 | 9 | 0 | ||
| import_items | 1 | 7 | 0 | ||
| import_record_matches | 1 | 3 | 0 | ||
| import_records | 3 | 1 | 15 | 0 | |
| issues | 2 | 11 | 0 | information related to check outs or issues | |
| issuingrules | 19 | 0 | |||
| item_circulation_alert_preferences | 5 | 0 | |||
| items | 7 | 3 | 39 | 0 | holdings/item information |
| itemtypes | 2 | 6 | 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 | 3 | 7 | 0 | table for all notice templates in Koha | |
| marc_matchers | 3 | 5 | 0 | ||
| marc_subfield_structure | 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 | 3 | 1 | 0 | ||
| message_transports | 5 | 6 | 0 | ||
| messages | 6 | 0 | circulation messages left via the patron's check out screen | ||
| need_merge_authorities | 3 | 0 | keeping track of authority records still to be merged by merge_authority cron job (used only if pref dontmerge is ON) | ||
| notifys | 7 | 0 | |||
| nozebra | 4 | 0 | |||
| oai_sets | 3 | 3 | 0 | ||
| oai_sets_biblios | 2 | 2 | 0 | ||
| oai_sets_descriptions | 1 | 2 | 0 | ||
| oai_sets_mappings | 1 | 4 | 0 | ||
| old_issues | 2 | 11 | 0 | lists items that were checked out and have been returned | |
| old_reserves | 18 | 0 | this table holds all holds/reserves that have been completed (either filled or cancelled) | ||
| opac_news | 7 | 0 | data from the news tool | ||
| overduerules | 11 | 0 | overdue notice status and triggers | ||
| patroncards | 1 | 4 | 0 | ||
| patronimage | 1 | 3 | 0 | ||
| pending_offline_operations | 7 | 0 | |||
| permissions | 2 | 1 | 3 | 0 | |
| printers | 3 | 0 | |||
| printers_profile | 10 | 0 | |||
| ratings | 4 | 0 | |||
| 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 | ||
| reserveconstraints | 5 | 0 | |||
| reserves | 18 | 0 | information related to holds/reserves in Koha | ||
| reviews | 2 | 6 | 0 | patron opac comments | |
| roadtype | 2 | 0 | road types defined in administration and used in patron management | ||
| saved_reports | 4 | 0 | |||
| saved_sql | 11 | 0 | |||
| search_history | 6 | 0 | Opac search history results | ||
| serial | 1 | 11 | 0 | ||
| serialitems | 2 | 2 | 0 | ||
| services_throttle | 2 | 0 | |||
| sessions | 2 | 0 | |||
| social_data | 7 | 0 | |||
| special_holidays | 8 | 0 | non repeatable holidays/library closings | ||
| statistics | 11 | 0 | information related to transactions (circulation and fines) in Koha | ||
| stopwords | 1 | 0 | |||
| subscription | 1 | 51 | 0 | ||
| subscriptionhistory | 8 | 0 | |||
| subscriptionroutinglist | 2 | 4 | 0 | information related to the routing lists attached to subscriptions | |
| suggestions | 32 | 0 | purchase suggestions | ||
| systempreferences | 5 | 0 | global system preferences | ||
| tags | 2 | 0 | |||
| tags_all | 2 | 6 | 0 | ||
| tags_approval | 1 | 1 | 5 | 0 | |
| tags_index | 2 | 3 | 0 | ||
| tmp_holdsqueue | 15 | 0 | |||
| user_permissions | 3 | 3 | 0 | ||
| userflags | 1 | 4 | 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 | 16 | 0 | connection information for the Z39.50 targets used in cataloging | ||
| zebraqueue | 6 | 0 | |||
| 140 Tables | 1,282 | 0 | |||
| 0 Views | 0 |