Tables


SchemaSpy Analysis of testsql_comments

Generated on Thu Jun 20 14:10 NZST 2019

XML Representation
Insertion Order Deletion Order
TABLES 204
VIEWS 0
COLUMNS 1879
Constraints 222
Anomalies 43
Routines 0

Database Properties

Database Type: MySQL - 5.5.5-10.3.15-MariaDB-2-log

Tables

Table / View Children Parents Columns Rows Type Comments
borrower_files 0 2 7 0 Table
marc_matchers 3 1 5 0 Table
subscription_frequencies 1 0 6 0 Table
marc_subfield_structure 0 1 18 0 Table
linktracker 0 0 6 0 Table
creator_batches 0 3 8 0 Table
old_reserves 0 4 19 0 Table
import_records 4 1 14 0 Table
oai_sets_descriptions 0 1 2 0 Table
search_field 1 1 6 0 Table
items_search_fields 9 1 5 0 Table
borrower_debarments 0 1 8 0 Table
account_offset_types 3 0 1 0 Table
categories 8 0 19 0 Table
club_template_fields 1 1 5 0 Table
club_enrollment_fields 0 2 4 0 Table
discharges 0 1 4 0 Table
additional_field_values 0 1 4 0 Table
matcher_matchpoints 0 2 2 0 Table
biblio_framework 2 0 2 0 Table
vendor_edi_accounts 1 2 19 0 Table
message_attributes 2 0 3 0 Table
saved_reports 0 0 4 0 Table
oai_sets 3 0 3 0 Table
need_merge_authorities 0 0 6 0 Table
tags 0 0 2 0 Table
branchtransfers 0 3 7 0 Table
class_sources 4 2 5 0 Table
aqorder_users 0 2 2 0 Table
oai_sets_biblios 0 1 2 0 Table
aqbudgets_planning 0 1 7 0 Table
social_data 2 0 7 0 Table
language_subtag_registry 0 0 5 0 Table
zebraqueue 0 0 6 0 Table
creator_layouts 0 0 15 0 Table
language_descriptions 0 0 5 0 Table
messages 0 2 7 0 Table
account_offsets 0 3 6 0 Table
aqinvoice_adjustments 0 2 8 0 Table
action_logs 0 0 8 0 Table
serial 1 0 15 0 Table
branch_item_rules 0 2 5 0 Table
aqcontract 1 1 6 0 Table
default_branch_item_rules 0 1 4 0 Table
housebound_profile 1 1 8 0 Table
statistics 0 1 10 0 Table
tags_all 0 3 6 0 Table
opac_news 0 2 9 0 Table
subscriptionhistory 0 0 8 0 Table
illcomments 0 2 5 0 Table
printers_profile 0 0 10 0 Table
search_history 0 1 8 0 Table

Opac search history results

old_issues 0 2 16 0 Table
courses 2 1 11 0 Table
language_script_bidi 0 0 2 0 Table
quotes 0 0 4 0 Table
illrequestattributes 0 1 4 0 Table
borrower_message_transport_preferences 0 2 2 0 Table
deleteditems 0 1 45 0 Table
itemtypes 5 0 15 0 Table
alert 0 0 4 0 Table
borrower_password_recovery 0 0 3 0 Table
club_templates 3 1 9 0 Table
saved_sql 0 1 15 0 Table
creator_templates 0 0 18 0 Table
search_marc_map 1 0 4 0 Table
additional_fields 1 1 6 0 Table
deletedborrowers 0 1 75 0 Table
import_auths 0 1 5 0 Table
aqbudgets 7 0 15 0 Table
language_script_mapping 0 0 2 0 Table
library_groups 1 2 10 0 Table
matchpoint_component_norms 0 1 3 0 Table
virtualshelfshares 0 2 5 0 Table
aqbasket 3 4 16 0 Table
authorised_values_branches 0 2 2 0 Table
patronimage 0 1 3 0 Table
borrower_attribute_types 3 0 11 0 Table
authorised_value_categories 3 0 1 0 Table
matchchecks 0 3 4 0 Table
tags_approval 2 1 5 0 Table
pending_offline_operations 0 0 8 0 Table
misc_files 0 1 8 0 Table
printers 0 0 3 0 Table
auth_tag_structure 0 1 7 0 Table
default_branch_circ_rules 0 1 4 0 Table
plugin_data 0 0 3 0 Table
patron_consent 0 1 5 0 Table
browser 0 0 5 0 Table
aqbasketusers 0 2 2 0 Table
aqbasketgroups 1 1 8 0 Table
illrequests 2 3 18 0 Table
item_circulation_alert_preferences 0 1 5 0 Table
class_sort_rules 1 0 3 0 Table
oauth_access_tokens 0 1 3 0 Table
course_items 1 2 8 0 Table
tmp_holdsqueue 0 1 15 0 Table
columns_settings 0 0 6 0 Table
user_permissions 0 3 3 0 Table
biblio_metadata 0 1 6 0 Table
housebound_visit 0 3 6 0 Table
tags_index 0 2 3 0 Table
subscriptionroutinglist 0 2 4 0 Table
branches_overdrive 0 1 2 0 Table
currency 5 0 8 0 Table
collections_tracking 0 1 3 0 Table
issuingrules 0 0 33 0 Table
reports_dictionary 0 1 7 0 Table
patron_lists 1 2 4 0 Table
course_instructors 0 2 2 0 Table
import_items 0 1 7 0 Table
aqbudgetperiods 0 0 9 0 Table
branches 31 0 23 0 Table
reserves 0 5 19 0 Table
deletedbiblioitems 0 1 32 0 Table
sessions 0 0 2 0 Table
fieldmapping 0 0 5 0 Table
borrower_attributes 0 2 4 0 Table
categories_branches 0 2 2 0 Table
special_holidays 0 0 8 0 Table
uploaded_files 0 0 10 0 Table
club_fields 0 2 4 0 Table
deletedbiblio_metadata 0 1 6 0 Table
api_keys 1 1 5 0 Table
import_biblios 0 2 9 0 Table
authorised_values 2 1 6 0 Table
localization 0 0 5 0 Table
virtualshelves 2 1 9 0 Table
import_record_matches 0 1 3 0 Table
marc_tag_structure 0 0 9 0 Table
oai_sets_mappings 0 1 5 0 Table
systempreferences 0 0 5 0 Table
aqorders_items 0 1 3 0 Table
accountlines 2 4 16 0 Table
article_requests 0 4 17 0 Table
default_circ_rules 0 0 4 0 Table
auth_subfield_structure 0 1 17 0 Table
matchpoint_components 1 1 7 0 Table
sms_providers 1 1 3 0 Table
ratings 0 2 4 0 Table
message_queue 0 2 12 0 Table
stockrotationitems 0 2 4 0 Table
serialitems 0 2 2 0 Table
biblioitems 1 2 32 0 Table
edifact_messages 1 3 10 0 Table
class_split_rules 1 0 4 0 Table
stockrotationrotas 1 0 5 0 Table
export_format 0 0 10 0 Table

Used for CSV export

matchpoints 4 1 4 0 Table
branch_transfer_limits 0 0 5 0 Table
overduerules 1 1 12 0 Table
aqorders 4 7 51 0 Table
patron_list_patrons 0 2 3 0 Table
club_template_enrollment_fields 1 1 5 0 Table
subscription 2 2 43 0 Table
aqorders_transfers 0 2 3 0 Table
items_last_borrower 0 2 4 0 Table
auth_header 0 1 9 0 Table
biblio 15 1 12 0 Table
audio_alerts 0 0 4 0 Table
overduerules_transport_types 0 2 4 0 Table
borrowers 49 3 75 0 Table
deletedbiblio 1 1 12 0 Table
repeatable_holidays 0 0 7 0 Table
letter 0 1 9 0 Table
permissions 2 1 3 0 Table
borrower_attribute_types_branches 0 2 2 0 Table
circulation_rules 0 3 6 0 Table
items 14 5 45 0 Table
marc_modification_template_actions 0 1 20 0 Table
search_marc_to_field 0 2 5 0 Table
clubs 2 2 9 0 Table
refund_lost_item_fee_rules 0 0 2 0 Table
biblioimages 0 1 5 0 Table
borrower_message_preferences 1 3 6 0 Table
aqbooksellers 7 3 26 0 Table
borrower_modifications 0 1 70 0 Table
reviews 0 2 6 0 Table
aqcontacts 0 1 14 0 Table
collections 1 1 4 0 Table
suggestions 0 9 31 0 Table
creator_images 0 0 3 0 Table
message_transport_types 5 0 1 0 Table
hold_fill_targets 0 4 5 0 Table
edifact_ean 0 1 5 0 Table
club_enrollments 1 3 8 0 Table
course_reserves 0 2 6 0 Table
subscription_numberpatterns 1 0 23 0 Table
aqbudgetborrowers 0 2 2 0 Table
message_transports 0 2 6 0 Table
cities 0 0 5 0 Table
virtualshelfcontents 0 3 5 0 Table
userflags 1 0 4 0 Table
language_rfc4646_to_iso639 0 0 3 0 Table
marc_modification_templates 1 0 2 0 Table
stockrotationstages 1 2 5 0 Table
keyboard_shortcuts 0 0 2 0 Table
import_batches 1 0 15 0 Table
transport_cost 0 2 4 0 Table
auth_types 3 0 4 0 Table
z3950servers 0 0 17 0 Table
housebound_role 0 1 3 0 Table
issues 0 2 16 0 Table
aqinvoices 2 3 9 0 Table