Columns
Table | Type | Column | Type | Size | Nullable | Auto | Default | Comments |
---|---|---|---|---|---|---|---|---|
sessions | Table | a_session | LONGBLOB | 2147483647 | null | |||
deletedbiblio | Table | abstract | LONGTEXT | 2147483647 | √ | null | summary from the MARC record (520$a in MARC21) | |
biblio | Table | abstract | LONGTEXT | 2147483647 | √ | null | summary from the MARC record (520$a in MARC21) | |
suggestions | Table | acceptedby | INT | 10 | √ | null | borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table | |
suggestions | Table | accepteddate | DATE | 10 | √ | null | date the suggestion was marked as accepted | |
oauth_access_tokens | Table | access_token | VARCHAR | 191 | null | generarated access token | ||
erm_eholdings_titles | Table | access_type | VARCHAR | 255 | √ | null | ||
illrequests | Table | accessurl | VARCHAR | 500 | √ | null | Potential URL for accessing item | |
aqbookseller_interfaces | Table | account_email | MEDIUMTEXT | 16777215 | √ | null | account email | |
accountlines | Table | accountlines_id | INT | 10 | √ | null | ||
aqbooksellers | Table | accountnumber | LONGTEXT | 2147483647 | √ | null | vendor account number | |
aqcontacts | Table | acqprimary | BIT | 0 | 0 | is this the primary contact for acquisitions messages | ||
pending_offline_operations | Table | action | VARCHAR | 10 | null | |||
marc_modification_template_actions | Table | action | enum('delete_field', 'add_field', 'update_field', 'move_field', 'copy_field', 'copy_and_replace_field') | 22 | null | |||
action_logs | Table | action | MEDIUMTEXT | 16777215 | √ | null | the action (includes things like DELETED, ADDED, MODIFY, etc) | |
action_logs | Table | action_id | INT | 10 | √ | null | unique identifier for each action | |
aqbooksellers | Table | active | TINYINT | 3 | √ | null | is this vendor active (1 for yes, 0 for no) | |
currency | Table | active | BIT | 0 | √ | null | ||
api_keys | Table | active | BIT | 0 | 1 | 0 means this API key is revoked | ||
stockrotationrotas | Table | active | BIT | 0 | 0 | Is this rota currently active? | ||
marc_overlay_rules | Table | add | BIT | 0 | 0 | |||
subscription_numberpatterns | Table | add1 | INT | 10 | √ | null | ||
subscription_numberpatterns | Table | add2 | INT | 10 | √ | null | ||
subscription_numberpatterns | Table | add3 | INT | 10 | √ | null | ||
z3950servers | Table | add_xslt | LONGTEXT | 2147483647 | √ | null | zero or more paths to XSLT files to be processed on the search results | |
language_subtag_registry | Table | added | DATE | 10 | √ | null | ||
borrower_modifications | Table | address | LONGTEXT | 2147483647 | √ | null | ||
deletedborrowers | Table | address | LONGTEXT | 2147483647 | √ | null | the first address line for your patron/borrower’s primary address | |
borrowers | Table | address | LONGTEXT | 2147483647 | √ | null | the first address line for your patron/borrower’s primary address | |
aqbooksellers | Table | address1 | LONGTEXT | 2147483647 | √ | null | first line of vendor physical address | |
deletedborrowers | Table | address2 | MEDIUMTEXT | 16777215 | √ | null | the second address line for your patron/borrower’s primary address | |
borrowers | Table | address2 | MEDIUMTEXT | 16777215 | √ | null | the second address line for your patron/borrower’s primary address | |
aqbooksellers | Table | address2 | LONGTEXT | 2147483647 | √ | null | second line of vendor physical address | |
borrower_modifications | Table | address2 | MEDIUMTEXT | 16777215 | √ | null | ||
aqbooksellers | Table | address3 | LONGTEXT | 2147483647 | √ | null | third line of vendor physical address | |
aqbooksellers | Table | address4 | LONGTEXT | 2147483647 | √ | null | fourth line of vendor physical address | |
aqinvoice_adjustments | Table | adjustment | DECIMAL | 28 | √ | null | amount of adjustment | |
aqinvoice_adjustments | Table | adjustment_id | INT | 10 | √ | null | primary key for adjustments | |
biblioitems | Table | agerestriction | VARCHAR | 255 | √ | null | target audience/age restriction from the bib record (MARC21 521$a) | |
deletedbiblioitems | Table | agerestriction | VARCHAR | 255 | √ | null | target audience/age restriction from the bib record (MARC21 521$a) | |
erm_agreements | Table | agreement_id | INT | 10 | √ | null | primary key | |
erm_eholdings_packages_agreements | Table | agreement_id | INT | 10 | null | link to the agreement | ||
erm_user_roles | Table | agreement_id | INT | 10 | √ | null | link to the agreement | |
erm_agreement_periods | Table | agreement_id | INT | 10 | null | link to the agreement | ||
erm_agreement_licenses | Table | agreement_id | INT | 10 | null | link to the agreement | ||
erm_agreement_relationships | Table | agreement_id | INT | 10 | null | link to the agreement | ||
erm_documents | Table | agreement_id | INT | 10 | √ | null | link to the agreement | |
erm_agreement_licenses | Table | agreement_license_id | INT | 10 | √ | null | primary key | |
erm_agreement_periods | Table | agreement_period_id | INT | 10 | √ | null | primary key | |
alert | Table | alertid | INT | 10 | √ | null |