TABLES
209
VIEWS
0
COLUMNS
1922
Constraints
242
Anomalies
48
Routines
0
Database Properties
Database Type: MySQL - 5.5.5-10.3.21-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 | 20 | 0 | Table | |
| import_records | 4 | 1 | 14 | 0 | Table | |
| oai_sets_descriptions | 0 | 1 | 2 | 0 | Table | |
| search_field | 1 | 1 | 8 | 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 | |
| club_holds | 1 | 3 | 5 | 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 | |
| borrower_relationships | 0 | 2 | 4 | 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 | |
| aqcontract | 1 | 1 | 6 | 0 | Table | |
| housebound_profile | 1 | 1 | 8 | 0 | Table | |
| statistics | 0 | 2 | 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 | 9 | 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 | |
| account_credit_types_branches | 0 | 2 | 2 | 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 | |
| itemtypes_branches | 0 | 2 | 2 | 0 | Table | |
| misc_files | 0 | 1 | 8 | 0 | Table | |
| printers | 0 | 0 | 3 | 0 | Table | |
| auth_tag_structure | 0 | 1 | 7 | 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 | |
| account_credit_types | 2 | 0 | 4 | 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 | |
| club_holds_to_patron_holds | 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 | 33 | 0 | 23 | 0 | Table | |
| reserves | 1 | 5 | 20 | 0 | Table | |
| deletedbiblioitems | 0 | 2 | 32 | 0 | Table | |
| sessions | 0 | 0 | 2 | 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 | 7 | 18 | 0 | Table | |
| article_requests | 0 | 4 | 17 | 0 | Table | |
| auth_subfield_structure | 0 | 1 | 17 | 0 | Table | |
| matchpoint_components | 1 | 1 | 7 | 0 | Table | |
| sms_providers | 1 | 1 | 3 | 0 | Table | |
| cash_registers | 1 | 1 | 7 | 0 | Table | |
| ratings | 0 | 2 | 4 | 0 | Table | |
| plugin_methods | 0 | 0 | 2 | 0 | Table | |
| message_queue | 0 | 2 | 12 | 0 | Table | |
| return_claims | 0 | 6 | 12 | 0 | Table | |
| stockrotationitems | 0 | 2 | 4 | 0 | Table | |
| serialitems | 0 | 2 | 2 | 0 | Table | |
| biblioitems | 1 | 3 | 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 | 1 | 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 | 3 | 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 | 16 | 1 | 16 | 0 | Table | |
| audio_alerts | 0 | 0 | 4 | 0 | Table | |
| overduerules_transport_types | 0 | 2 | 4 | 0 | Table | |
| borrowers | 56 | 3 | 75 | 0 | Table | |
| deletedbiblio | 1 | 1 | 16 | 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 | 16 | 5 | 45 | 0 | Table | |
| marc_modification_template_actions | 0 | 1 | 20 | 0 | Table | |
| search_marc_to_field | 0 | 2 | 6 | 0 | Table | |
| clubs | 3 | 2 | 9 | 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 | |
| account_debit_types_branches | 0 | 2 | 2 | 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 | |
| account_debit_types | 2 | 0 | 6 | 0 | Table | |
| housebound_role | 0 | 1 | 3 | 0 | Table | |
| issues | 1 | 2 | 16 | 0 | Table | |
| aqinvoices | 2 | 3 | 9 | 0 | Table |