Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
deleteditems Table booksellerid LONGTEXT 2147483647 √ null

where the item was purchased (MARC21 952$e)
account_credit_types Table code VARCHAR 80 null
saved_sql Table report_area VARCHAR 6 √ null
suggestions Table publicationyear SMALLINT 5 √ 0
import_biblios Table has_items BIT 0 0
export_format Table used_for VARCHAR 255 √ export_records
borrower_modifications Table B_city LONGTEXT 2147483647 √ null
matchpoint_components Table subfields VARCHAR 40
deletedborrowers Table streettype VARCHAR 50 √ null

the street type (Rd., Blvd, etc) for your patron/borrower's primary address
borrower_modifications Table surname LONGTEXT 2147483647 √ null
items Table itemlost BIT 0 0

authorized value defining this item as lost (MARC21 952$1)
deletedborrowers Table othernames LONGTEXT 2147483647 √ null

any other names associated with the patron/borrower
itemtypes Table imageurl VARCHAR 200 √ null

URL for the item type icon
special_holidays Table day SMALLINT 5 0

day of the month this closing is on
import_record_matches Table candidate_match_id INT 10 null

the biblio the imported record matches (biblio.biblionumber)
borrowers Table updated_on TIMESTAMP 19 current_timestamp()

time of last change could be useful for synchronization with external systems (among others)
club_holds Table id INT 10 √ null
matchpoint_components Table offset INT 10 0
edifact_messages Table deleted BIT 0 0
subscription_numberpatterns Table add2 INT 10 √ null
illrequestattributes Table value MEDIUMTEXT 16777215 null
saved_sql Table savedsql MEDIUMTEXT 16777215 √ null

the SQL for this report
biblioitems Table volumedesc MEDIUMTEXT 16777215 √ null

volume information (MARC21 362$a)
authorised_values_branches Table av_id INT 10 null
plugin_data Table plugin_key VARCHAR 255 null
misc_files Table file_name VARCHAR 255 null

file name
subscription Table location VARCHAR 80 √

default shelving location (items.location)
old_issues Table timestamp TIMESTAMP 19 current_timestamp()

the date and time this record was last touched
borrowers Table dateenrolled DATE 10 √ null

date the patron was added to Koha (YYYY-MM-DD)
api_keys Table description VARCHAR 255 null
z3950servers Table add_xslt LONGTEXT 2147483647 √ null

zero or more paths to XSLT files to be processed on the search results
courses Table staff_note LONGTEXT 2147483647 √ null

the text of the staff only note
cash_registers Table branch VARCHAR 10 null

the foreign key the library this account register belongs
borrower_modifications Table opacnote LONGTEXT 2147483647 √ null
suggestions Table lastmodificationby INT 10 √ null

borrowernumber for the librarian who edit the suggestion for the last time
items Table booksellerid LONGTEXT 2147483647 √ null

where the item was purchased (MARC21 952$e)
old_issues Table auto_renew BIT 0 √ 0

automatic renewal
deletedborrowers Table altcontactaddress1 VARCHAR 255 √ null

the first address line for the alternate contact for the patron/borrower
borrower_modifications Table verification_token VARCHAR 255
statistics Table itemtype VARCHAR 10 √ null

foreign key from the itemtypes table, links transaction to a specific item type
course_instructors Table borrowernumber INT 10 null

foreign key to link to borrowers.borrowernumber for instructor information
subscription_numberpatterns Table setto2 INT 10 √ null
uploaded_files Table hashvalue CHAR 40 null
vendor_edi_accounts Table auto_orders BIT 0 0
subscription Table aqbudgetid INT 10 √ 0
need_merge_authorities Table reportxml MEDIUMTEXT 16777215 √ null

xml showing original reporting tag
import_records Table status enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') 14 staged
uploaded_files Table filesize INT 10 √ null
account_credit_types Table can_be_added_manually TINYINT 3 1
biblioitems Table cn_sort VARCHAR 255 √ null

normalized version of the call number used for sorting
club_enrollments Table borrowernumber INT 10 null
marc_modification_template_actions Table conditional enum('if', 'unless') 6 √ null
matchpoint_component_norms Table matchpoint_component_id INT 10 null
search_marc_map Table marc_type enum('marc21', 'unimarc', 'normarc') 7 null

what MARC type this map is for
club_enrollments Table date_enrolled TIMESTAMP 19 current_timestamp()
import_biblios Table isbn VARCHAR 30 √ null
subscription Table internalnotes LONGTEXT 2147483647 √ null
aqbooksellers Table id INT 10 √ null

primary key and unique identifier assigned by Koha
deletedborrowers Table 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'.
import_items Table import_items_id INT 10 √ null
clubs Table description MEDIUMTEXT 16777215 √ null
search_marc_to_field Table suggestible BIT 0 √ 0

true if this field can be used to generate suggestions for browse
deletedborrowers Table borrowernumber INT 10 0

primary key, Koha assigned ID number for patrons/borrowers
uploaded_files Table filename MEDIUMTEXT 16777215 null
library_groups Table ft_hide_patron_info BIT 0 0

Turn on the feature "Hide patron's info" for this group
creator_templates Table top_text_margin FLOAT 12 0
borrowers Table privacy_guarantor_checkouts BIT 0 0

controls if relatives can see this patron's checkouts
aqbudgets Table budget_owner_id INT 10 √ null

borrowernumber of the person who owns this fund (borrowers.borrowernumber)
deletedbiblioitems Table isbn LONGTEXT 2147483647 √ null

ISBN (MARC21 020$a)
deletedbiblio Table timestamp TIMESTAMP 19 current_timestamp()

date and time this record was last touched
search_marc_to_field Table search_field_id INT 10 null
aqbooksellers Table address4 LONGTEXT 2147483647 √ null

fourth line of vendor physical address
export_format Table content LONGTEXT 2147483647 null
cash_registers Table archived BIT 0 0

boolean flag to denote if this till is archived or not
deletedborrowers Table mobile VARCHAR 50 √ null

the other phone number for your patron/borrower's primary address
deletedbiblio Table author LONGTEXT 2147483647 √ null

statement of responsibility from MARC record (100$a in MARC21)
marc_subfield_structure Table isurl BIT 0 √ null
creator_layouts Table font CHAR 10 TR
serial Table serialseq VARCHAR 100

issue information (volume, number, etc)
biblio Table subtitle LONGTEXT 2147483647 √ null

remainder of the title from the MARC record (245$b in MARC21)
deletedbiblio Table seriestitle LONGTEXT 2147483647 √ null
social_data Table num_scores INT 10 √ null
collections Table colId INT 10 √ null
biblioitems Table place VARCHAR 255 √ null

publication place (MARC21 260$a)
borrowers Table 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
borrower_modifications Table streettype VARCHAR 50 √ null
courses Table section VARCHAR 255 √ null

the 'section' of a course
patron_lists Table patron_list_id INT 10 √ null

unique identifier
items Table dateaccessioned DATE 10 √ null

date the item was acquired or added to Koha (MARC21 952$d)
ratings Table timestamp TIMESTAMP 19 current_timestamp()
matchpoints Table matcher_id INT 10 null
opac_news Table idnew INT UNSIGNED 10 √ null

unique identifier for the news article
cash_register_actions Table timestamp TIMESTAMP 19 current_timestamp()
search_field Table id INT 10 √ null
library_groups Table created_on TIMESTAMP 19 √ null
deletedbiblioitems Table cn_class VARCHAR 30 √ null
aqorders Table created_by INT 10 √ null

the borrowernumber of order line's creator
search_field Table staff_client BIT 0 1
accountlines Table note MEDIUMTEXT 16777215 √ null
suggestions Table acceptedby INT 10 √ null

borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table
need_merge_authorities Table timestamp TIMESTAMP 19 current_timestamp()

date and time last modified
deletedborrowers Table opacnote LONGTEXT 2147483647 √ null

a note on the patron/borrower's account that is visible in the OPAC and staff client
authorised_value_categories Table category_name VARCHAR 32
accountlines Table register_id INT 10 √ null
reserves Table biblionumber INT 10 0

foreign key from the biblio table defining which bib record this hold is on
patron_consent Table id INT 10 √ null
branches Table pickup_location BIT 0 1

the ability to act as a pickup location
housebound_profile Table fav_itemtypes MEDIUMTEXT 16777215 √ null

Free text describing preferred itemtypes.
categories Table description LONGTEXT 2147483647 √ null

description of the patron category
serialitems Table serialid INT 10 null
marc_matchers Table matcher_id INT 10 √ null
borrower_message_preferences Table borrower_message_preference_id INT 10 √ null
accountlines Table accountlines_id INT 10 √ null
deletedbiblioitems Table biblioitemnumber INT 10 0

primary key, unique identifier assigned by Koha
housebound_role Table housebound_chooser BIT 0 0

set to 1 to indicate this patron is a housebound chooser volunteer
cash_register_actions Table amount DECIMAL 28 √ null

amount recorded in action (signed)
borrower_modifications Table email LONGTEXT 2147483647 √ null
borrower_attribute_types Table class VARCHAR 255
suggestions Table reason MEDIUMTEXT 16777215 √ null

reason for accepting or rejecting the suggestion
currency Table rate FLOAT 15 √ null
misc_files Table date_uploaded TIMESTAMP 19 current_timestamp()

date and time the file was added
deletedbiblioitems Table editionstatement MEDIUMTEXT 16777215 √ null
deleteditems Table damaged_on DATETIME 19 √ null

the date and time an item was last marked as damaged, NULL if not damaged
biblioitems Table lccn VARCHAR 25 √ null

library of congress control number (MARC21 010$a)
deletedbiblioitems Table volumedesc MEDIUMTEXT 16777215 √ null

volume information (MARC21 362$a)
clubs Table club_template_id INT 10 null
biblio Table timestamp TIMESTAMP 19 current_timestamp()

date and time this record was last touched
marc_modification_template_actions Table ordering INT 10 null
borrower_attribute_types Table display_checkout BIT 0 0
branches Table branchurl LONGTEXT 2147483647 √ null

the URL for your library or branch's website
repeatable_holidays Table day SMALLINT 5 √ null

day of the month this closing is on
creator_templates Table label_height FLOAT 12 0
borrower_modifications Table smsalertnumber VARCHAR 50 √ null
userflags Table flag VARCHAR 30 √ null
borrower_modifications Table altcontactaddress3 VARCHAR 255 √ null
oai_sets_mappings Table rule_order INT 10 √ null
accountlines Table branchcode VARCHAR 10 √ null

the branchcode of the library where a payment was made, a manual invoice created, etc.
aqbooksellers Table tax_rate DECIMAL 6 √ null

the tax rate the library is charged
creator_images Table image_name CHAR 20 DEFAULT
issues Table returndate DATETIME 19 √ null

date the item was returned, will be NULL until moved to old_issues
overduerules_transport_types Table message_transport_type VARCHAR 20 email
items Table biblioitemnumber INT 10 0

foreign key from the biblioitems table to link to item to additional information
suggestions Table managedby INT 10 √ null

borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
club_templates Table description MEDIUMTEXT 16777215 √ null
marc_tag_structure Table important TINYINT 3 0
subscription_frequencies Table issuesperunit INT 10 1
club_holds Table date_created TIMESTAMP 19 current_timestamp()

Timestamp for the placed hold
aqbudgets_planning Table display BIT 0 √ 1
reserves Table notificationdate DATE 10 √ null

currently unused
borrower_modifications Table borrowernotes LONGTEXT 2147483647 √ null
subscription_frequencies Table id INT 10 √ null
additional_fields Table tablename VARCHAR 255

tablename of the new field
old_reserves Table lowestPriority BIT 0 0

has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
aqorders Table uncertainprice BIT 0 √ null

was this price uncertain (1 for yes, 0 for no)
suggestions Table branchcode VARCHAR 10 √ null

foreign key linking the suggested branch to the branches table
z3950servers Table sru_fields LONGTEXT 2147483647 √ null

contains the mapping between the Z3950 search fields and the specific SRU server indexes
tags_all Table tag_id INT 10 √ null

unique id and primary key
borrower_attributes Table borrowernumber INT 10 null

foreign key from the borrowers table, defines which patron/borrower has this attribute
aqorders Table timestamp TIMESTAMP 19 current_timestamp()

the date and time this order line was last modified
deletedborrowers Table dateexpiry DATE 10 √ null

date the patron/borrower's card is set to expire (YYYY-MM-DD)
permissions Table module_bit INT 10 0
aqcontacts Table position VARCHAR 100 √ null

contact person's position
categories Table change_password BIT 0 √ null

if patrons of this category can change their passwords in the OAPC
cash_register_actions Table id INT 10 √ null

unique identifier for each account register action
borrower_modifications Table dateexpiry DATE 10 √ null
categories Table issuelimit SMALLINT 5 √ null

unused in Koha
deletedbiblio Table subtitle LONGTEXT 2147483647 √ null

remainder of the title from the MARC record (245$b in MARC21)
aqorders Table rrp_tax_excluded DECIMAL 28 √ null

the replacement cost excluding tax
creator_layouts Table barcode_type CHAR 100 CODE39
statistics Table datetime DATETIME 19 √ null

date and time of the transaction
aqorders Table currency VARCHAR 10 √ null

the currency used for the purchase
borrowers Table surname LONGTEXT 2147483647 √ null

patron/borrower's last name (surname)
branchtransfers Table comments LONGTEXT 2147483647 √ null

any comments related to the transfer
borrower_modifications Table extended_attributes MEDIUMTEXT 16777215 √ null
authorised_values_branches Table branchcode VARCHAR 10 null
illrequests Table orderid VARCHAR 50 √ null
borrower_modifications Table fax LONGTEXT 2147483647 √ null
aqbooksellers Table phone VARCHAR 30 √ null

vendor phone number
deletedborrowers Table 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)
subscription Table staffdisplaycount VARCHAR 10 √ null

how many issues to show to the staff
creator_templates Table template_id INT 10 √ null
tmp_holdsqueue Table cardnumber VARCHAR 32 √ null
auth_header Table datecreated DATE 10 √ null
itemtypes Table rentalcharge_daily_calendar BIT 0 1

controls if the daily retnal fee is calculated directly or using finesCalendar
creator_batches Table item_number INT 10 √ null
oai_sets Table id INT 10 √ null
account_offsets Table created_on TIMESTAMP 19 current_timestamp()
issues Table notedate DATETIME 19 √ null

datetime of issue note (yyyy-mm-dd hh:mm::ss)
biblioitems Table illus VARCHAR 255 √ null

illustrations (MARC21 300$b)
account_offsets Table debit_id INT 10 √ null

The id of the accountline that decreased the patron's balance
categories Table enrolmentfee DECIMAL 28 √ null

enrollment fee for the patron
currency Table archived BIT 0 √ 0
account_debit_types Table is_system BIT 0 0
matchpoint_components Table matchpoint_component_id INT 10 √ null
library_groups Table title VARCHAR 100 √ null
auth_subfield_structure Table mandatory TINYINT 3 0
aqbooksellers Table listincgst TINYINT 3 √ null

is tax included in list prices (1 for yes, 0 for no)
items Table coded_location_qualifier VARCHAR 10 √ null

coded location qualifier(MARC21 952$f)
courses Table department VARCHAR 80 √ null

the authorised value for the DEPARTMENT
subscription Table callnumber MEDIUMTEXT 16777215 √ null

default call number
transport_cost Table tobranch VARCHAR 10 null
import_batches Table file_name VARCHAR 100 √ null

the name of the file uploaded
creator_layouts Table font_size INT 10 10
aqbasket Table basketname VARCHAR 50 √ null

name given to the basket at creation
borrowers Table address LONGTEXT 2147483647 √ null

the first address line for your patron/borrower's primary address
tags_index Table term VARCHAR 191 null

the tag
courses Table students_count VARCHAR 20 √ null

how many students will be taking this course/section
reserves Table itemtype VARCHAR 10 √ null

If record level hold, the optional itemtype of the item the patron is requesting
edifact_messages Table filename MEDIUMTEXT 16777215 √ null
search_history Table type VARCHAR 16 biblio

search type, must be 'biblio' or 'authority'
import_batches Table import_status enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') 9 staging

the status of the imported file
marc_subfield_structure Table link VARCHAR 80 √ null
aqbudgetperiods Table budget_period_startdate DATE 10 null

date when the budget starts
search_field Table name VARCHAR 255 null

the name of the field as it will be stored in the search engine
message_transport_types Table message_transport_type VARCHAR 20 null
course_items Table holdingbranch VARCHAR 10 √ null

new holding branch for the item to have while on reserve (optional)
biblio_metadata Table timestamp TIMESTAMP 19 current_timestamp()
branch_transfer_limits Table toBranch VARCHAR 10 null
action_logs Table info MEDIUMTEXT 16777215 √ null

information about the action (usually includes SQL statement)
deleteditems Table copynumber VARCHAR 32 √ null

copy number (MARC21 952$t)
matchchecks Table source_matchpoint_id INT 10 null
aqbooksellers Table discount FLOAT 6 √ null

discount offered on all items ordered from this vendor
borrower_modifications Table userid VARCHAR 75 √ null
accountlines Table description LONGTEXT 2147483647 √ null
biblio Table biblionumber INT 10 √ null

unique identifier assigned to each bibliographic record
aqbasketusers Table basketno INT 10 null
subscription Table lastvalue1 INT 10 √ null
import_records Table import_error LONGTEXT 2147483647 √ null
items_search_fields Table tagfield CHAR 3 null
virtualshelfcontents Table flags INT 10 √ null
virtualshelfcontents Table borrowernumber INT 10 √ null

borrower number that created this list entry (only the first one is saved: no need for use in/as key)
return_claims Table borrowernumber INT 10 null
aqbooksellers Table invoiceincgst TINYINT 3 √ null

is tax included in invoice prices (1 for yes, 0 for no)
discharges Table validated TIMESTAMP 19 √ null
borrowers Table borrowernumber INT 10 √ null

primary key, Koha assigned ID number for patrons/borrowers
old_issues Table auto_renew_error VARCHAR 32 √ null

automatic renewal error
deleteditems Table biblionumber INT 10 0

foreign key from biblio table used to link this item to the right bib record
search_history Table id INT 10 √ null

search history id
issues Table timestamp TIMESTAMP 19 current_timestamp()

the date and time this record was last touched
old_issues Table returndate DATETIME 19 √ null

date the item was returned
article_requests Table notes MEDIUMTEXT 16777215 √ null
collections_tracking Table itemnumber INT 10 0

items.itemnumber
collections Table colBranchcode VARCHAR 10 √ null

'branchcode for branch where item should be held.'
matchpoint_component_norms Table norm_routine VARCHAR 50
course_reserves Table cr_id INT 10 √ null
aqinvoices Table booksellerid INT 10 null
subscription Table innerloop3 INT 10 √ 0
borrower_modifications Table date_renewed DATE 10 √ null
audio_alerts Table selector VARCHAR 255 null
oai_sets_mappings Table marcvalue VARCHAR 80 null
aqorders_claims Table claimed_on TIMESTAMP 19 current_timestamp()

Date of the claims
deleteditems Table timestamp TIMESTAMP 19 current_timestamp()

date and time this item was last altered
aqorders_transfers Table ordernumber_from INT 10 √ null
course_items Table itype VARCHAR 10 √ null

new itemtype for the item to have while on reserve (optional)
deletedbiblio Table serial BIT 0 √ null

Boolean indicating whether biblio is for a serial
matchchecks Table target_matchpoint_id INT 10 null
oai_sets_mappings Table operator VARCHAR 8 equal
categories Table 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
reserves Table lowestPriority BIT 0 0
biblioimages Table timestamp TIMESTAMP 19 current_timestamp()

image creation/update time
borrowers Table phone MEDIUMTEXT 16777215 √ null

the primary phone number for your patron/borrower's primary address
old_reserves Table item_level_hold BIT 0 0

Is the hpld placed at item level
saved_sql Table date_created DATETIME 19 √ null

the date this report was created
items Table datelastseen DATE 10 √ null

the date the item was last see (usually the last time the barcode was scanned or inventory was done)
branchtransfers Table tobranch VARCHAR 10

the branch the transfer was going to
deletedborrowers Table B_email MEDIUMTEXT 16777215 √ null

the patron/borrower's alternate email address
reserves Table branchcode VARCHAR 10 √ null

foreign key from the branches table defining which branch the patron wishes to pick this hold up at
old_reserves Table reserve_id INT 10 null

primary key
audio_alerts Table precedence SMALLINT UNSIGNED 5 null
housebound_role Table borrowernumber_id INT 10 null

borrowernumber link
creator_layouts Table creator CHAR 15 Labels
deletedborrowers Table email LONGTEXT 2147483647 √ null

the primary email address for your patron/borrower's primary address
items Table biblionumber INT 10 0

foreign key from biblio table used to link this item to the right bib record
search_marc_to_field Table search_marc_map_id INT 10 null
branchtransfers Table datesent DATETIME 19 √ null

the date the transfer was initialized
branches Table branchaddress3 LONGTEXT 2147483647 √ null

the third address line of for your library or branch
items Table copynumber VARCHAR 32 √ null

copy number (MARC21 952$t)
search_field Table facet_order TINYINT 3 √ null

the order place of the field in facet list if faceted
itemtypes Table checkinmsgtype CHAR 16 message

type (CSS class) for the checkinmsg, can be "alert" or "message"
aqbasket Table billingplace VARCHAR 10 √ null

basket billing place
tags_all Table borrowernumber INT 10 √ null

the patron who added the tag (borrowers.borrowernumber)
aqinvoice_adjustments Table timestamp TIMESTAMP 19 current_timestamp()

timestamp of last adjustment to adjustment
quotes Table source MEDIUMTEXT 16777215 √ null

source/credit for the quote
language_subtag_registry Table added DATE 10 √ null
items_search_fields Table authorised_values_category VARCHAR 32 √ null
biblio_metadata Table metadata LONGTEXT 2147483647 null
illcomments Table illrequest_id BIGINT UNSIGNED 20 null
reviews Table datereviewed DATETIME 19 √ null

the date the comment was left
old_reserves Table itemtype VARCHAR 10 √ null

If record level hold, the optional itemtype of the item the patron is requesting
branch_transfer_limits Table ccode VARCHAR 80 √ null
suggestions Table isbn VARCHAR 30 √ null

isbn of the suggested item
branches_overdrive Table branchcode VARCHAR 10 null
aqorders Table parent_ordernumber INT 10 √ null

ordernumber of parent order line, or same as ordernumber if no parent
virtualshelfcontents Table shelfnumber INT 10 0

foreign key linking to the virtualshelves table, defines the list that this record has been added to
courses Table term VARCHAR 80 √ null

the authorised value for the TERM
deletedborrowers Table firstname MEDIUMTEXT 16777215 √ null

patron/borrower's first name
import_records Table record_sequence INT 10 0
deletedborrowers Table B_phone LONGTEXT 2147483647 √ null

the patron/borrower's alternate phone number
subscription Table librarian VARCHAR 100 √

the librarian's username from borrowers.userid
course_reserves Table public_note LONGTEXT 2147483647 √ null

public, OPAC visible note
subscription_numberpatterns Table add1 INT 10 √ null
problem_reports Table recipient enum('admin', 'library') 7 library

the 'to-address' of the problem report
aqbudgetperiods Table sort1_authcat VARCHAR 10 √ null

statistical category for this budget
biblioitems Table number LONGTEXT 2147483647 √ null
borrower_modifications Table B_streetnumber VARCHAR 10 √ null
aqorder_users Table ordernumber INT 10 null

the order this patrons receive notifications from (aqorders.ordernumber)
action_logs Table object INT 10 √ null

the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
biblioitems Table timestamp TIMESTAMP 19 current_timestamp()
auth_subfield_structure Table authorised_value VARCHAR 10 √ null
plugin_methods Table plugin_class VARCHAR 255 null
club_template_enrollment_fields Table name TEXT 65535 null
language_subtag_registry Table id INT 10 √ null
columns_settings Table columnname VARCHAR 255 null
vendor_edi_accounts Table description MEDIUMTEXT 16777215 null
accountlines Table amountoutstanding DECIMAL 28 √ null
branchtransfers Table branchtransfer_id INT 10 √ null

primary key
virtualshelfshares Table 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
old_reserves Table timestamp TIMESTAMP 19 current_timestamp()

the date and time this hold was last updated
creator_layouts Table layout_xml MEDIUMTEXT 16777215 null
subscriptionhistory Table histenddate DATE 10 √ null
localization Table entity VARCHAR 16 null
categories Table category_type VARCHAR 1 A

type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
old_issues Table itemnumber INT 10 √ null

foreign key, linking this to the items table for the item that was checked out
import_auths Table matched_authid INT 10 √ null
subscriptionhistory Table missinglist LONGTEXT 2147483647 null
borrowers Table dateofbirth DATE 10 √ null

the patron/borrower's date of birth (YYYY-MM-DD)
reports_dictionary Table date_created DATETIME 19 √ null

date and time this definition was created
deletedborrowers Table B_zipcode VARCHAR 25 √ null

the zip or postal code for your patron/borrower's alternate address
cities Table city_zipcode VARCHAR 20 √ null

zip or postal code
serial Table claimdate DATE 10 √ null

date claimed
creator_templates Table template_code CHAR 100 DEFAULT TEMPLATE
auth_subfield_structure Table isurl BIT 0 √ null
matchpoints Table search_index VARCHAR 30
saved_reports Table report_id INT 10 √ null
import_batches Table record_type enum('biblio', 'auth', 'holdings') 8 biblio

type of record in the batch
club_templates Table is_enrollable_from_opac BIT 0 0
items Table renewals SMALLINT 5 √ null

number of times this item has been renewed
deleteditems Table itemnotes_nonpublic LONGTEXT 2147483647 √ null

non-public notes on this item (MARC21 952$x)
reserves Table suspend_until DATETIME 19 √ null
subscription_numberpatterns Table label3 VARCHAR 255 √ null
aqbudgets_planning Table authcat VARCHAR 30 null
z3950servers Table db VARCHAR 255 √ null

target's database name
account_debit_types Table can_be_invoiced BIT 0 1

boolean flag to denote if this debit type is available for manual invoicing
borrower_modifications Table timestamp TIMESTAMP 19 current_timestamp()
vendor_edi_accounts Table password VARCHAR 40 √ null
suggestions Table STATUS VARCHAR 10

suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)
matchchecks Table matcher_id INT 10 null
borrower_modifications Table altcontactzipcode VARCHAR 50 √ null
localization Table translation MEDIUMTEXT 16777215 √ null
aqorders Table suppliers_report MEDIUMTEXT 16777215 √ null

reports received from suppliers
letter Table lang VARCHAR 25 default

lang of the notice
borrower_files Table date_uploaded TIMESTAMP 19 current_timestamp()

date and time the file was added
aqorders Table tax_rate_on_receiving DECIMAL 6 √ null

the tax rate on receiving for this line item (%)
creator_templates Table units CHAR 20 POINT
borrower_modifications Table zipcode VARCHAR 25 √ null
aqbudgets_planning Table budget_period_id INT 10 null
reports_dictionary Table description MEDIUMTEXT 16777215 √ null

description for this definition
categories Table categorycode VARCHAR 10

unique primary key used to idenfity the patron category
aqbooksellers Table notes LONGTEXT 2147483647 √ null

order notes
course_items Table itype_storage VARCHAR 10 √ null

a place to store the itype when item is on course reserve
biblioitems Table volume LONGTEXT 2147483647 √ null
additional_field_values Table id INT 10 √ null

primary key identifier
itemtypes Table rentalcharge_daily DECIMAL 28 √ null

the amount charged for each day between checkout date and due date
course_instructors Table course_id INT 10 null

foreign key to link to courses.course_id
vendor_edi_accounts Table download_directory MEDIUMTEXT 16777215 √ null
aqcontract Table contractstartdate DATE 10 √ null
deletedborrowers Table relationship VARCHAR 100 √ null

used for children to include the relationship to their guarantor
virtualshelves Table category VARCHAR 1 √ null

type of list (private 1, public 2)
oauth_access_tokens Table client_id VARCHAR 191 null

the client id the access token belongs to
housebound_visit Table appointment_date DATE 10 √ null

Date of visit.
import_records Table encoding VARCHAR 40
tmp_holdsqueue Table notes MEDIUMTEXT 16777215 √ null
courses Table course_id INT 10 √ null

unique id for the course
itemtypes Table checkinmsg VARCHAR 255 √ null

message that is displayed when an item with the given item type is checked in
borrower_modifications Table altcontactsurname VARCHAR 255 √ null
serial Table routingnotes MEDIUMTEXT 16777215 √ null

notes from the routing list
aqbooksellers Table listprice VARCHAR 10 √ null

currency code for list prices
deletedborrowers Table address LONGTEXT 2147483647 √ null

the first address line for your patron/borrower's primary address
cash_registers Table description LONGTEXT 2147483647 null

the user friendly description for each account register
import_batches Table template_id INT 10 √ null
item_circulation_alert_preferences Table branchcode VARCHAR 10 null
patronimage Table borrowernumber INT 10 null

the borrowernumber of the patron this image is attached to (borrowers.borrowernumber)
deleteditems Table withdrawn_on DATETIME 19 √ null

the date and time an item was last marked as withdrawn, NULL if not withdrawn
z3950servers Table syntax VARCHAR 80 √ null

marc format provided by this target
housebound_profile Table day MEDIUMTEXT 16777215 null
browser Table level INT 10 null
illrequests Table updated TIMESTAMP 19 current_timestamp()
borrower_debarments Table manager_id INT 10 √ null

foreign key for borrowers.borrowernumber for the librarian managing the restriction
virtualshelfshares Table sharedate DATETIME 19 √ null
marc_modification_template_actions Table field_value VARCHAR 100 √ null
edifact_messages Table transfer_date DATE 10 √ null
borrower_message_transport_preferences Table message_transport_type VARCHAR 20 0
oai_sets_biblios Table set_id INT 10 null
items Table uri MEDIUMTEXT 16777215 √ null

URL for the item (MARC21 952$u)
categories Table reset_password BIT 0 √ null

if patrons of this category can do the password reset flow,
aqcontract Table booksellerid INT 10 null
subscription Table innerloop1 INT 10 √ 0
circulation_rules Table rule_value VARCHAR 32 null
aqorders Table ecost DECIMAL 13 √ null

the replacement cost for this line item
problem_reports Table reportid INT 10 √ null

unique identifier assigned by Koha
class_split_rules Table description LONGTEXT 2147483647 √ null
patron_consent Table borrowernumber INT 10 null
deletedborrowers Table contacttitle MEDIUMTEXT 16777215 √ null

used for children to include title (Mr., Mrs., etc) of guarantor
discharges Table discharge_id INT 10 √ null
z3950servers Table checked SMALLINT 5 √ null

whether this target is checked by default (1 for yes, 0 for no)
branches Table branchcode VARCHAR 10

a unique key assigned to each branch
z3950servers Table sru_options VARCHAR 255 √ null

options like sru=get, sru_version=1.1; will be passed to the server via ZOOM
creator_layouts Table oblique_title INT 10 √ 1
aqbasketgroups Table deliverycomment VARCHAR 255 √ null
deletedbiblio_metadata Table id INT 10 √ null
marc_tag_structure Table mandatory TINYINT 3 0
deletedborrowers Table B_address VARCHAR 100 √ null

the first address line for your patron/borrower's alternate address
matchpoint_components Table sequence INT 10 0
biblioitems Table ean LONGTEXT 2147483647 √ null
deletedborrowers Table borrowernotes LONGTEXT 2147483647 √ null

a note on the patron/borrower's account that is only visible in the staff client
statistics Table value DOUBLE 16 √ null

monetary value associated with the transaction
serial Table serialseq_y VARCHAR 100 √ null

second part of issue information
borrowers Table altcontactzipcode VARCHAR 50 √ null

the zipcode for the alternate contact for the patron/borrower
club_templates Table branchcode VARCHAR 10 √ null
housebound_visit Table id INT 10 √ null

ID of the visit.
aqinvoice_adjustments Table adjustment_id INT 10 √ null

primary key for adjustments
branches Table branchreturnpath LONGTEXT 2147483647 √ null

the email to be used as Return-Path
reserves Table found VARCHAR 1 √ null

a one letter code defining what the status is of the hold is after it has been confirmed
subscription Table graceperiod INT 10 0

grace period in days
deleteditems Table paidfor LONGTEXT 2147483647 √ null
action_logs Table user INT 10 0

the staff member who performed the action (borrowers.borrowernumber)
import_record_matches Table import_record_id INT 10 null

the id given to the imported bib record (import_records.import_record_id)
special_holidays Table title VARCHAR 50

title for this closing
borrowers Table contacttitle MEDIUMTEXT 16777215 √ null

used for children to include title (Mr., Mrs., etc) of guarantor
deletedbiblioitems Table illus VARCHAR 255 √ null

illustrations (MARC21 300$b)
return_claims Table updated_on TIMESTAMP 19 √ null

Time and date of the latest change on the claim (notes)
aqorders Table ecost_tax_excluded DECIMAL 28 √ null

the estimated cost excluding tax
message_queue Table from_address LONGTEXT 2147483647 √ null
course_items Table holdingbranch_storage VARCHAR 10 √ null

a place to store the holdingbranch when item is on course reserve
itemtypes Table sip_media_type VARCHAR 3 √ null

SIP2 protocol media type for this itemtype
suggestions Table volumedesc VARCHAR 255 √ null
club_holds_to_patron_holds Table hold_id INT 10 √ null
borrower_modifications Table privacy INT 10 √ null
cities Table city_country VARCHAR 100 √ null

name of the country
branches Table geolocation VARCHAR 255 √ null

geolocation of your library
marc_matchers Table description VARCHAR 255
biblioimages Table imagenumber INT 10 √ null

unique identifier for the image
issues Table auto_renew_error VARCHAR 32 √ null

automatic renewal error
account_credit_types_branches Table branchcode VARCHAR 10 √ null
import_records Table overlay_status enum('no_match', 'auto_match', 'manual_match', 'match_applied') 13 no_match
illrequestattributes Table readonly BIT 0 1
oai_sets Table name VARCHAR 80 null
action_logs Table action_id INT 10 √ null

unique identifier for each action
subscription Table irregularity MEDIUMTEXT 16777215 √ null

any irregularities in the subscription
deleteditems Table itype VARCHAR 10 √ null

foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
auth_subfield_structure Table tab BIT 0 √ null
club_enrollment_fields Table value MEDIUMTEXT 16777215 null
account_credit_types_branches Table credit_type_code VARCHAR 80 √ null
deletedbiblio_metadata Table format VARCHAR 16 null
subscription_frequencies Table unit enum('day', 'week', 'month', 'year') 5 √ null
language_subtag_registry Table type VARCHAR 25 √ null

language-script-region-variant-extension-privateuse
items_last_borrower Table created_on TIMESTAMP 19 current_timestamp()
subscription Table periodicity INT 10 √ null

frequency type links to subscription_frequencies.id
z3950servers Table host VARCHAR 255 √ null

target's host name
advanced_editor_macros Table macro LONGTEXT 2147483647 √ null
club_fields Table value MEDIUMTEXT 16777215 √ null
aqbooksellers Table active TINYINT 3 √ null

is this vendor active (1 for yes, 0 for no)
subscriptionhistory Table opacnote LONGTEXT 2147483647 √ null
deletedbiblioitems Table editionresponsibility MEDIUMTEXT 16777215 √ null
items_last_borrower Table itemnumber INT 10 null
uploaded_files Table uploadcategorycode TEXT 65535 √ null
repeatable_holidays Table month SMALLINT 5 √ null

month this closing is in
oai_sets_descriptions Table set_id INT 10 null
accountlines Table itemnumber INT 10 √ null
user_permissions Table code VARCHAR 64 √ null
itemtypes Table itemtype VARCHAR 10

unique key, a code associated with the item type
stockrotationstages Table stage_id INT 10 √ null
aqbudgetborrowers Table budget_id INT 10 null
aqbudgets_planning Table budget_id INT 10 null
reserves Table reminderdate DATE 10 √ null

currently unused
borrowers Table phonepro MEDIUMTEXT 16777215 √ null

the secondary phone number for your patron/borrower's primary address
borrower_message_preferences Table categorycode VARCHAR 10 √ null
borrowers Table altcontactaddress1 VARCHAR 255 √ null

the first address line for the alternate contact for the patron/borrower
tags_approval Table weight_total INT 10 1

the total number of times this tag was used
items Table itype VARCHAR 10 √ null

foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
cities Table city_name VARCHAR 100

name of the city
accountlines Table issue_id INT 10 √ null
aqcontract Table contractname VARCHAR 50 √ null
systempreferences Table options LONGTEXT 2147483647 √ null

options for multiple choice system preferences
creator_batches Table borrower_number INT 10 √ null
aqinvoice_adjustments Table invoiceid INT 10 null

foreign key to link an adjustment to an invoice
quotes Table text LONGTEXT 2147483647 null

text of the quote
sms_providers Table id INT 10 √ null
course_items Table timestamp TIMESTAMP 19 current_timestamp()
aqinvoice_adjustments Table note MEDIUMTEXT 16777215 √ null

text to explain adjustment
import_biblios Table control_number VARCHAR 25 √ null
subscription Table startdate DATE 10 √ null

start date for this subscription
suggestions Table author VARCHAR 80 √ null

author of the suggested item
biblioitems Table size VARCHAR 255 √ null

material size (MARC21 300$c)
subscription Table notes LONGTEXT 2147483647 √ null

notes
housebound_role Table housebound_deliverer BIT 0 0

set to 1 to indicate this patron is a housebound deliverer volunteer
aqcontacts Table claimissues BIT 0 0

should this contact receive serial claims
club_templates Table date_updated TIMESTAMP 19 √ null
auth_tag_structure Table repeatable TINYINT 3 0
overduerules Table debarred3 INT 10 √ 0

is the patron restricted when the third notice is sent (1 for yes, 0 for no)
club_template_fields Table id INT 10 √ null
auth_subfield_structure Table seealso VARCHAR 255 √ null
aqbasketusers Table borrowernumber INT 10 null
class_split_rules Table class_split_rule VARCHAR 10
deletedborrowers Table contactfirstname MEDIUMTEXT 16777215 √ null

used for children to include first name of guarantor
borrower_debarments Table borrowernumber INT 10 null

foreign key for borrowers.borrowernumber for patron who is restricted
auth_types Table authtypecode VARCHAR 10
cash_register_actions Table manager_id INT 10 null

staff member performing the action
clubs Table date_start DATE 10 √ null
search_field Table type enum('', 'string', 'date', 'number', 'boolean', 'sum', 'isbn', 'stdno') 7 null

what type of data this holds, relevant when storing it in the search engine
reserves Table item_level_hold BIT 0 0

Is the hpld placed at item level
reserves Table cancellationdate DATE 10 √ null

the date this hold was cancelled
borrower_modifications Table B_country MEDIUMTEXT 16777215 √ null
subscription Table subscriptionid INT 10 √ null

unique key for this subscription
items Table datelastborrowed DATE 10 √ null

the date the item was last checked out/issued
marc_subfield_structure Table libopac VARCHAR 255
deletedbiblioitems Table cn_suffix VARCHAR 10 √ null
return_claims Table id INT 10 √ null
items Table notforloan BIT 0 0

authorized value defining why this item is not for loan (MARC21 952$7)
zebraqueue Table time TIMESTAMP 19 current_timestamp()
deleteditems Table coded_location_qualifier VARCHAR 10 √ null

coded location qualifier(MARC21 952$f)
message_transports Table letter_code VARCHAR 20
aqinvoice_adjustments Table reason VARCHAR 80 √ null

reason for adjustment defined by authorised values in ADJ_REASON category
language_descriptions Table description VARCHAR 255 √ null
plugin_data Table plugin_value MEDIUMTEXT 16777215 √ null
deletedbiblio Table notes LONGTEXT 2147483647 √ null

values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
currency Table symbol VARCHAR 5 √ null
biblioitems Table editionresponsibility MEDIUMTEXT 16777215 √ null
auth_types Table auth_tag_to_report VARCHAR 3
items Table location VARCHAR 80 √ null

authorized value for the shelving location for this item (MARC21 952$c)
borrowers Table zipcode VARCHAR 25 √ null

the zip or postal code for your patron/borrower's primary address
ratings Table rating_value BIT 0 null

the rating, from 1 to 5
items Table enumchron MEDIUMTEXT 16777215 √ null

serial enumeration/chronology for the item (MARC21 952$h)
itemtypes Table description LONGTEXT 2147483647 √ null

a plain text explanation of the item type
import_biblios Table matched_biblionumber INT 10 √ null
deletedbiblio_metadata Table schema VARCHAR 16 null
hold_fill_targets Table item_level_request TINYINT 3 0
deletedborrowers Table streetnumber VARCHAR 10 √ null

the house number for your patron/borrower's primary address
api_keys Table patron_id INT 10 null
old_reserves Table found VARCHAR 1 √ null

a one letter code defining what the status is of the hold is after it has been confirmed
deletedbiblioitems Table pages VARCHAR 255 √ null

number of pages (MARC21 300$c)
borrowers Table userid VARCHAR 75 √ null

patron/borrower's opac and/or staff client log in
opac_news Table title VARCHAR 250

title of the news article
borrowers Table branchcode VARCHAR 10

foreign key from the branches table, includes the code of the patron/borrower's home branch
aqbooksellers Table address3 LONGTEXT 2147483647 √ null

third line of vendor physical address
borrowers Table mobile VARCHAR 50 √ null

the other phone number for your patron/borrower's primary address
borrower_modifications Table altcontactfirstname VARCHAR 255 √ null
borrowers Table flags INT 10 √ null

will include a number associated with the staff member's permissions
borrower_modifications Table cardnumber VARCHAR 32 √ null
message_queue Table to_address LONGTEXT 2147483647 √ null
course_reserves Table timestamp TIMESTAMP 19 current_timestamp()
aqinvoices Table shipmentcost DECIMAL 28 √ null
deletedbiblioitems Table number LONGTEXT 2147483647 √ null
deletedbiblioitems Table cn_item VARCHAR 10 √ null
old_reserves Table branchcode VARCHAR 10 √ null

foreign key from the branches table defining which branch the patron wishes to pick this hold up at
biblioitems Table pages VARCHAR 255 √ null

number of pages (MARC21 300$c)
creator_layouts Table layout_id INT 10 √ null
z3950servers Table password VARCHAR 255 √ null

password needed to log in to target
biblioitems Table issn LONGTEXT 2147483647 √ null

ISSN (MARC21 022$a)
marc_subfield_structure Table defaultvalue MEDIUMTEXT 16777215 √ null
branches Table branchaddress2 LONGTEXT 2147483647 √ null

the second address line of for your library or branch
aqorders Table orderstatus VARCHAR 16 √ new

the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled'
creator_templates Table left_margin FLOAT 12 0
message_attributes Table message_attribute_id INT 10 √ null
course_reserves Table staff_note LONGTEXT 2147483647 √ null

staff only note
borrower_modifications Table phone MEDIUMTEXT 16777215 √ null
creator_templates Table left_text_margin FLOAT 12 0
borrower_attribute_types Table 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_modifications Table contactname LONGTEXT 2147483647 √ null
branches Table branchreplyto LONGTEXT 2147483647 √ null

the email to be used as a Reply-To
illrequestattributes Table type VARCHAR 200 null
zebraqueue Table id INT 10 √ null
biblioitems Table publicationyear MEDIUMTEXT 16777215 √ null
borrowers Table B_address VARCHAR 100 √ null

the first address line for your patron/borrower's alternate address
club_enrollments Table id INT 10 √ null
auth_subfield_structure Table hidden TINYINT 3 0
marc_subfield_structure Table liblibrarian VARCHAR 255
problem_reports Table borrowernumber INT 10 0

the user who created the problem report
search_field Table opac BIT 0 1
borrowers Table altcontactsurname VARCHAR 255 √ null

surname or last name of the alternate contact for the patron/borrower
return_claims Table updated_by INT 10 √ null
subscriptionroutinglist Table subscriptionid INT 10 null

foreign key from the subscription table, defines which subscription this routing list is for
transport_cost Table disable_transfer BIT 0 0
deletedbiblioitems Table lccn VARCHAR 25 √ null

library of congress control number (MARC21 010$a)
accountlines Table manager_id INT 10 √ null
aqorders Table basketno INT 10 √ null

links this order line to a specific basket (aqbasket.basketno)
deletedborrowers Table sms_provider_id INT 10 √ null

the provider of the mobile phone number defined in smsalertnumber
overduerules Table letter3 VARCHAR 20 √ null

foreign key from the letter table to define which notice should be sent as the third notice
subscription_numberpatterns Table every1 INT 10 √ null
biblioitems Table cn_class VARCHAR 30 √ null
opac_news Table lang VARCHAR 25

location for the article (koha is the staff client, slip is the circulation receipt and language codes are for the opac)
borrower_modifications Table sort2 VARCHAR 80 √ null
import_batches Table nomatch_action enum('create_new', 'ignore') 11 create_new

how to handle records where no match is found
biblio Table datecreated DATE 10 null

the date this record was added to Koha
auth_subfield_structure Table tagfield VARCHAR 3
creator_templates Table profile_id INT 10 √ null
export_format Table csv_separator VARCHAR 2 ,
old_issues Table onsite_checkout INT 10 0

in house use flag
plugin_methods Table plugin_method VARCHAR 255 null
linktracker Table timeclicked DATETIME 19 √ null

the date and time the link was clicked
z3950servers Table userid VARCHAR 255 √ null

username needed to log in to target
categories Table dateofbirthrequired BIT 0 √ null

the minimum age required for the patron category
aqbudgets Table budget_code VARCHAR 30 √ null

code assigned to the fund by the user
club_templates Table date_created TIMESTAMP 19 current_timestamp()
aqbudgetperiods Table budget_period_total DECIMAL 28 √ null

total amount available in this budget
virtualshelfcontents Table dateadded TIMESTAMP 19 current_timestamp()

date and time this bib record was added to the list
deletedborrowers Table phone MEDIUMTEXT 16777215 √ null

the primary phone number for your patron/borrower's primary address
additional_fields Table id INT 10 √ null

primary key identifier
pending_offline_operations Table amount DECIMAL 28 √ null
desks Table desk_name VARCHAR 100

name of the desk
article_requests Table chapters MEDIUMTEXT 16777215 √ null
import_batches Table branchcode VARCHAR 10 √ null
aqbasket Table basketgroupid INT 10 √ null

links this basket to its group (aqbasketgroups.id)
search_marc_map Table id INT 10 √ null
biblioitems Table cn_item VARCHAR 10 √ null
tmp_holdsqueue Table barcode VARCHAR 20 √ null
tags Table weight BIGINT 19 0
circulation_rules Table rule_name VARCHAR 32 null
borrower_password_recovery Table valid_until TIMESTAMP 19 current_timestamp()

a time limit on the password recovery attempt
borrowers Table B_city LONGTEXT 2147483647 √ null

the city or town for your patron/borrower's alternate address
housebound_visit Table borrowernumber INT 10 null

Number of the borrower, & the profile, linked to this visit.
creator_batches Table creator CHAR 15 Labels
statistics Table other LONGTEXT 2147483647 √ null

used by SIP
branches Table branchcity LONGTEXT 2147483647 √ null

the city or province for your library or branch
borrower_modifications Table firstname MEDIUMTEXT 16777215 √ null
import_auths Table authorized_heading VARCHAR 128 √ null
subscription Table monthlength INT 10 √ 0

subscription length in weeks (will not be filled in if weeklength or numberlength is set)
biblioimages Table imagefile MEDIUMBLOB 16777215 null

image file contents
reserves Table 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)
borrowers Table overdrive_auth_token MEDIUMTEXT 16777215 √ null

persist OverDrive auth token
z3950servers Table servertype enum('zed', 'sru') 4 zed

zed means z39.50 server
serial Table biblionumber INT 10 null

foreign key for the biblio.biblionumber that this issue is attached to
suggestions Table place VARCHAR 255 √ null

publication place of the suggested item
saved_sql Table notes MEDIUMTEXT 16777215 √ null

the notes or description given to this report
class_sources Table class_split_rule VARCHAR 10
currency Table p_sep_by_space BIT 0 √ 0
authorised_values Table id INT 10 √ null

unique key, used to identify the authorized value
biblioitems Table publishercode VARCHAR 255 √ null

publisher (MARC21 260$b)
aqbasketgroups Table booksellerid INT 10 null
message_queue Table status enum('sent', 'pending', 'failed', 'deleted') 7 pending
stockrotationitems Table indemand BIT 0 0

Should this item be skipped for rotation?
serial Table serialseq_z VARCHAR 100 √ null

third part of issue information
aqinvoices Table shipmentcost_budgetid INT 10 √ null
deletedbiblioitems Table collectiontitle LONGTEXT 2147483647 √ null
reports_dictionary Table id INT 10 √ null

unique identifier assigned by Koha
items Table paidfor LONGTEXT 2147483647 √ null
stockrotationitems Table itemnumber_id INT 10 null
marc_modification_template_actions Table template_id INT 10 null
deletedborrowers Table dateofbirth DATE 10 √ null

the patron/borrower's date of birth (YYYY-MM-DD)
discharges Table borrower INT 10 √ null
printers_profile Table offset_vert FLOAT 12 0
auth_header Table marc BLOB 65535 √ null
deletedbiblioitems Table volumedate DATE 10 √ null
aqcontract Table contractenddate DATE 10 √ null
auth_subfield_structure Table libopac VARCHAR 255
deletedbiblio Table datecreated DATE 10 null

the date this record was added to Koha
edifact_ean Table description VARCHAR 128 √ null
biblio Table part_name LONGTEXT 2147483647 √ null

part name from the MARC record (245$p in MARC21)
aqorders Table budgetdate DATE 10 √ null

not used? always NULL
repeatable_holidays Table title VARCHAR 50

title of this closing
article_requests Table biblionumber INT 10 null
aqbudgetperiods Table budget_period_description LONGTEXT 2147483647 √ null

description assigned to this budget
biblio Table seriestitle LONGTEXT 2147483647 √ null
suggestions Table total DECIMAL 28 √ null

suggested total cost (price*quantity updated for currency)
subscription_frequencies Table unitsperissue INT 10 1
borrowers Table login_attempts INT 10 √ 0

number of failed login attemps
aqcontacts Table orderacquisition BIT 0 0

should this contact receive acquisition orders
problem_reports Table created_on TIMESTAMP 19 current_timestamp()

timestamp of report submission
creator_templates Table page_height FLOAT 12 0
old_reserves Table priority SMALLINT 5 1

where in the queue the patron sits
aqbooksellers Table name LONGTEXT 2147483647 null

vendor name
search_marc_to_field Table facet BIT 0 √ 0

true if a facet field should be generated for this
overduerules Table delay1 INT 10 √ null

number of days after the item is overdue that the first notice is sent
misc_files Table record_id INT 10 null

record id from the table this file is associated to
biblioitems Table collectionissn MEDIUMTEXT 16777215 √ null
aqorder_users Table borrowernumber INT 10 null

the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber)
subscriptionhistory Table biblionumber INT 10 null
audio_alerts Table sound VARCHAR 255 null
permissions Table description VARCHAR 255 √ null
social_data Table num_critics INT 10 √ null
oai_sets_mappings Table marcsubfield CHAR 1 null
search_marc_map Table index_name enum('biblios', 'authorities') 11 null

what storage index this map is for
userflags Table flagdesc VARCHAR 255 √ null
tmp_holdsqueue Table biblionumber INT 10 √ null
accountlines Table credit_type_code VARCHAR 80 √ null
auth_tag_structure Table liblibrarian VARCHAR 255
authorised_values Table imageurl VARCHAR 200 √ null

authorized value URL
items Table cn_sort VARCHAR 255 √ null
virtualshelves Table shelfnumber INT 10 √ null

unique identifier assigned by Koha
subscription Table branchcode VARCHAR 10

default branches (items.homebranch)
subscriptionhistory Table librariannote LONGTEXT 2147483647 √ null
systempreferences Table value MEDIUMTEXT 16777215 √ null

system preference values
marc_matchers Table record_type VARCHAR 10 biblio
subscription Table previousitemtype VARCHAR 10 √ null
messages Table message_id INT 10 √ null

unique identifier assigned by Koha
vendor_edi_accounts Table host VARCHAR 40 √ null
letter Table title VARCHAR 200

subject line of the notice
deletedborrowers Table categorycode VARCHAR 10

foreign key from the categories table, includes the code of the patron category
vendor_edi_accounts Table invoices_enabled BIT 0 0
import_items Table itemnumber INT 10 √ null
import_items Table branchcode VARCHAR 10 √ null
suggestions Table accepteddate DATE 10 √ null

date the suggestion was marked as accepted
subscription_numberpatterns Table setto1 INT 10 √ null
api_keys Table secret VARCHAR 191 null
reserves Table priority SMALLINT 5 1

where in the queue the patron sits
borrowers Table altcontactaddress3 VARCHAR 255 √ null

the city for the alternate contact for the patron/borrower
course_items Table location_storage VARCHAR 80 √ null

a place to store the location when the item is on course reserve
marc_matchers Table code VARCHAR 10
borrowers Table B_country MEDIUMTEXT 16777215 √ null

the country for your patron/borrower's alternate address
biblioitems Table biblioitemnumber INT 10 √ null

primary key, unique identifier assigned by Koha
overduerules Table delay3 INT 10 √ null

number of days after the item is overdue that the third notice is sent
language_descriptions Table lang VARCHAR 25 √ null
serial Table publisheddate DATE 10 √ null

date published
auth_header Table linkid BIGINT 19 √ null
biblio Table notes LONGTEXT 2147483647 √ null

values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
deleteditems Table datelastseen DATE 10 √ null

the date the item was last see (usually the last time the barcode was scanned or inventory was done)
aqorders Table datecancellationprinted DATE 10 √ null

the date the line item was deleted
course_items Table location VARCHAR 80 √ null

new shelving location for the item to have while on reseve (optional)
collections_tracking Table colId INT 10 0

collections.colId
library_groups Table id INT 10 √ null
tmp_holdsqueue Table phone MEDIUMTEXT 16777215 √ null
club_enrollments Table date_created TIMESTAMP 19 √ null
deletedbiblioitems Table size VARCHAR 255 √ null

material size (MARC21 300$c)
ratings Table biblionumber INT 10 null

the biblio this rating is for (biblio.biblionumber)
search_marc_to_field Table sort BIT 0 √ null

true/false creates special sort handling, null doesn't
items Table cn_source VARCHAR 10 √ null

classification source used on this item (MARC21 952$2)
deletedborrowers Table B_streetnumber VARCHAR 10 √ null

the house number for your patron/borrower's alternate address
items Table permanent_location VARCHAR 80 √ null

linked to the CART and PROC temporary locations feature, stores the permanent shelving location
saved_reports Table date_run DATETIME 19 √ null
deletedborrowers Table altcontactaddress2 VARCHAR 255 √ null

the second address line for the alternate contact for the patron/borrower
import_biblios Table title VARCHAR 128 √ null
borrower_modifications Table altcontactcountry MEDIUMTEXT 16777215 √ null
article_requests Table pages MEDIUMTEXT 16777215 √ null
export_format Table field_separator VARCHAR 2 √ null
subscription Table closed BIT 0 0

yes / no if the subscription is closed
borrowers Table relationship VARCHAR 100 √ null

used for children to include the relationship to their guarantor
subscription_numberpatterns Table label VARCHAR 255 null
message_transports Table message_transport_type VARCHAR 20 null
aqorders Table unitprice_tax_included DECIMAL 28 √ null

the unit price including tax (on receiving)
subscription Table distributedto MEDIUMTEXT 16777215 √ null
club_templates Table is_email_required BIT 0 0
columns_settings Table page VARCHAR 255 null
marc_modification_templates Table name MEDIUMTEXT 16777215 null
borrower_debarments Table type enum('SUSPENSION', 'OVERDUES', 'MANUAL', 'DISCHARGE') 11 MANUAL

type of restriction
letter Table is_html BIT 0 √ 0

does this notice or slip use HTML (1 for yes, 0 for no)
borrowers Table lang VARCHAR 25 default

lang to use to send notices to this patron
subscription_numberpatterns Table id INT 10 √ null
import_items Table marcxml LONGTEXT 2147483647 null
course_items Table homebranch VARCHAR 10 √ null

new home branch for the item to have while on reserve (optional)
issues Table borrowernumber INT 10 √ null

foreign key, linking this to the borrowers table for the patron this item was checked out to
aqbooksellers Table deliverytime INT 10 √ null

vendor delivery time
saved_sql Table public BIT 0 0
account_offsets Table id INT 10 √ null

unique identifier for each offset
patron_consent Table refused_on DATETIME 19 √ null
search_history Table query_desc VARCHAR 255 null

the search that was performed
club_template_fields Table authorised_value_category VARCHAR 16 √ null
aqbooksellers Table url VARCHAR 255 √ null

vendor web address
club_template_fields Table club_template_id INT 10 null
creator_layouts Table layout_name CHAR 25 DEFAULT
borrowers Table smsalertnumber VARCHAR 50 √ null

the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
special_holidays Table id INT 10 √ null

unique identifier assigned by Koha
club_enrollment_fields Table id INT 10 √ null
courses Table course_number VARCHAR 255 √ null

the "course number" assigned to a course
course_items Table ccode VARCHAR 80 √ null

new category code for the item to have while on reserve (optional)
deletedbiblio_metadata Table biblionumber INT 10 null
virtualshelves Table 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)
stockrotationrotas Table rota_id INT 10 √ null
saved_sql Table last_run DATETIME 19 √ null
items Table replacementprice DECIMAL 8 √ null

cost the library charges to replace the item if it has been marked lost (MARC21 952$v)
deletedborrowers Table password VARCHAR 60 √ null

patron/borrower's encrypted password
deletedbiblio Table frameworkcode VARCHAR 4

foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
deleteditems Table dateaccessioned DATE 10 √ null

date the item was acquired or added to Koha (MARC21 952$d)
subscriptionroutinglist Table ranking INT 10 √ null

where the patron stands in line to receive the serial
auth_header Table authtrees LONGTEXT 2147483647 √ null
branches Table branchphone LONGTEXT 2147483647 √ null

the primary phone for your library or branch
deletedborrowers Table flags INT 10 √ null

will include a number associated with the staff member's permissions
marc_subfield_structure Table repeatable TINYINT 3 0
branches Table marcorgcode VARCHAR 16 √ null

MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
borrowers Table B_email MEDIUMTEXT 16777215 √ null

the patron/borrower's alternate email address
biblio_metadata Table format VARCHAR 16 null
marc_subfield_structure Table tagfield VARCHAR 3
message_transports Table branchcode VARCHAR 10
deletedborrowers Table overdrive_auth_token MEDIUMTEXT 16777215 √ null

persist OverDrive auth token
uploaded_files Table dir MEDIUMTEXT 16777215 null
class_sort_rules Table description LONGTEXT 2147483647 √ null
import_batches Table item_action enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore', 'replace') 20 always_add

what to do with item records
reserves Table waitingdate DATE 10 √ null

the date the item was marked as waiting for the patron at the library
stockrotationstages Table position INT 10 null
old_issues Table branchcode VARCHAR 10 √ null

foreign key, linking to the branches table for the location the item was checked out
creator_templates Table label_width FLOAT 12 0
issues Table onsite_checkout INT 10 0

in house use flag
message_queue Table letter_code VARCHAR 64 √ null
illcomments Table comment TEXT 65535 √ null
search_field Table weight DECIMAL 5 √ null
class_sort_rules Table sort_routine VARCHAR 30
borrower_files Table file_id INT 10 √ null

unique key
message_queue Table metadata MEDIUMTEXT 16777215 √ null
messages Table borrowernumber INT 10 null

foreign key linking this message to the borrowers table
import_records Table marc LONGBLOB 2147483647 null
course_items Table ci_id INT 10 √ null

course item id
deleteditems Table issues SMALLINT 5 √ 0

number of times this item has been checked out
subscription_numberpatterns Table displayorder INT 10 √ null
aqorders Table cancellationreason MEDIUMTEXT 16777215 √ null

reason of cancellation
message_queue Table content MEDIUMTEXT 16777215 √ null
deleteditems Table renewals SMALLINT 5 √ null

number of times this item has been renewed
deletedborrowers Table privacy_guarantor_fines BIT 0 0

controls if relatives can see this patron's fines
deletedborrowers Table country MEDIUMTEXT 16777215 √ null

the country for your patron/borrower's primary address
aqbooksellers Table address2 LONGTEXT 2147483647 √ null

second line of vendor physical address
borrower_password_recovery Table uuid VARCHAR 128 null

a unique string to identify a password recovery attempt
edifact_messages Table status MEDIUMTEXT 16777215 √ null
message_queue Table updated_on TIMESTAMP 19 current_timestamp()
aqorders Table purchaseordernumber LONGTEXT 2147483647 √ null

not used? always NULL
borrower_attribute_types Table 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)
account_debit_types_branches Table branchcode VARCHAR 10 √ null
opac_news Table branchcode VARCHAR 10 √ null

branch code users to create branch specific news, NULL is every branch.
biblioitems Table isbn LONGTEXT 2147483647 √ null

ISBN (MARC21 020$a)
import_batches Table num_records INT 10 0

number of records in the file
aqbasket Table is_standing BIT 0 0

orders in this basket are standing
overduerules Table debarred2 VARCHAR 1 √ 0

is the patron restricted when the second notice is sent (1 for yes, 0 for no)
article_requests Table created_on TIMESTAMP 19 √ null

Be careful with two timestamps in one table not allowing NULL
matchpoint_component_norms Table sequence INT 10 0
stockrotationstages Table duration INT 10 4

The number of days items shoud occupy this stage
oai_sets_mappings Table rule_operator VARCHAR 3 √ null
suggestions Table biblionumber INT 10 √ null

foreign key linking the suggestion to the biblio table after the suggestion has been ordered
deletedbiblioitems Table collectionvolume LONGTEXT 2147483647 √ null
accountlines Table amount DECIMAL 28 √ null
misc_files Table file_id INT 10 √ null

unique id for the file record
patron_consent Table given_on DATETIME 19 √ null
categories_branches Table branchcode VARCHAR 10 √ null
creator_layouts Table format_string VARCHAR 210 barcode
borrower_modifications Table initials MEDIUMTEXT 16777215 √ null
reviews Table reviewid INT 10 √ null

unique identifier for this comment
marc_subfield_structure Table important TINYINT 3 0
borrowers Table altcontactfirstname VARCHAR 255 √ null

first name of alternate contact for the patron/borrower
virtualshelves Table allow_change_from_owner BIT 0 √ 1

can owner change contents?
z3950servers Table attributes VARCHAR 255 √ null

additional attributes passed to PQF queries
suggestions Table archived BIT 0 0

is the suggestion archived?
currency Table timestamp TIMESTAMP 19 current_timestamp()
zebraqueue Table server CHAR 20
biblioitems Table volumedate DATE 10 √ null
account_credit_types Table is_system BIT 0 0
edifact_messages Table vendor_id INT 10 √ null
sessions Table a_session LONGTEXT 2147483647 null
borrower_debarments Table expiration DATE 10 √ null

expiration date of the restriction
aqbudgets Table budget_name VARCHAR 80 √ null

name assigned to the fund by the user
biblioitems Table agerestriction VARCHAR 255 √ null

target audience/age restriction from the bib record (MARC21 521$a)
printers_profile Table template_id INT 10 0
overduerules Table letter1 VARCHAR 20 √ null

foreign key from the letter table to define which notice should be sent as the first notice
biblio Table medium LONGTEXT 2147483647 √ null

medium from the MARC record (245$h in MARC21)
language_descriptions Table subtag VARCHAR 25 √ null
club_holds Table biblio_id INT 10 null

id for the bibliographic record the hold has been placed against
course_items Table location_enabled BIT 0 0

indicates if itype should be changed while on course reserve
borrower_modifications Table B_streettype VARCHAR 50 √ null
edifact_messages Table id INT 10 √ null
biblio_metadata Table biblionumber INT 10 null
deletedborrowers Table cardnumber VARCHAR 32 √ null

unique key, library assigned ID number for patrons/borrowers
serial Table status TINYINT 3 0

status code for this issue (see manual for full descriptions)
itemtypes Table summary MEDIUMTEXT 16777215 √ null

information from the summary field, may include HTML
suggestions Table rejecteddate DATE 10 √ null

date the suggestion was marked as rejected
deletedborrowers Table fax LONGTEXT 2147483647 √ null

the fax number for your patron/borrower's primary address
return_claims Table resolved_on TIMESTAMP 19 √ null
borrowers Table contactfirstname MEDIUMTEXT 16777215 √ null

used for children to include first name of guarantor
illrequests Table branchcode VARCHAR 50 null
suggestions Table budgetid INT 10 √ null

foreign key linking the suggested budget to the aqbudgets table
biblio Table copyrightdate SMALLINT 5 √ null

publication or copyright date from the MARC record
borrowers Table B_phone LONGTEXT 2147483647 √ null

the patron/borrower's alternate phone number
deletedborrowers Table lastseen DATETIME 19 √ null

last time a patron has been seen (connected at the OPAC or staff interface)
subscription_frequencies Table description MEDIUMTEXT 16777215 null
marc_modification_template_actions Table field_number SMALLINT 5 0
borrower_debarments Table created TIMESTAMP 19 current_timestamp()

date the restriction was added
borrower_modifications Table altcontactphone VARCHAR 50 √ null
club_fields Table club_template_field_id INT 10 null
additional_fields Table searchable BIT 0 0

is the field searchable?
patron_lists Table owner INT 10 null
item_circulation_alert_preferences Table categorycode VARCHAR 10 null
borrowers Table address2 MEDIUMTEXT 16777215 √ null

the second address line for your patron/borrower's primary address
virtualshelfcontents Table biblionumber INT 10 0

foreign key linking to the biblio table, defines the bib record that has been added to the list
items_search_fields Table tagsubfield CHAR 1 √ null
housebound_profile Table frequency MEDIUMTEXT 16777215 null

The Authorised_Value definining the pattern for delivery.
borrower_debarments Table updated TIMESTAMP 19 √ null

date the restriction was updated
aqbooksellers Table accountnumber LONGTEXT 2147483647 √ null

vendor account number
club_holds Table item_id INT 10 √ null

If item-level, the id for the item the hold has been placed agains
marc_tag_structure Table tagfield VARCHAR 3
borrowers Table sms_provider_id INT 10 √ null

the provider of the mobile phone number defined in smsalertnumber
aqorders Table order_vendornote LONGTEXT 2147483647 √ null

notes related to this order line, made for vendor
categories Table reservefee DECIMAL 28 √ null

cost to place holds
course_items Table enabled enum('yes', 'no') 4 no

if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
messages Table message_type VARCHAR 1 null

whether the message is for the librarians (L) or the patron (B)
subscription Table biblionumber INT 10 null

foreign key for biblio.biblionumber that this subscription is attached to
borrower_files Table file_content LONGBLOB 2147483647 null

the file
borrower_modifications Table mobile VARCHAR 50 √ null
items Table ccode VARCHAR 80 √ null

authorized value for the collection code associated with this item (MARC21 952$8)
aqinvoices Table message_id INT 10 √ null

foreign key to edifact invoice message
aqbudgetperiods Table budget_period_active BIT 0 √ 0

whether this budget is active or not (1 for yes, 0 for no)
marc_tag_structure Table frameworkcode VARCHAR 4
borrowers Table 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
items_search_fields Table label VARCHAR 255 null
printers_profile Table units CHAR 20 POINT
biblio Table title LONGTEXT 2147483647 √ null

title (without the subtitle) from the MARC record (245$a in MARC21)
borrowers Table date_renewed DATE 10 √ null

date the patron/borrower's card was last renewed
matcher_matchpoints Table matcher_id INT 10 null
deletedborrowers Table contactname LONGTEXT 2147483647 √ null

used for children and profesionals to include surname or last name of guarantor or organization name
accountlines Table timestamp TIMESTAMP 19 current_timestamp()
suggestions Table price DECIMAL 28 √ null

suggested price
branches Table branchnotes LONGTEXT 2147483647 √ null

notes related to your library or branch
printers_profile Table profile_id INT 10 √ null
aqinvoices Table invoicenumber LONGTEXT 2147483647 null
biblioitems Table collectiontitle LONGTEXT 2147483647 √ null
borrower_attribute_types Table authorised_value_category VARCHAR 32 √ null

foreign key from authorised_values that links this custom field to an authorized value category
z3950servers Table rank INT 10 √ null

where this target appears in the list of targets
deletedborrowers Table B_country MEDIUMTEXT 16777215 √ null

the country for your patron/borrower's alternate address
club_enrollments Table club_id INT 10 null
pending_offline_operations Table operationid INT 10 √ null
club_template_fields Table name TEXT 65535 null
course_items Table ccode_enabled BIT 0 0

indicates if ccode should be changed while on course reserve
tags_all Table biblionumber INT 10 null

the bib record this tag was left on (biblio.biblionumber)
itemtypes Table searchcategory VARCHAR 80 √ null

Group this item type with others with the same value on OPAC search options
search_history Table userid INT 10 null

the patron who performed the search (borrowers.borrowernumber)
reports_dictionary Table saved_sql MEDIUMTEXT 16777215 √ null

SQL snippet for us in reports
messages Table message_date TIMESTAMP 19 current_timestamp()

the date and time the message was written
itemtypes Table rentalcharge_hourly DECIMAL 28 √ null

the amount charged for each hour between checkout date and due date
aqorders Table rrp DECIMAL 13 √ null

the retail cost for this line item
deletedborrowers Table sex VARCHAR 1 √ null

patron/borrower's gender
courses Table course_name VARCHAR 255 √ null

the name of the course
aqorders Table tax_value_bak DECIMAL 28 √ null

the tax value for this line item
aqorders Table entrydate DATE 10 √ null

the date the bib was added to the basket
auth_tag_structure Table authorised_value VARCHAR 10 √ null
message_queue Table content_type MEDIUMTEXT 16777215 √ null
subscription Table lastvalue2 INT 10 √ null
alert Table externalid VARCHAR 20
additional_fields Table marcfield VARCHAR 16

contains the marc field to copied into the record
borrowers Table othernames LONGTEXT 2147483647 √ null

any other names associated with the patron/borrower
borrowers Table cardnumber VARCHAR 32 √ null

unique key, library assigned ID number for patrons/borrowers
opac_news Table borrowernumber INT 10 √ null

The user who created the news article
aqcontacts Table booksellerid INT 10 null
courses Table enabled enum('yes', 'no') 4 yes

determines whether the course is active
printers_profile Table creator CHAR 15 Labels
marc_modification_template_actions Table to_regex_modifiers VARCHAR 8 √
deleteditems Table cn_source VARCHAR 10 √ null

classification source used on this item (MARC21 952$2)
export_format Table type VARCHAR 255 √ marc
overduerules Table delay2 INT 10 √ null

number of days after the item is overdue that the second notice is sent
suggestions Table title VARCHAR 255 √ null

title of the suggested item
auth_subfield_structure Table frameworkcode VARCHAR 10
deletedborrowers Table phonepro MEDIUMTEXT 16777215 √ null

the secondary phone number for your patron/borrower's primary address
additional_field_values Table record_id INT 10 null

record_id
marc_subfield_structure Table tab BIT 0 √ null
illrequests Table medium VARCHAR 30 √ null
subscription_numberpatterns Table numbering2 VARCHAR 255 √ null
special_holidays Table branchcode VARCHAR 10 null

foreign key from the branches table, defines which branch this closing is for
authorised_values Table authorised_value VARCHAR 80

code use to identify the authorized value
old_reserves Table 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)
borrower_debarments Table comment MEDIUMTEXT 16777215 √ null

comments about the restriction
matchpoints Table score INT 10 0
cities Table city_state VARCHAR 100 √ null

name of the state/province
language_script_bidi Table bidi VARCHAR 3 √ null

rtl ltr
aqcontract Table contractdescription LONGTEXT 2147483647 √ null
items Table 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.
aqbudgets Table budget_amount DECIMAL 28 √ 0.000000

total amount for this fund
illrequests Table accessurl VARCHAR 500 √ null
linktracker Table borrowernumber INT 10 √ null

borrowernumber who clicked the link
marc_tag_structure Table ind2_defaultvalue VARCHAR 1
audio_alerts Table id INT 10 √ null
deletedborrowers Table sort1 VARCHAR 80 √ null

a field that can be used for any information unique to the library
patron_lists Table shared BIT 0 √ 0
letter Table code VARCHAR 20

unique identifier for this notice or slip
club_fields Table id INT 10 √ null
borrower_modifications Table gdpr_proc_consent DATETIME 19 √ null

data processing consent
reserves Table 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
borrower_modifications Table B_address VARCHAR 100 √ null
borrower_modifications Table relationship VARCHAR 100 √ null
aqbudgets Table budget_parent_id INT 10 √ null

if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
account_debit_types_branches Table debit_type_code VARCHAR 80 √ null
deleteditems Table withdrawn BIT 0 0

authorized value defining this item as withdrawn (MARC21 952$0)
export_format Table description LONGTEXT 2147483647 null
marc_modification_template_actions Table conditional_comparison enum('exists', 'not_exists', 'equals', 'not_equals') 10 √ null
borrowers Table sort1 VARCHAR 80 √ null

a field that can be used for any information unique to the library
clubs Table name TEXT 65535 null
suggestions Table copyrightdate SMALLINT 5 √ null

copyright date of the suggested item
borrower_attribute_types Table description VARCHAR 255 null

description for each custom field
pending_offline_operations Table branchcode VARCHAR 10 null
deletedborrowers Table emailpro MEDIUMTEXT 16777215 √ null

the secondary email addres for your patron/borrower's primary address
items_last_borrower Table id INT 10 √ null
auth_header Table origincode VARCHAR 20 √ null
authorised_values Table lib VARCHAR 200 √ null

authorized value description as printed in the staff client
aqbooksellers Table invoiceprice VARCHAR 10 √ null

currency code for invoice prices
marc_subfield_structure Table maxlength INT 10 9999
aqbasket Table booksellerinvoicenumber LONGTEXT 2147483647 √ null

appears to always be NULL
course_items Table homebranch_enabled BIT 0 0

indicates if homebranch should be changed while on course reserve
patron_list_patrons Table borrowernumber INT 10 null
deletedborrowers Table altcontactphone VARCHAR 50 √ null

the phone number for the alternate contact for the patron/borrower
account_credit_types Table archived BIT 0 0

boolean flag to denote if this till is archived or not
marc_modification_template_actions Table conditional_subfield VARCHAR 1 √ null
deletedbiblio Table part_name LONGTEXT 2147483647 √ null

part name from the MARC record (245$p in MARC21)
virtualshelves Table created_on DATETIME 19 null

creation time
itemtypes Table rentalcharge DECIMAL 28 √ null

the amount charged when this item is checked out/issued
additional_fields Table authorised_value_category VARCHAR 16

is an authorised value category
items Table stocknumber VARCHAR 32 √ null

inventory number (MARC21 952$i)
illrequests Table placed DATE 10 √ null
edifact_ean Table branchcode VARCHAR 10 √ null
club_enrollments Table branchcode VARCHAR 10 √ null
statistics Table branch VARCHAR 10 √ null

foreign key, branch where the transaction occurred
zebraqueue Table biblio_auth_number BIGINT UNSIGNED 20 0
class_sources Table cn_source VARCHAR 10
deletedborrowers Table userid VARCHAR 75 √ null

patron/borrower's opac and/or staff client log in
message_queue Table borrowernumber INT 10 √ null
borrower_modifications Table categorycode VARCHAR 10 √ null
search_history Table time TIMESTAMP 19 current_timestamp()

the date and time the search was run
patron_list_patrons Table patron_list_id INT 10 null
account_offsets Table credit_id INT 10 √ null

The id of the accountline the increased the patron's balance
stockrotationrotas Table cyclical BIT 0 0

Should items on this rota keep cycling?
letter Table content MEDIUMTEXT 16777215 √ null

body text for the notice or slip
aqbooksellers Table address1 LONGTEXT 2147483647 √ null

first line of vendor physical address
subscription Table firstacquidate DATE 10 √ null

first issue received date
branches Table issuing TINYINT 3 √ null

unused in Koha
tags_index Table weight INT 10 1

the number of times this term was used on this bib record
illrequests Table price_paid VARCHAR 20 √ null
deletedborrowers Table altcontactzipcode VARCHAR 50 √ null

the zipcode for the alternate contact for the patron/borrower
club_enrollments Table date_updated TIMESTAMP 19 √ null
saved_reports Table id INT 10 √ null
authorised_values Table lib_opac VARCHAR 200 √ null

authorized value description as printed in the OPAC
reserves Table suspend BIT 0 0
biblio Table abstract LONGTEXT 2147483647 √ null

summary from the MARC record (520$a in MARC21)
itemtypes Table processfee DECIMAL 28 √ null

default text be recorded in the column note when the processing fee is applied
deletedborrowers Table B_state MEDIUMTEXT 16777215 √ null

the state for your patron/borrower's alternate address
deleteditems Table reserves SMALLINT 5 √ null

number of times this item has been placed on hold/reserved
itemtypes Table notforloan SMALLINT 5 √ null

1 if the item is not for loan, 0 if the item is available for loan
items Table damaged_on DATETIME 19 √ null

the date and time an item was last marked as damaged, NULL if not damaged
deletedbiblio Table abstract LONGTEXT 2147483647 √ null

summary from the MARC record (520$a in MARC21)
letter Table module VARCHAR 20

Koha module that triggers this notice or slip
deletedbiblioitems Table cn_source VARCHAR 10 √ null

classification source (MARC21 942$2)
serial Table planneddate DATE 10 √ null

date expected
additional_fields Table name VARCHAR 255

name of the field
z3950servers Table id INT 10 √ null

unique identifier assigned by Koha
deletedbiblio_metadata Table timestamp TIMESTAMP 19 current_timestamp()
illrequests Table notesstaff MEDIUMTEXT 16777215 √ null
edifact_messages Table basketno INT 10 √ null
misc_files Table file_description VARCHAR 255 √ null

description given to the file
items Table replacementpricedate DATE 10 √ null

the date the price is effective from (MARC21 952$w)
subscription Table locale VARCHAR 80 √ null

for foreign language subscriptions to display months, seasons, etc correctly
borrower_modifications Table othernames LONGTEXT 2147483647 √ null
branches Table branchzip VARCHAR 25 √ null

the zip or postal code for your library or branch
creator_batches Table timestamp TIMESTAMP 19 current_timestamp()
tmp_holdsqueue Table firstname MEDIUMTEXT 16777215 √ null
items Table reserves SMALLINT 5 √ null

number of times this item has been placed on hold/reserved
social_data Table isbn VARCHAR 30
deletedborrowers Table surname LONGTEXT 2147483647 √ null

patron/borrower's last name (surname)
items Table itemnumber INT 10 √ null

primary key and unique identifier added by Koha
edifact_ean Table ee_id INT 10 √ null
borrower_attribute_types Table unique_id BIT 0 0

defines if this value needs to be unique (1 for yes, 0 for no)
aqbudgetperiods Table sort2_authcat VARCHAR 10 √ null

second statistical category for this budget
deletedborrowers Table privacy_guarantor_checkouts BIT 0 0

controls if relatives can see this patron's checkouts
columns_settings Table is_hidden INT 10 0
suggestions Table collectiontitle MEDIUMTEXT 16777215 √ null

collection name for the suggested item
stockrotationrotas Table description TEXT 65535 null
aqinvoice_adjustments Table encumber_open SMALLINT 5 1

whether or not to encumber the funds when invoice is still open, 1 = yes, 0 = no
deletedbiblioitems Table publishercode VARCHAR 255 √ null

publisher (MARC21 260$b)
letter Table branchcode VARCHAR 10

the branch this notice or slip is used at (branches.branchcode)
illrequests Table backend VARCHAR 20 √ null
z3950servers Table recordtype enum('authority', 'biblio') 10 biblio

server contains bibliographic or authority records
reports_dictionary Table name VARCHAR 255 √ null

name for this definition
deletedbiblioitems Table cn_sort VARCHAR 255 √ null

normalized version of the call number used for sorting
pending_offline_operations Table barcode VARCHAR 20 √ null
auth_subfield_structure Table kohafield VARCHAR 45 √
club_holds_to_patron_holds Table club_hold_id INT 10 null
statistics Table type VARCHAR 16 √ null

transaction type (localuse, issue, return, renew, writeoff, payment)
deletedbiblioitems Table totalissues INT 10 √ null
aqorders_items Table timestamp TIMESTAMP 19 current_timestamp()

the date and time this order item was last touched
permissions Table code VARCHAR 64
account_debit_types Table can_be_sold BIT 0 0

boolean flag to denote if this debit type is available at point of sale
deletedborrowers Table altcontactsurname VARCHAR 255 √ null

surname or last name of the alternate contact for the patron/borrower
user_permissions Table borrowernumber INT 10 0
old_issues Table renewals TINYINT 3 0

lists the number of times the item was renewed
marc_modification_template_actions Table conditional_regex BIT 0 0
auth_types Table authtypetext VARCHAR 255
import_auths Table import_record_id INT 10 null
aqbasket Table note LONGTEXT 2147483647 √ null

the internal note added at basket creation
matchpoint_components Table length INT 10 0
club_holds Table club_id INT 10 null

id for the club the hold was generated for
borrower_modifications Table dateofbirth DATE 10 √ null
misc_files Table file_type VARCHAR 255 null

MIME type of the file
subscription Table serialsadditems BIT 0 0

does receiving this serial create an item record
class_sources Table description LONGTEXT 2147483647 √ null
vendor_edi_accounts Table upload_directory MEDIUMTEXT 16777215 √ null
deleteditems Table itemlost BIT 0 0

authorized value defining this item as lost (MARC21 952$1)
marc_modification_template_actions Table conditional_value MEDIUMTEXT 16777215 √ null
import_record_matches Table score INT 10 0

the match score
subscriptionhistory Table recievedlist LONGTEXT 2147483647 null
biblio Table frameworkcode VARCHAR 4

foreign key from the biblio_framework table to identify which framework was used in cataloging this record
misc_files Table table_tag VARCHAR 255 null

usually table name, or arbitrary unique tag
deleteditems Table itemnumber INT 10 0

primary key and unique identifier added by Koha
issues Table issue_id INT 10 √ null

primary key for issues table
aqbudgetperiods Table budget_period_locked BIT 0 √ null

whether this budget is locked or not (1 for yes, 0 for no)
suggestions Table suggesteddate DATE 10 null

date the suggestion was submitted
social_data Table num_critics_pro INT 10 √ null
library_groups Table ft_search_groups_opac BIT 0 0

Use this group for staff side search groups
message_attributes Table message_name VARCHAR 40
import_batches Table batch_type enum('batch', 'z3950', 'webservice') 10 batch

where this batch has come from
aqorders_claims Table id INT 10 √ null

ID of the claims
course_items Table itemnumber INT 10 null

items.itemnumber for the item on reserve
account_offsets Table amount DECIMAL 26 null

The amount of the change
tags_all Table language INT 10 √ null

the language the tag was left in
message_transports Table letter_module VARCHAR 20
vendor_edi_accounts Table id INT 10 √ null
aqcontacts Table serialsprimary BIT 0 0

is this the primary contact for serials messages
items Table stack BIT 0 √ null
old_issues Table issuedate DATETIME 19 √ null

date the item was checked out or issued
deleteditems Table itemcallnumber VARCHAR 255 √ null

call number for this item (MARC21 952$o)
tmp_holdsqueue Table holdingbranch VARCHAR 10 √ null
categories Table finetype VARCHAR 30 √ null

unused in Koha
borrower_message_transport_preferences Table borrower_message_preference_id INT 10 0
deleteditems Table more_subfields_xml LONGTEXT 2147483647 √ null

additional 952 subfields in XML format
problem_reports Table content VARCHAR 255

report message content
deletedborrowers Table contactnote VARCHAR 255 √ null

a note related to the patron/borrower's alternate address
import_batches Table import_batch_id INT 10 √ null

unique identifier and primary key
housebound_profile Table referral MEDIUMTEXT 16777215 √ null

Free text indicating how the borrower was added to the service.
borrower_modifications Table streetnumber VARCHAR 10 √ null
courses Table public_note LONGTEXT 2147483647 √ null

the text of the public / opac note
message_queue Table reply_address LONGTEXT 2147483647 √ null
aqorders Table subscriptionid INT 10 √ null

links this order line to a subscription (subscription.subscriptionid)
systempreferences Table variable VARCHAR 50

system preference name
item_circulation_alert_preferences Table id INT 10 √ null
reviews Table borrowernumber INT 10 √ null

foreign key from the borrowers table defining which patron left this comment
virtualshelves Table lastmodified TIMESTAMP 19 current_timestamp()

date and time the list was last modified
uploaded_files Table dtcreated TIMESTAMP 19 current_timestamp()
borrowers Table B_zipcode VARCHAR 25 √ null

the zip or postal code for your patron/borrower's alternate address
subscriptionroutinglist Table borrowernumber INT 10 null

foreign key from the borrowers table, defines with patron is on the routing list
message_transports Table is_digest BIT 0 0
deletedborrowers Table address2 MEDIUMTEXT 16777215 √ null

the second address line for your patron/borrower's primary address
matcher_matchpoints Table matchpoint_id INT 10 null
borrowers Table altcontactphone VARCHAR 50 √ null

the phone number for the alternate contact for the patron/borrower
borrowers Table 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)
borrower_modifications Table phonepro MEDIUMTEXT 16777215 √ null
aqinvoice_adjustments Table adjustment DECIMAL 28 √ null

amount of adjustment
sessions Table id VARCHAR 32 null
deletedborrowers Table date_renewed DATE 10 √ null

date the patron/borrower's card was last renewed
aqbudgetperiods Table budget_period_enddate DATE 10 null

date when the budget ends
deletedborrowers Table lang VARCHAR 25 default

lang to use to send notices to this patron
old_issues Table notedate DATETIME 19 √ null

datetime of issue note (yyyy-mm-dd hh:mm::ss)
deleteditems Table location VARCHAR 80 √ null

authorized value for the shelving location for this item (MARC21 952$c)
opac_news Table number INT 10 √ null

the order in which this article appears in that specific location
deleteditems Table restricted BIT 0 √ null

authorized value defining use restrictions for this item (MARC21 952$5)
deletedborrowers Table B_streettype VARCHAR 50 √ null

the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
hold_fill_targets Table itemnumber INT 10 null
library_groups Table ft_search_groups_staff BIT 0 0

Use this group for opac side search groups
serialitems Table itemnumber INT 10 null
aqorders Table quantity SMALLINT 5 √ null

the quantity ordered
borrower_relationships Table id INT 10 √ null
borrowers Table emailpro MEDIUMTEXT 16777215 √ null

the secondary email addres for your patron/borrower's primary address
items Table barcode VARCHAR 20 √ null

item barcode (MARC21 952$p)
statistics Table ccode VARCHAR 80 √ null

foreign key from the items table, links transaction to a specific collection code
additional_field_values Table field_id INT 10 null

foreign key references additional_fields(id)
club_templates Table is_deletable BIT 0 1
keyboard_shortcuts Table shortcut_name VARCHAR 80 null
repeatable_holidays Table id INT 10 √ null

unique identifier assigned by Koha
items Table holdingbranch VARCHAR 10 √ null

foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
tmp_holdsqueue Table borrowernumber INT 10 null
patron_list_patrons Table patron_list_patron_id INT 10 √ null

unique identifier
borrowers Table contactnote VARCHAR 255 √ null

a note related to the patron/borrower's alternate address
creator_templates Table cols INT 10 0
return_claims Table created_on TIMESTAMP 19 √ null
uploaded_files Table public TINYINT 3 √ null
borrower_modifications Table branchcode VARCHAR 10 √ null
subscription Table aqbooksellerid INT 10 √ 0

foreign key for aqbooksellers.id to link to the vendor
biblioimages Table mimetype VARCHAR 15 null

image type
printers_profile Table paper_bin VARCHAR 20 Bypass
deleteditems Table onloan DATE 10 √ null

defines if item is checked out (NULL for not checked out, and due date for checked out)
borrower_message_preferences Table wants_digest BIT 0 0
import_batches Table upload_timestamp TIMESTAMP 19 current_timestamp()

date and time the file was uploaded
categories Table hidelostitems BIT 0 0

are lost items shown to this category (1 for yes, 0 for no)
itemtypes Table rentalcharge_hourly_calendar BIT 0 1

controls if the hourly retnal fee is calculated directly or using finesCalendar
overduerules Table letter2 VARCHAR 20 √ null

foreign key from the letter table to define which notice should be sent as the second notice
borrower_modifications Table password VARCHAR 30 √ null
borrowers Table lastseen DATETIME 19 √ null

last time a patron has been seen (connected at the OPAC or staff interface)
article_requests Table patron_notes MEDIUMTEXT 16777215 √ null
borrowers Table contactname LONGTEXT 2147483647 √ null

used for children and profesionals to include surname or last name of guarantor or organization name
deletedborrowers Table B_city LONGTEXT 2147483647 √ null

the city or town for your patron/borrower's alternate address
overduerules Table branchcode VARCHAR 10

foreign key from the branches table to define which branch this rule is for (if blank it's all libraries)
borrower_modifications Table B_address2 MEDIUMTEXT 16777215 √ null
borrower_modifications Table B_zipcode VARCHAR 25 √ null
authorised_value_categories Table is_system BIT 0 √ 0
borrower_modifications Table B_state MEDIUMTEXT 16777215 √ null
item_circulation_alert_preferences Table item_type VARCHAR 10 null
tmp_holdsqueue Table surname LONGTEXT 2147483647 null
housebound_profile Table fav_authors MEDIUMTEXT 16777215 √ null

Free text describing preferred authors.
deletedbiblioitems Table timestamp TIMESTAMP 19 current_timestamp()
return_claims Table resolution VARCHAR 80 √ null
aqcontacts Table email VARCHAR 100 √ null

contact's email address
messages Table manager_id INT 10 √ null

creator of message
article_requests Table issue MEDIUMTEXT 16777215 √ null
deletedborrowers Table city LONGTEXT 2147483647 √ null

the city or town for your patron/borrower's primary address
aqorders Table tax_value_on_ordering DECIMAL 28 √ null

the tax value on ordering for this line item
marc_modification_template_actions Table action enum('delete_field', 'add_field', 'update_field', 'move_field', 'copy_field', 'copy_and_replace_field') 22 null
browser Table number BIGINT 19 null
import_biblios Table issn VARCHAR 9 √ null
deleteditems Table uri MEDIUMTEXT 16777215 √ null

URL for the item (MARC21 952$u)
borrowers Table streettype VARCHAR 50 √ null

the street type (Rd., Blvd, etc) for your patron/borrower's primary address
article_requests Table volume MEDIUMTEXT 16777215 √ null
subscription_numberpatterns Table numbering1 VARCHAR 255 √ null
patron_lists Table name VARCHAR 255 null
sms_providers Table domain VARCHAR 255 null
opac_news Table expirationdate DATE 10 √ null

date the article is set to expire or no longer be visible
old_issues Table borrowernumber INT 10 √ null

foreign key, linking this to the borrowers table for the patron this item was checked out to
deleteditems Table enumchron MEDIUMTEXT 16777215 √ null

serial enumeration/chronology for the item (MARC21 952$h)
aqbudgets_planning Table estimated_amount DECIMAL 28 √ null
club_holds_to_patron_holds Table patron_id INT 10 null
creator_templates Table row_gap FLOAT 12 0
matchpoint_components Table tag VARCHAR 3
currency Table active BIT 0 √ null
auth_subfield_structure Table linkid BIT 0 0
deletedbiblio Table medium LONGTEXT 2147483647 √ null

medium from the MARC record (245$h in MARC21)
deletedbiblio Table unititle LONGTEXT 2147483647 √ null

uniform title (without the subtitle) from the MARC record (240$a in MARC21)
aqbasketgroups Table name VARCHAR 50 √ null
aqcontacts Table claimacquisition BIT 0 0

should this contact receive acquisitions claims
creator_batches Table batch_id INT 10 1
borrowers Table debarredcomment VARCHAR 255 √ null

comment on the stop of the patron
biblioitems Table cn_source VARCHAR 10 √ null

classification source (MARC21 942$2)
auth_subfield_structure Table value_builder VARCHAR 80 √ null
aqbasket Table booksellerid INT 10 1

the Koha assigned ID for the vendor (aqbooksellers.id)
issues Table branchcode VARCHAR 10 √ null

foreign key, linking to the branches table for the location the item was checked out
oai_sets_biblios Table biblionumber INT 10 null
printers_profile Table creep_horz FLOAT 12 0
user_permissions Table module_bit INT 10 0
borrower_attribute_types_branches Table b_branchcode VARCHAR 10 √ null
borrowers Table fax LONGTEXT 2147483647 √ null

the fax number for your patron/borrower's primary address
club_holds_to_patron_holds Table id INT 10 √ null
aqorders Table replacementprice DECIMAL 28 √ null

the replacement cost for this line item
circulation_rules Table categorycode VARCHAR 10 √ null
borrower_modifications Table flags INT 10 √ null
edifact_ean Table id_code_qualifier VARCHAR 3 14
club_template_enrollment_fields Table description MEDIUMTEXT 16777215 √ null
subscription Table mana_id INT 10 √ null
borrower_modifications Table sort1 VARCHAR 80 √ null
subscription_numberpatterns Table numberingmethod VARCHAR 255 null
api_keys Table active BIT 0 1
subscription Table lastbranch VARCHAR 10 √ null
subscriptionroutinglist Table routingid INT 10 √ null

unique identifier assigned by Koha
virtualshelves Table shelfname VARCHAR 255 √ null

name of the list
marc_modification_template_actions Table to_regex_replace MEDIUMTEXT 16777215 √ null
aqorders Table line_item_id VARCHAR 35 √ null

Supplier's article id for Edifact orderline
import_auths Table control_number VARCHAR 25 √ null
borrower_attributes Table id INT 10 √ null

Row id field
transport_cost Table frombranch VARCHAR 10 null
aqbudgets_planning Table authvalue VARCHAR 30 null
edifact_messages Table raw_msg LONGTEXT 2147483647 √ null
club_templates Table name TEXT 65535 null
deleteditems Table datelastborrowed DATE 10 √ null

the date the item was last checked out
deletedborrowers Table 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
import_records Table marcxml LONGTEXT 2147483647 null
suggestions Table suggestedby INT 10 √ null

borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
borrowers Table sex VARCHAR 1 √ null

patron/borrower's gender
message_attributes Table takes_days BIT 0 0
suggestions Table suggestionid INT 10 √ null

unique identifier assigned automatically by Koha
misc_files Table file_content LONGBLOB 2147483647 null

file content
aqcontacts Table id INT 10 √ null

primary key and unique number assigned by Koha
import_records Table import_batch_id INT 10 null
social_data Table num_videos INT 10 √ null
old_issues Table date_due DATETIME 19 √ null

date the item is due (yyyy-mm-dd)
biblio_metadata Table schema VARCHAR 16 null
illcomments Table borrowernumber INT 10 √ null
reports_dictionary Table report_area VARCHAR 6 √ null

Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts)
borrower_attribute_types_branches Table bat_code VARCHAR 10 √ null
aqbooksellers Table postal LONGTEXT 2147483647 √ null

vendor postal address (all lines)
issues Table noteseen INT 10 √ null

describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null
serial Table serialseq_x VARCHAR 100 √ null

first part of issue information
language_rfc4646_to_iso639 Table iso639_2_code VARCHAR 25 √ null
import_auths Table original_source VARCHAR 25 √ null
article_requests Table borrowernumber INT 10 null
creator_layouts Table printing_type CHAR 32 BAR
course_reserves Table course_id INT 10 null

foreign key to link to courses.course_id
old_issues Table lastreneweddate DATETIME 19 √ null

date the item was last renewed
aqbooksellers Table gstreg TINYINT 3 √ null

is your library charged tax (1 for yes, 0 for no)
accountlines Table borrowernumber INT 10 √ null
marc_tag_structure Table liblibrarian VARCHAR 255
systempreferences Table type VARCHAR 20 √ null

type of question this preference asks (multiple choice, plain text, yes or no, etc)
deleteditems Table ccode VARCHAR 80 √ null

authorized value for the collection code associated with this item (MARC21 952$8)
deletedborrowers Table anonymized BIT 0 0

flag for data anonymization
columns_settings Table cannot_be_toggled INT 10 0
stockrotationrotas Table title VARCHAR 100 null
action_logs Table timestamp TIMESTAMP 19 current_timestamp()

the date and time the action took place
borrower_modifications Table borrowernumber INT 10 0
language_rfc4646_to_iso639 Table id INT 10 √ null
issues Table itemnumber INT 10 √ null

foreign key, linking this to the items table for the item that was checked out
currency Table currency VARCHAR 10
old_reserves Table biblionumber INT 10 √ null

foreign key from the biblio table defining which bib record this hold is on
import_biblios Table original_source VARCHAR 25 √ null
borrower_modifications Table altcontactaddress2 VARCHAR 255 √ null
aqorders Table rrp_tax_included DECIMAL 28 √ null

the replacement cost including tax
borrowers Table privacy INT 10 1

patron/borrower's privacy settings related to their reading history
aqbudgets Table budget_period_id INT 10 √ null

id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)
borrower_attributes Table attribute VARCHAR 255 √ null

custom patron field value
aqorders Table sort1 VARCHAR 80 √ null

statistical field
illrequests Table biblio_id INT 10 √ null
branch_transfer_limits Table itemtype VARCHAR 10 √ null
deletedborrowers Table privacy INT 10 1

patron/borrower's privacy settings related to their reading history KEY borrowernumber (borrowernumber),
import_records Table branchcode VARCHAR 10 √ null
deleteditems Table replacementpricedate DATE 10 √ null

the date the price is effective from (MARC21 952$w)
aqorders_transfers Table timestamp TIMESTAMP 19 current_timestamp()
deletedbiblioitems Table collectionissn MEDIUMTEXT 16777215 √ null
aqorders Table tax_value_on_receiving DECIMAL 28 √ null

the tax value on receiving for this line item
aqbudgets Table budget_encumb DECIMAL 28 √ 0.000000

budget warning at percentage
subscription Table manualhistory BIT 0 0

yes or no to managing the history manually
itemtypes Table defaultreplacecost DECIMAL 28 √ null

default replacement cost
old_reserves Table borrowernumber INT 10 √ null

foreign key from the borrowers table defining which patron this hold is for
desks Table branchcode VARCHAR 10 null
borrowers Table autorenew_checkouts BIT 0 1

flag for allowing auto-renewal
branches Table branchname LONGTEXT 2147483647 null

the name of your library or branch
uploaded_files Table permanent TINYINT 3 √ null
subscription Table lastvalue3 INT 10 √ null
aqorders Table ecost_tax_included DECIMAL 28 √ null

the estimated cost including tax
message_queue Table message_transport_type VARCHAR 20 null
borrower_modifications Table title LONGTEXT 2147483647 √ null
borrower_modifications Table gonenoaddress BIT 0 √ null
club_enrollment_fields Table club_enrollment_id INT 10 null
club_template_enrollment_fields Table club_template_id INT 10 null
z3950servers Table port INT 10 √ null

port number used to connect to target
items Table itemlost_on DATETIME 19 √ null

the date and time an item was last marked as lost, NULL if not lost
suggestions Table quantity SMALLINT 5 √ null

suggested quantity to be purchased
reserves Table reserve_id INT 10 √ null

primary key
old_reserves Table reservenotes LONGTEXT 2147483647 √ null

notes related to this hold
creator_templates Table creator CHAR 15 Labels
alert Table type VARCHAR 10
creator_templates Table top_margin FLOAT 12 0
authorised_values Table category VARCHAR 32

key used to identify the authorized value category
items Table damaged BIT 0 0

authorized value defining this item as damaged (MARC21 952$4)
letter Table name VARCHAR 100

plain text name for this notice or slip
vendor_edi_accounts Table vendor_id INT 10 √ null
deletedbiblioitems Table issn LONGTEXT 2147483647 √ null

ISSN (MARC21 022$a)
marc_subfield_structure Table seealso VARCHAR 1100 √ null
deletedborrowers Table 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
zebraqueue Table done INT 10 0
need_merge_authorities Table id INT 10 √ null

unique id
aqorders Table unitprice_tax_excluded DECIMAL 28 √ null

the unit price excluding tax (on receiving)
old_reserves Table 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
suggestions Table currency VARCHAR 10 √ null

suggested currency for the suggested price
language_descriptions Table id INT 10 √ null
subscription Table itemtype VARCHAR 10 √ null
library_groups Table updated_on TIMESTAMP 19 current_timestamp()

Date and time of last
biblioitems Table totalissues INT 10 √ null
problem_reports Table problempage TEXT 65535 √ null

page the user triggered the problem report form from
clubs Table id INT 10 √ null
borrower_modifications Table changed_fields MEDIUMTEXT 16777215 √ null
linktracker Table itemnumber INT 10 √ null

itemnumber if applicable that the link was from
collections_tracking Table collections_tracking_id INT 10 √ null
borrower_message_preferences Table borrowernumber INT 10 √ null
subscription_numberpatterns Table every2 INT 10 √ null
reserves Table reservenotes LONGTEXT 2147483647 √ null

notes related to this hold
courses Table timestamp TIMESTAMP 19 current_timestamp()
stockrotationstages Table branchcode_id VARCHAR 10 null
virtualshelfshares Table borrowernumber INT 10 √ null
club_enrollment_fields Table club_template_enrollment_field_id INT 10 null
aqcontract Table contractnumber INT 10 √ null
categories Table bulk BIT 0 √ null
deleteditems Table homebranch VARCHAR 10 √ null

foreign key from the branches table for the library that owns this item (MARC21 952$a)
illrequestattributes Table illrequest_id BIGINT UNSIGNED 20 null

ILL request number
old_reserves Table notificationdate DATE 10 √ null

currently unused
deletedborrowers Table sort2 VARCHAR 80 √ null

a field that can be used for any information unique to the library
deleteditems Table biblioitemnumber INT 10 0

foreign key from the biblioitems table to link to item to additional information
deleteditems Table replacementprice DECIMAL 8 √ null

cost the library charges to replace the item if it has been marked lost (MARC21 952$v)
marc_modification_template_actions Table from_field VARCHAR 3 null
subscription_frequencies Table displayorder INT 10 √ null
branchtransfers Table itemnumber INT 10 0

the itemnumber that it is in transit (items.itemnumber)
aqorders Table tax_rate_on_ordering DECIMAL 6 √ null

the tax rate on ordering for this line item (%)
biblio Table serial BIT 0 √ null

Boolean indicating whether biblio is for a serial
deletedbiblioitems Table notes LONGTEXT 2147483647 √ null
zebraqueue Table operation CHAR 20
tags_all Table term VARCHAR 191 null

the tag
auth_tag_structure Table tagfield VARCHAR 3
suggestions Table lastmodificationdate DATE 10 √ null

date of the last modification
opac_news Table timestamp TIMESTAMP 19 current_timestamp()

pulibcation date and time
aqorders Table quantityreceived SMALLINT 5 0

the quantity that have been received so far
aqbooksellers Table fax VARCHAR 50 √ null

vendor fax number
import_items Table import_record_id INT 10 null
old_reserves Table suspend BIT 0 0

in this hold suspended (1 for yes, 0 for no)
account_offset_types Table type VARCHAR 16 null

The type of offset this is
categories_branches Table categorycode VARCHAR 10 √ null
subscription Table countissuesperunit INT 10 1
marc_modification_template_actions Table description MEDIUMTEXT 16777215 √ null
tmp_holdsqueue Table pickbranch VARCHAR 10 √ null
tags_index Table biblionumber INT 10 null

the bib record this tag was used on (biblio.biblionumber)
aqorders Table order_internalnote LONGTEXT 2147483647 √ null

notes related to this order line, made for staff
aqorders Table sort2 VARCHAR 80 √ null

second statistical field
deletedbiblio Table part_number LONGTEXT 2147483647 √ null

part number from the MARC record (245$n in MARC21)
aqorders Table unitprice DECIMAL 28 √ null

the actual cost entered when receiving this line item
deleteditems Table permanent_location VARCHAR 80 √ null

linked to the CART and PROC temporary locations feature, stores the permanent shelving location
overduerules Table overduerules_id INT 10 √ null

unique identifier for the overduerules
api_keys Table client_id VARCHAR 191 null
auth_types Table summary LONGTEXT 2147483647 null
pending_offline_operations Table timestamp TIMESTAMP 19 current_timestamp()
import_items Table status enum('error', 'staged', 'imported', 'reverted', 'ignored') 8 staged
cash_registers Table starting_float DECIMAL 28 √ null

the starting float this account register should be assigned
items_search_fields Table name VARCHAR 255 null
borrower_modifications Table contactfirstname MEDIUMTEXT 16777215 √ null
borrowers Table altcontactaddress2 VARCHAR 255 √ null

the second address line for the alternate contact for the patron/borrower
deletedborrowers Table initials MEDIUMTEXT 16777215 √ null

initials for your patron/borrower
patron_consent Table type enum('GDPR_PROCESSING') 16 √ null

allows for future extension
marc_modification_template_actions Table from_subfield VARCHAR 1 √ null
serial Table serialid INT 10 √ null

unique key for the issue
aqorders Table freight DECIMAL 28 √ null

shipping costs (not used)
issues Table renewals TINYINT 3 0

lists the number of times the item was renewed
illrequests Table status VARCHAR 50 √ null
import_items Table import_error LONGTEXT 2147483647 √ null
oai_sets_mappings Table set_id INT 10 null
borrower_files Table borrowernumber INT 10 null

foreign key linking to the patron via the borrowernumber
deletedborrowers Table altcontactstate MEDIUMTEXT 16777215 √ null

the state for the alternate contact for the patron/borrower
deleteditems Table barcode VARCHAR 20 √ null

item barcode (MARC21 952$p)
illrequests Table illrequest_id BIGINT UNSIGNED 20 √ null
advanced_editor_macros Table shared BIT 0 √ 0
deletedborrowers Table title LONGTEXT 2147483647 √ null

patron/borrower's title, for example: Mr. or Mrs.
library_groups Table ft_local_hold_group BIT 0 0

Use this group to identify libraries as pick up location for holds
deletedborrowers Table altcontactfirstname VARCHAR 255 √ null

first name of alternate contact for the patron/borrower
auth_tag_structure Table mandatory TINYINT 3 0
branches_overdrive Table authname VARCHAR 255 null
collections Table colTitle VARCHAR 100
article_requests Table status enum('PENDING', 'PROCESSING', 'COMPLETED', 'CANCELED') 10 PENDING
borrowers Table city LONGTEXT 2147483647 √ null

the city or town for your patron/borrower's primary address
language_script_bidi Table rfc4646_subtag VARCHAR 25 √ null

script subtag, Arab, Hebr, etc.
creator_templates Table page_width FLOAT 12 0
aqbudgetperiods Table budget_period_id INT 10 √ null

primary key and unique number assigned by Koha
subscription_numberpatterns Table every3 INT 10 √ null
aqcontacts Table fax VARCHAR 100 √ null
housebound_profile Table borrowernumber INT 10 null

Number of the borrower associated with this profile.
serial Table claims_count INT 10 √ 0

number of claims made related to this issue
special_holidays Table description MEDIUMTEXT 16777215 null

description of this closing
vendor_edi_accounts Table last_activity DATE 10 √ null
return_claims Table itemnumber INT 10 null
issues Table auto_renew BIT 0 √ 0

automatic renewal
deleteditems Table stocknumber VARCHAR 32 √ null

inventory number (MARC21 952$i)
marc_subfield_structure Table authorised_value VARCHAR 32 √ null
class_split_rules Table split_regex VARCHAR 255
search_marc_to_field Table search BIT 0 1
aqbasket Table closedate DATE 10 √ null

the date the basket was closed
aqorders Table suppliers_reference_qualifier VARCHAR 3 √ null

Type of number above usually 'QLI'
issues Table lastreneweddate DATETIME 19 √ null

date the item was last renewed
club_template_fields Table description MEDIUMTEXT 16777215 √ null
auth_header Table modification_time TIMESTAMP 19 current_timestamp()
import_records Table marcxml_old LONGTEXT 2147483647 null
subscription_numberpatterns Table numbering3 VARCHAR 255 √ null
opac_news Table content MEDIUMTEXT 16777215 null

the body of your news article
deletedbiblioitems Table publicationyear MEDIUMTEXT 16777215 √ null
virtualshelves Table sortfield VARCHAR 16 √ title

the field this list is sorted on
old_issues Table noteseen INT 10 √ null

describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null
pending_offline_operations Table cardnumber VARCHAR 32 √ null
borrower_files Table file_description VARCHAR 255 √ null

description given to the file
deletedborrowers Table branchcode VARCHAR 10

foreign key from the branches table, includes the code of the patron/borrower's home branch
overduerules_transport_types Table overduerules_id INT 10 null
borrower_modifications Table dateenrolled DATE 10 √ null
items Table restricted BIT 0 √ null

authorized value defining use restrictions for this item (MARC21 952$5)
subscription Table innerloop2 INT 10 √ 0
aqbudgetborrowers Table borrowernumber INT 10 null
oai_sets Table spec VARCHAR 80 null
biblioitems Table editionstatement MEDIUMTEXT 16777215 √ null
search_history Table sessionid VARCHAR 32 null

a system generated session id
article_requests Table id INT 10 √ null
categories Table upperagelimit SMALLINT 5 √ null

age limit for the patron
borrowers Table password VARCHAR 60 √ null

patron/borrower's Bcrypt encrypted password
borrower_modifications Table B_email MEDIUMTEXT 16777215 √ null
return_claims Table issue_id INT 10 √ null
borrower_message_preferences Table message_attribute_id INT 10 √ 0
items Table itemcallnumber VARCHAR 255 √ null

call number for this item (MARC21 952$o)
borrower_modifications Table B_phone LONGTEXT 2147483647 √ null
aqorders Table discount FLOAT 6 √ null

the discount for this line item (%)
deletedborrowers Table state MEDIUMTEXT 16777215 √ null

the state or province for your patron/borrower's primary address
biblioitems Table notes LONGTEXT 2147483647 √ null
localization Table localization_id INT 10 √ null
quotes Table id INT 10 √ null

unique id for the quote
clubs Table branchcode VARCHAR 10 √ null
aqorders Table biblionumber INT 10 √ null

links the order to the biblio being ordered (biblio.biblionumber)
aqcontacts Table name VARCHAR 100 √ null

name of contact at vendor
subscription Table cost INT 10 √ 0
circulation_rules Table branchcode VARCHAR 10 √ null
biblio_framework Table frameworktext VARCHAR 255

the description/name given to the framework
deletedborrowers Table login_attempts INT 10 √ 0

number of failed login attemps
old_reserves Table waitingdate DATE 10 √ null

the date the item was marked as waiting for the patron at the library
deletedbiblioitems Table place VARCHAR 255 √ null

publication place (MARC21 260$a)
deletedbiblioitems Table url MEDIUMTEXT 16777215 √ null

url (MARC21 856$u)
subscription_numberpatterns Table whenmorethan3 INT 10 √ null
repeatable_holidays Table branchcode VARCHAR 10 null

foreign key from the branches table, defines which branch this closing is for
borrowers Table altcontactcountry MEDIUMTEXT 16777215 √ null

the country for the alternate contact for the patron/borrower
saved_reports Table report LONGTEXT 2147483647 √ null
auth_header Table authid BIGINT UNSIGNED 20 √ null
subscription Table enddate DATE 10 √ null

subscription end date
library_groups Table branchcode VARCHAR 10 √ null

The branchcode of a branch belonging to the parent group
branches Table branchemail LONGTEXT 2147483647 √ null

the primary email address for your library or branch
virtualshelfshares Table shelfnumber INT 10 null
aqbudgets Table budget_expend DECIMAL 28 √ 0.000000

budget warning at amount
accountlines Table debit_type_code VARCHAR 80 √ null
borrowers Table country MEDIUMTEXT 16777215 √ null

the country for your patron/borrower's primary address
biblio_metadata Table id INT 10 √ null
club_template_enrollment_fields Table authorised_value_category VARCHAR 16 √ null
clubs Table date_end DATE 10 √ null
deletedborrowers Table smsalertnumber VARCHAR 50 √ null

the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
borrowers Table sort2 VARCHAR 80 √ null

a field that can be used for any information unique to the library
pending_offline_operations Table userid VARCHAR 30 null
borrower_relationships Table guarantee_id INT 10 null
statistics Table borrowernumber INT 10 √ null

foreign key from the borrowers table, links transaction to a specific borrower
aqcontacts Table acqprimary BIT 0 0

is this the primary contact for acquisitions messages
borrower_message_preferences Table days_in_advance INT 10 √ 0
borrower_attribute_types Table category_code VARCHAR 10 √ null
article_requests Table updated_on TIMESTAMP 19 current_timestamp()
vendor_edi_accounts Table transport VARCHAR 6 √ FTP
class_sources Table used TINYINT 3 0
marc_modification_template_actions Table to_field VARCHAR 3 √ null
edifact_messages Table edi_acct INT 10 √ null
aqbasketgroups Table closed BIT 0 √ null
article_requests Table author MEDIUMTEXT 16777215 √ null
borrowers Table streetnumber VARCHAR 10 √ null

the house number for your patron/borrower's primary address
aqorders_items Table ordernumber INT 10 null

the order this item is attached to (aqorders.ordernumber)
cash_register_actions Table register_id INT 10 null

id of cash_register this action belongs to,
account_debit_types Table archived BIT 0 0

boolean flag to denote if this till is archived or not
club_fields Table club_id INT 10 null
reports_dictionary Table date_modified DATETIME 19 √ null

date and time this definition was last modified
old_reserves Table suspend_until DATETIME 19 √ null

the date this hold is suspended until (NULL for infinitely)
marc_modification_templates Table template_id INT 10 √ null
cash_register_actions Table code VARCHAR 24 null

action code denoting the type of action recorded (enum),
borrower_modifications Table altcontactaddress1 VARCHAR 255 √ null
subscription_numberpatterns Table label1 VARCHAR 255 √ null
marc_subfield_structure Table kohafield VARCHAR 40 √ null
aqinvoices Table closedate DATE 10 √ null
creator_images Table image_id INT 10 √ null
deletedbiblioitems Table ean LONGTEXT 2147483647 √ null
borrowers Table B_streetnumber VARCHAR 10 √ null

the house number for your patron/borrower's alternate address
branches Table branchaddress1 LONGTEXT 2147483647 √ null

the first address line of for your library or branch
tmp_holdsqueue Table item_level_request TINYINT 3 0
deletedbiblio Table copyrightdate SMALLINT 5 √ null

publication or copyright date from the MARC record
vendor_edi_accounts Table responses_enabled BIT 0 0
z3950servers Table timeout INT 10 0

number of seconds before Koha stops trying to access this server
aqbasketgroups Table id INT 10 √ null
suggestions Table note LONGTEXT 2147483647 √ null

note entered on the suggestion
advanced_editor_macros Table id INT 10 √ null
borrower_modifications Table contacttitle MEDIUMTEXT 16777215 √ null
statistics Table location VARCHAR 80 √ null

authorized value for the shelving location for this item (MARC21 952$c)
creator_templates Table template_desc CHAR 100 Default description
deletedbiblio_metadata Table metadata LONGTEXT 2147483647 null
auth_tag_structure Table libopac VARCHAR 255
hold_fill_targets Table source_branchcode VARCHAR 10 √ null
subscriptionhistory Table subscriptionid INT 10 null
aqbasket Table branch VARCHAR 10 √ null

basket branch
social_data Table num_quotations INT 10 √ null
saved_sql Table mana_id INT 10 √ null
categories Table 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'.
aqbasket Table create_items enum('ordering', 'receiving', 'cataloguing') 11 √ null

when items should be created for orders in this basket
items Table issues SMALLINT 5 √ 0

number of times this item has been checked out/issued
creator_batches Table label_id INT 10 √ null
edifact_messages Table message_type VARCHAR 10 null
itemtypes_branches Table branchcode VARCHAR 10 null
search_field Table label VARCHAR 255 null

the human readable name of the field, for display
tags_approval Table approved_by INT 10 √ null

the librarian who approved the tag (borrowers.borrowernumber)
branch_transfer_limits Table limitId INT 10 √ null
marc_tag_structure Table authorised_value VARCHAR 10 √ null
import_records Table record_type enum('biblio', 'auth', 'holdings') 8 biblio
ratings Table borrowernumber INT 10 null

the borrowernumber of the patron who left this rating (borrowers.borrowernumber)
systempreferences Table explanation MEDIUMTEXT 16777215 √ null

descriptive text for the system preference
action_logs Table interface VARCHAR 30 √ null

the context this action was taken in
tags_approval Table term VARCHAR 191 null

the tag
saved_sql Table type VARCHAR 255 √ null

always 1 for tabular
biblioimages Table thumbnail MEDIUMBLOB 16777215 null

thumbnail file contents
marc_subfield_structure Table frameworkcode VARCHAR 4
account_offsets Table type VARCHAR 16 null

The type of offset this is
aqinvoices Table shipmentdate DATE 10 √ null
suggestions Table itemtype VARCHAR 30 √ null

suggested item type
subscription_numberpatterns Table add3 INT 10 √ null
export_format Table export_format_id INT 10 √ null
language_descriptions Table type VARCHAR 25 √ null
deleteditems Table price DECIMAL 8 √ null

purchase price (MARC21 952$g)
borrower_attribute_types Table 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)
message_queue Table time_queued TIMESTAMP 19 √ null
biblio Table part_number LONGTEXT 2147483647 √ null

part number from the MARC record (245$n in MARC21)
old_issues Table issue_id INT 10 null

primary key for issues table
deletedbiblioitems Table itemtype VARCHAR 10 √ null

biblio level item type (MARC21 942$c)
subscriptionhistory Table histstartdate DATE 10 √ null
suggestions Table manageddate DATE 10 √ null

date the suggestion was updated
import_batches Table comments LONGTEXT 2147483647 √ null

any comments added when the file was uploaded
marc_subfield_structure Table mandatory TINYINT 3 0
browser Table classification VARCHAR 20 null
reserves Table timestamp TIMESTAMP 19 current_timestamp()

the date and time this hold was last updated
reserves Table borrowernumber INT 10 0

foreign key from the borrowers table defining which patron this hold is for
import_records Table import_record_id INT 10 √ null
import_records Table upload_timestamp TIMESTAMP 19 current_timestamp()
deleteditems Table stack BIT 0 √ null
borrower_modifications Table debarred DATE 10 √ null
marc_modification_template_actions Table mmta_id INT 10 √ null
class_sources Table class_sort_rule VARCHAR 10
transport_cost Table cost DECIMAL 6 null
saved_sql Table report_subgroup VARCHAR 80 √ null
old_reserves Table reservedate DATE 10 √ null

the date the hold was places
illrequests Table status_alias VARCHAR 80 √ null
auth_header Table marcxml LONGTEXT 2147483647 null
aqorders Table invoiceid INT 10 √ null

id of invoice
overduerules Table categorycode VARCHAR 10

foreign key from the categories table to define which patron category this rule is for
borrower_modifications Table lost BIT 0 √ null
linktracker Table id INT 10 √ null

primary key identifier
auth_subfield_structure Table authtypecode VARCHAR 10
return_claims Table created_by INT 10 √ null
biblioimages Table biblionumber INT 10 null

foreign key from biblio table to link to biblionumber
items Table more_subfields_xml LONGTEXT 2147483647 √ null

additional 952 subfields in XML format
creator_layouts Table units CHAR 20 POINT
borrower_modifications Table address LONGTEXT 2147483647 √ null
housebound_visit Table day_segment VARCHAR 10 √ null
subscription_numberpatterns Table whenmorethan2 INT 10 √ null
aqbasketgroups Table deliveryplace VARCHAR 10 √ null
course_reserves Table ci_id INT 10 null

foreign key to link to courses_items.ci_id
auth_tag_structure Table authtypecode VARCHAR 10
auth_header Table authtypecode VARCHAR 10
tags_all Table date_created DATETIME 19 null

the date the tag was added
aqbudgets Table budget_branchcode VARCHAR 10 √ null

branch that this fund belongs to (branches.branchcode)
aqcontacts Table phone VARCHAR 100 √ null

contact's phone number
borrower_modifications Table sex VARCHAR 1 √ null
borrower_modifications Table country MEDIUMTEXT 16777215 √ null
course_items Table holdingbranch_enabled BIT 0 0

indicates if itype should be changed while on course reserve
subscription Table status VARCHAR 100
branchtransfers Table frombranch VARCHAR 10

the branch the transfer is coming from
deletedborrowers Table autorenew_checkouts BIT 0 1

flag for allowing auto-renewal
biblio Table author LONGTEXT 2147483647 √ null

statement of responsibility from MARC record (100$a in MARC21)
localization Table lang VARCHAR 25 null

could be a foreign key
pending_offline_operations Table action VARCHAR 10 null
clubs Table date_updated TIMESTAMP 19 √ null
marc_matchers Table threshold INT 10 0
vendor_edi_accounts Table san VARCHAR 20 √ null
biblioitems Table url MEDIUMTEXT 16777215 √ null

url (MARC21 856$u)
stockrotationitems Table fresh BIT 0 0
need_merge_authorities Table authid BIGINT 19 null

reference to original authority record
account_credit_types Table description VARCHAR 200 √ null
suggestions Table rejectedby INT 10 √ null

borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table
borrower_attribute_types Table code VARCHAR 10 null

unique key used to identify each custom field
hold_fill_targets Table borrowernumber INT 10 null
tmp_holdsqueue Table reservedate DATE 10 √ null
borrower_relationships Table guarantor_id INT 10 √ null
reviews Table biblionumber INT 10 √ null

foreign key from the biblio table defining which bibliographic record this comment is for
borrowers Table dateexpiry DATE 10 √ null

date the patron/borrower's card is set to expire (YYYY-MM-DD)
borrower_modifications Table emailpro MEDIUMTEXT 16777215 √ null
serial Table subscriptionid INT 10 null

foreign key to the subscription.subscriptionid that this issue is part of
aqbasket Table creationdate DATE 10 √ null

the date the basket was created
borrower_password_recovery Table borrowernumber INT 10 null

the user asking a password recovery
borrower_modifications Table city LONGTEXT 2147483647 √ null
subscription Table skip_serialseq BIT 0 0
biblio Table unititle LONGTEXT 2147483647 √ null

uniform title (without the subtitle) from the MARC record (240$a in MARC21)
auth_subfield_structure Table liblibrarian VARCHAR 255
subscription Table opacdisplaycount VARCHAR 10 √ null

how many issues to show to the public
borrower_modifications Table altcontactstate MEDIUMTEXT 16777215 √ null
search_history Table total INT 10 null

the total of results found
quotes Table timestamp DATETIME 19 √ null

date and time that the quote last appeared in the opac
aqorders Table ordernumber INT 10 √ null

primary key and unique identifier assigned by Koha to each line
patronimage Table mimetype VARCHAR 15 null

the format of the image (png, jpg, etc)
issues Table date_due DATETIME 19 √ null

datetime the item is due (yyyy-mm-dd hh:mm::ss)
aqbudgets_planning Table plan_id INT 10 √ null
reviews Table approved TINYINT 3 √ 0

whether this comment has been approved by a librarian (1 for yes, 0 for no)
language_subtag_registry Table subtag VARCHAR 25 √ null
reserves Table reservedate DATE 10 √ null

the date the hold was placed
circulation_rules Table id INT 10 √ null
deletedbiblio Table title LONGTEXT 2147483647 √ null

title (without the subtitle) from the MARC record (245$a in MARC21)
items Table price DECIMAL 8 √ null

purchase price (MARC21 952$g)
items Table timestamp TIMESTAMP 19 current_timestamp()

date and time this item was last altered
problem_reports Table branchcode VARCHAR 10

borrower's branch
saved_sql Table report_name VARCHAR 255

the name of this report
oauth_access_tokens Table expires INT 10 null
borrower_modifications Table state MEDIUMTEXT 16777215 √ null
items Table materials MEDIUMTEXT 16777215 √ null

materials specified (MARC21 952$3)
marc_modification_template_actions Table to_regex_search MEDIUMTEXT 16777215 √ null
aqorders Table sort2_authcat VARCHAR 10 √ null
language_subtag_registry Table description VARCHAR 25 √ null

only one of the possible descriptions for ease of reference, see language_descriptions for the complete list
alert Table alertid INT 10 √ null
aqorders Table datereceived DATE 10 √ null

the date this order was received
items Table onloan DATE 10 √ null

defines if item is checked out (NULL for not checked out, and due date for checked out)
advanced_editor_macros Table borrowernumber INT 10 √ null
language_rfc4646_to_iso639 Table rfc4646_subtag VARCHAR 25 √ null
overduerules_transport_types Table id INT 10 √ null
creator_batches Table branch_code VARCHAR 10 NB
aqbudgets Table sort2_authcat VARCHAR 80 √ null

second statistical category for this fund
language_script_mapping Table language_subtag VARCHAR 25 √ null
club_holds_to_patron_holds Table error_code enum('damaged', 'ageRestricted', 'itemAlreadyOnHold', 'tooManyHoldsForThisRecord', 'tooManyReservesToday', 'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches', 'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred') 30 √ null
borrowers Table title LONGTEXT 2147483647 √ null

patron/borrower's title, for example: Mr. or Mrs.
serial Table publisheddatetext VARCHAR 100 √ null

date published (descriptive)
social_data Table score_avg DECIMAL 5 √ null
deleteditems Table itemnotes LONGTEXT 2147483647 √ null

public notes on this item (MARC21 952$z)
accountlines Table date TIMESTAMP 19 √ null
aqbasketgroups Table freedeliveryplace MEDIUMTEXT 16777215 √ null
oauth_access_tokens Table access_token VARCHAR 191 null

generarated access token
oai_sets_descriptions Table description VARCHAR 255 null
matchpoint_components Table matchpoint_id INT 10 null
branches Table branchfax LONGTEXT 2147483647 √ null

the fax number for your library or branch
deletedborrowers Table debarredcomment VARCHAR 255 √ null

comment on the stop of patron
subscription Table reneweddate DATE 10 √ null

date of last renewal for the subscription
auth_subfield_structure Table tagsubfield VARCHAR 1
subscription Table letter VARCHAR 20 √ null
deleteditems Table 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.
aqbasket Table basketno INT 10 √ null

primary key, Koha defined number
illrequests Table notesopac MEDIUMTEXT 16777215 √ null
borrowers Table B_address2 MEDIUMTEXT 16777215 √ null

the second address line for your patron/borrower's alternate address
linktracker Table url MEDIUMTEXT 16777215 √ null

the link itself
import_batches Table matcher_id INT 10 √ null

the id of the match rule used (matchpoints.matcher_id)
course_items Table homebranch_storage VARCHAR 10 √ null

a place to store the homebranch when item is on course reserve
deleteditems Table itemlost_on DATETIME 19 √ null

the date and time an item was last marked as lost, NULL if not lost
userflags Table bit INT 10 0
browser Table description VARCHAR 255 null
branchtransfers Table datearrived DATETIME 19 √ null

the date the transfer arrived at its destination
aqbasket Table booksellernote LONGTEXT 2147483647 √ null

the vendor note added at basket creation
items Table itemnotes LONGTEXT 2147483647 √ null

public notes on this item (MARC21 952$z)
subscription_numberpatterns Table label2 VARCHAR 255 √ null
vendor_edi_accounts Table plugin VARCHAR 256
sms_providers Table name VARCHAR 255 null
aqbasket Table contractnumber INT 10 √ null

links this basket to the aqcontract table (aqcontract.contractnumber)
stockrotationrotas Table active BIT 0 0
borrowers Table categorycode VARCHAR 10

foreign key from the categories table, includes the code of the patron category
marc_subfield_structure Table authtypecode VARCHAR 20 √ null
aqcontacts Table altphone VARCHAR 100 √ null

contact's alternate phone number
z3950servers Table encoding MEDIUMTEXT 16777215 √ null

characters encoding provided by this target
userflags Table defaulton INT 10 √ null
marc_subfield_structure Table hidden BIT 0 8
aqbudgets Table budget_permission INT 10 √ 0

level of permission for this fund (used only by the owner, only by the library, or anyone)
deletedbiblio Table biblionumber INT 10 √ null

unique identifier assigned to each bibliographic record
aqinvoices Table invoiceid INT 10 √ null
subscription Table numberlength INT 10 √ 0

subscription length in weeks (will not be filled in if monthlength or weeklength is set)
browser Table endnode TINYINT 3 null
cash_registers Table branch_default BIT 0 0

boolean flag to denote that this till is the branch default
saved_sql Table borrowernumber INT 10 √ null

the staff member who created this report (borrowers.borrowernumber)
problem_reports Table status VARCHAR 6 New

status of the report. New, Viewed, Closed
special_holidays Table year SMALLINT 5 0

year this closing is in
columns_settings Table tablename VARCHAR 255 null
branches Table branchip VARCHAR 15 √ null

the IP address for your library or branch
saved_sql Table id INT 10 √ null

unique id and primary key assigned by Koha
item_circulation_alert_preferences Table notification VARCHAR 16 null
creator_layouts Table callnum_split INT 10 √ 0
deletedborrowers Table zipcode VARCHAR 25 √ null

the zip or postal code for your patron/borrower's primary address
deleteditems Table damaged BIT 0 0

authorized value defining this item as damaged (MARC21 952$4)
tmp_holdsqueue Table title LONGTEXT 2147483647 √ null
class_split_rules Table split_routine VARCHAR 30
serial Table notes MEDIUMTEXT 16777215 √ null

notes
message_queue Table subject MEDIUMTEXT 16777215 √ null
creator_templates Table col_gap FLOAT 12 0
branches Table branchstate LONGTEXT 2147483647 √ null

the state for your library or branch
tags Table entry VARCHAR 255
collections Table colDesc MEDIUMTEXT 16777215 null
localization Table code VARCHAR 64 null
z3950servers Table servername LONGTEXT 2147483647 null

name given to the target by the library
account_debit_types Table description VARCHAR 200 √ null
search_history Table query_cgi MEDIUMTEXT 16777215 null

the string to append to the search url to rerun the search
cities Table cityid INT 10 √ null

unique identifier added by Koha
deletedborrowers Table altcontactaddress3 VARCHAR 255 √ null

the city for the alternate contact for the patron/borrower
items Table homebranch VARCHAR 10 √ null

foreign key from the branches table for the library that owns this item (MARC21 952$a)
aqbudgets Table timestamp TIMESTAMP 19 current_timestamp()

date and time this fund was last touched (created or modified)
vendor_edi_accounts Table orders_enabled BIT 0 0
advanced_editor_macros Table name VARCHAR 80 null
items Table withdrawn_on DATETIME 19 √ null

the date and time an item was last marked as withdrawn, NULL if not withdrawn
article_requests Table title MEDIUMTEXT 16777215 √ null
tags_approval Table date_approved DATETIME 19 √ null

the date this tag was approved
patronimage Table imagefile MEDIUMBLOB 16777215 null

the image
aqinvoice_adjustments Table budget_id INT 10 √ null

optional link to budget to apply adjustment to
currency Table isocode VARCHAR 5 √ null
library_groups Table parent_id INT 10 √ null
matchchecks Table matchcheck_id INT 10 √ null
tmp_holdsqueue Table itemcallnumber VARCHAR 255 √ null
repeatable_holidays Table weekday SMALLINT 5 √ null

day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on
housebound_visit Table chooser_brwnumber INT 10 √ null

Number of the borrower to choose items for delivery.
accountlines Table status VARCHAR 16 √ null
accountlines Table payment_type VARCHAR 80 √ null

optional authorised value PAYMENT_TYPE
marc_modification_template_actions Table conditional_field VARCHAR 3 √ null
additional_field_values Table value VARCHAR 255

value for this field
creator_layouts Table start_label INT 10 1
borrower_modifications Table debarredcomment VARCHAR 255 √ null
borrowers Table borrowernotes LONGTEXT 2147483647 √ null

a note on the patron/borrower's account that is only visible in the staff client
borrowers Table privacy_guarantor_fines BIT 0 0

controls if relatives can see this patron's fines
aqorders Table sort1_authcat VARCHAR 10 √ null
alert Table borrowernumber INT 10 0
aqorders Table budget_id INT 10 null

the fund this order goes against (aqbudgets.budget_id)
overduerules Table debarred1 VARCHAR 1 √ 0

is the patron restricted when the first notice is sent (1 for yes, 0 for no)
branches Table branchcountry MEDIUMTEXT 16777215 √ null

the county for your library or branch
clubs Table date_created TIMESTAMP 19 current_timestamp()
items_last_borrower Table borrowernumber INT 10 null
deletedbiblioitems Table volume LONGTEXT 2147483647 √ null
desks Table desk_id INT 10 √ null

unique identifier
borrowers Table B_state MEDIUMTEXT 16777215 √ null

the state for your patron/borrower's alternate address
branchtransfers Table reason enum('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve') 25 √ null

what triggered the transfer
aqorders_items Table itemnumber INT 10 null

the item number for this item (items.itemnumber)
export_format Table profile VARCHAR 255 null
housebound_visit Table deliverer_brwnumber INT 10 √ null

Number of the borrower to deliver items.
account_debit_types Table code VARCHAR 80 null
problem_reports Table title VARCHAR 40

report subject line
letter Table message_transport_type VARCHAR 20 email

transport type for this notice
illrequests Table replied DATE 10 √ null
subscription Table numberpattern INT 10 √ null

the numbering pattern used links to subscription_numberpatterns.id
article_requests Table itemnumber INT 10 √ null
suggestions Table publishercode VARCHAR 255 √ null

publisher of the suggested item
borrower_modifications Table address2 MEDIUMTEXT 16777215 √ null
import_biblios Table author VARCHAR 80 √ null
aqbudgets Table sort1_authcat VARCHAR 80 √ null

statistical category for this fund
illrequests Table completed DATE 10 √ null
subscription_numberpatterns Table description MEDIUMTEXT 16777215 null
subscription_numberpatterns Table setto3 INT 10 √ null
article_requests Table date MEDIUMTEXT 16777215 √ null
problem_reports Table username VARCHAR 75 √ null

OPAC username
aqbasket Table authorisedby VARCHAR 10 √ null

the borrowernumber of the person who created the basket
borrowers Table initials MEDIUMTEXT 16777215 √ null

initials for your patron/borrower
illcomments Table illcomment_id INT 10 √ null

Unique ID of the comment
illrequests Table cost VARCHAR 20 √ null
aqbasket Table deliveryplace VARCHAR 10 √ null

basket delivery place
branches Table opac_info MEDIUMTEXT 16777215 √ null

HTML that displays in OPAC
deleteditems Table cn_sort VARCHAR 255 √ null

normalized form of the call number (MARC21 952$o) used for sorting
aqorders_transfers Table ordernumber_to INT 10 √ null
borrowers Table anonymized BIT 0 0

flag for data anonymization
hold_fill_targets Table biblionumber INT 10 null
housebound_profile Table notes MEDIUMTEXT 16777215 √ null

Free text for additional notes.
subscription_numberpatterns Table whenmorethan1 INT 10 √ null
edifact_ean Table ean VARCHAR 15 null
course_items Table itype_enabled BIT 0 0

indicates if itype should be changed while on course reserve
matchpoints Table matchpoint_id INT 10 √ null
export_format Table encoding VARCHAR 255 utf8
old_reserves Table cancellationdate DATE 10 √ null

the date this hold was cancelled
borrower_modifications Table contactnote VARCHAR 255 √ null
aqbudgets Table budget_id INT 10 √ null

primary key and unique number assigned to each fund by Koha
itemtypes_branches Table itemtype VARCHAR 10 null
vendor_edi_accounts Table id_code_qualifier VARCHAR 3 √ 14
account_debit_types Table default_amount DECIMAL 28 √ null
creator_layouts Table text_justify CHAR 1 L
tmp_holdsqueue Table itemnumber INT 10 √ null
marc_subfield_structure Table tagsubfield VARCHAR 1
messages Table message MEDIUMTEXT 16777215 null

the text of the message
biblioitems Table biblionumber INT 10 0

foreign key linking this table to the biblio table
deletedborrowers Table updated_on TIMESTAMP 19 current_timestamp()

time of last change could be useful for synchronization with external systems (among others)
language_script_mapping Table script_subtag VARCHAR 25 √ null
biblioitems Table cn_suffix VARCHAR 10 √ null
statistics Table itemnumber INT 10 √ null

foreign key from the items table, links transaction to a specific item
illrequests Table borrowernumber INT 10 √ null
need_merge_authorities Table done TINYINT 3 √ 0
discharges Table needed TIMESTAMP 19 √ null
borrower_files Table file_type VARCHAR 255 null

type of file
export_format Table subfield_separator VARCHAR 2 √ null
subscription Table weeklength INT 10 √ 0

subscription length in weeks (will not be filled in if monthlength or numberlength is set)
itemtypes Table hideinopac BIT 0 0

Hide the item type from the search options in OPAC
borrowers Table opacnote LONGTEXT 2147483647 √ null

a note on the patron/borrower's account that is visible in the OPAC and staff client
aqinvoices Table billingdate DATE 10 √ null
saved_sql Table report_group VARCHAR 80 √ null
suggestions Table date TIMESTAMP 19 current_timestamp()
course_items Table ccode_storage VARCHAR 80 √ null

a place to store the ccode when item is on course reserve
return_claims Table notes MEDIUMTEXT 16777215 √ null
branch_transfer_limits Table fromBranch VARCHAR 10 null
club_holds_to_patron_holds Table error_message VARCHAR 100 √ null
stockrotationstages Table rota_id INT 10 null
printers_profile Table creep_vert FLOAT 12 0
biblioitems Table collectionvolume LONGTEXT 2147483647 √ null
vendor_edi_accounts Table quotes_enabled BIT 0 0
biblio_framework Table frameworkcode VARCHAR 4

the unique code assigned to the framework
aqorders_claims Table ordernumber INT 10 null

order linked to this claim
messages Table branchcode VARCHAR 10 √ null

foreign key linking the message to the branches table
deletedborrowers Table B_address2 MEDIUMTEXT 16777215 √ null

the second address line for your patron/borrower's alternate address
borrowers Table B_streettype VARCHAR 50 √ null

the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
borrower_relationships Table relationship VARCHAR 100 null
vendor_edi_accounts Table username VARCHAR 40 √ null
cash_registers Table id INT 10 √ null

unique identifier for each account register
action_logs Table action MEDIUMTEXT 16777215 √ null

the action (includes things like DELETED, ADDED, MODIFY, etc)
uploaded_files Table id INT 10 √ null
borrowers Table email LONGTEXT 2147483647 √ null

the primary email address for your patron/borrower's primary address
deleteditems Table holdingbranch VARCHAR 10 √ null

foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
special_holidays Table isexception SMALLINT 5 1

is this a holiday exception to a repeatable holiday (1 for yes, 0 for no)
import_biblios Table import_record_id INT 10 null
housebound_profile Table fav_subjects MEDIUMTEXT 16777215 √ null

Free text describing preferred subjects.
tags_approval Table approved INT 10 0

whether the tag is approved or not (1=yes, 0=pending, -1=rejected)
message_transports Table message_attribute_id INT 10 null
creator_layouts Table guidebox INT 10 √ 0
overduerules_transport_types Table letternumber INT 10 1
printers_profile Table offset_horz FLOAT 12 0
deletedbiblioitems Table agerestriction VARCHAR 255 √ null

target audience/age restriction from the bib record (MARC21 521$a)
aqorders Table suppliers_reference_number VARCHAR 35 √ null

Suppliers unique edifact quote ref
stockrotationitems Table stage_id INT 10 null
message_queue Table message_id INT 10 √ null
import_batches Table overlay_action enum('replace', 'create_new', 'use_template', 'ignore') 12 create_new

how to handle duplicate records
deletedbiblioitems Table biblionumber INT 10 0

foreign key linking this table to the biblio table
aqbudgets Table budget_notes LONGTEXT 2147483647 √ null

notes related to this fund
virtualshelves Table allow_change_from_others BIT 0 √ 0

can others change contents?
auth_subfield_structure Table defaultvalue MEDIUMTEXT 16777215 √ null
biblioitems Table itemtype VARCHAR 10 √ null

biblio level item type (MARC21 942$c)
printers_profile Table printer_name VARCHAR 40 Default Printer
aqorders Table tax_rate_bak DECIMAL 6 √ null

the tax rate for this line item (%)
items Table itemnotes_nonpublic LONGTEXT 2147483647 √ null

non-public notes on this item (MARC21 952$x)
deletedborrowers Table dateenrolled DATE 10 √ null

date the patron was added to Koha (YYYY-MM-DD)
club_templates Table id INT 10 √ null
borrowers Table 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'.
virtualshelfshares Table id INT 10 √ null
accountlines Table interface VARCHAR 16 null
linktracker Table biblionumber INT 10 √ null

biblionumber of the record the link is from
oai_sets_mappings Table marcfield CHAR 3 null
reviews Table review MEDIUMTEXT 16777215 √ null

the body of the comment
categories Table default_privacy enum('default', 'never', 'forever') 8 default

Default privacy setting for this patron category
issues Table note LONGTEXT 2147483647 √ null

issue note text
aqcontacts Table notes LONGTEXT 2147483647 √ null

notes related to the contact
cash_registers Table name VARCHAR 24 null

the user friendly identifier for each account register
old_issues Table note LONGTEXT 2147483647 √ null

issue note text
borrowers Table altcontactstate MEDIUMTEXT 16777215 √ null

the state for the alternate contact for the patron/borrower
creator_batches Table description MEDIUMTEXT 16777215 √ null
uploaded_files Table owner INT 10 √ null
article_requests Table branchcode VARCHAR 10 √ null
return_claims Table resolved_by INT 10 √ null
plugin_data Table plugin_class VARCHAR 255 null
import_records Table import_date DATE 10 √ null
club_template_enrollment_fields Table id INT 10 √ null
auth_subfield_structure Table repeatable TINYINT 3 0
marc_subfield_structure Table value_builder VARCHAR 80 √ null
special_holidays Table month SMALLINT 5 0

month this closing is in
action_logs Table module MEDIUMTEXT 16777215 √ null

the module this action was taken against
borrowers Table state MEDIUMTEXT 16777215 √ null

the state or province for your patron/borrower's primary address
circulation_rules Table itemtype VARCHAR 10 √ null
saved_sql Table cache_expiry INT 10 300
marc_tag_structure Table repeatable TINYINT 3 0
class_sort_rules Table class_sort_rule VARCHAR 10
vendor_edi_accounts Table shipment_budget INT 10 √ null
items Table withdrawn BIT 0 0

authorized value defining this item as withdrawn (MARC21 952$0)
marc_tag_structure Table ind1_defaultvalue VARCHAR 1
borrowers Table firstname MEDIUMTEXT 16777215 √ null

patron/borrower's first name
deleteditems Table materials MEDIUMTEXT 16777215 √ null

materials specified (MARC21 952$3)
borrower_debarments Table borrower_debarment_id INT 10 √ null

unique key for the restriction
repeatable_holidays Table description MEDIUMTEXT 16777215 null

description for this closing
aqbasketgroups Table billingplace VARCHAR 10 √ null
keyboard_shortcuts Table shortcut_keys VARCHAR 80 null
deleteditems Table notforloan BIT 0 0

authorized value defining why this item is not for loan (MARC21 952$7)
marc_modification_template_actions Table to_subfield VARCHAR 1 √ null
categories Table enrolmentperiod SMALLINT 5 √ null

number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)
categories Table overduenoticerequired BIT 0 √ null

are overdue notices sent to this patron category (1 for yes, 0 for no)
need_merge_authorities Table authid_new BIGINT 19 √ null

reference to optional new authority record
creator_images Table imagefile MEDIUMBLOB 16777215 √ null
search_marc_map Table marc_field VARCHAR 255 null

the MARC specifier for this field
borrower_attribute_types Table repeatable BIT 0 0

defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no)
categories Table enrolmentperioddate DATE 10 √ null

date the patron is enrolled until (will be NULL if enrolmentperiod is set)
aqorders Table listprice DECIMAL 28 √ null

the vendor price for this line item
club_enrollments Table date_canceled TIMESTAMP 19 √ null
import_batches Table num_items INT 10 0

number of items in the file
saved_sql Table last_modified DATETIME 19 √ null

the date this report was last edited
creator_templates Table rows INT 10 0
deletedborrowers Table altcontactcountry MEDIUMTEXT 16777215 √ null

the country for the alternate contact for the patron/borrower
library_groups Table description MEDIUMTEXT 16777215 √ null
issues Table issuedate DATETIME 19 √ null

date the item was checked out or issued
borrower_attributes Table code VARCHAR 10 null

foreign key from the borrower_attribute_types table, defines which custom field this value was entered for
old_reserves Table reminderdate DATE 10 √ null

currently unused
columns_settings Table module VARCHAR 255 null
borrower_files Table file_name VARCHAR 255 null

file name
illcomments Table timestamp TIMESTAMP 19 current_timestamp()

Date and time when the comment was made
marc_tag_structure Table libopac VARCHAR 255
suggestions Table patronreason MEDIUMTEXT 16777215 √ null

reason for making the suggestion