SchemaSpy Analysis of testsql_comments - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jul 16 08:37 NZST 2018
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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