SchemaSpy Analysis of testsql_comments - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jun 26 10:02 NZST 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

testsql_comments contains 1796 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
biblio abstract mediumtext 16777215  √  null summary from the MARC record (520$a in MARC21)
deletedbiblio abstract mediumtext 16777215  √  null summary from the MARC record (520$a in MARC21)
suggestions acceptedby int 10  √  null borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table
suggestions accepteddate date 10  √  null date the suggestion was marked as accepted
aqbooksellers accountnumber mediumtext 16777215  √  null unused in Koha
issuingrules accountsent int 10  √  null not used? always NULL
accountlines accounttype varchar 5  √  null
action_logs action text 65535  √  null the action (includes things like DELETED, ADDED, MODIFY, etc)
aqbooksellers active tinyint 3  √  null is this vendor active (1 for yes, 0 for no)
currency active bit 0  √  null
subscription_numberpatterns add1 int 10  √  null
subscription_numberpatterns add2 int 10  √  null
subscription_numberpatterns add3 int 10  √  null
z3950servers add_xslt mediumtext 16777215  √  null zero or more paths to XSLT files to be processed on the search results
language_subtag_registry added date 10  √  null
borrower_modifications address mediumtext 16777215  √  null
aqbooksellers address1 mediumtext 16777215  √  null first line of vendor physical address
aqbooksellers address2 mediumtext 16777215  √  null second line of vendor physical address
borrower_modifications address2 text 65535  √  null
borrowers address2 text 65535  √  null the second address line for your patron/borrower's primary address
deletedborrowers address2 text 65535  √  null the second address line for your patron/borrower's primary address
aqbooksellers address3 mediumtext 16777215  √  null third line of vendor physical address
aqbooksellers address4 mediumtext 16777215  √  null fourth line of vendor physical address
biblioitems agerestriction varchar 255  √  null target audience/age restriction from the bib record (MARC21 521$a)
deletedbiblioitems agerestriction varchar 255  √  null target audience/age restriction from the bib record (MARC21 521$a)
virtualshelves allow_add bit 0  √  0 permission for adding entries to list
virtualshelves allow_delete_other bit 0  √  0 permission for deleting entries from list that another person added
virtualshelves allow_delete_own bit 0  √  1 permission for deleting entries frm list that you added yourself
borrower_modifications altcontactaddress1 varchar 255  √  null
borrowers altcontactaddress1 varchar 255  √  null the first address line for the alternate contact for the patron/borrower
deletedborrowers altcontactaddress1 varchar 255  √  null the first address line for the alternate contact for the patron/borrower
borrower_modifications altcontactaddress2 varchar 255  √  null
borrowers altcontactaddress2 varchar 255  √  null the second address line for the alternate contact for the patron/borrower
deletedborrowers altcontactaddress2 varchar 255  √  null the second address line for the alternate contact for the patron/borrower
borrower_modifications altcontactaddress3 varchar 255  √  null
borrowers altcontactaddress3 varchar 255  √  null the city for the alternate contact for the patron/borrower
deletedborrowers altcontactaddress3 varchar 255  √  null the city for the alternate contact for the patron/borrower
borrower_modifications altcontactcountry text 65535  √  null
borrowers altcontactcountry text 65535  √  null the country for the alternate contact for the patron/borrower
deletedborrowers altcontactcountry text 65535  √  null the country for the alternate contact for the patron/borrower
borrower_modifications altcontactfirstname varchar 255  √  null
borrowers altcontactfirstname varchar 255  √  null first name of alternate contact for the patron/borrower
deletedborrowers altcontactfirstname varchar 255  √  null first name of alternate contact for the patron/borrower
borrower_modifications altcontactphone varchar 50  √  null
borrowers altcontactphone varchar 50  √  null the phone number for the alternate contact for the patron/borrower
deletedborrowers altcontactphone varchar 50  √  null the phone number for the alternate contact for the patron/borrower
borrower_modifications altcontactstate text 65535  √  null
borrowers altcontactstate text 65535  √  null the state for the alternate contact for the patron/borrower
deletedborrowers altcontactstate text 65535  √  null the state for the alternate contact for the patron/borrower
borrower_modifications altcontactsurname varchar 255  √  null
borrowers altcontactsurname varchar 255  √  null surname or last name of the alternate contact for the patron/borrower
deletedborrowers altcontactsurname varchar 255  √  null surname or last name of the alternate contact for the patron/borrower
borrower_modifications altcontactzipcode varchar 50  √  null
borrowers altcontactzipcode varchar 50  √  null the zipcode for the alternate contact for the patron/borrower
deletedborrowers altcontactzipcode varchar 50  √  null the zipcode for the alternate contact for the patron/borrower
aqcontacts altphone varchar 100  √  null contact's alternate phone number
accountlines amount decimal 28,6  √  null
pending_offline_operations amount decimal 28,6  √  null
accountlines amountoutstanding decimal 28,6  √  null
housebound_visit appointment_date date 10  √  null Date of visit.
reviews approved tinyint 3  √  0 whether this comment has been approved by a librarian (1 for yes, 0 for no)
tags_approval approved_by int 10  √  null the librarian who approved the tag (borrowers.borrowernumber)
subscription aqbooksellerid int 10  √  0 foreign key for aqbooksellers.id to link to the vendor
subscription aqbudgetid int 10  √  0
currency archived bit 0  √  0
statistics associatedborrower int 10  √  null unused in Koha
borrower_attributes attribute varchar 255  √  null custom patron field value
need_merge_authorities authid_new bigint 19  √  null reference to optional new authority record
article_requests author text 65535  √  null
biblio author mediumtext 16777215  √  null statement of responsibility from MARC record (100$a in MARC21)
deletedbiblio author mediumtext 16777215  √  null statement of responsibility from MARC record (100$a in MARC21)
import_biblios author varchar 80  √  null
suggestions author varchar 80  √  null author of the suggested item
auth_subfield_structure authorised_value varchar 10  √  null
auth_tag_structure authorised_value varchar 10  √  null
marc_subfield_structure authorised_value varchar 32  √  null
marc_tag_structure authorised_value varchar 10  √  null
borrower_attribute_types authorised_value_category varchar 32  √  null foreign key from authorised_values that links this custom field to an authorized value category
club_template_enrollment_fields authorised_value_category varchar 16  √  null
club_template_fields authorised_value_category varchar 16  √  null
items_search_fields authorised_values_category varchar 32  √  null
aqbasket authorisedby varchar 10  √  null the borrowernumber of the person who created the basket
import_auths authorized_heading varchar 128  √  null
auth_header authtrees mediumtext 16777215  √  null
marc_subfield_structure authtypecode varchar 20  √  null
issues auto_renew bit 0  √  0 automatic renewal
issuingrules auto_renew bit 0  √  0 automatic renewal
old_issues auto_renew bit 0  √  0 automatic renewal
issues auto_renew_error varchar 32  √  null automatic renewal error
old_issues auto_renew_error varchar 32  √  null automatic renewal error
borrower_modifications B_address varchar 100  √  null
borrowers B_address varchar 100  √  null the first address line for your patron/borrower's alternate address
deletedborrowers B_address varchar 100  √  null the first address line for your patron/borrower's alternate address
borrower_modifications B_address2 text 65535  √  null
borrowers B_address2 text 65535  √  null the second address line for your patron/borrower's alternate address
deletedborrowers B_address2 text 65535  √  null the second address line for your patron/borrower's alternate address
borrower_attribute_types_branches b_branchcode varchar 10  √  null
borrower_modifications B_city mediumtext 16777215  √  null
borrowers B_city mediumtext 16777215  √  null the city or town for your patron/borrower's alternate address
deletedborrowers B_city mediumtext 16777215  √  null the city or town for your patron/borrower's alternate address
borrower_modifications B_country text 65535  √  null
borrowers B_country text 65535  √  null the country for your patron/borrower's alternate address
deletedborrowers B_country text 65535  √  null the country for your patron/borrower's alternate address
borrower_modifications B_email text 65535  √  null
borrowers B_email text 65535  √  null the patron/borrower's alternate email address
deletedborrowers B_email text 65535  √  null the patron/borrower's alternate email address
borrower_modifications B_phone mediumtext 16777215  √  null
borrowers B_phone mediumtext 16777215  √  null the patron/borrower's alternate phone number
deletedborrowers B_phone mediumtext 16777215  √  null the patron/borrower's alternate phone number
borrower_modifications B_state text 65535  √  null
borrowers B_state text 65535  √  null the state for your patron/borrower's alternate address
deletedborrowers B_state text 65535  √  null the state for your patron/borrower's alternate address
borrower_modifications B_streetnumber varchar 10  √  null
borrowers B_streetnumber varchar 10  √  null the house number for your patron/borrower's alternate address
deletedborrowers B_streetnumber varchar 10  √  null the house number for your patron/borrower's alternate address
borrower_modifications B_streettype varchar 50  √  null
borrowers B_streettype varchar 50  √  null the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
deletedborrowers B_streettype varchar 50  √  null the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
borrower_modifications B_zipcode varchar 25  √  null
borrowers B_zipcode varchar 25  √  null the zip or postal code for your patron/borrower's alternate address
deletedborrowers B_zipcode varchar 25  √  null the zip or postal code for your patron/borrower's alternate address
deleteditems barcode varchar 20  √  null item barcode (MARC21 952$p)
items barcode varchar 20  √  null item barcode (MARC21 952$p)
pending_offline_operations barcode varchar 20  √  null
tmp_holdsqueue barcode varchar 20  √  null
aqbasket basketgroupid int 10  √  null links this basket to its group (aqbasketgroups.id)
aqbasket basketname varchar 50  √  null name given to the basket at creation
aqorders basketno int 10  √  null links this order line to a specific basket (aqbasket.basketno)
edifact_messages basketno int 10  √  null
borrower_attribute_types_branches bat_code varchar 10  √  null
aqorders biblionumber int 10  √  null links the order to the biblio being ordered (biblio.biblionumber)
linktracker biblionumber int 10  √  null biblionumber of the record the link is from
old_reserves biblionumber int 10  √  null foreign key from the biblio table defining which bib record this hold is on
reviews biblionumber int 10  √  null foreign key from the biblio table defining which bibliographic record this comment is for
suggestions biblionumber int 10  √  null foreign key linking the suggestion to the biblio table after the suggestion has been ordered
tmp_holdsqueue biblionumber int 10  √  null
language_script_bidi bidi varchar 3  √  null rtl ltr
aqinvoices billingdate date 10  √  null
aqbasket billingplace varchar 10  √  null basket billing place
aqbasketgroups billingplace varchar 10  √  null
aqbooksellers bookselleremail mediumtext 16777215  √  null vendor email
aqbooksellers booksellerfax mediumtext 16777215  √  null vendor fax number
deleteditems booksellerid mediumtext 16777215  √  null where the item was purchased (MARC21 952$e)
items booksellerid mediumtext 16777215  √  null where the item was purchased (MARC21 952$e)
aqbasket booksellerinvoicenumber mediumtext 16777215  √  null appears to always be NULL
aqbasket booksellernote mediumtext 16777215  √  null the vendor note added at basket creation
aqbooksellers booksellerurl mediumtext 16777215  √  null unused in Koha
discharges borrower int 10  √  null
creator_batches borrower_number int 10  √  null
borrower_modifications borrowernotes mediumtext 16777215  √  null
borrowers borrowernotes mediumtext 16777215  √  null a note on the patron/borrower's account that is only visible in the staff client
deletedborrowers borrowernotes mediumtext 16777215  √  null a note on the patron/borrower's account that is only visible in the staff client
borrower_message_preferences borrowernumber int 10  √  null
issues borrowernumber int 10  √  null foreign key, linking this to the borrowers table for the patron this item was checked out to
linktracker borrowernumber int 10  √  null borrowernumber who clicked the link
message_queue borrowernumber int 10  √  null
old_issues borrowernumber int 10  √  null foreign key, linking this to the borrowers table for the patron this item was checked out to
old_reserves borrowernumber int 10  √  null foreign key from the borrowers table defining which patron this hold is for
opac_news borrowernumber int 10  √  null The user who created the news article
reviews borrowernumber int 10  √  null foreign key from the borrowers table defining which patron left this comment
saved_sql borrowernumber int 10  √  null the staff member who created this report (borrowers.borrowernumber)
statistics borrowernumber int 10  √  null foreign key from the borrowers table, links transaction to a specific borrower
tags_all borrowernumber int 10  √  null the patron who added the tag (borrowers.borrowernumber)
virtualshelfcontents borrowernumber int 10  √  null borrower number that created this list entry (only the first one is saved: no need for use in/as key)
virtualshelfshares borrowernumber int 10  √  null
aqbasket branch varchar 10  √  null basket branch
statistics branch varchar 10  √  null foreign key, branch where the transaction occurred
branches branchaddress1 mediumtext 16777215  √  null the first address line of for your library or branch
branches branchaddress2 mediumtext 16777215  √  null the second address line of for your library or branch
branches branchaddress3 mediumtext 16777215  √  null the third address line of for your library or branch
branches branchcity mediumtext 16777215  √  null the city or province for your library or branch
article_requests branchcode varchar 10  √  null
borrower_modifications branchcode varchar 10  √  null
categories_branches branchcode varchar 10  √  null
club_enrollments branchcode varchar 10  √  null
club_templates branchcode varchar 10  √  null
clubs branchcode varchar 10  √  null
import_batches branchcode varchar 10  √  null
import_items branchcode varchar 10  √  null
import_records branchcode varchar 10  √  null
issues branchcode varchar 10  √  null foreign key, linking to the branches table for the location the item was checked out
messages branchcode varchar 10  √  null foreign key linking the message to the branches table
old_issues branchcode varchar 10  √  null foreign key, linking to the branches table for the location the item was checked out
old_reserves branchcode varchar 10  √  null foreign key from the branches table defining which branch the patron wishes to pick this hold up at
opac_news branchcode varchar 10  √  null branch code users to create branch specific news, NULL is every branch.
reserves branchcode varchar 10  √  null foreign key from the branches table defining which branch the patron wishes to pick this hold up at
suggestions branchcode varchar 10  √  null foreign key linking the suggested branch to the branches table
branches branchcountry text 65535  √  null the county for your library or branch
branches branchemail mediumtext 16777215  √  null the primary email address for your library or branch
branches branchfax mediumtext 16777215  √  null the fax number for your library or branch
branches branchip varchar 15  √  null the IP address for your library or branch
branches branchnotes mediumtext 16777215  √  null notes related to your library or branch
branches branchphone mediumtext 16777215  √  null the primary phone for your library or branch
branches branchprinter varchar 100  √  null unused in Koha
branches branchreplyto mediumtext 16777215  √  null the email to be used as a Reply-To
branches branchreturnpath mediumtext 16777215  √  null the email to be used as Return-Path
branches branchstate mediumtext 16777215  √  null the state for your library or branch
branches branchurl mediumtext 16777215  √  null the URL for your library or branch's website
branches branchzip varchar 25  √  null the zip or postal code for your library or branch
aqbudgets budget_amount decimal 28,6  √  0.000000 total amount for this fund
aqbudgets budget_branchcode varchar 10  √  null branch that this fund belongs to (branches.branchcode)
aqbudgets budget_code varchar 30  √  null code assigned to the fund by the user
aqbudgets budget_encumb decimal 28,6  √  0.000000 not used in the code
aqbudgets budget_expend decimal 28,6  √  0.000000 not used in the code
aqbudgets budget_name varchar 80  √  null name assigned to the fund by the user
aqbudgets budget_notes mediumtext 16777215  √  null notes related to this fund
aqbudgets budget_owner_id int 10  √  null borrowernumber of the person who owns this fund (borrowers.borrowernumber)
aqbudgets budget_parent_id int 10  √  null if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
aqbudgetperiods budget_period_active bit 0  √  0 whether this budget is active or not (1 for yes, 0 for no)
aqbudgetperiods budget_period_description mediumtext 16777215  √  null description assigned to this budget
aqbudgets budget_period_id int 10  √  null id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)
aqbudgetperiods budget_period_locked bit 0  √  null whether this budget is locked or not (1 for yes, 0 for no)
aqbudgetperiods budget_period_total decimal 28,6  √  null total amount available in this budget
aqbudgets budget_permission int 10  √  0 level of permission for this fund (used only by the owner, only by the library, or anyone)
aqorders budgetdate date 10  √  null not used? always NULL
suggestions budgetid int 10  √  null foreign key linking the suggested budget to the aqbudgets table
categories bulk bit 0  √  null
creator_layouts callnum_split int 10  √  0
subscription callnumber text 65535  √  null default call number
old_reserves cancellationdate date 10  √  null the date this hold was cancelled
reserves cancellationdate date 10  √  null the date this hold was cancelled
aqorders cancellationreason text 65535  √  null reason of cancellation
borrower_modifications cardnumber varchar 16  √  null
borrowers cardnumber varchar 16  √  null unique key, library assigned ID number for patrons/borrowers
deletedborrowers cardnumber varchar 16  √  null unique key, library assigned ID number for patrons/borrowers
pending_offline_operations cardnumber varchar 16  √  null
tmp_holdsqueue cardnumber varchar 16  √  null
virtualshelves category varchar 1  √  null type of list (private [1], public [2])
borrower_attribute_types category_code varchar 10  √  null
borrower_message_preferences categorycode varchar 10  √  null
borrower_modifications categorycode varchar 10  √  null
categories_branches categorycode varchar 10  √  null
branchcategories categoryname varchar 32  √  null name of the library/branch group
branchcategories categorytype varchar 16  √  null says whether this is a search group or a properties group
branch_transfer_limits ccode varchar 10  √  null
course_items ccode varchar 10  √  null new category code for the item to have while on reserve (optional)
deleteditems ccode varchar 10  √  null authorized value for the collection code associated with this item (MARC21 952$8)
items ccode varchar 10  √  null authorized value for the collection code associated with this item (MARC21 952$8)
statistics ccode varchar 10  √  null foreign key from the items table, links transaction to a specific collection code
article_requests chapters text 65535  √  null
issuingrules chargename varchar 100  √  null not used? always NULL
issuingrules chargeperiod int 10  √  null how often the fine amount is charged
z3950servers checked smallint 5  √  null whether this target is checked by default (1 for yes, 0 for no)
itemtypes checkinmsg varchar 255  √  null message that is displayed when an item with the given item type is checked in
housebound_visit chooser_brwnumber int 10  √  null Number of the borrower to choose items for delivery.
borrower_modifications city mediumtext 16777215  √  null
cities city_country varchar 100  √  null name of the country
cities city_state varchar 100  √  null name of the state/province
cities city_zipcode varchar 20  √  null zip or postal code
serial claimdate date 10  √  null date claimed
aqorders claimed_date date 10  √  null last date a claim was generated
aqorders claims_count int 10  √  0 count of claim letters generated
serial claims_count int 10  √  0 number of claims made related to this issue
aqbasketgroups closed bit 0  √  null
aqbasket closedate date 10  √  null the date the basket was closed
aqinvoices closedate date 10  √  null
biblioitems cn_class varchar 30  √  null
deletedbiblioitems cn_class varchar 30  √  null
biblioitems cn_item varchar 10  √  null
deletedbiblioitems cn_item varchar 10  √  null
biblioitems cn_sort varchar 255  √  null normalized version of the call number used for sorting
deletedbiblioitems cn_sort varchar 255  √  null normalized version of the call number used for sorting
deleteditems cn_sort varchar 255  √  null normalized form of the call number (MARC21 952$o) used for sorting
items cn_sort varchar 255  √  null
biblioitems cn_source varchar 10  √  null classification source (MARC21 942$2)
deletedbiblioitems cn_source varchar 10  √  null classification source (MARC21 942$2)
deleteditems cn_source varchar 10  √  null classification source used on this item (MARC21 952$2)
items cn_source varchar 10  √  null classification source used on this item (MARC21 952$2)
biblioitems cn_suffix varchar 10  √  null
deletedbiblioitems cn_suffix varchar 10  √  null
user_permissions code varchar 64  √  null
deleteditems coded_location_qualifier varchar 10  √  null coded location qualifier(MARC21 952$f)
items coded_location_qualifier varchar 10  √  null coded location qualifier(MARC21 952$f)
branchcategories codedescription mediumtext 16777215  √  null longer description of the library/branch group
collections colBranchcode varchar 10  √  null 'branchcode for branch where item should be held.'
biblioitems collectionissn text 65535  √  null
deletedbiblioitems collectionissn text 65535  √  null
biblioitems collectiontitle mediumtext 16777215  √  null
deletedbiblioitems collectiontitle mediumtext 16777215  √  null
suggestions collectiontitle text 65535  √  null collection name for the suggested item
biblioitems collectionvolume mediumtext 16777215  √  null
deletedbiblioitems collectionvolume mediumtext 16777215  √  null
borrower_debarments comment text 65535  √  null comments about the restriction
branchtransfers comments mediumtext 16777215  √  null any comments related to the transfer
import_batches comments mediumtext 16777215  √  null any comments added when the file was uploaded
marc_modification_template_actions conditional enum 6  √  null
marc_modification_template_actions conditional_comparison enum 10  √  null
marc_modification_template_actions conditional_field varchar 3  √  null
marc_modification_template_actions conditional_subfield varchar 1  √  null
marc_modification_template_actions conditional_value text 65535  √  null
borrower_modifications contactfirstname text 65535  √  null
borrowers contactfirstname text 65535  √  null used for children to include first name of guarantor
deletedborrowers contactfirstname text 65535  √  null used for children to include first name of guarantor
borrower_modifications contactname mediumtext 16777215  √  null
borrowers contactname mediumtext 16777215  √  null used for children and profesionals to include surname or last name of guarantor or organization name
deletedborrowers contactname mediumtext 16777215  √  null used for children and profesionals to include surname or last name of guarantor or organization name
borrower_modifications contactnote varchar 255  √  null
borrowers contactnote varchar 255  √  null a note related to the patron/borrower's alternate address
deletedborrowers contactnote varchar 255  √  null a note related to the patron/borrower's alternate address
borrower_modifications contacttitle text 65535  √  null
borrowers contacttitle text 65535  √  null used for children to include title (Mr., Mrs., etc) of guarantor
deletedborrowers contacttitle text 65535  √  null used for children to include title (Mr., Mrs., etc) of guarantor
letter content text 65535  √  null body text for the notice or slip
message_queue content text 65535  √  null
message_queue content_type text 65535  √  null
aqcontract contractdescription mediumtext 16777215  √  null
aqcontract contractenddate date 10  √  null
aqcontract contractname varchar 50  √  null
aqbasket contractnumber int 10  √  null links this basket to the aqcontract table (aqcontract.contractnumber)
aqcontract contractstartdate date 10  √  null
import_auths control_number varchar 25  √  null
import_biblios control_number varchar 25  √  null
deleteditems copynumber varchar 32  √  null copy number (MARC21 952$t)
items copynumber varchar 32  √  null copy number (MARC21 952$t)
biblio copyrightdate smallint 5  √  null publication or copyright date from the MARC record
deletedbiblio copyrightdate smallint 5  √  null publication or copyright date from the MARC record
suggestions copyrightdate smallint 5  √  null copyright date of the suggested item
subscription cost int 10  √  0
borrower_modifications country text 65535  √  null
borrowers country text 65535  √  null the country for your patron/borrower's primary address
deletedborrowers country text 65535  √  null the country for your patron/borrower's primary address
courses course_name varchar 255  √  null the name of the course
courses course_number varchar 255  √  null the "course number" assigned to a course
aqbasket creationdate date 10  √  null the date the basket was created
aqorders currency varchar 10  √  null the currency used for the purchase
suggestions currency varchar 10  √  null suggested currency for the suggested price
accountlines date date 10  √  null
article_requests date text 65535  √  null
tags_approval date_approved datetime 19  √  null the date this tag was approved
club_enrollments date_canceled timestamp 19  √  null
reports_dictionary date_created datetime 19  √  null date and time this definition was created
saved_sql date_created datetime 19  √  null the date this report was created
issues date_due datetime 19  √  null datetime the item is due (yyyy-mm-dd hh:mm::ss)
old_issues date_due datetime 19  √  null date the item is due (yyyy-mm-dd)
clubs date_end date 10  √  null
reports_dictionary date_modified datetime 19  √  null date and time this definition was last modified
saved_reports date_run datetime 19  √  null
clubs date_start date 10  √  null
club_enrollments date_updated timestamp 19  √  null
club_templates date_updated timestamp 19  √  null
clubs date_updated timestamp 19  √  null
deleteditems dateaccessioned date 10  √  null date the item was acquired or added to Koha (MARC21 952$d)
items dateaccessioned date 10  √  null date the item was acquired or added to Koha (MARC21 952$d)
branchtransfers datearrived datetime 19  √  null the date the transfer arrived at its destination
aqorders datecancellationprinted date 10  √  null the date the line item was deleted
auth_header datecreated date 10  √  null
borrower_modifications dateenrolled date 10  √  null
borrowers dateenrolled date 10  √  null date the patron was added to Koha (YYYY-MM-DD)
deletedborrowers dateenrolled date 10  √  null date the patron was added to Koha (YYYY-MM-DD)
borrower_modifications dateexpiry date 10  √  null
borrowers dateexpiry date 10  √  null date the patron/borrower's card is set to expire (YYYY-MM-DD)
deletedborrowers dateexpiry date 10  √  null date the patron/borrower's card is set to expire (YYYY-MM-DD)
deleteditems datelastborrowed date 10  √  null the date the item was last checked out
items datelastborrowed date 10  √  null the date the item was last checked out/issued
deleteditems datelastseen date 10  √  null the date the item was last see (usually the last time the barcode was scanned or inventory was done)
items datelastseen date 10  √  null the date the item was last see (usually the last time the barcode was scanned or inventory was done)
borrower_modifications dateofbirth date 10  √  null
borrowers dateofbirth date 10  √  null the patron/borrower's date of birth (YYYY-MM-DD)
deletedborrowers dateofbirth date 10  √  null the patron/borrower's date of birth (YYYY-MM-DD)
categories dateofbirthrequired bit 0  √  null the minimum age required for the patron category
aqorders datereceived date 10  √  null the date this order was received
reviews datereviewed datetime 19  √  null the date the comment was left
branchtransfers datesent datetime 19  √  null the date the transfer was initialized
statistics datetime datetime 19  √  null date and time of the transaction
repeatable_holidays day smallint 5  √  null day of the month this closing is on
housebound_visit day_segment varchar 10  √  null
borrower_message_preferences days_in_advance int 10  √  0
z3950servers db varchar 255  √  null target's database name
borrower_modifications debarred date 10  √  null
borrowers debarred date 10  √  null until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD)
deletedborrowers debarred date 10  √  null until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD)
overduerules debarred1 varchar 1  √  0 is the patron restricted when the first notice is sent (1 for yes, 0 for no)
overduerules debarred2 varchar 1  √  0 is the patron restricted when the second notice is sent (1 for yes, 0 for no)
overduerules debarred3 int 10  √  0 is the patron restricted when the third notice is sent (1 for yes, 0 for no)
borrower_modifications debarredcomment varchar 255  √  null
borrowers debarredcomment varchar 255  √  null comment on the stop of the patron
deletedborrowers debarredcomment varchar 255  √  null comment on the stop of patron
userflags defaulton int 10  √  null
auth_subfield_structure defaultvalue text 65535  √  null
marc_subfield_structure defaultvalue text 65535  √  null
overduerules delay1 int 10  √  null number of days after the item is overdue that the first notice is sent
overduerules delay2 int 10  √  null number of days after the item is overdue that the second notice is sent
overduerules delay3 int 10  √  null number of days after the item is overdue that the third notice is sent
housebound_visit deliverer_brwnumber int 10  √  null Number of the borrower to deliver items.
aqbasketgroups deliverycomment varchar 255  √  null
aqbasket deliveryplace varchar 10  √  null basket delivery place
aqbasketgroups deliveryplace varchar 10  √  null
aqbooksellers deliverytime int 10  √  null vendor delivery time
courses department varchar 80  √  null the authorised value for the DEPARTMENT
accountlines description mediumtext 16777215  √  null
categories description mediumtext 16777215  √  null description of the patron category
class_sort_rules description mediumtext 16777215  √  null
class_sources description mediumtext 16777215  √  null
club_template_enrollment_fields description text 65535  √  null
club_template_fields description text 65535  √  null
club_templates description text 65535  √  null
clubs description text 65535  √  null
edifact_ean description varchar 128  √  null
itemtypes description mediumtext 16777215  √  null a plain text explanation of the item type
language_descriptions description varchar 255  √  null
language_subtag_registry description varchar 25  √  null only one of the possible descriptions for ease of reference, see language_descriptions for the complete list
marc_modification_template_actions description text 65535  √  null
permissions description varchar 255  √  null
reports_dictionary description text 65535  √  null description for this definition
aqbooksellers discount float 6,4  √  null discount offered on all items ordered from this vendor
aqorders discount float 6,4  √  null the discount for this line item (%)
aqbudgets_planning display bit 0  √  1
subscription_frequencies displayorder int 10  √  null
subscription_numberpatterns displayorder int 10  √  null
accountlines dispute mediumtext 16777215  √  null
subscription distributedto text 65535  √  null
need_merge_authorities done tinyint 3  √  0
vendor_edi_accounts download_directory text 65535  √  null
biblioitems ean varchar 13  √  null
deletedbiblioitems ean varchar 13  √  null
aqorders ecost decimal 13,2  √  null the replacement cost for this line item
aqorders ecost_tax_excluded decimal 28,6  √  null the estimated cost excluding tax
aqorders ecost_tax_included decimal 28,6  √  null the estimated cost including tax
edifact_messages edi_acct int 10  √  null
biblioitems editionresponsibility text 65535  √  null
deletedbiblioitems editionresponsibility text 65535  √  null
biblioitems editionstatement text 65535  √  null
deletedbiblioitems editionstatement text 65535  √  null
aqcontacts email varchar 100  √  null contact's email address
borrower_modifications email mediumtext 16777215  √  null
borrowers email mediumtext 16777215  √  null the primary email address for your patron/borrower's primary address
deletedborrowers email mediumtext 16777215  √  null the primary email address for your patron/borrower's primary address
borrower_modifications emailpro text 65535  √  null
borrowers emailpro text 65535  √  null the secondary email addres for your patron/borrower's primary address
deletedborrowers emailpro text 65535  √  null the secondary email addres for your patron/borrower's primary address
z3950servers encoding text 65535  √  null characters encoding provided by this target
subscription enddate date 10  √  null subscription end date
categories enrolmentfee decimal 28,6  √  null enrollment fee for the patron
categories enrolmentperiod smallint 5  √  null number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)
categories enrolmentperioddate date 10  √  null date the patron is enrolled until (will be NULL if enrolmentperiod is set)
aqorders entrydate date 10  √  null the date the bib was added to the basket
deleteditems enumchron text 65535  √  null serial enumeration/chronology for the item (MARC21 952$h)
items enumchron text 65535  √  null serial enumeration/chronology for the item (MARC21 952$h)
aqbudgets_planning estimated_amount decimal 28,6  √  null
subscription_numberpatterns every1 int 10  √  null
subscription_numberpatterns every2 int 10  √  null
subscription_numberpatterns every3 int 10  √  null
borrower_debarments expiration date 10  √  null expiration date of the restriction
old_reserves expirationdate date 10  √  null the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
opac_news expirationdate date 10  √  null date the article is set to expire or no longer be visible
reserves expirationdate date 10  √  null the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
systempreferences explanation text 65535  √  null descriptive text for the system preference
borrower_modifications extended_attributes text 65535  √  null
search_marc_to_field facet bit 0  √  0 true if a facet field should be generated for this
housebound_profile fav_authors text 65535  √  null Free text describing preferred authors.
housebound_profile fav_itemtypes text 65535  √  null Free text describing preferred itemtypes.
housebound_profile fav_subjects text 65535  √  null Free text describing preferred subjects.
aqbooksellers fax varchar 50  √  null vendor fax number
aqcontacts fax varchar 100  √  null
borrower_modifications fax mediumtext 16777215  √  null
borrowers fax mediumtext 16777215  √  null the fax number for your patron/borrower's primary address
deletedborrowers fax mediumtext 16777215  √  null the fax number for your patron/borrower's primary address
marc_modification_template_actions field_value varchar 100  √  null
borrower_files file_description varchar 255  √  null description given to the file
misc_files file_description varchar 255  √  null description given to the file
import_batches file_name varchar 100  √  null the name of the file uploaded
edifact_messages filename text 65535  √  null
uploaded_files filesize int 10  √  null
issuingrules fine decimal 28,6  √  null fine amount
issuingrules finedays int 10  √  null suspension in days
categories finetype varchar 30  √  null unused in Koha
subscription firstacquidate date 10  √  null first issue received date
borrower_modifications firstname text 65535  √  null
borrowers firstname text 65535  √  null patron/borrower's first name
deletedborrowers firstname text 65535  √  null patron/borrower's first name
tmp_holdsqueue firstname text 65535  √  null
issuingrules firstremind int 10  √  null fine grace period
userflags flag varchar 30  √  null
userflags flagdesc varchar 255  √  null
borrower_modifications flags int 10  √  null
borrowers flags int 10  √  null will include a number associated with the staff member's permissions
deletedborrowers flags int 10  √  null will include a number associated with the staff member's permissions
virtualshelfcontents flags int 10  √  null
old_reserves found varchar 1  √  null a one letter code defining what the status is of the hold is after it has been confirmed
reserves found varchar 1  √  null a one letter code defining what the status is of the hold is after it has been confirmed
aqbasketgroups freedeliveryplace text 65535  √  null
aqorders freight decimal 28,6  √  null shipping costs (not used)
message_queue from_address mediumtext 16777215  √  null
marc_modification_template_actions from_subfield varchar 1  √  null
branches geolocation varchar 255  √  null geolocation of your library
borrower_modifications gonenoaddress bit 0  √  null
borrowers gonenoaddress bit 0  √  null set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address
deletedborrowers gonenoaddress bit 0  √  null set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address
aqbooksellers gstreg tinyint 3  √  null is your library charged tax (1 for yes, 0 for no)
borrower_modifications guarantorid int 10  √  null
borrowers guarantorid int 10  √  null borrowernumber used for children or professionals to link them to guarantors or organizations
deletedborrowers guarantorid int 10  √  null borrowernumber used for children or professionals to link them to guarantors or organizations
creator_layouts guidebox int 10  √  0
issuingrules hardduedate date 10  √  null hard due date
borrower_sync hashed_pin varchar 64  √  null Perhaps specific to The Norwegian national patron database, this column holds a hashed PIN code
marc_subfield_structure hidden bit 0  √  null
subscriptionhistory histenddate date 10  √  null
subscriptionhistory histstartdate date 10  √  null
branch_item_rules holdallowed bit 0  √  null the number of holds allowed
default_branch_circ_rules holdallowed bit 0  √  null
default_branch_item_rules holdallowed bit 0  √  null
default_circ_rules holdallowed int 10  √  null
course_items holdingbranch varchar 10  √  null new holding branch for the item to have while on reserve (optional)
deleteditems holdingbranch varchar 10  √  null foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
items holdingbranch varchar 10  √  null foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
tmp_holdsqueue holdingbranch varchar 10  √  null
deleteditems homebranch varchar 10  √  null foreign key from the branches table for the library that owns this item (MARC21 952$a)
items homebranch varchar 10  √  null foreign key from the branches table for the library that owns this item (MARC21 952$a)
vendor_edi_accounts host varchar 40  √  null
z3950servers host varchar 255  √  null target's host name
vendor_edi_accounts id_code_qualifier varchar 3  √  14
biblioitems illus varchar 255  √  null illustrations (MARC21 300$b)
deletedbiblioitems illus varchar 255  √  null illustrations (MARC21 300$b)
creator_images imagefile mediumblob 16777215  √  null
authorised_values imageurl varchar 200  √  null authorized value URL
itemtypes imageurl varchar 200  √  null URL for the item type icon
import_records import_date date 10  √  null
import_items import_error mediumtext 16777215  √  null
import_records import_error mediumtext 16777215  √  null
action_logs info text 65535  √  null information about the action (usually includes SQL statement)
borrower_modifications initials text 65535  √  null
borrowers initials text 65535  √  null initials for your patron/borrower
deletedborrowers initials text 65535  √  null initials for your patron/borrower
subscription innerloop1 int 10  √  0
subscription innerloop2 int 10  √  0
subscription innerloop3 int 10  √  0
action_logs interface varchar 30  √  null the context this action was taken in
subscription internalnotes longtext 2147483647  √  null
virtualshelfshares invitekey varchar 10  √  null temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet
aqorders invoiceid int 10  √  null id of invoice
aqbooksellers invoiceincgst tinyint 3  √  null is tax included in invoice prices (1 for yes, 0 for no)
aqbooksellers invoiceprice varchar 10  √  null currency code for invoice prices
subscription irregularity text 65535  √  null any irregularities in the subscription
letter is_html bit 0  √  0 does this notice or slip use HTML (1 for yes, 0 for no)
biblioitems isbn mediumtext 16777215  √  null ISBN (MARC21 020$a)
deletedbiblioitems isbn mediumtext 16777215  √  null ISBN (MARC21 020$a)
import_biblios isbn varchar 30  √  null
suggestions isbn varchar 30  √  null isbn of the suggested item
language_rfc4646_to_iso639 iso639_2_code varchar 25  √  null
currency isocode varchar 5  √  null
biblioitems issn mediumtext 16777215  √  null ISSN (MARC21 022$a)
deletedbiblioitems issn mediumtext 16777215  √  null ISSN (MARC21 022$a)
import_biblios issn varchar 9  √  null
article_requests issue text 65535  √  null
accountlines issue_id int 10  √  null
issues issuedate datetime 19  √  null date the item was checked out or issued
old_issues issuedate datetime 19  √  null date the item was checked out or issued
issuingrules issuelength int 10  √  null length of checkout in the unit set in issuingrules.lengthunit
categories issuelimit smallint 5  √  null unused in Koha
deleteditems issues smallint 5  √  null number of times this item has been checked out
items issues smallint 5  √  null number of times this item has been checked out/issued
branches issuing tinyint 3  √  null unused in Koha
auth_subfield_structure isurl bit 0  √  null
marc_subfield_structure isurl bit 0  √  null
creator_batches item_number int 10  √  null
deleteditems itemcallnumber varchar 255  √  null call number for this item (MARC21 952$o)
items itemcallnumber varchar 255  √  null call number for this item (MARC21 952$o)
tmp_holdsqueue itemcallnumber varchar 255  √  null
deleteditems itemlost_on datetime 19  √  null the date and time an item was last marked as lost, NULL if not lost
items itemlost_on datetime 19  √  null the date and time an item was last marked as lost, NULL if not lost
deleteditems itemnotes mediumtext 16777215  √  null public notes on this item (MARC21 952$x)
items itemnotes mediumtext 16777215  √  null public notes on this item (MARC21 952$x)
deleteditems itemnotes_nonpublic mediumtext 16777215  √  null
items itemnotes_nonpublic mediumtext 16777215  √  null
accountlines itemnumber int 10  √  null
article_requests itemnumber int 10  √  null
import_items itemnumber int 10  √  null
issues itemnumber int 10  √  null foreign key, linking this to the items table for the item that was checked out
linktracker itemnumber int 10  √  null itemnumber if applicable that the link was from
old_issues itemnumber int 10  √  null foreign key, linking this to the items table for the item that was checked out
old_reserves itemnumber int 10  √  null foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
reserves itemnumber int 10  √  null foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
statistics itemnumber int 10  √  null foreign key from the items table, links transaction to a specific item
tmp_holdsqueue itemnumber int 10  √  null
biblioitems itemtype varchar 10  √  null biblio level item type (MARC21 942$c)
branch_transfer_limits itemtype varchar 10  √  null
deletedbiblioitems itemtype varchar 10  √  null biblio level item type (MARC21 942$c)
old_reserves itemtype varchar 10  √  null If record level hold, the optional itemtype of the item the patron is requesting
reserves itemtype varchar 10  √  null If record level hold, the optional itemtype of the item the patron is requesting
statistics itemtype varchar 10  √  null foreign key from the itemtypes table, links transaction to a specific item type
subscription itemtype varchar 10  √  null
suggestions itemtype varchar 30  √  null suggested item type
course_items itype varchar 10  √  null new itemtype for the item to have while on reserve (optional)
deleteditems itype varchar 10  √  null foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
items itype varchar 10  √  null foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
auth_subfield_structure kohafield varchar 45  √ 
marc_subfield_structure kohafield varchar 40  √  null
subscription_numberpatterns label1 varchar 255  √  null
subscription_numberpatterns label2 varchar 255  √  null
subscription_numberpatterns label3 varchar 255  √  null
language_descriptions lang varchar 25  √  null
tags_all language int 10  √  null the language the tag was left in
language_script_mapping language_subtag varchar 25  √  null
vendor_edi_accounts last_activity date 10  √  null
saved_sql last_modified datetime 19  √  null the date this report was last edited
saved_sql last_run datetime 19  √  null
subscription lastbranch varchar 10  √  null
accountlines lastincrement decimal 28,6  √  null
issues lastreneweddate datetime 19  √  null date the item was last renewed
old_issues lastreneweddate datetime 19  √  null date the item was last renewed
borrowers lastseen datetime 19  √  null last time a patron has been seed (connected at the OPAC or staff interface)
deletedborrowers lastseen datetime 19  √  null last time a patron has been seed (connected at the OPAC or staff interface)
borrower_sync lastsync varchar 50  √  null Date of the last successfull sync. The date format might be different depending on the service that is being used, so no special date format is being enforced here.
subscription lastvalue1 int 10  √  null
subscription lastvalue2 int 10  √  null
subscription lastvalue3 int 10  √  null
biblioitems lccn varchar 25  √  null library of congress control number (MARC21 010$a)
deletedbiblioitems lccn varchar 25  √  null library of congress control number (MARC21 010$a)
issuingrules lengthunit varchar 10  √  days unit of checkout length (days, hours)
subscription letter varchar 20  √  null
overduerules letter1 varchar 20  √  null foreign key from the letter table to define which notice should be sent as the first notice
overduerules letter2 varchar 20  √  null foreign key from the letter table to define which notice should be sent as the second notice
overduerules letter3 varchar 20  √  null foreign key from the letter table to define which notice should be sent as the third notice
message_queue letter_code varchar 64  √  null
authorised_values lib varchar 200  √  null authorized value description as printed in the staff client
authorised_values lib_opac varchar 200  √  null authorized value description as printed in the OPAC
subscription librarian varchar 100  √  the librarian's username from borrowers.userid
aqorders line_item_id varchar 35  √  null Supplier's article id for Edifact orderline
marc_subfield_structure link varchar 80  √  null
auth_header linkid bigint 19  √  null
aqbooksellers listincgst tinyint 3  √  null is tax included in list prices (1 for yes, 0 for no)
aqbooksellers listprice varchar 10  √  null currency code for list prices
aqorders listprice decimal 28,6  √  null the vendor price for this line item
subscription locale varchar 80  √  null for foreign language subscriptions to display months, seasons, etc correctly
course_items location varchar 80  √  null new shelving location for the item to have while on reseve (optional)
deleteditems location varchar 80  √  null authorized value for the shelving location for this item (MARC21 952$c)
items location varchar 80  √  null authorized value for the shelving location for this item (MARC21 952$c)
subscription location varchar 80  √  default shelving location (items.location)
borrowers login_attempts int 10  √  0 number of failed login attemps
deletedborrowers login_attempts int 10  √  0 number of failed login attemps
borrower_modifications lost bit 0  √  null
borrowers lost bit 0  √  null set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card
deletedborrowers lost bit 0  √  null set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card
suggestions managedby int 10  √  null borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
suggestions manageddate date 10  √  null date the suggestion was updated
accountlines manager_id int 10  √  null
borrower_debarments manager_id int 10  √  null foreign key for borrowers.borrowernumber for the librarian managing the restriction
messages manager_id int 10  √  null creator of message
auth_header marc blob 65535  √  null
import_auths matched_authid int 10  √  null
import_biblios matched_biblionumber int 10  √  null
import_batches matcher_id int 10  √  null the id of the match rule used (matchpoints.matcher_id)
deleteditems materials text 65535  √  null materials specified (MARC21 952$3)
items materials text 65535  √  null materials specified (MARC21 952$3)
branch_borrower_circ_rules maxissueqty int 10  √  null the maximum number of checkouts this patron category can have at this branch
default_borrower_circ_rules maxissueqty int 10  √  null
default_branch_circ_rules maxissueqty int 10  √  null
default_circ_rules maxissueqty int 10  √  null
issuingrules maxissueqty int 10  √  null total number of checkouts allowed
branch_borrower_circ_rules maxonsiteissueqty int 10  √  null the maximum number of on-site checkouts this patron category can have at this branch
default_borrower_circ_rules maxonsiteissueqty int 10  √  null
default_branch_circ_rules maxonsiteissueqty int 10  √  null
default_circ_rules maxonsiteissueqty int 10  √  null
issuingrules maxonsiteissueqty int 10  √  null total number of on-site checkouts allowed
issuingrules maxsuspensiondays int 10  √  null max suspension days
borrower_message_preferences message_attribute_id int 10  √  0
aqinvoices message_id int 10  √  null foreign key to edifact invoice message
message_queue metadata text 65535  √  null
borrower_modifications mobile varchar 50  √  null
borrowers mobile varchar 50  √  null the other phone number for your patron/borrower's primary address
deletedborrowers mobile varchar 50  √  null the other phone number for your patron/borrower's primary address
action_logs module text 65535  √  null the module this action was taken against
repeatable_holidays month smallint 5  √  null month this closing is in
subscription monthlength int 10  √  0 subscription length in weeks (will not be filled in if weeklength or numberlength is set)
deleteditems more_subfields_xml longtext 2147483647  √  null additional 952 subfields in XML format
items more_subfields_xml longtext 2147483647  √  null additional 952 subfields in XML format
aqbasketgroups name varchar 50  √  null
aqcontacts name varchar 100  √  null name of contact at vendor
reports_dictionary name varchar 255  √  null name for this definition
discharges needed timestamp 19  √  null
deleteditems new_status varchar 32  √  null 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
items new_status varchar 32  √  null 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
issuingrules no_auto_renewal_after int 10  √  null no auto renewal allowed after X days or hours after the issue date
issuingrules no_auto_renewal_after_hard_limit date 10  √  null no auto renewal allowed after a given date
issuingrules norenewalbefore int 10  √  null no renewal allowed until X days or hours before due date.
accountlines note text 65535  √  null
aqbasket note mediumtext 16777215  √  null the internal note added at basket creation
issues note mediumtext 16777215  √  null issue note text
old_issues note mediumtext 16777215  √  null issue note text
suggestions note mediumtext 16777215  √  null note entered on the suggestion
issues notedate datetime 19  √  null datetime of issue note (yyyy-mm-dd hh:mm::ss)
old_issues notedate datetime 19  √  null datetime of issue note (yyyy-mm-dd hh:mm::ss)
aqbooksellers notes mediumtext 16777215  √  null order notes
aqcontacts notes mediumtext 16777215  √  null notes related to the contact
article_requests notes text 65535  √  null
biblio notes mediumtext 16777215  √  null values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
biblioitems notes mediumtext 16777215  √  null
deletedbiblio notes mediumtext 16777215  √  null values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
deletedbiblioitems notes mediumtext 16777215  √  null
housebound_profile notes text 65535  √  null Free text for additional notes.
saved_sql notes text 65535  √  null the notes or description given to this report
serial notes text 65535  √  null notes
subscription notes mediumtext 16777215  √  null notes
tmp_holdsqueue notes text 65535  √  null
itemtypes notforloan smallint 5  √  null 1 if the item is not for loan, 0 if the item is available for loan
old_reserves notificationdate date 10  √  null currently unused
reserves notificationdate date 10  √  null currently unused
notifys notify_date date 10  √  null
notifys notify_send_date date 10  √  null
social_data num_critics int 10  √  null
social_data num_critics_pro int 10  √  null
social_data num_quotations int 10  √  null
social_data num_scores int 10  √  null
social_data num_videos int 10  √  null
biblioitems number mediumtext 16777215  √  null
deletedbiblioitems number mediumtext 16777215  √  null
opac_news number int 10  √  null the order in which this article appears in that specific location
subscription_numberpatterns numbering1 varchar 255  √  null
subscription_numberpatterns numbering2 varchar 255  √  null
subscription_numberpatterns numbering3 varchar 255  √  null
subscription numberlength int 10  √  0 subscription length in weeks (will not be filled in if monthlength or weeklength is set)
subscription numberpattern int 10  √  null the numbering pattern used links to subscription_numberpatterns.id
action_logs object int 10  √  null the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
creator_layouts oblique_title int 10  √  1
accountoffsets offsetamount decimal 28,6  √  null
deleteditems onloan date 10  √  null defines if item is checked out (NULL for not checked out, and due date for checked out)
items onloan date 10  √  null defines if item is checked out (NULL for not checked out, and due date for checked out)
branches opac_info text 65535  √  null HTML that displays in OPAC
subscription opacdisplaycount varchar 10  √  null how many issues to show to the public
borrower_modifications opacnote mediumtext 16777215  √  null
borrowers opacnote mediumtext 16777215  √  null a note on the patron/borrower's account that is visible in the OPAC and staff client
deletedborrowers opacnote mediumtext 16777215  √  null a note on the patron/borrower's account that is visible in the OPAC and staff client
systempreferences options mediumtext 16777215  √  null options for multiple choice system preferences
aqorders order_internalnote mediumtext 16777215  √  null notes related to this order line, made for staff
aqorders order_vendornote mediumtext 16777215  √  null notes related to this order line, made for vendor
aqorders_transfers ordernumber_from int 10  √  null
aqorders_transfers ordernumber_to int 10  √  null
aqorders orderstatus varchar 16  √  new the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled'
import_auths original_source varchar 25  √  null
import_biblios original_source varchar 25  √  null
auth_header origincode varchar 20  √  null
statistics other mediumtext 16777215  √  null used by SIP
borrower_modifications othernames mediumtext 16777215  √  null
borrowers othernames mediumtext 16777215  √  null any other names associated with the patron/borrower
deletedborrowers othernames mediumtext 16777215  √  null any other names associated with the patron/borrower
aqbooksellers othersupplier mediumtext 16777215  √  null
borrowers overdrive_auth_token text 65535  √  null persist OverDrive auth token
deletedborrowers overdrive_auth_token text 65535  √  null persist OverDrive auth token
issuingrules overduefinescap decimal 28,6  √  null the maximum amount of an overdue fine
categories overduenoticerequired bit 0  √  null are overdue notices sent to this patron category (1 for yes, 0 for no)
uploaded_files owner int 10  √  null
virtualshelves owner int 10  √  null foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int)
article_requests pages text 65535  √  null
biblioitems pages varchar 255  √  null number of pages (MARC21 300$c)
deletedbiblioitems pages varchar 255  √  null number of pages (MARC21 300$c)
deleteditems paidfor mediumtext 16777215  √  null
items paidfor mediumtext 16777215  √  null
aqorders parent_ordernumber int 10  √  null ordernumber of parent order line, or same as ordernumber if no parent
borrower_modifications password varchar 30  √  null
borrowers password varchar 60  √  null patron/borrower's Bcrypt encrypted password
deletedborrowers password varchar 60  √  null patron/borrower's encrypted password
vendor_edi_accounts password varchar 40  √  null
z3950servers password varchar 255  √  null password needed to log in to target
article_requests patron_notes text 65535  √  null
suggestions patronreason text 65535  √  null reason for making the suggestion
subscription periodicity int 10  √  null frequency type links to subscription_frequencies.id
uploaded_files permanent tinyint 3  √  null
deleteditems permanent_location varchar 80  √  null linked to the CART and PROC temporary locations feature, stores the permanent shelving location
items permanent_location varchar 80  √  null linked to the CART and PROC temporary locations feature, stores the permanent shelving location
aqbooksellers phone varchar 30  √  null vendor phone number
aqcontacts phone varchar 100  √  null contact's phone number
borrower_modifications phone text 65535  √  null
borrowers phone text 65535  √  null the primary phone number for your patron/borrower's primary address
deletedborrowers phone text 65535  √  null the primary phone number for your patron/borrower's primary address
tmp_holdsqueue phone text 65535  √  null
borrower_modifications phonepro text 65535  √  null
borrowers phonepro text 65535  √  null the secondary phone number for your patron/borrower's primary address
deletedborrowers phonepro text 65535  √  null the secondary phone number for your patron/borrower's primary address
tmp_holdsqueue pickbranch varchar 10  √  null
biblioitems place varchar 255  √  null publication place (MARC21 260$a)
deletedbiblioitems place varchar 255  √  null publication place (MARC21 260$a)
suggestions place varchar 255  √  null publication place of the suggested item
serial planneddate date 10  √  null date expected
plugin_data plugin_value text 65535  √  null
z3950servers port int 10  √  null port number used to connect to target
aqcontacts position varchar 100  √  null contact person's position
aqbooksellers postal mediumtext 16777215  √  null vendor postal address (all lines)
subscription previousitemtype varchar 10  √  null
deleteditems price decimal 8,2  √  null purchase price (MARC21 952$g)
items price decimal 8,2  √  null purchase price (MARC21 952$g)
suggestions price decimal 28,6  √  null suggested price
printers printqueue varchar 20  √  null
printers printtype varchar 20  √  null
old_reserves priority smallint 5  √  null where in the queue the patron sits
reserves priority smallint 5  √  null where in the queue the patron sits
borrower_modifications privacy int 10  √  null
statistics proccode varchar 4  √  null type of procedure used when making payments (does not appear in the code)
creator_templates profile_id int 10  √  null
uploaded_files public tinyint 3  √  null
course_reserves public_note mediumtext 16777215  √  null public, OPAC visible note
courses public_note mediumtext 16777215  √  null the text of the public / opac note
biblioitems publicationyear text 65535  √  null
deletedbiblioitems publicationyear text 65535  √  null
suggestions publicationyear smallint 5  √  0
serial publisheddate date 10  √  null date published
serial publisheddatetext varchar 100  √  null date published (descriptive)
biblioitems publishercode varchar 255  √  null publisher (MARC21 260$b)
deletedbiblioitems publishercode varchar 255  √  null publisher (MARC21 260$b)
suggestions publishercode varchar 255  √  null publisher of the suggested item
aqorders purchaseordernumber mediumtext 16777215  √  null not used? always NULL
aqorders quantity smallint 5  √  null the quantity ordered
suggestions quantity smallint 5  √  null suggested quantity to be purchased
z3950servers rank int 10  √  null where this target appears in the list of targets
subscriptionroutinglist ranking int 10  √  null where the patron stands in line to receive the serial
currency rate float 15,5  √  null
edifact_messages raw_msg mediumtext 16777215  √  null
suggestions reason text 65535  √  null reason for accepting or rejecting the suggestion
housebound_profile referral text 65535  √  null Free text indicating how the borrower was added to the service.
suggestions rejectedby int 10  √  null borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table
suggestions rejecteddate date 10  √  null date the suggestion was marked as rejected
borrower_modifications relationship varchar 100  √  null
borrowers relationship varchar 100  √  null used for children to include the relationship to their guarantor
deletedborrowers relationship varchar 100  √  null used for children to include the relationship to their guarantor
old_reserves reminderdate date 10  √  null currently unused
reserves reminderdate date 10  √  null currently unused
issuingrules renewalperiod int 10  √  null renewal period in the unit set in issuingrules.lengthunit
deleteditems renewals smallint 5  √  null number of times this item has been renewed
issues renewals tinyint 3  √  null lists the number of times the item was renewed
items renewals smallint 5  √  null number of times this item has been renewed
old_issues renewals tinyint 3  √  null lists the number of times the item was renewed
subscription reneweddate date 10  √  null date of last renewal for the subscription
itemtypes rentalcharge double 16,4  √  null the amount charged when this item is checked out/issued
issuingrules rentaldiscount decimal 28,6  √  null percent discount on the rental charge for this item
deleteditems replacementprice decimal 8,2  √  null cost the library charges to replace the item if it has been marked lost (MARC21 952$v)
items replacementprice decimal 8,2  √  null cost the library charges to replace the item if it has been marked lost (MARC21 952$v)
deleteditems replacementpricedate date 10  √  null the date the price is effective from (MARC21 952$w)
items replacementpricedate date 10  √  null the date the price is effective from (MARC21 952$w)
saved_reports report longtext 2147483647  √  null
reports_dictionary report_area varchar 6  √  null Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts)
saved_sql report_area varchar 6  √  null
saved_sql report_group varchar 80  √  null
saved_reports report_id int 10  √  null
saved_sql report_subgroup varchar 80  √  null
need_merge_authorities reportxml text 65535  √  null xml showing original reporting tag
issuingrules reservecharge decimal 28,6  √  null
old_reserves reservedate date 10  √  null the date the hold was places
reserves reservedate date 10  √  null the date the hold was places
tmp_holdsqueue reservedate date 10  √  null
categories reservefee decimal 28,6  √  null cost to place holds
old_reserves reservenotes mediumtext 16777215  √  null notes related to this hold
reserves reservenotes mediumtext 16777215  √  null notes related to this hold
deleteditems reserves smallint 5  √  null number of times this item has been placed on hold/reserved
items reserves smallint 5  √  null number of times this item has been placed on hold/reserved
deleteditems restricted bit 0  √  null authorized value defining use restrictions for this item (MARC21 952$5)
items restricted bit 0  √  null authorized value defining use restrictions for this item (MARC21 952$5)
issuingrules restrictedtype bit 0  √  null not used? always NULL
branch_item_rules returnbranch varchar 15  √  null the branch the item returns to (homebranch, holdingbranch, noreturn)
default_branch_circ_rules returnbranch varchar 15  √  null
default_branch_item_rules returnbranch varchar 15  √  null
default_circ_rules returnbranch varchar 15  √  null
issues returndate datetime 19  √  null date the item was returned, will be NULL until moved to old_issues
old_issues returndate datetime 19  √  null date the item was returned
reviews review text 65535  √  null the body of the comment
language_rfc4646_to_iso639 rfc4646_subtag varchar 25  √  null
language_script_bidi rfc4646_subtag varchar 25  √  null script subtag, Arab, Hebr, etc.
serial routingnotes text 65535  √  null notes from the routing list
aqorders rrp decimal 13,2  √  null the replacement cost for this line item
aqorders rrp_tax_excluded decimal 28,6  √  null the replacement cost excluding tax
aqorders rrp_tax_included decimal 28,6  √  null the replacement cost including tax
vendor_edi_accounts san varchar 20  √  null
reports_dictionary saved_sql text 65535  √  null SQL snippet for us in reports
saved_sql savedsql text 65535  √  null the SQL for this report
social_data score_avg decimal 5,2  √  null
language_script_mapping script_subtag varchar 25  √  null
itemtypes searchcategory varchar 80  √  null Group this item type with others with the same value on OPAC search options
courses section varchar 255  √  null the 'section' of a course
auth_subfield_structure seealso varchar 255  √  null
marc_subfield_structure seealso varchar 1100  √  null
biblio serial bit 0  √  null Boolean indicating whether biblio is for a serial
deletedbiblio serial bit 0  √  null Boolean indicating whether biblio is for a serial
serial serialseq_x varchar 100  √  null first part of issue information
serial serialseq_y varchar 100  √  null second part of issue information
serial serialseq_z varchar 100  √  null third part of issue information
biblio seriestitle mediumtext 16777215  √  null
deletedbiblio seriestitle mediumtext 16777215  √  null
services_throttle service_count varchar 45  √  null
subscription_numberpatterns setto1 int 10  √  null
subscription_numberpatterns setto2 int 10  √  null
subscription_numberpatterns setto3 int 10  √  null
borrower_modifications sex varchar 1  √  null
borrowers sex varchar 1  √  null patron/borrower's gender
deletedborrowers sex varchar 1  √  null patron/borrower's gender
virtualshelfshares sharedate datetime 19  √  null
virtualshelves shelfname varchar 255  √  null name of the list
vendor_edi_accounts shipment_budget int 10  √  null
aqinvoices shipmentcost decimal 28,6  √  null
aqinvoices shipmentcost_budgetid int 10  √  null
aqinvoices shipmentdate date 10  √  null
itemtypes sip_media_type varchar 3  √  null SIP2 protocol media type for this itemtype
biblioitems size varchar 255  √  null material size (MARC21 300$c)
deletedbiblioitems size varchar 255  √  null material size (MARC21 300$c)
borrowers sms_provider_id int 10  √  null the provider of the mobile phone number defined in smsalertnumber
deletedborrowers sms_provider_id int 10  √  null the provider of the mobile phone number defined in smsalertnumber
borrower_modifications smsalertnumber varchar 50  √  null
borrowers smsalertnumber varchar 50  √  null the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
deletedborrowers smsalertnumber varchar 50  √  null the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
search_marc_to_field sort bit 0  √  null true/false creates special sort handling, null doesn't
aqorders sort1 varchar 80  √  null statistical field
borrower_modifications sort1 varchar 80  √  null
borrowers sort1 varchar 80  √  null a field that can be used for any information unique to the library
deletedborrowers sort1 varchar 80  √  null a field that can be used for any information unique to the library
aqbudgetperiods sort1_authcat varchar 10  √  null statistical category for this budget
aqbudgets sort1_authcat varchar 80  √  null statistical category for this fund
aqorders sort1_authcat varchar 10  √  null
aqorders sort2 varchar 80  √  null second statistical field
borrower_modifications sort2 varchar 80  √  null
borrowers sort2 varchar 80  √  null a field that can be used for any information unique to the library
deletedborrowers sort2 varchar 80  √  null a field that can be used for any information unique to the library
aqbudgetperiods sort2_authcat varchar 10  √  null second statistical category for this budget
aqbudgets sort2_authcat varchar 80  √  null second statistical category for this fund
aqorders sort2_authcat varchar 10  √  null
virtualshelves sortfield varchar 16  √  title the field this list is sorted on
quotes source text 65535  √  null source/credit for the quote
hold_fill_targets source_branchcode varchar 10  √  null
z3950servers sru_fields mediumtext 16777215  √  null contains the mapping between the Z3950 search fields and the specific SRU server indexes
z3950servers sru_options varchar 255  √  null options like sru=get, sru_version=1.1; will be passed to the server via ZOOM
deleteditems stack bit 0  √  null
items stack bit 0  √  null
course_reserves staff_note mediumtext 16777215  √  null staff only note
courses staff_note mediumtext 16777215  √  null the text of the staff only note
subscription staffdisplaycount varchar 10  √  null how many issues to show to the staff
subscription startdate date 10  √  null start date for this subscription
borrower_modifications state text 65535  √  null
borrowers state text 65535  √  null the state or province for your patron/borrower's primary address
deletedborrowers state text 65535  √  null the state or province for your patron/borrower's primary address
edifact_messages status text 65535  √  null
deleteditems stocknumber varchar 32  √  null inventory number (MARC21 952$i)
items stocknumber varchar 32  √  null inventory number (MARC21 952$i)
borrower_modifications streetnumber varchar 10  √  null
borrowers streetnumber varchar 10  √  null the house number for your patron/borrower's primary address
deletedborrowers streetnumber varchar 10  √  null the house number for your patron/borrower's primary address
borrower_modifications streettype varchar 50  √  null
borrowers streettype varchar 50  √  null the street type (Rd., Blvd, etc) for your patron/borrower's primary address
deletedborrowers streettype varchar 50  √  null the street type (Rd., Blvd, etc) for your patron/borrower's primary address
courses students_count varchar 20  √  null how many students will be taking this course/section
message_queue subject text 65535  √  null
aqorders subscriptionid int 10  √  null links this order line to a subscription (subscription.subscriptionid)
language_descriptions subtag varchar 25  √  null
language_subtag_registry subtag varchar 25  √  null
search_marc_to_field suggestible bit 0  √  0 true if this field can be used to generate suggestions for browse
itemtypes summary text 65535  √  null information from the summary field, may include HTML
aqorders suppliers_reference_number varchar 35  √  null Suppliers unique edifact quote ref
aqorders suppliers_reference_qualifier varchar 3  √  null Type of number above usually 'QLI'
aqorders suppliers_report text 65535  √  null reports received from suppliers
borrower_modifications surname mediumtext 16777215  √  null
old_reserves suspend_until datetime 19  √  null the date this hold is suspended until (NULL for infinitely)
reserves suspend_until datetime 19  √  null
currency symbol varchar 5  √  null
borrower_sync syncstatus varchar 10  √  null The sync status for any given borrower. Could be text strings like 'new', 'edited', 'synced' etc. The values used here will depend on the actual syncing being done.
z3950servers syntax varchar 80  √  null marc format provided by this target
auth_subfield_structure tab bit 0  √  null
marc_subfield_structure tab bit 0  √  null
items_search_fields tagsubfield char 1  √  null
aqbooksellers tax_rate decimal 6,4  √  null the tax rate the library is charged
aqorders tax_rate_bak decimal 6,4  √  null the tax rate for this line item (%)
aqorders tax_rate_on_ordering decimal 6,4  √  null the tax rate on ordering for this line item (%)
aqorders tax_rate_on_receiving decimal 6,4  √  null the tax rate on receiving for this line item (%)
aqorders tax_value_bak decimal 28,6  √  null the tax value for this line item
aqorders tax_value_on_ordering decimal 28,6  √  null the tax value on ordering for this line item
aqorders tax_value_on_receiving decimal 28,6  √  null the tax value on receiving for this line item
import_batches template_id int 10  √  null
courses term varchar 80  √  null the authorised value for the TERM
linktracker timeclicked datetime 19  √  null the date and time the link was clicked
article_requests title text 65535  √  null
biblio title mediumtext 16777215  √  null title (without the subtitle) from the MARC record (245$a in MARC21)
borrower_modifications title mediumtext 16777215  √  null
borrowers title mediumtext 16777215  √  null patron/borrower's title, for example: Mr. or Mrs.
deletedbiblio title mediumtext 16777215  √  null title (without the subtitle) from the MARC record (245$a in MARC21)
deletedborrowers title mediumtext 16777215  √  null patron/borrower's title, for example: Mr. or Mrs.
import_biblios title varchar 128  √  null
suggestions title varchar 255  √  null title of the suggested item
tmp_holdsqueue title mediumtext 16777215  √  null
message_queue to_address mediumtext 16777215  √  null
marc_modification_template_actions to_field varchar 3  √  null
marc_modification_template_actions to_regex_modifiers varchar 8  √ 
marc_modification_template_actions to_regex_replace text 65535  √  null
marc_modification_template_actions to_regex_search text 65535  √  null
marc_modification_template_actions to_subfield varchar 1  √  null
suggestions total decimal 28,6  √  null suggested total cost (price*quantity updated for currency)
biblioitems totalissues int 10  √  null
deletedbiblioitems totalissues int 10  √  null
edifact_messages transfer_date date 10  √  null
localization translation text 65535  √  null
vendor_edi_accounts transport varchar 6  √  FTP
export_format type varchar 255  √  marc
language_descriptions type varchar 25  √  null
language_subtag_registry type varchar 25  √  null language-script-region-variant-extension-privateuse
saved_sql type varchar 255  √  null always 1 for tabular
statistics type varchar 16  √  null transaction type (locause, issue, return, renew, writeoff, payment, Credit*)
systempreferences type varchar 20  √  null type of question this preference asks (multiple choice, plain text, yes or no, etc)
aqorders uncertainprice bit 0  √  null was this price uncertain (1 for yes, 0 for no)
subscription_frequencies unit enum 5  √  null
biblio unititle mediumtext 16777215  √  null uniform title (without the subtitle) from the MARC record (240$a in MARC21)
deletedbiblio unititle mediumtext 16777215  √  null uniform title (without the subtitle) from the MARC record (240$a in MARC21)
aqorders unitprice decimal 28,6  √  null the actual cost entered when receiving this line item
aqorders unitprice_tax_excluded decimal 28,6  √  null the unit price excluding tax (on receiving)
aqorders unitprice_tax_included decimal 28,6  √  null the unit price including tax (on receiving)
borrower_debarments updated timestamp 19  √  null date the restriction was updated
article_requests updated_on timestamp 19  √  null
vendor_edi_accounts upload_directory text 65535  √  null
uploaded_files uploadcategorycode tinytext 255  √  null
categories upperagelimit smallint 5  √  null age limit for the patron
deleteditems uri varchar 255  √  null URL for the item (MARC21 952$u)
items uri varchar 255  √  null URL for the item (MARC21 952$u)
aqbooksellers url varchar 255  √  null vendor web address
biblioitems url text 65535  √  null url (MARC21 856$u)
deletedbiblioitems url text 65535  √  null url (MARC21 856$u)
linktracker url text 65535  √  null the link itself
statistics usercode varchar 10  √  null unused in Koha
borrower_modifications userid varchar 75  √  null
borrowers userid varchar 75  √  null patron/borrower's opac and/or staff client log in
deletedborrowers userid varchar 75  √  null patron/borrower's opac and/or staff client log in
z3950servers userid varchar 255  √  null username needed to log in to target
vendor_edi_accounts username varchar 40  √  null
discharges validated timestamp 19  √  null
club_fields value text 65535  √  null
statistics value double 16,4  √  null monetary value associated with the transaction
systempreferences value text 65535  √  null system preference values
auth_subfield_structure value_builder varchar 80  √  null
marc_subfield_structure value_builder varchar 80  √  null
edifact_messages vendor_id int 10  √  null
vendor_edi_accounts vendor_id int 10  √  null
article_requests volume text 65535  √  null
biblioitems volume mediumtext 16777215  √  null
deletedbiblioitems volume mediumtext 16777215  √  null
biblioitems volumedate date 10  √  null
deletedbiblioitems volumedate date 10  √  null
biblioitems volumedesc text 65535  √  null volume information (MARC21 362$a)
deletedbiblioitems volumedesc text 65535  √  null volume information (MARC21 362$a)
suggestions volumedesc varchar 255  √  null
old_reserves waitingdate date 10  √  null the date the item was marked as waiting for the patron at the library
reserves waitingdate date 10  √  null the date the item was marked as waiting for the patron at the library
repeatable_holidays weekday smallint 5  √  null day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on
subscription weeklength int 10  √  0 subscription length in weeks (will not be filled in if monthlength or numberlength is set)
subscription_numberpatterns whenmorethan1 int 10  √  null
subscription_numberpatterns whenmorethan2 int 10  √  null
subscription_numberpatterns whenmorethan3 int 10  √  null
deleteditems withdrawn_on datetime 19  √  null the date and time an item was last marked as withdrawn, NULL if not withdrawn
items withdrawn_on datetime 19  √  null the date and time an item was last marked as withdrawn, NULL if not withdrawn
import_records z3950random varchar 40  √  null
borrower_modifications zipcode varchar 25  √  null
borrowers zipcode varchar 25  √  null the zip or postal code for your patron/borrower's primary address
deletedborrowers zipcode varchar 25  √  null the zip or postal code for your patron/borrower's primary address
sessions a_session mediumtext 16777215
accountlines accountlines_id int 10  √ 
accountlines accountno smallint 5 0
accountoffsets accountno smallint 5 0
aqcontacts acqprimary bit 0 0 is this the primary contact for acquisitions messages
marc_modification_template_actions action enum 22
pending_offline_operations action varchar 10
action_logs action_id int 10  √  unique identifier for each action
borrowers address mediumtext 16777215 the first address line for your patron/borrower's primary address
deletedborrowers address mediumtext 16777215 the first address line for your patron/borrower's primary address
alert alertid int 10  √ 
tags_approval approved int 10 0 whether the tag is approved or not (1=yes, 0=pending, -1=rejected)
issuingrules article_requests enum 9 no allow article requests to be placed,
auth_types auth_tag_to_report varchar 3
aqbudgets_planning authcat varchar 30
auth_header authid bigint unsigned 20  √ 
need_merge_authorities authid bigint 19 reference to original authority record
authorised_values authorised_value varchar 80 code use to identify the authorized value
additional_fields authorised_value_category varchar 16 is an authorised value category
auth_header authtypecode varchar 10
auth_subfield_structure authtypecode varchar 10
auth_tag_structure authtypecode varchar 10
auth_types authtypecode varchar 10
auth_types authtypetext varchar 255
aqbudgets_planning authvalue varchar 30
vendor_edi_accounts auto_orders bit 0 0
authorised_values_branches av_id int 10
creator_layouts barcode_type char 100 CODE39
aqbasket basketno int 10  √  primary key, Koha defined number
aqbasketusers basketno int 10
creator_batches batch_id int 10 1
import_batches batch_type enum 10 batch where this batch has come from
zebraqueue biblio_auth_number bigint unsigned 20 0
biblioitems biblioitemnumber int 10  √  primary key, unique identifier assigned by Koha
deletedbiblioitems biblioitemnumber int 10 0 primary key, unique identifier assigned by Koha
deleteditems biblioitemnumber int 10 0 foreign key from the biblioitems table to link to item to additional information
items biblioitemnumber int 10 0 foreign key from the biblioitems table to link to item to additional information
article_requests biblionumber int 10
biblio biblionumber int 10  √  unique identifier assigned to each bibliographic record
biblio_metadata biblionumber int 10
biblioimages biblionumber int 10 foreign key from biblio table to link to biblionumber
biblioitems biblionumber int 10 0 foreign key linking this table to the biblio table
deletedbiblio biblionumber int 10  √  unique identifier assigned to each bibliographic record
deletedbiblio_metadata biblionumber int 10
deletedbiblioitems biblionumber int 10 0 foreign key linking this table to the biblio table
deleteditems biblionumber int 10 0 foreign key from biblio table used to link this item to the right bib record
hold_fill_targets biblionumber int 10
items biblionumber int 10 0 foreign key from biblio table used to link this item to the right bib record
oai_sets_biblios biblionumber int 10
ratings biblionumber int 10 the biblio this rating is for (biblio.biblionumber)
reserves biblionumber int 10 0 foreign key from the biblio table defining which bib record this hold is on
serial biblionumber varchar 100 foreign key for the biblio.biblionumber that this issue is attached to
subscription biblionumber int 10 0 foreign key for biblio.biblionumber that this subscription is attached to
subscriptionhistory biblionumber int 10 0
tags_all biblionumber int 10 the bib record this tag was left on (biblio.biblionumber)
tags_index biblionumber int 10 the bib record this tag was used on (biblio.biblionumber)
virtualshelfcontents biblionumber int 10 0 foreign key linking to the biblio table, defines the bib record that has been added to the list
userflags bit int 10 0
categories BlockExpiredPatronOpacActions bit 0 -1 wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions
aqbasket booksellerid int 10 1 the Koha assigned ID for the vendor (aqbooksellers.id)
aqbasketgroups booksellerid int 10
aqcontacts booksellerid int 10
aqcontract booksellerid int 10
aqinvoices booksellerid int 10
borrower_debarments borrower_debarment_id int 10  √  unique key for the restriction
borrower_message_preferences borrower_message_preference_id int 10  √ 
borrower_message_transport_preferences borrower_message_preference_id int 10 0
accountlines borrowernumber int 10 0
accountoffsets borrowernumber int 10 0
alert borrowernumber int 10 0
aqbasketusers borrowernumber int 10
aqbudgetborrowers borrowernumber int 10
aqorder_users borrowernumber int 10 the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber)
article_requests borrowernumber int 10
borrower_attributes borrowernumber int 10 foreign key from the borrowers table, defines which patron/borrower has this attribute
borrower_debarments borrowernumber int 10 foreign key for borrowers.borrowernumber for patron who is restricted
borrower_files borrowernumber int 10 foreign key linking to the patron via the borrowernumber
borrower_modifications borrowernumber int 10 0
borrower_password_recovery borrowernumber int 10 the user asking a password recovery
borrower_sync borrowernumber int 10 Connects data about synchronisations to a borrower
borrowers borrowernumber int 10  √  primary key, Koha assigned ID number for patrons/borrowers
club_enrollments borrowernumber int 10
course_instructors borrowernumber int 10 foreign key to link to borrowers.borrowernumber for instructor information
deletedborrowers borrowernumber int 10 0 primary key, Koha assigned ID number for patrons/borrowers
hold_fill_targets borrowernumber int 10
housebound_profile borrowernumber int 10 Number of the borrower associated with this profile.
housebound_visit borrowernumber int 10 Number of the borrower, & the profile, linked to this visit.
items_last_borrower borrowernumber int 10
messages borrowernumber int 10 foreign key linking this message to the borrowers table
notifys borrowernumber int 10 0
patron_list_patrons borrowernumber int 10
patronimage borrowernumber int 10 the borrowernumber of the patron this image is attached to (borrowers.borrowernumber)
ratings borrowernumber int 10 the borrowernumber of the patron who left this rating (borrowers.borrowernumber)
reserves borrowernumber int 10 0 foreign key from the borrowers table defining which patron this hold is for
subscriptionroutinglist borrowernumber int 10 foreign key from the borrowers table, defines with patron is on the routing list
tmp_holdsqueue borrowernumber int 10
user_permissions borrowernumber int 10 0
housebound_role borrowernumber_id int 10 borrowernumber link
borrower_sync borrowersyncid int 10  √  Primary key, unique identifier
creator_batches branch_code varchar 10 NB
authorised_values_branches branchcode varchar 10
borrowers branchcode varchar 10 foreign key from the branches table, includes the code of the patron/borrower's home branch
branch_borrower_circ_rules branchcode varchar 10 the branch this rule applies to (branches.branchcode)
branch_item_rules branchcode varchar 10 the branch this rule is for (branches.branchcode)
branches branchcode varchar 10 a unique key assigned to each branch
branchrelations branchcode varchar 10 foreign key from the branches table to identify the branch
default_branch_circ_rules branchcode varchar 10
deletedborrowers branchcode varchar 10 foreign key from the branches table, includes the code of the patron/borrower's home branch
edifact_ean branchcode varchar 10
issuingrules branchcode varchar 10 the branch this rule is for (branches.branchcode)
item_circulation_alert_preferences branchcode varchar 10
letter branchcode varchar 10 the branch this notice or slip is used at (branches.branchcode)
message_transports branchcode varchar 10
overduerules branchcode varchar 10 foreign key from the branches table to define which branch this rule is for (if blank it's all libraries)
pending_offline_operations branchcode varchar 10
refund_lost_item_fee_rules branchcode varchar 10 the branch this rule is for (branches.branchcode)
repeatable_holidays branchcode varchar 10 foreign key from the branches table, defines which branch this closing is for
special_holidays branchcode varchar 10 foreign key from the branches table, defines which branch this closing is for
subscription branchcode varchar 10 default branches (items.homebranch)
branches branchname mediumtext 16777215 the name of your library or branch
branchtransfers branchtransfer_id int 10  √  primary key
aqbudgetborrowers budget_id int 10
aqbudgets budget_id int 10  √  primary key and unique number assigned to each fund by Koha
aqbudgets_planning budget_id int 10
aqorders budget_id int 10 the fund this order goes against (aqbudgets.budget_id)
aqbudgetperiods budget_period_enddate date 10 date when the budget ends
aqbudgetperiods budget_period_id int 10  √  primary key and unique number assigned by Koha
aqbudgets_planning budget_period_id int 10
aqbudgetperiods budget_period_startdate date 10 date when the budget starts
saved_sql cache_expiry int 10 300
import_record_matches candidate_match_id int 10 the biblio the imported record matches (biblio.biblionumber)
columns_settings cannot_be_toggled int 10 0
issuingrules cap_fine_to_replacement_price bit 0 0 cap the fine based on item's replacement price
authorised_values category varchar 32 key used to identify the authorized value category
authorised_value_categories category_name varchar 32
categories category_type varchar 1 A type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
borrowers categorycode varchar 10 foreign key from the categories table, includes the code of the patron category
branch_borrower_circ_rules categorycode varchar 10 the patron category this rule applies to (categories.categorycode)
branchcategories categorycode varchar 10 unique identifier for the library/branch group
branchrelations categorycode varchar 10 foreign key from the branchcategories table to identify the group
categories categorycode varchar 10 unique primary key used to idenfity the patron category
default_borrower_circ_rules categorycode varchar 10 patron category this rul
deletedborrowers categorycode varchar 10 foreign key from the categories table, includes the code of the patron category
issuingrules categorycode varchar 10 patron category this rule is for (categories.categorycode)
item_circulation_alert_preferences categorycode varchar 10
overduerules categorycode varchar 10 foreign key from the categories table to define which patron category this rule is for
issuingrules chargeperiod_charge_at bit 0 0 Should fine be given at the start ( 1 ) or the end ( 0 ) of the period
itemtypes checkinmsgtype char 16 message type (CSS class) for the checkinmsg, can be "alert" or "message"
borrowers checkprevcheckout varchar 7 inherit produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
categories checkprevcheckout varchar 7 inherit produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'.
deletedborrowers checkprevcheckout varchar 7 inherit produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
course_items ci_id int 10  √  course item id
course_reserves ci_id int 10 foreign key to link to courses_items.ci_id
borrowers city mediumtext 16777215 the city or town for your patron/borrower's primary address
deletedborrowers city mediumtext 16777215 the city or town for your patron/borrower's primary address
cities city_name varchar 100 name of the city
cities cityid int 10  √  unique identifier added by Koha
aqcontacts claimacquisition bit 0 0 should this contact receive acquisitions claims
aqcontacts claimissues bit 0 0 should this contact receive serial claims
borrower_attribute_types class varchar 255
class_sort_rules class_sort_rule varchar 10
class_sources class_sort_rule varchar 10
browser classification varchar 20
subscription closed int 10 0 yes / no if the subscription is closed
club_enrollment_fields club_enrollment_id int 10
club_enrollments club_id int 10
club_fields club_id int 10
club_enrollment_fields club_template_enrollment_field_id int 10
club_fields club_template_field_id int 10
club_template_enrollment_fields club_template_id int 10
club_template_fields club_template_id int 10
clubs club_template_id int 10
class_sources cn_source varchar 10
borrower_attribute_types code varchar 10 unique key used to identify each custom field
borrower_attributes code varchar 10 foreign key from the borrower_attribute_types table, defines which custom field this value was entered for
letter code varchar 20 unique identifier for this notice or slip
localization code varchar 64
marc_matchers code varchar 10
permissions code varchar 64
creator_templates col_gap float 12 0
collections colDesc text 65535
collections colId int 10  √ 
collections_tracking colId int 10 0 collections.colId
collections_tracking collections_tracking_id int 10  √ 
creator_templates cols int 10 0
collections colTitle varchar 100
columns_settings columnname varchar 255
marc_modification_template_actions conditional_regex bit 0 0
export_format content mediumtext 16777215
opac_news content text 65535 the body of your news article
aqcontract contractnumber int 10  √ 
transport_cost cost decimal 6,2
subscription countissuesperunit int 10 1
course_instructors course_id int 10 foreign key to link to courses.course_id
course_reserves course_id int 10 foreign key to link to courses.course_id
courses course_id int 10  √  unique id for the course
course_reserves cr_id int 10  √ 
borrower_debarments created timestamp 19 CURRENT_TIMESTAMP date the restriction was added
article_requests created_on timestamp 19 CURRENT_TIMESTAMP
items_last_borrower created_on timestamp 19 CURRENT_TIMESTAMP
virtualshelves created_on datetime 19 creation time
creator_batches creator char 15 Labels
creator_layouts creator char 15 Labels
creator_templates creator char 15 Labels
printers_profile creator char 15 Labels
printers_profile creep_horz float 12 0
printers_profile creep_vert float 12 0
export_format csv_separator varchar 2
aqbooksellers currency varchar 10 unused in Koha
currency currency varchar 10
deleteditems damaged bit 0 0 authorized value defining this item as damaged (MARC21 952$4)
items damaged bit 0 0 authorized value defining this item as damaged (MARC21 952$4)
suggestions date timestamp 19 CURRENT_TIMESTAMP
club_enrollments date_created timestamp 19 0000-00-00 00:00:00
club_templates date_created timestamp 19 CURRENT_TIMESTAMP
clubs date_created timestamp 19 CURRENT_TIMESTAMP
tags_all date_created datetime 19 the date the tag was added
club_enrollments date_enrolled timestamp 19 CURRENT_TIMESTAMP
borrower_files date_uploaded timestamp 19 CURRENT_TIMESTAMP date and time the file was added
misc_files date_uploaded timestamp 19 CURRENT_TIMESTAMP date and time the file was added
virtualshelfcontents dateadded timestamp 19 CURRENT_TIMESTAMP date and time this bib record was added to the list
biblio datecreated date 10 the date this record was added to Koha
deletedbiblio datecreated date 10 the date this record was added to Koha
housebound_profile day text 65535
special_holidays day smallint 5 0 day of the month this closing is on
categories default_privacy enum 8 default Default privacy setting for this patron category
edifact_messages deleted bit 0 0
borrower_attribute_types description varchar 255 description for each custom field
browser description varchar 255
export_format description mediumtext 16777215
marc_matchers description varchar 255
oai_sets_descriptions description varchar 255
repeatable_holidays description text 65535 description for this closing
special_holidays description text 65535 description of this closing
subscription_frequencies description text 65535
subscription_numberpatterns description text 65535
vendor_edi_accounts description text 65535
uploaded_files dir text 65535
transport_cost disable_transfer bit 0 0
discharges discharge_id int 10  √ 
borrower_attribute_types display_checkout bit 0 0
sms_providers domain varchar 255
zebraqueue done int 10 0
uploaded_files dtcreated timestamp 19 CURRENT_TIMESTAMP
edifact_ean ean varchar 15
edifact_ean ee_id int 10  √ 
course_items enabled enum 4 no if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
courses enabled enum 4 yes determines whether the course is active
export_format encoding varchar 255
import_records encoding varchar 40
browser endnode tinyint 3
localization entity varchar 16
tags entry varchar 255
export_format export_format_id int 10  √ 
alert externalid varchar 20
fieldmapping field varchar 255 keyword to be mapped to (ex. subtitle)
additional_field_values field_id int 10 foreign key references additional_fields(id)
marc_modification_template_actions field_number smallint 5 0
export_format field_separator varchar 2
fieldmapping fieldcode char 3 marc field number to map to this keyword
borrower_files file_content longblob 2147483647 the file
misc_files file_content longblob 2147483647 file content
borrower_files file_id int 10  √  unique key
misc_files file_id int 10  √  unique id for the file record
borrower_files file_name varchar 255 file name
misc_files file_name varchar 255 file name
borrower_files file_type varchar 255 type of file
misc_files file_type varchar 255 MIME type of the file
uploaded_files filename text 65535
creator_layouts font char 10 TR
creator_layouts font_size int 10 10
biblio_metadata format varchar 16
deletedbiblio_metadata format varchar 16
creator_layouts format_string varchar 210 barcode
auth_subfield_structure frameworkcode varchar 10
biblio frameworkcode varchar 4 foreign key from the biblio_framework table to identify which framework was used in cataloging this record
biblio_framework frameworkcode varchar 4 the unique code assigned to the framework
deletedbiblio frameworkcode varchar 4 foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
fieldmapping frameworkcode char 4 foreign key from the biblio_framework table to link this mapping to a specific framework
marc_subfield_structure frameworkcode varchar 4
marc_tag_structure frameworkcode varchar 4
biblio_framework frameworktext varchar 255 the description/name given to the framework
housebound_profile frequency text 65535 The Authorised_Value definining the pattern for delivery.
marc_modification_template_actions from_field varchar 3
branch_transfer_limits fromBranch varchar 10
branchtransfers frombranch varchar 10 the branch the transfer is coming from
transport_cost frombranch varchar 10
subscription graceperiod int 10 0 grace period in days
issuingrules hardduedatecompare tinyint 3 0 type of hard due date (1 = after, 0 = on, -1 = before)
import_biblios has_items bit 0 0
uploaded_files hashvalue char 40
auth_subfield_structure hidden tinyint 3 0
itemtypes hideinopac bit 0 0 Hide the item type from the search options in OPAC
categories hidelostitems bit 0 0 are lost items shown to this category (1 for yes, 0 for no)
branch_item_rules hold_fulfillment_policy enum 13 any limit trapping of holds by branchcode
default_branch_circ_rules hold_fulfillment_policy enum 13 any limit trapping of holds by branchcode
default_branch_item_rules hold_fulfillment_policy enum 13 any limit trapping of holds by branchcode
default_circ_rules hold_fulfillment_policy enum 13 any limit trapping of holds by branchcode
issuingrules holds_per_record smallint 5 1 How many holds a patron can have on a given bib
housebound_role housebound_chooser bit 0 0 set to 1 to indicate this patron is a housebound chooser volunteer
housebound_role housebound_deliverer bit 0 0 set to 1 to indicate this patron is a housebound deliverer volunteer
additional_field_values id int 10  √  primary key identifier
additional_fields id int 10  √  primary key identifier
aqbasketgroups id int 10  √ 
aqbooksellers id int 10  √  primary key and unique identifier assigned by Koha
aqcontacts id int 10  √  primary key and unique number assigned by Koha
article_requests id int 10  √ 
audio_alerts id int 10  √ 
authorised_values id int 10  √  unique key, used to identify the authorized value
biblio_metadata id int 10  √ 
borrower_attributes id int 10  √  Row id field
club_enrollment_fields id int 10  √ 
club_enrollments id int 10  √ 
club_fields id int 10  √ 
club_template_enrollment_fields id int 10  √ 
club_template_fields id int 10  √ 
club_templates id int 10  √ 
clubs id int 10  √ 
deletedbiblio_metadata id int 10  √ 
edifact_messages id int 10  √ 
fieldmapping id int 10  √  unique identifier assigned by Koha
housebound_visit id int 10  √  ID of the visit.
item_circulation_alert_preferences id int 10  √ 
items_last_borrower id int 10  √ 
language_descriptions id int 10  √ 
language_rfc4646_to_iso639 id int 10  √ 
language_subtag_registry id int 10  √ 
linktracker id int 10  √  primary key identifier
need_merge_authorities id int 10  √  unique id
oai_sets id int 10  √ 
overduerules_transport_types id int 10  √ 
quotes id int 10  √  unique id for the quote
repeatable_holidays id int 10  √  unique identifier assigned by Koha
reports_dictionary id int 10  √  unique identifier assigned by Koha
saved_reports id int 10  √ 
saved_sql id int 10  √  unique id and primary key assigned by Koha
search_field id int 10  √ 
search_history id int 10  √  search history id
search_marc_map id int 10  √ 
sessions id varchar 32
sms_providers id int 10  √ 
special_holidays id int 10  √  unique identifier assigned by Koha
subscription_frequencies id int 10  √ 
subscription_numberpatterns id int 10  √ 
uploaded_files id int 10  √ 
vendor_edi_accounts id int 10  √ 
virtualshelfshares id int 10  √ 
z3950servers id int 10  √  unique identifier assigned by Koha
zebraqueue id int 10  √ 
edifact_ean id_code_qualifier varchar 3 14
opac_news idnew int unsigned 10  √  unique identifier for the news article
creator_images image_id int 10  √ 
creator_images image_name char 20 DEFAULT
biblioimages imagefile mediumblob 16777215 image file contents
patronimage imagefile mediumblob 16777215 the image
biblioimages imagenumber int 10  √  unique identifier for the image
import_batches import_batch_id int 10  √  unique identifier and primary key
import_records import_batch_id int 10
import_items import_items_id int 10  √ 
import_auths import_record_id int 10
import_biblios import_record_id int 10
import_items import_record_id int 10
import_record_matches import_record_id int 10 the id given to the imported bib record (import_records.import_record_id)
import_records import_record_id int 10  √ 
import_batches import_status enum 9 staging the status of the imported file
search_marc_map index_name enum 11 what storage index this map is for
aqinvoices invoiceid int 10  √ 
aqinvoices invoicenumber mediumtext 16777215
vendor_edi_accounts invoices_enabled bit 0 0
club_templates is_deletable bit 0 1
message_transports is_digest bit 0 0
club_templates is_email_required bit 0 0
club_templates is_enrollable_from_opac bit 0 0
columns_settings is_hidden int 10 0
aqbasket is_standing bit 0 0 orders in this basket are standing
social_data isbn varchar 30
special_holidays isexception smallint 5 1 is this a holiday exception to a repeatable holiday (1 for yes, 0 for no)
issues issue_id int 10  √  primary key for issues table
old_issues issue_id int 10 primary key for issues table
subscription_frequencies issuesperunit int 10 1
import_batches item_action enum 20 always_add what to do with item records
hold_fill_targets item_level_request tinyint 3 0
tmp_holdsqueue item_level_request tinyint 3 0
item_circulation_alert_preferences item_type varchar 10
deleteditems itemlost bit 0 0 authorized value defining this item as lost (MARC21 952$1)
items itemlost bit 0 0 authorized value defining this item as lost (MARC21 952$1)
aqorders_items itemnumber int 10 the item number for this item (items.itemnumber)
branchtransfers itemnumber int 10 0 the itemnumber that it is in transit (items.itemnumber)
collections_tracking itemnumber int 10 0 items.itemnumber
course_items itemnumber int 10 items.itemnumber for the item on reserve
deleteditems itemnumber int 10 0 primary key and unique identifier added by Koha
hold_fill_targets itemnumber int 10
items itemnumber int 10  √  primary key and unique identifier added by Koha
items_last_borrower itemnumber int 10
notifys itemnumber int 10 0
serialitems itemnumber int 10
branch_item_rules itemtype varchar 10 the item type this rule applies to (items.itype)
default_branch_item_rules itemtype varchar 10
issuingrules itemtype varchar 10 item type this rule is for (itemtypes.itemtype)
itemtypes itemtype varchar 10 unique key, a code associated with the item type
items_search_fields label varchar 255
search_field label varchar 255 the human readable name of the field, for display
subscription_numberpatterns label varchar 255
creator_templates label_height float 12 0
creator_batches label_id int 10  √ 
creator_templates label_width float 12 0
borrowers lang varchar 25 default lang to use to send notices to this patron
deletedborrowers lang varchar 25 default lang to use to send notices to this patron
letter lang varchar 25 default lang of the notice
localization lang varchar 25 could be a foreign key
opac_news lang varchar 25 location for the article (koha is the staff client, slip is the circulation receipt and language codes are for the opac)
virtualshelves lastmodified timestamp 19 CURRENT_TIMESTAMP date and time the list was last modified
creator_layouts layout_id int 10  √ 
creator_layouts layout_name char 25 DEFAULT
creator_layouts layout_xml text 65535
creator_templates left_margin float 12 0
creator_templates left_text_margin float 12 0
matchpoint_components length int 10 0
message_transports letter_code varchar 20
message_transports letter_module varchar 20
overduerules_transport_types letternumber int 10 1
browser level int 10
auth_subfield_structure liblibrarian varchar 255
auth_tag_structure liblibrarian varchar 255
marc_subfield_structure liblibrarian varchar 255
marc_tag_structure liblibrarian varchar 255
auth_subfield_structure libopac varchar 255
auth_tag_structure libopac varchar 255
marc_subfield_structure libopac varchar 255
marc_tag_structure libopac varchar 255
subscriptionhistory librariannote varchar 150
branch_transfer_limits limitId int 10  √ 
auth_subfield_structure linkid bit 0 0
localization localization_id int 10  √ 
old_reserves lowestPriority bit 0 has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
reserves lowestPriority bit 0
auth_subfield_structure mandatory tinyint 3 0
auth_tag_structure mandatory tinyint 3 0
marc_subfield_structure mandatory tinyint 3 0
marc_tag_structure mandatory tinyint 3 0
subscription manualhistory bit 0 0 yes or no to managing the history manually
import_records marc longblob 2147483647
search_marc_map marc_field varchar 255 the MARC specifier for this field
search_marc_map marc_type enum 7 what MARC type this map is for
additional_fields marcfield varchar 16 contains the marc field to copied into the record
oai_sets_mappings marcfield char 3
biblio_metadata marcflavour varchar 16
deletedbiblio_metadata marcflavour varchar 16
oai_sets_mappings marcsubfield char 1
oai_sets_mappings marcvalue varchar 80
auth_header marcxml longtext 2147483647
import_items marcxml longtext 2147483647
import_records marcxml longtext 2147483647
import_records marcxml_old longtext 2147483647
matchchecks matchcheck_id int 10  √ 
marc_matchers matcher_id int 10  √ 
matchchecks matcher_id int 10
matcher_matchpoints matcher_id int 10
matchpoints matcher_id int 10
matchpoint_component_norms matchpoint_component_id int 10
matchpoint_components matchpoint_component_id int 10  √ 
matcher_matchpoints matchpoint_id int 10
matchpoint_components matchpoint_id int 10
matchpoints matchpoint_id int 10  √ 
marc_subfield_structure maxlength int 10 9999
messages message text 65535 the text of the message
message_attributes message_attribute_id int 10  √ 
message_transports message_attribute_id int 10
messages message_date timestamp 19 CURRENT_TIMESTAMP the date and time the message was written
message_queue message_id int 10  √ 
messages message_id int 10  √  unique identifier assigned by Koha
message_attributes message_name varchar 40
borrower_message_transport_preferences message_transport_type varchar 20 0
letter message_transport_type varchar 20 email transport type for this notice
message_queue message_transport_type varchar 20
message_transport_types message_transport_type varchar 20
message_transports message_transport_type varchar 20
overduerules_transport_types message_transport_type varchar 20 email
edifact_messages message_type varchar 10
messages message_type varchar 1 whether the message is for the librarians (L) or the patron (B)
biblio_metadata metadata longtext 2147483647
deletedbiblio_metadata metadata longtext 2147483647
notifys method varchar 20
biblioimages mimetype varchar 15 image type
patronimage mimetype varchar 15 the format of the image (png, jpg, etc)
subscriptionhistory missinglist longtext 2147483647
marc_modification_template_actions mmta_id int 10  √ 
auth_header modification_time timestamp 19 CURRENT_TIMESTAMP
columns_settings module varchar 255
letter module varchar 20 Koha module that triggers this notice or slip
permissions module_bit int 10 0
user_permissions module_bit int 10 0
special_holidays month smallint 5 0 month this closing is in
additional_fields name varchar 255 name of the field
aqbooksellers name mediumtext 16777215 vendor name
club_template_enrollment_fields name tinytext 255
club_template_fields name tinytext 255
club_templates name tinytext 255
clubs name tinytext 255
items_search_fields name varchar 255
letter name varchar 100 plain text name for this notice or slip
marc_modification_templates name text 65535
oai_sets name varchar 80
patron_lists name varchar 255
search_field name varchar 255 the name of the field as it will be stored in the search engine
sms_providers name varchar 255
import_batches nomatch_action enum 11 create_new how to handle records where no match is found
matchpoint_component_norms norm_routine varchar 50
deleteditems notforloan bit 0 0 authorized value defining why this item is not for loan (MARC21 952$7)
items notforloan bit 0 0 authorized value defining why this item is not for loan (MARC21 952$7)
item_circulation_alert_preferences notification varchar 16
accountlines notify_id int 10 0
notifys notify_id int 10 0
accountlines notify_level int 10 0
notifys notify_level int 10 0
import_batches num_items int 10 0 number of items in the file
import_batches num_records int 10 0 number of records in the file
browser number bigint 19
subscription_numberpatterns numberingmethod varchar 255
matchpoint_components offset int 10 0
printers_profile offset_horz float 12 0
printers_profile offset_vert float 12 0
accountoffsets offsetaccount smallint 5 0
issuingrules onshelfholds bit 0 0 allow holds for items that are on shelf
issues onsite_checkout int 10 0 in house use flag
old_issues onsite_checkout int 10 0 in house use flag
borrower_attribute_types opac_display bit 0 0 defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no)
borrower_attribute_types opac_editable bit 0 0 defines if this field is editable by patrons on their account in the OPAC (1 for yes, 0 for no)
issuingrules opacitemholds char 1 N allow opac users to place specific items on hold
subscriptionhistory opacnote varchar 150
zebraqueue operation char 20
pending_offline_operations operationid int 10  √ 
oai_sets_mappings operator varchar 8 equal
aqcontacts orderacquisition bit 0 0 should this contact receive acquisition orders
marc_modification_template_actions ordering int 10
aqorder_users ordernumber int 10 the order this patrons receive notifications from (aqorders.ordernumber)
aqorders ordernumber int 10  √  primary key and unique identifier assigned by Koha to each line
aqorders_items ordernumber int 10 the order this item is attached to (aqorders.ordernumber)
vendor_edi_accounts orders_enabled bit 0 0
overduerules overduerules_id int 10  √  unique identifier for the overduerules
overduerules_transport_types overduerules_id int 10
import_batches overlay_action enum 12 create_new how to handle duplicate records
import_records overlay_status enum 13 no_match
patron_lists owner int 10
columns_settings page varchar 255
creator_templates page_height float 12 0
creator_templates page_width float 12 0
printers_profile paper_bin varchar 20 Bypass
patron_list_patrons patron_list_id int 10
patron_lists patron_list_id int 10  √  unique identifier
patron_list_patrons patron_list_patron_id int 10  √  unique identifier
aqbudgets_planning plan_id int 10  √ 
vendor_edi_accounts plugin varchar 256
plugin_data plugin_class varchar 255
plugin_data plugin_key varchar 255
audio_alerts precedence smallint unsigned 5
printers_profile printer_name varchar 40 Default Printer
printers printername varchar 40
creator_layouts printing_type char 32 BAR
borrowers privacy int 10 1 patron/borrower's privacy settings related to their reading history
deletedborrowers privacy int 10 1 patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`),
borrowers privacy_guarantor_checkouts bit 0 0 controls if relatives can see this patron's checkouts
deletedborrowers privacy_guarantor_checkouts bit 0 0 controls if relatives can see this patron's checkouts
export_format profile varchar 255
printers_profile profile_id int 10  √ 
saved_sql public bit 0 0
aqorders quantityreceived smallint 5 0 the quantity that have been received so far
search_history query_cgi text 65535 the string to append to the search url to rerun the search
search_history query_desc varchar 255 the search that was performed
vendor_edi_accounts quotes_enabled bit 0 0
ratings rating_value bit 0 the rating, from 1 to 5
subscriptionhistory recievedlist longtext 2147483647
additional_field_values record_id int 10 record_id
misc_files record_id int 10 record id from the table this file is associated to
import_records record_sequence int 10 0
import_batches record_type enum 8 biblio type of record in the batch
import_records record_type enum 8 biblio
marc_matchers record_type varchar 10 biblio
z3950servers recordtype enum 10 biblio server contains bibliographic or authority records
refund_lost_item_fee_rules refund bit 0 0 control wether to refund lost item fees on return
issuingrules renewalsallowed smallint 5 0 how many renewals are allowed
auth_subfield_structure repeatable tinyint 3 0
auth_tag_structure repeatable tinyint 3 0
borrower_attribute_types repeatable bit 0 0 defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no)
marc_subfield_structure repeatable tinyint 3 0
marc_tag_structure repeatable tinyint 3 0
saved_sql report_name varchar 255 the name of this report
old_reserves reserve_id int 10 primary key
reserves reserve_id int 10  √  primary key
issuingrules reservesallowed smallint 5 0 how many holds are allowed
vendor_edi_accounts responses_enabled bit 0 0
reviews reviewid int 10  √  unique identifier for this comment
subscriptionroutinglist routingid int 10  √  unique identifier assigned by Koha
creator_templates row_gap float 12 0
creator_templates rows int 10 0
import_record_matches score int 10 0 the match score
matchpoints score int 10 0
search_marc_to_field search_field_id int 10
matchpoints search_index varchar 30
search_marc_to_field search_marc_map_id int 10
additional_fields searchable bit 0 0 is the field searchable?
audio_alerts selector varchar 255
matchpoint_component_norms sequence int 10 0
matchpoint_components sequence int 10 0
serial serialid int 10  √  unique key for the issue
serialitems serialid int 10
subscription serialsadditems bit 0 0 does receiving this serial create an item record
serial serialseq varchar 100 issue information (volume, number, etc)
aqcontacts serialsprimary bit 0 0 is this the primary contact for serials messages
zebraqueue server char 20
z3950servers servername mediumtext 16777215 name given to the target by the library
z3950servers servertype enum 4 zed zed means z39.50 server
services_throttle service_type varchar 10
search_history sessionid varchar 32 a system generated session id
oai_sets_biblios set_id int 10
oai_sets_descriptions set_id int 10
oai_sets_mappings set_id int 10
virtualshelfcontents shelfnumber int 10 0 foreign key linking to the virtualshelves table, defines the list that this record has been added to
virtualshelfshares shelfnumber int 10
virtualshelves shelfnumber int 10  √  unique identifier assigned by Koha
branchcategories show_in_pulldown bit 0 0 says this group should be in the opac libararies pulldown if it is enabled
default_circ_rules singleton enum 10 singleton
subscription skip_serialseq bit 0 0
class_sort_rules sort_routine varchar 30
audio_alerts sound varchar 255
matchchecks source_matchpoint_id int 10
oai_sets spec varchar 80
borrower_attribute_types staff_searchable bit 0 0 defines if this field is searchable via the patron search in the staff client (1 for yes, 0 for no)
creator_layouts start_label int 10 1
article_requests status enum 10 PENDING
import_items status enum 8 staged
import_records status enum 14 staged
message_queue status enum 7 pending
serial status tinyint 3 0 status code for this issue (see manual for full descriptions)
subscription status varchar 100
suggestions STATUS varchar 10 suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
export_format subfield_separator varchar 2
fieldmapping subfieldcode char 1 marc subfield associated with the fieldcode to map to this keyword
matchpoint_components subfields varchar 40
serial subscriptionid varchar 100 foreign key to the subscription.subscriptionid that this issue is part of
subscription subscriptionid int 10  √  unique key for this subscription
subscriptionhistory subscriptionid int 10 0
subscriptionroutinglist subscriptionid int 10 foreign key from the subscription table, defines which subscription this routing list is for
suggestions suggestedby int 10 0 borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
suggestions suggesteddate date 10 date the suggestion was submitted
suggestions suggestionid int 10  √  unique identifier assigned automatically by Koha
auth_types summary mediumtext 16777215
borrowers surname mediumtext 16777215 patron/borrower's last name (surname)
deletedborrowers surname mediumtext 16777215 patron/borrower's last name (surname)
tmp_holdsqueue surname mediumtext 16777215
old_reserves suspend bit 0 0 in this hold suspended (1 for yes, 0 for no)
reserves suspend bit 0 0
borrower_sync sync bit 0 0 A boolean (1/0) for turning syncing off and on for individual borrowers
borrower_sync synctype varchar 32 There could potentially be more than one kind of syncing going on, a text string here can be used to tell them apart. E.g.: The Norwegian national patron database uses 'norwegianpatrondb' in this column
misc_files table_tag varchar 255 usually table name, or arbitrary unique tag
additional_fields tablename varchar 255 tablename of the new field
columns_settings tablename varchar 255
matchpoint_components tag varchar 3
tags_all tag_id int 10  √  unique id and primary key
auth_subfield_structure tagfield varchar 3
auth_tag_structure tagfield varchar 3
items_search_fields tagfield char 3
marc_subfield_structure tagfield varchar 3
marc_tag_structure tagfield varchar 3
auth_subfield_structure tagsubfield varchar 1
marc_subfield_structure tagsubfield varchar 1
message_attributes takes_days bit 0 0
matchchecks target_matchpoint_id int 10
creator_templates template_code char 100 DEFAULT TEMPLATE
creator_templates template_desc char 100 Default description
creator_templates template_id int 10  √ 
marc_modification_template_actions template_id int 10
marc_modification_templates template_id int 10  √ 
printers_profile template_id int 10 0
tags_all term varchar 255 the tag
tags_approval term varchar 255 the tag
tags_index term varchar 255 the tag
quotes text mediumtext 16777215 text of the quote
creator_layouts text_justify char 1 L
marc_matchers threshold int 10 0
biblioimages thumbnail mediumblob 16777215 thumbnail file contents
search_history time timestamp 19 CURRENT_TIMESTAMP the date and time the search was run
zebraqueue time timestamp 19 CURRENT_TIMESTAMP
message_queue time_queued timestamp 19 CURRENT_TIMESTAMP
z3950servers timeout int 10 0 number of seconds before Koha stops trying to access this server
accountlines timestamp timestamp 19 CURRENT_TIMESTAMP
accountoffsets timestamp timestamp 19 CURRENT_TIMESTAMP
action_logs timestamp timestamp 19 CURRENT_TIMESTAMP the date and time the action took place
aqbudgets timestamp timestamp 19 CURRENT_TIMESTAMP date and time this fund was last touched (created or modified)
aqorders timestamp timestamp 19 CURRENT_TIMESTAMP the date and time this order line was last modified
aqorders_items timestamp timestamp 19 CURRENT_TIMESTAMP the date and time this order item was last touched
aqorders_transfers timestamp timestamp 19 CURRENT_TIMESTAMP
biblio timestamp timestamp 19 CURRENT_TIMESTAMP date and time this record was last touched
biblioitems timestamp timestamp 19 CURRENT_TIMESTAMP
borrower_modifications timestamp timestamp 19 CURRENT_TIMESTAMP
course_items timestamp timestamp 19 CURRENT_TIMESTAMP
course_reserves timestamp timestamp 19 CURRENT_TIMESTAMP
courses timestamp timestamp 19 CURRENT_TIMESTAMP
creator_batches timestamp timestamp 19 CURRENT_TIMESTAMP
currency timestamp timestamp 19 CURRENT_TIMESTAMP
deletedbiblio timestamp timestamp 19 CURRENT_TIMESTAMP date and time this record was last touched
deletedbiblioitems timestamp timestamp 19 CURRENT_TIMESTAMP
deleteditems timestamp timestamp 19 CURRENT_TIMESTAMP date and time this item was last altered
issues timestamp timestamp 19 CURRENT_TIMESTAMP the date and time this record was last touched
items timestamp timestamp 19 CURRENT_TIMESTAMP date and time this item was last altered
need_merge_authorities timestamp timestamp 19 CURRENT_TIMESTAMP date and time last modified
old_issues timestamp timestamp 19 CURRENT_TIMESTAMP the date and time this record was last touched
old_reserves timestamp timestamp 19 CURRENT_TIMESTAMP the date and time this hold was last updated
opac_news timestamp timestamp 19 CURRENT_TIMESTAMP pulibcation date and time
pending_offline_operations timestamp timestamp 19 CURRENT_TIMESTAMP
quotes timestamp datetime 19 date and time that the quote last appeared in the opac
ratings timestamp timestamp 19 CURRENT_TIMESTAMP
reserves timestamp timestamp 19 CURRENT_TIMESTAMP the date and time this hold was last updated
letter title varchar 200 subject line of the notice
opac_news title varchar 250 title of the news article
repeatable_holidays title varchar 50 title of this closing
special_holidays title varchar 50 title for this closing
branch_transfer_limits toBranch varchar 10
branchtransfers tobranch varchar 10 the branch the transfer was going to
transport_cost tobranch varchar 10
creator_templates top_margin float 12 0
creator_templates top_text_margin float 12 0
search_history total int 10 the total of results found
alert type varchar 10
borrower_debarments type enum 11 MANUAL type of restriction
search_field type enum 7 what type of data this holds, relevant when storing it in the search engine
search_history type varchar 16 biblio search type, must be 'biblio' or 'authority'
borrower_attribute_types unique_id bit 0 0 defines if this value needs to be unique (1 for yes, 0 for no)
creator_layouts units char 20 POINT
creator_templates units char 20 POINT
printers_profile units char 20 POINT
subscription_frequencies unitsperissue int 10 1
borrowers updated_on timestamp 19 CURRENT_TIMESTAMP time of last change could be useful for synchronization with external systems (among others)
deletedborrowers updated_on timestamp 19 CURRENT_TIMESTAMP time of last change could be useful for synchronization with external systems (among others)
import_batches upload_timestamp timestamp 19 CURRENT_TIMESTAMP date and time the file was uploaded
import_records upload_timestamp timestamp 19 CURRENT_TIMESTAMP
class_sources used tinyint 3 0
action_logs user int 10 0 the staff member who performed the action (borrowers.borrowernumber)
pending_offline_operations userid varchar 30
search_history userid int 10 the patron who performed the search (borrowers.borrowernumber)
borrower_password_recovery uuid varchar 128 a unique string to identify a password recovery attempt
borrower_password_recovery valid_until timestamp 19 CURRENT_TIMESTAMP a time limit on the password recovery attempt
additional_field_values value varchar 255 value for this field
club_enrollment_fields value text 65535
systempreferences variable varchar 50 system preference name
borrower_modifications verification_token varchar 255
borrower_message_preferences wants_digest bit 0 0
tags weight bigint 19 0
tags_index weight int 10 1 the number of times this term was used on this bib record
tags_approval weight_total int 10 1 the total number of times this tag was used
deleteditems withdrawn bit 0 0 authorized value defining this item as withdrawn (MARC21 952$0)
items withdrawn bit 0 0 authorized value defining this item as withdrawn (MARC21 952$0)
special_holidays year smallint 5 0 year this closing is in