SchemaSpy Analysis of testsql_comments Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jul 16 08:37 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 16 0
action_logs 8 0
additional_field_values 1 4 0
additional_fields 1 6 0
alert 4 0
api_keys 1 5 0
aqbasket 3 4 16 0
aqbasketgroups 1 1 8 0
aqbasketusers 2 2 0
aqbooksellers 7 2 26 0
aqbudgetborrowers 2 2 0
aqbudgetperiods 9 0
aqbudgets 6 15 0
aqbudgets_planning 1 7 0
aqcontacts 1 14 0
aqcontract 1 1 6 0
aqinvoices 1 3 9 0
aqorder_users 2 2 0
aqorders 4 6 49 0
aqorders_items 1 3 0
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
authorised_values_branches 2 2 0
biblio 14 12 0
biblio_framework 2 0
biblio_metadata 1 6 0
biblioimages 1 5 0
biblioitems 1 1 32 0
borrower_attribute_types 2 11 0
borrower_attribute_types_branches 2 2 0
borrower_attributes 2 4 0
borrower_debarments 1 8 0
borrower_files 1 7 0
borrower_message_preferences 1 3 6 0
borrower_message_transport_preferences 2 2 0
borrower_modifications 69 0
borrower_password_recovery 3 0
borrower_sync 1 7 0
borrowers 41 3 74 0
branch_borrower_circ_rules 2 4 0
branch_item_rules 2 5 0
branch_transfer_limits 5 0
branches 27 22 0
branchtransfers 3 7 0
browser 5 0
categories 5 17 0
categories_branches 2 2 0
cities 5 0
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 8 0
default_borrower_circ_rules 1 3 0
default_branch_circ_rules 1 6 0
default_branch_item_rules 1 4 0
default_circ_rules 6 0
deletedbiblio 1 12 0
deletedbiblio_metadata 1 6 0
deletedbiblioitems 32 0
deletedborrowers 74 0
deleteditems 45 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
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
import_biblios 1 9 0
import_items 1 7 0
import_record_matches 1 3 0
import_records 4 1 15 0
issues 2 15 0
issuingrules 34 0
item_circulation_alert_preferences 5 0
items 12 4 45 0
items_last_borrower 2 4 0
items_search_fields 1 5 0
itemtypes 4 13 0
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
library_groups 1 2 10 0
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 9 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
misc_files 8 0
need_merge_authorities 6 0
oai_sets 3 3 0
oai_sets_biblios 1 2 0
oai_sets_descriptions 1 2 0
oai_sets_mappings 1 5 0
oauth_access_tokens 3 0
old_issues 2 15 0
old_reserves 4 19 0
opac_news 2 9 0
overduerules 1 12 0
overduerules_transport_types 2 4 0
patron_list_patrons 2 3 0
patron_lists 1 1 3 0
patronimage 1 3 0
pending_offline_operations 8 0
permissions 2 1 3 0
plugin_data 3 0
printers 3 0
printers_profile 10 0
quotes 4 0
ratings 2 4 0
refund_lost_item_fee_rules 2 0
repeatable_holidays 7 0
reports_dictionary 7 0
reserves 5 19 0
reviews 2 6 0
saved_reports 4 0
saved_sql 14 0
search_field 1 4 0
search_history 8 0 Opac search history results
search_marc_map 1 4 0
search_marc_to_field 2 5 0
serial 1 15 0
serialitems 2 2 0
services_throttle 2 0
sessions 2 0
sms_providers 1 3 0
social_data 7 0
special_holidays 8 0
statistics 13 0
subscription 2 2 42 0
subscription_frequencies 1 6 0
subscription_numberpatterns 1 23 0
subscriptionhistory 8 0
subscriptionroutinglist 2 4 0
suggestions 1 31 0
systempreferences 5 0
tags 2 0
tags_all 2 6 0
tags_approval 1 1 5 0
tags_index 2 3 0
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
virtualshelfshares 2 5 0
virtualshelves 2 1 9 0
z3950servers 17 0
zebraqueue 6 0
           
198 Tables     1,836 0  
0 Views     0