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 |
---|---|---|---|---|---|---|
account_offset_types | 3 | 0 | 1 | 0 | Table | |
account_offsets | 0 | 3 | 6 | 0 | Table | |
accountlines | 2 | 4 | 16 | 0 | Table | |
action_logs | 0 | 0 | 8 | 0 | Table | |
additional_field_values | 0 | 1 | 4 | 0 | Table | |
additional_fields | 1 | 1 | 6 | 0 | Table | |
alert | 0 | 0 | 4 | 0 | Table | |
api_keys | 1 | 1 | 5 | 0 | Table | |
aqbasket | 3 | 4 | 16 | 0 | Table | |
aqbasketgroups | 1 | 1 | 8 | 0 | Table | |
aqbasketusers | 0 | 2 | 2 | 0 | Table | |
aqbooksellers | 7 | 3 | 26 | 0 | Table | |
aqbudgetborrowers | 0 | 2 | 2 | 0 | Table | |
aqbudgetperiods | 0 | 0 | 9 | 0 | Table | |
aqbudgets | 7 | 0 | 15 | 0 | Table | |
aqbudgets_planning | 0 | 1 | 7 | 0 | Table | |
aqcontacts | 0 | 1 | 14 | 0 | Table | |
aqcontract | 1 | 1 | 6 | 0 | Table | |
aqinvoice_adjustments | 0 | 2 | 8 | 0 | Table | |
aqinvoices | 2 | 3 | 9 | 0 | Table | |
aqorder_users | 0 | 2 | 2 | 0 | Table | |
aqorders | 4 | 7 | 51 | 0 | Table | |
aqorders_items | 0 | 1 | 3 | 0 | Table | |
aqorders_transfers | 0 | 2 | 3 | 0 | Table | |
article_requests | 0 | 4 | 17 | 0 | Table | |
audio_alerts | 0 | 0 | 4 | 0 | Table | |
auth_header | 0 | 1 | 9 | 0 | Table | |
auth_subfield_structure | 0 | 1 | 17 | 0 | Table | |
auth_tag_structure | 0 | 1 | 7 | 0 | Table | |
auth_types | 3 | 0 | 4 | 0 | Table | |
authorised_value_categories | 3 | 0 | 1 | 0 | Table | |
authorised_values | 2 | 1 | 6 | 0 | Table | |
authorised_values_branches | 0 | 2 | 2 | 0 | Table | |
biblio | 15 | 1 | 12 | 0 | Table | |
biblio_framework | 2 | 0 | 2 | 0 | Table | |
biblio_metadata | 0 | 1 | 6 | 0 | Table | |
biblioimages | 0 | 1 | 5 | 0 | Table | |
biblioitems | 1 | 2 | 32 | 0 | Table | |
borrower_attribute_types | 3 | 0 | 11 | 0 | Table | |
borrower_attribute_types_branches | 0 | 2 | 2 | 0 | Table | |
borrower_attributes | 0 | 2 | 4 | 0 | Table | |
borrower_debarments | 0 | 1 | 8 | 0 | Table | |
borrower_files | 0 | 2 | 7 | 0 | Table | |
borrower_message_preferences | 1 | 3 | 6 | 0 | Table | |
borrower_message_transport_preferences | 0 | 2 | 2 | 0 | Table | |
borrower_modifications | 0 | 1 | 70 | 0 | Table | |
borrower_password_recovery | 0 | 0 | 3 | 0 | Table | |
borrowers | 49 | 3 | 75 | 0 | Table | |
branch_item_rules | 0 | 2 | 5 | 0 | Table | |
branch_transfer_limits | 0 | 0 | 5 | 0 | Table |