SchemaSpy Analysis of testsql_comments Generated by
SchemaSpy
Generated by SchemaSpy on Tue Dec 27 18:01 NZDT 2016
Database Type: MySQL - 5.5.5-10.1.20-MariaDB-3 SourceForge.net


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

Table Children Parents Columns Rows Comments
accountlines 2 16 0
accountoffsets 1 5 0
action_logs 7 0
alert 4 0
aqbasket 2 4 14 0
aqbasketgroups 1 1 8 0
aqbasketusers 2 2 0
aqbooksellers 5 2 26 0
aqbudgetborrowers 2 2 0
aqbudgetperiods 9 0
aqbudgets 3 15 0
aqbudgets_planning 1 7 0
aqcontacts 1 13 0
aqcontract 1 1 6 0
aqinvoices 1 2 8 0
aqorders 3 4 37 0
aqorders_items 1 3 0
aqorders_transfers 2 3 0
auth_header 9 0
auth_subfield_structure 17 0
auth_tag_structure 1 7 0
auth_types 1 4 0
authorised_values 2 6 0
authorised_values_branches 2 2 0
biblio 12 12 0
biblio_framework 2 0
biblioimages 1 5 0
biblioitems 1 1 34 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_sync 1 7 0
borrowers 30 2 67 0
branch_borrower_circ_rules 2 3 0
branch_item_rules 2 4 0
branch_transfer_limits 5 0
branchcategories 1 5 0
branches 21 20 0
branchrelations 2 2 0
branchtransfers 3 6 0
browser 5 0
categories 5 16 0
categories_branches 2 2 0
cities 5 0
class_sort_rules 1 3 0
class_sources 1 4 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 14 0
creator_templates 18 0
currency 2 6 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
deletedbiblioitems 34 0
deletedborrowers 67 0
deleteditems 42 0
ethnicity 2 0
export_format 9 0 Used for CSV export
fieldmapping 5 0
hold_fill_targets 4 5 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 13 0
issuingrules 24 0
item_circulation_alert_preferences 5 0
items 10 3 42 0
items_search_fields 1 5 0
itemtypes 2 9 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 3 1 8 0
linktracker 6 0
marc_matchers 3 5 0
marc_modification_template_actions 1 20 0
marc_modification_templates 1 2 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 5 1 0
message_transports 5 6 0
messages 6 0
misc_files 8 0
need_merge_authorities 3 0
notifys 7 0
oai_sets 3 3 0
oai_sets_biblios 2 2 0
oai_sets_descriptions 1 2 0
oai_sets_mappings 1 5 0
old_issues 2 13 0
old_reserves 3 19 0
opac_news 1 8 0
overduerules 2 11 0
overduerules_transport_types 3 5 0
patron_list_patrons 2 3 0
patron_lists 1 1 3 0
patroncards 1 4 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
repeatable_holidays 7 0
reports_dictionary 7 0
reserveconstraints 5 0
reserves 4 19 0
reviews 2 6 0
saved_reports 4 0
saved_sql 14 0
search_history 7 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
statistics 12 0
stopwords 1 0
subscription 2 2 40 0
subscription_frequencies 1 6 0
subscription_numberpatterns 1 23 0
subscriptionhistory 8 0
subscriptionroutinglist 2 4 0
suggestions 32 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
user_permissions 3 3 0
userflags 1 4 0
virtualshelfcontents 3 5 0
virtualshelfshares 2 5 0
virtualshelves 2 1 9 0
z3950servers 17 0
zebraqueue 6 0
           
168 Tables     1,556 0  
0 Views     0