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

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