TABLES
205
VIEWS
0
COLUMNS
1884
Constraints
214
Anomalies
39
Routines
0
Database Properties
Database Type: MySQL - 5.5.5-10.3.12-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 | |
linktracker | 0 | 0 | 6 | 0 | Table | |
marc_subfield_structure | 0 | 1 | 18 | 0 | Table | |
creator_batches | 0 | 3 | 8 | 0 | Table | |
old_reserves | 0 | 4 | 19 | 0 | Table | |
import_records | 4 | 1 | 15 | 0 | Table | |
oai_sets_descriptions | 0 | 1 | 2 | 0 | Table | |
search_field | 1 | 1 | 5 | 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 | 6 | 0 | 17 | 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 | 1 | 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 | 13 | 0 | Table | |
tags_all | 0 | 2 | 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 | 13 | 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 | 14 | 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 | 0 | 74 | 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 | 1 | 1 | 5 | 0 | Table | |
pending_offline_operations | 0 | 0 | 8 | 0 | Table | |
misc_files | 0 | 1 | 8 | 0 | Table | |
branch_borrower_circ_rules | 0 | 2 | 4 | 0 | Table | |
printers | 0 | 0 | 3 | 0 | Table | |
auth_tag_structure | 0 | 1 | 7 | 0 | Table | |
default_branch_circ_rules | 0 | 1 | 6 | 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 | 2 | 17 | 0 | Table | |
item_circulation_alert_preferences | 0 | 0 | 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 | 0 | 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 | 36 | 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 | 30 | 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 | 1 | 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 | 2 | 15 | 0 | Table | |
article_requests | 0 | 4 | 17 | 0 | Table | |
default_circ_rules | 0 | 0 | 6 | 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 | 0 | 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 | 42 | 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 | 14 | 1 | 12 | 0 | Table | |
audio_alerts | 0 | 0 | 4 | 0 | Table | |
overduerules_transport_types | 0 | 2 | 4 | 0 | Table | |
borrowers | 43 | 3 | 74 | 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 | 13 | 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 | |
borrower_message_preferences | 1 | 3 | 6 | 0 | Table | |
biblioimages | 0 | 1 | 5 | 0 | Table | |
aqbooksellers | 7 | 3 | 26 | 0 | Table | |
borrower_modifications | 0 | 0 | 70 | 0 | Table | |
reviews | 0 | 2 | 6 | 0 | Table | |
aqcontacts | 0 | 1 | 14 | 0 | Table | |
collections | 1 | 1 | 4 | 0 | Table | |
suggestions | 0 | 3 | 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 | |
default_borrower_circ_rules | 0 | 1 | 3 | 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 | |
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 | |
issues | 0 | 2 | 16 | 0 | Table | |
housebound_role | 0 | 1 | 3 | 0 | Table | |
aqinvoices | 2 | 3 | 9 | 0 | Table |