Columns
Table | Type | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|---|
sessions | Table | a_session | LONGTEXT | 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 |
||
illrequests | Table | accessurl | VARCHAR | 500 | √ | null | ||
accountlines | Table | accountlines_id | INT | 10 | √ | null | ||
aqbooksellers | Table | accountnumber | LONGTEXT | 2147483647 | √ | null | unused in Koha |
|
issuingrules | Table | accountsent | INT | 10 | √ | null | not used? always NULL |
|
aqcontacts | Table | acqprimary | BIT | 0 | 0 | is this the primary contact for acquisitions messages |
||
marc_modification_template_actions | Table | action | enum('delete_field', 'add_field', 'update_field', 'move_field', 'copy_field', 'copy_and_replace_field') | 22 | null | |||
pending_offline_operations | Table | action | VARCHAR | 10 | 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 |
|
currency | Table | active | BIT | 0 | √ | null | ||
stockrotationrotas | Table | active | BIT | 0 | 0 | |||
aqbooksellers | Table | active | TINYINT | 3 | √ | null | is this vendor active (1 for yes, 0 for no) |
|
api_keys | Table | active | BIT | 0 | 1 | |||
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 | ||
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 |
|
borrower_modifications | Table | address | LONGTEXT | 2147483647 | √ | null | ||
aqbooksellers | Table | address1 | LONGTEXT | 2147483647 | √ | null | first line of vendor physical address |
|
borrowers | Table | address2 | MEDIUMTEXT | 16777215 | √ | null | the second address line for your patron/borrower's primary address |
|
borrower_modifications | Table | address2 | MEDIUMTEXT | 16777215 | √ | null | ||
deletedborrowers | 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 |
|
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 |
|
deletedbiblioitems | Table | agerestriction | VARCHAR | 255 | √ | null | target audience/age restriction from the bib record (MARC21 521$a) |
|
biblioitems | Table | agerestriction | VARCHAR | 255 | √ | null | target audience/age restriction from the bib record (MARC21 521$a) |
|
alert | Table | alertid | INT | 10 | √ | null | ||
virtualshelves | Table | allow_change_from_others | BIT | 0 | √ | 0 | can others change contents? |
|
virtualshelves | Table | allow_change_from_owner | BIT | 0 | √ | 1 | can owner change contents? |
|
borrower_modifications | Table | altcontactaddress1 | VARCHAR | 255 | √ | null | ||
borrowers | Table | altcontactaddress1 | VARCHAR | 255 | √ | null | the first address line for the alternate contact for the patron/borrower |
|
deletedborrowers | Table | altcontactaddress1 | VARCHAR | 255 | √ | null | the first address line for the alternate contact for the patron/borrower |
|
deletedborrowers | Table | altcontactaddress2 | VARCHAR | 255 | √ | null | the second address line for the alternate contact for the patron/borrower |
|
borrower_modifications | Table | altcontactaddress2 | VARCHAR | 255 | √ | null | ||
borrowers | Table | altcontactaddress2 | VARCHAR | 255 | √ | null | the second address line for the alternate contact for the patron/borrower |
|
borrowers | Table | altcontactaddress3 | VARCHAR | 255 | √ | null | the city for the alternate contact for the patron/borrower |
|
borrower_modifications | Table | altcontactaddress3 | VARCHAR | 255 | √ | null | ||
deletedborrowers | Table | altcontactaddress3 | VARCHAR | 255 | √ | null | the city for the alternate contact for the patron/borrower |