testsql_comments contains 1724 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
branchrelations	branchcode	varchar	10				foreign key from the branches table to identify the 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
branchcategories	categorycode	varchar	10				unique identifier for the library/branch group
branchrelations	categorycode	varchar	10				foreign key from the branchcategories table to identify the group
categories	categorycode	varchar	10				unique primary key used to idenfity the patron category
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
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
notifys	method	varchar	20
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
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
accountoffsets	accountno	smallint	5			0
aqcontacts	acqprimary	bit	0			0	is this the primary contact for acquisitions messages
virtualshelves	allow_add	bit	0	√		0	permission for adding entries to list
virtualshelves	allow_delete_other	bit	0	√		0	permission for deleting entries from list that another person added
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
accountoffsets	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
notifys	borrowernumber	int	10			0
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
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
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
notifys	itemnumber	int	10			0
creator_templates	label_height	float	12			0
creator_templates	label_width	float	12			0
creator_templates	left_margin	float	12			0
creator_templates	left_text_margin	float	12			0
matchpoint_components	length	int	10			0
auth_subfield_structure	linkid	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)
accountlines	notify_id	int	10			0
notifys	notify_id	int	10			0
accountlines	notify_level	int	10			0
notifys	notify_level	int	10			0
import_batches	num_items	int	10			0	number of items in the file
import_batches	num_records	int	10			0	number of records in the file
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
accountoffsets	offsetaccount	smallint	5			0
issuingrules	onshelfholds	bit	0			0	allow holds for items that are on shelf
issues	onsite_checkout	int	10			0	in house use flag
old_issues	onsite_checkout	int	10			0	in house use flag
borrower_attribute_types	opac_display	bit	0			0	defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no)
aqcontacts	orderacquisition	bit	0			0	should this contact receive acquisition orders
vendor_edi_accounts	orders_enabled	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
branchcategories	show_in_pulldown	bit	0			0	says this group should be in the opac libararies pulldown if it is enabled
subscription	skip_serialseq	bit	0			0
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
virtualshelves	allow_delete_own	bit	0	√		1	permission for deleting entries frm list that you added yourself
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
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
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
article_requests	created_on	timestamp	19			CURRENT_TIMESTAMP
items_last_borrower	created_on	timestamp	19			CURRENT_TIMESTAMP
suggestions	date	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
accountoffsets	timestamp	timestamp	19			CURRENT_TIMESTAMP
action_logs	timestamp	timestamp	19			CURRENT_TIMESTAMP	the date and time the action took place
aqbudgets	timestamp	timestamp	19			CURRENT_TIMESTAMP	date and time this fund was last touched (created or modified)
aqorders	timestamp	timestamp	19			CURRENT_TIMESTAMP	the date and time this order line was last modified
aqorders_items	timestamp	timestamp	19			CURRENT_TIMESTAMP	the date and time this order item was last touched
aqorders_transfers	timestamp	timestamp	19			CURRENT_TIMESTAMP
biblio	timestamp	timestamp	19			CURRENT_TIMESTAMP	date and time this record was last touched
biblioitems	timestamp	timestamp	19			CURRENT_TIMESTAMP
borrower_modifications	timestamp	timestamp	19			CURRENT_TIMESTAMP
course_items	timestamp	timestamp	19			CURRENT_TIMESTAMP
course_reserves	timestamp	timestamp	19			CURRENT_TIMESTAMP
courses	timestamp	timestamp	19			CURRENT_TIMESTAMP
creator_batches	timestamp	timestamp	19			CURRENT_TIMESTAMP
currency	timestamp	timestamp	19			CURRENT_TIMESTAMP
deletedbiblio	timestamp	timestamp	19			CURRENT_TIMESTAMP	date and time this record was last touched
deletedbiblioitems	timestamp	timestamp	19			CURRENT_TIMESTAMP
deleteditems	timestamp	timestamp	19			CURRENT_TIMESTAMP	date and time this item was last altered
issues	timestamp	timestamp	19			CURRENT_TIMESTAMP	the date and time this record was last touched
items	timestamp	timestamp	19			CURRENT_TIMESTAMP	date and time this item was last altered
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
borrowers	updated_on	timestamp	19			CURRENT_TIMESTAMP	time of last change could be useful for synchronization with external systems (among others)
deletedborrowers	updated_on	timestamp	19			CURRENT_TIMESTAMP	time of last change could be useful for synchronization with external systems (among others)
import_batches	upload_timestamp	timestamp	19			CURRENT_TIMESTAMP	date and time the file was uploaded
import_records	upload_timestamp	timestamp	19			CURRENT_TIMESTAMP
borrower_password_recovery	valid_until	timestamp	19			CURRENT_TIMESTAMP	a time limit on the password recovery attempt
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
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
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	mediumtext	16777215
biblio	abstract	mediumtext	16777215	√		null	summary from the MARC record (520$a in MARC21)
deletedbiblio	abstract	mediumtext	16777215	√		null	summary from the MARC record (520$a in MARC21)
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
accountlines	accountlines_id	int	10		√
aqbooksellers	accountnumber	mediumtext	16777215	√		null	unused in Koha
issuingrules	accountsent	int	10	√		null	not used? always NULL
accountlines	accounttype	varchar	5	√		null
action_logs	action	text	65535	√		null	the action (includes things like DELETED, ADDED, MODIFY, etc)
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	mediumtext	16777215	√		null	zero or more paths to XSLT files to be processed on the search results
language_subtag_registry	added	date	10	√		null
borrower_modifications	address	mediumtext	16777215	√		null
borrowers	address	mediumtext	16777215				the first address line for your patron/borrower's primary address
deletedborrowers	address	mediumtext	16777215				the first address line for your patron/borrower's primary address
aqbooksellers	address1	mediumtext	16777215	√		null	first line of vendor physical address
aqbooksellers	address2	mediumtext	16777215	√		null	second line of vendor physical address
borrower_modifications	address2	text	65535	√		null
borrowers	address2	text	65535	√		null	the second address line for your patron/borrower's primary address
deletedborrowers	address2	text	65535	√		null	the second address line for your patron/borrower's primary address
aqbooksellers	address3	mediumtext	16777215	√		null	third line of vendor physical address
aqbooksellers	address4	mediumtext	16777215	√		null	fourth line of vendor physical address
biblioitems	agerestriction	varchar	255	√		null	target audience/age restriction from the bib record (MARC21 521$a)
deletedbiblioitems	agerestriction	varchar	255	√		null	target audience/age restriction from the bib record (MARC21 521$a)
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	text	65535	√		null
borrowers	altcontactcountry	text	65535	√		null	the country for the alternate contact for the patron/borrower
deletedborrowers	altcontactcountry	text	65535	√		null	the country for the alternate contact for the patron/borrower
borrower_modifications	altcontactfirstname	varchar	255	√		null
borrowers	altcontactfirstname	varchar	255	√		null	first name of alternate contact for the patron/borrower
deletedborrowers	altcontactfirstname	varchar	255	√		null	first name of alternate contact for the patron/borrower
borrower_modifications	altcontactphone	varchar	50	√		null
borrowers	altcontactphone	varchar	50	√		null	the phone number for the alternate contact for the patron/borrower
deletedborrowers	altcontactphone	varchar	50	√		null	the phone number for the alternate contact for the patron/borrower
borrower_modifications	altcontactstate	text	65535	√		null
borrowers	altcontactstate	text	65535	√		null	the state for the alternate contact for the patron/borrower
deletedborrowers	altcontactstate	text	65535	√		null	the state for the alternate contact for the patron/borrower
borrower_modifications	altcontactsurname	varchar	255	√		null
borrowers	altcontactsurname	varchar	255	√		null	surname or last name of the alternate contact for the patron/borrower
deletedborrowers	altcontactsurname	varchar	255	√		null	surname or last name of the alternate contact for the patron/borrower
borrower_modifications	altcontactzipcode	varchar	50	√		null
borrowers	altcontactzipcode	varchar	50	√		null	the zipcode for the alternate contact for the patron/borrower
deletedborrowers	altcontactzipcode	varchar	50	√		null	the zipcode for the alternate contact for the patron/borrower
aqcontacts	altphone	varchar	100	√		null	contact's alternate phone number
accountlines	amount	decimal	28,6	√		null
pending_offline_operations	amount	decimal	28,6	√		null
accountlines	amountoutstanding	decimal	28,6	√		null
housebound_visit	appointment_date	date	10	√		null	Date of visit.
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 authority record
article_requests	author	text	65535	√		null
biblio	author	mediumtext	16777215	√		null	statement of responsibility from MARC record (100$a in MARC21)
deletedbiblio	author	mediumtext	16777215	√		null	statement of responsibility from MARC record (100$a in MARC21)
import_biblios	author	varchar	80	√		null
suggestions	author	varchar	80	√		null	author of the suggested item
auth_subfield_structure	authorised_value	varchar	10	√		null
auth_tag_structure	authorised_value	varchar	10	√		null
marc_subfield_structure	authorised_value	varchar	32	√		null
marc_tag_structure	authorised_value	varchar	10	√		null
borrower_attribute_types	authorised_value_category	varchar	32	√		null	foreign key from authorised_values that links this custom field to an authorized value category
items_search_fields	authorised_values_category	varchar	32	√		null
aqbasket	authorisedby	varchar	10	√		null	the borrowernumber of the person who created the basket
import_auths	authorized_heading	varchar	128	√		null
auth_header	authtrees	mediumtext	16777215	√		null
marc_subfield_structure	authtypecode	varchar	20	√		null
aqbudgets_planning	authvalue	varchar	30
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	text	65535	√		null
borrowers	B_address2	text	65535	√		null	the second address line for your patron/borrower's alternate address
deletedborrowers	B_address2	text	65535	√		null	the second address line for your patron/borrower's alternate address
borrower_attribute_types_branches	b_branchcode	varchar	10	√		null
borrower_modifications	B_city	mediumtext	16777215	√		null
borrowers	B_city	mediumtext	16777215	√		null	the city or town for your patron/borrower's alternate address
deletedborrowers	B_city	mediumtext	16777215	√		null	the city or town for your patron/borrower's alternate address
borrower_modifications	B_country	text	65535	√		null
borrowers	B_country	text	65535	√		null	the country for your patron/borrower's alternate address
deletedborrowers	B_country	text	65535	√		null	the country for your patron/borrower's alternate address
borrower_modifications	B_email	text	65535	√		null
borrowers	B_email	text	65535	√		null	the patron/borrower's alternate email address
deletedborrowers	B_email	text	65535	√		null	the patron/borrower's alternate email address
borrower_modifications	B_phone	mediumtext	16777215	√		null
borrowers	B_phone	mediumtext	16777215	√		null	the patron/borrower's alternate phone number
deletedborrowers	B_phone	mediumtext	16777215	√		null	the patron/borrower's alternate phone number
borrower_modifications	B_state	text	65535	√		null
borrowers	B_state	text	65535	√		null	the state for your patron/borrower's alternate address
deletedborrowers	B_state	text	65535	√		null	the state for your patron/borrower's alternate address
borrower_modifications	B_streetnumber	varchar	10	√		null
borrowers	B_streetnumber	varchar	10	√		null	the house number for your patron/borrower's alternate address
deletedborrowers	B_streetnumber	varchar	10	√		null	the house number for your patron/borrower's alternate address
borrower_modifications	B_streettype	varchar	50	√		null
borrowers	B_streettype	varchar	50	√		null	the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
deletedborrowers	B_streettype	varchar	50	√		null	the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
borrower_modifications	B_zipcode	varchar	25	√		null
borrowers	B_zipcode	varchar	25	√		null	the zip or postal code for your patron/borrower's alternate address
deletedborrowers	B_zipcode	varchar	25	√		null	the zip or postal code for your patron/borrower's alternate address
deleteditems	barcode	varchar	20	√		null	item barcode (MARC21 952$p)
items	barcode	varchar	20	√		null	item barcode (MARC21 952$p)
pending_offline_operations	barcode	varchar	20	√		null
tmp_holdsqueue	barcode	varchar	20	√		null
aqbasket	basketgroupid	int	10	√		null	links this basket to its group (aqbasketgroups.id)
aqbasket	basketname	varchar	50	√		null	name given to the basket at creation
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
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
biblioimages	biblionumber	int	10				foreign key from biblio table to link to biblionumber
deletedbiblio	biblionumber	int	10		√		unique identifier assigned to each bibliographic record
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	mediumtext	16777215	√		null	vendor email
aqbooksellers	booksellerfax	mediumtext	16777215	√		null	vendor fax number
aqbasketgroups	booksellerid	int	10
aqcontacts	booksellerid	int	10
aqcontract	booksellerid	int	10
aqinvoices	booksellerid	int	10
deleteditems	booksellerid	mediumtext	16777215	√		null	where the item was purchased (MARC21 952$e)
items	booksellerid	mediumtext	16777215	√		null	where the item was purchased (MARC21 952$e)
aqbasket	booksellerinvoicenumber	mediumtext	16777215	√		null	appears to always be NULL
aqbasket	booksellernote	mediumtext	16777215	√		null	the vendor note added at basket creation
aqbooksellers	booksellerurl	mediumtext	16777215	√		null	unused in Koha
discharges	borrower	int	10	√		null
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	mediumtext	16777215	√		null
borrowers	borrowernotes	mediumtext	16777215	√		null	a note on the patron/borrower's account that is only visible in the staff client
deletedborrowers	borrowernotes	mediumtext	16777215	√		null	a note on the patron/borrower's account that is only visible in the staff client
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
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.
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	mediumtext	16777215	√		null	the first address line of for your library or branch
branches	branchaddress2	mediumtext	16777215	√		null	the second address line of for your library or branch
branches	branchaddress3	mediumtext	16777215	√		null	the third address line of for your library or branch
branches	branchcity	mediumtext	16777215	√		null	the city or province for your library or branch
article_requests	branchcode	varchar	10	√		null
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
default_branch_circ_rules	branchcode	varchar	10
edifact_ean	branchcode	varchar	10
import_batches	branchcode	varchar	10	√		null
import_items	branchcode	varchar	10	√		null
import_records	branchcode	varchar	10	√		null
issues	branchcode	varchar	10	√		null	foreign key, linking to the branches table for the location the item was checked out
item_circulation_alert_preferences	branchcode	varchar	10
messages	branchcode	varchar	10	√		null	foreign key linking the message to the branches table
old_issues	branchcode	varchar	10	√		null	foreign key, linking to the branches table for the location the item was checked out
old_reserves	branchcode	varchar	10	√		null	foreign key from the branches table defining which branch the patron wishes to pick this hold up at
opac_news	branchcode	varchar	10	√		null	branch code users to create branch specific news, NULL is every branch.
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	text	65535	√		null	the county for your library or branch
branches	branchemail	mediumtext	16777215	√		null	the primary email address for your library or branch
branches	branchfax	mediumtext	16777215	√		null	the fax number for your library or branch
branches	branchip	varchar	15	√		null	the IP address for your library or branch
branches	branchname	mediumtext	16777215				the name of your library or branch
branches	branchnotes	mediumtext	16777215	√		null	notes related to your library or branch
branches	branchphone	mediumtext	16777215	√		null	the primary phone for your library or branch
branches	branchprinter	varchar	100	√		null	unused in Koha
branches	branchreplyto	mediumtext	16777215	√		null	the email to be used as a Reply-To
branches	branchreturnpath	mediumtext	16777215	√		null	the email to be used as Return-Path
branches	branchstate	mediumtext	16777215	√		null	the state for your library or branch
branches	branchurl	mediumtext	16777215	√		null	the URL for your library or branch's website
branches	branchzip	varchar	25	√		null	the zip or postal code for your library or branch
aqbudgets	budget_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	mediumtext	16777215	√		null	notes related to this fund
aqbudgets	budget_owner_id	int	10	√		null	borrowernumber of the person who owns this fund (borrowers.borrowernumber)
aqbudgets	budget_parent_id	int	10	√		null	if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
aqbudgetperiods	budget_period_description	mediumtext	16777215	√		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	text	65535	√		null	default call number
old_reserves	cancellationdate	date	10	√		null	the date this hold was cancelled
reserves	cancellationdate	date	10	√		null	the date this hold was cancelled
aqorders	cancellationreason	text	65535	√		null	reason of cancellation
import_record_matches	candidate_match_id	int	10				the biblio the imported record matches (biblio.biblionumber)
borrower_modifications	cardnumber	varchar	16	√		null
borrowers	cardnumber	varchar	16	√		null	unique key, library assigned ID number for patrons/borrowers
deletedborrowers	cardnumber	varchar	16	√		null	unique key, library assigned ID number for patrons/borrowers
pending_offline_operations	cardnumber	varchar	16	√		null
tmp_holdsqueue	cardnumber	varchar	16	√		null
virtualshelves	category	varchar	1	√		null	type of list (private [1], public [2])
borrower_attribute_types	category_code	varchar	10	√		null
borrower_message_preferences	categorycode	varchar	10	√		null
borrower_modifications	categorycode	varchar	10	√		null
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
branchcategories	categoryname	varchar	32	√		null	name of the library/branch group
branchcategories	categorytype	varchar	16	√		null	says whether this is a search group or a properties group
branch_transfer_limits	ccode	varchar	10	√		null
course_items	ccode	varchar	10	√		null	new category code for the item to have while on reserve (optional)
deleteditems	ccode	varchar	10	√		null	authorized value for the collection code associated with this item (MARC21 952$8)
items	ccode	varchar	10	√		null	authorized value for the collection code associated with this item (MARC21 952$8)
statistics	ccode	varchar	10	√		null	foreign key from the items table, links transaction to a specific collection code
article_requests	chapters	text	65535	√		null
issuingrules	chargename	varchar	100	√		null	not used? always NULL
issuingrules	chargeperiod	int	10	√		null	how often the fine amount is charged
z3950servers	checked	smallint	5	√		null	whether this target is checked by default (1 for yes, 0 for no)
itemtypes	checkinmsg	varchar	255	√		null	message that is displayed when an item with the given item type is checked in
housebound_visit	chooser_brwnumber	int	10	√		null	Number of the borrower to choose items for delivery.
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	mediumtext	16777215	√		null
borrowers	city	mediumtext	16777215				the city or town for your patron/borrower's primary address
deletedborrowers	city	mediumtext	16777215				the city or town for your patron/borrower's primary address
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
aqbasketgroups	closed	bit	0	√		null
aqbasket	closedate	date	10	√		null	the date the basket was closed
aqinvoices	closedate	date	10	√		null
biblioitems	cn_class	varchar	30	√		null
deletedbiblioitems	cn_class	varchar	30	√		null
biblioitems	cn_item	varchar	10	√		null
deletedbiblioitems	cn_item	varchar	10	√		null
biblioitems	cn_sort	varchar	255	√		null	normalized version of the call number used for sorting
deletedbiblioitems	cn_sort	varchar	255	√		null	normalized version of the call number used for sorting
deleteditems	cn_sort	varchar	255	√		null	normalized form of the call number (MARC21 952$o) used for sorting
items	cn_sort	varchar	255	√		null
biblioitems	cn_source	varchar	10	√		null	classification source (MARC21 942$2)
deletedbiblioitems	cn_source	varchar	10	√		null	classification source (MARC21 942$2)
deleteditems	cn_source	varchar	10	√		null	classification source used on this item (MARC21 952$2)
items	cn_source	varchar	10	√		null	classification source used on this item (MARC21 952$2)
biblioitems	cn_suffix	varchar	10	√		null
deletedbiblioitems	cn_suffix	varchar	10	√		null
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)
branchcategories	codedescription	mediumtext	16777215	√		null	longer description of the library/branch group
collections	colBranchcode	varchar	10	√		null	'branchcode for branch where item should be held.'
collections	colDesc	text	65535
collections	colId	int	10		√
biblioitems	collectionissn	text	65535	√		null
deletedbiblioitems	collectionissn	text	65535	√		null
collections_tracking	collections_tracking_id	int	10		√
biblioitems	collectiontitle	mediumtext	16777215	√		null
deletedbiblioitems	collectiontitle	mediumtext	16777215	√		null
suggestions	collectiontitle	text	65535	√		null	collection name for the suggested item
biblioitems	collectionvolume	mediumtext	16777215	√		null
deletedbiblioitems	collectionvolume	mediumtext	16777215	√		null
columns_settings	columnname	varchar	255
borrower_debarments	comment	text	65535	√		null	comments about the restriction
branchtransfers	comments	mediumtext	16777215	√		null	any comments related to the transfer
import_batches	comments	mediumtext	16777215	√		null	any comments added when the file was uploaded
marc_modification_template_actions	conditional	enum	6	√		null
marc_modification_template_actions	conditional_comparison	enum	10	√		null
marc_modification_template_actions	conditional_field	varchar	3	√		null
marc_modification_template_actions	conditional_subfield	varchar	1	√		null
marc_modification_template_actions	conditional_value	text	65535	√		null
borrower_modifications	contactfirstname	text	65535	√		null
borrowers	contactfirstname	text	65535	√		null	used for children to include first name of guarentor
deletedborrowers	contactfirstname	text	65535	√		null	used for children to include first name of guarentor
borrower_modifications	contactname	mediumtext	16777215	√		null
borrowers	contactname	mediumtext	16777215	√		null	used for children and profesionals to include surname or last name of guarentor or organization name
deletedborrowers	contactname	mediumtext	16777215	√		null	used for children and profesionals to include surname or last name of guarentor or organization name
borrower_modifications	contactnote	varchar	255	√		null
borrowers	contactnote	varchar	255	√		null	a note related to the patron/borrower's alternate address
deletedborrowers	contactnote	varchar	255	√		null	a note related to the patron/borrower's alternate address
borrower_modifications	contacttitle	text	65535	√		null
borrowers	contacttitle	text	65535	√		null	used for children to include title (Mr., Mrs., etc) of guarentor
deletedborrowers	contacttitle	text	65535	√		null	used for children to include title (Mr., Mrs., etc) of guarentor
export_format	content	mediumtext	16777215
letter	content	text	65535	√		null	body text for the notice or slip
message_queue	content	text	65535	√		null
message_queue	content_type	text	65535	√		null
aqcontract	contractdescription	mediumtext	16777215	√		null
aqcontract	contractenddate	date	10	√		null
aqcontract	contractname	varchar	50	√		null
aqbasket	contractnumber	int	10	√		null	links this basket to the aqcontract table (aqcontract.contractnumber)
aqcontract	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
transport_cost	cost	decimal	6,2
borrower_modifications	country	text	65535	√		null
borrowers	country	text	65535	√		null	the country for your patron/borrower's primary address
deletedborrowers	country	text	65535	√		null	the country for your patron/borrower's primary address
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		√
virtualshelves	created_on	datetime	19				creation time
aqbasket	creationdate	date	10	√		null	the date the basket was created
export_format	csv_separator	varchar	2
aqorders	currency	varchar	10	√		null	the currency used for the purchase
suggestions	currency	varchar	10	√		null	suggested currency for the suggested price
accountlines	date	date	10	√		null
article_requests	date	text	65535	√		null
tags_approval	date_approved	datetime	19	√		null	the date this tag was approved
reports_dictionary	date_created	datetime	19	√		null	date and time this definition was created
saved_sql	date_created	datetime	19	√		null	the date this report was created
tags_all	date_created	datetime	19				the date the tag was added
issues	date_due	datetime	19	√		null	datetime the item is due (yyyy-mm-dd hh:mm::ss)
old_issues	date_due	datetime	19	√		null	date the item is due (yyyy-mm-dd)
reports_dictionary	date_modified	datetime	19	√		null	date and time this definition was last modified
saved_reports	date_run	datetime	19	√		null
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	text	65535
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 (YYY-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 (YYY-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
userflags	defaulton	int	10	√		null
auth_subfield_structure	defaultvalue	text	65535	√		null
marc_subfield_structure	defaultvalue	text	65535	√		null
overduerules	delay1	int	10	√		null	number of days after the item is overdue that the first notice is sent
overduerules	delay2	int	10	√		null	number of days after the item is overdue that the second notice is sent
overduerules	delay3	int	10	√		null	number of days after the item is overdue that the third notice is sent
housebound_visit	deliverer_brwnumber	int	10	√		null	Number of the borrower to deliver items.
aqbasketgroups	deliverycomment	varchar	255	√		null
aqbasket	deliveryplace	varchar	10	√		null	basket delivery place
aqbasketgroups	deliveryplace	varchar	10	√		null
aqbooksellers	deliverytime	int	10	√		null	vendor delivery time
courses	department	varchar	80	√		null	the authorised value for the DEPARTMENT
accountlines	description	mediumtext	16777215	√		null
borrower_attribute_types	description	varchar	255				description for each custom field
browser	description	varchar	255
categories	description	mediumtext	16777215	√		null	description of the patron category
class_sort_rules	description	mediumtext	16777215	√		null
class_sources	description	mediumtext	16777215	√		null
edifact_ean	description	varchar	128	√		null
export_format	description	mediumtext	16777215
itemtypes	description	mediumtext	16777215	√		null	a plain text explanation of the item type
language_descriptions	description	varchar	255	√		null
language_subtag_registry	description	varchar	25	√		null	only one of the possible descriptions for ease of reference, see language_descriptions for the complete list
marc_modification_template_actions	description	text	65535	√		null
oai_sets_descriptions	description	varchar	255
permissions	description	varchar	255	√		null
repeatable_holidays	description	text	65535				description for this closing
reports_dictionary	description	text	65535	√		null	description for this definition
special_holidays	description	text	65535				description of this closing
subscription_frequencies	description	text	65535
subscription_numberpatterns	description	text	65535
vendor_edi_accounts	description	text	65535
uploaded_files	dir	text	65535
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	mediumtext	16777215	√		null
subscription	distributedto	text	65535	√		null
sms_providers	domain	varchar	255
vendor_edi_accounts	download_directory	text	65535	√		null
biblioitems	ean	varchar	13	√		null
deletedbiblioitems	ean	varchar	13	√		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	text	65535	√		null
deletedbiblioitems	editionresponsibility	text	65535	√		null
biblioitems	editionstatement	text	65535	√		null
deletedbiblioitems	editionstatement	text	65535	√		null
edifact_ean	ee_id	int	10		√
aqcontacts	email	varchar	100	√		null	contact's email address
borrower_modifications	email	mediumtext	16777215	√		null
borrowers	email	mediumtext	16777215	√		null	the primary email address for your patron/borrower's primary address
deletedborrowers	email	mediumtext	16777215	√		null	the primary email address for your patron/borrower's primary address
borrower_modifications	emailpro	text	65535	√		null
borrowers	emailpro	text	65535	√		null	the secondary email addres for your patron/borrower's primary address
deletedborrowers	emailpro	text	65535	√		null	the secondary email addres for your patron/borrower's primary address
export_format	encoding	varchar	255
z3950servers	encoding	text	65535	√		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	text	65535	√		null	serial enumeration/chronology for the item (MARC21 952$h)
items	enumchron	text	65535	√		null	serial enumeration/chronology for the item (MARC21 952$h)
aqbudgets_planning	estimated_amount	decimal	28,6	√		null
subscription_numberpatterns	every1	int	10	√		null
subscription_numberpatterns	every2	int	10	√		null
subscription_numberpatterns	every3	int	10	√		null
borrower_debarments	expiration	date	10	√		null	expiration date of the restriction
old_reserves	expirationdate	date	10	√		null	the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
opac_news	expirationdate	date	10	√		null	date the article is set to expire or no longer be visible
reserves	expirationdate	date	10	√		null	the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
systempreferences	explanation	text	65535	√		null	descriptive text for the system preference
export_format	export_format_id	int	10		√
housebound_profile	fav_authors	text	65535	√		null	Free text describing preferred authors.
housebound_profile	fav_itemtypes	text	65535	√		null	Free text describing preferred itemtypes.
housebound_profile	fav_subjects	text	65535	√		null	Free text describing preferred subjects.
aqbooksellers	fax	varchar	50	√		null	vendor fax number
aqcontacts	fax	varchar	100	√		null
borrower_modifications	fax	mediumtext	16777215	√		null
borrowers	fax	mediumtext	16777215	√		null	the fax number for your patron/borrower's primary address
deletedborrowers	fax	mediumtext	16777215	√		null	the fax number for your patron/borrower's primary address
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
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	text	65535	√		null
uploaded_files	filename	text	65535
uploaded_files	filesize	int	10	√		null
issuingrules	fine	decimal	28,6	√		null	fine amount
issuingrules	finedays	int	10	√		null	suspension in days
categories	finetype	varchar	30	√		null	unused in Koha
subscription	firstacquidate	date	10	√		null	first issue received date
borrower_modifications	firstname	text	65535	√		null
borrowers	firstname	text	65535	√		null	patron/borrower's first name
deletedborrowers	firstname	text	65535	√		null	patron/borrower's first name
tmp_holdsqueue	firstname	text	65535	√		null
issuingrules	firstremind	int	10	√		null	fine grace period
userflags	flag	varchar	30	√		null
userflags	flagdesc	varchar	255	√		null
borrower_modifications	flags	int	10	√		null
borrowers	flags	int	10	√		null	will include a number associated with the staff member's permissions
deletedborrowers	flags	int	10	√		null	will include a number associated with the staff member's permissions
virtualshelfcontents	flags	int	10	√		null
old_reserves	found	varchar	1	√		null	a one letter code defining what the status is of the hold is after it has been confirmed
reserves	found	varchar	1	√		null	a one letter code defining what the status is of the hold is after it has been confirmed
aqbasketgroups	freedeliveryplace	text	65535	√		null
aqorders	freight	decimal	28,6	√		null	shipping costs (not used)
housebound_profile	frequency	text	65535				The Authorised_Value definining the pattern for delivery.
message_queue	from_address	mediumtext	16777215	√		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
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 guarentors or organizations
deletedborrowers	guarantorid	int	10	√		null	borrowernumber used for children or professionals to link them to guarentors 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
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
edifact_messages	id	int	10		√
fieldmapping	id	int	10		√		unique identifier assigned by Koha
housebound_visit	id	int	10		√		ID of the visit.
item_circulation_alert_preferences	id	int	10		√
items_last_borrower	id	int	10		√
language_descriptions	id	int	10		√
language_rfc4646_to_iso639	id	int	10		√
language_subtag_registry	id	int	10		√
linktracker	id	int	10		√		primary key identifier
need_merge_authorities	id	int	10		√		unique id
oai_sets	id	int	10		√
overduerules_transport_types	id	int	10		√
quotes	id	int	10		√		unique id for the quote
repeatable_holidays	id	int	10		√		unique identifier assigned by Koha
reports_dictionary	id	int	10		√		unique identifier assigned by Koha
saved_reports	id	int	10		√
saved_sql	id	int	10		√		unique id and primary key assigned by Koha
search_field	id	int	10		√
search_history	id	int	10		√		search history id
search_marc_map	id	int	10		√
sessions	id	varchar	32
sms_providers	id	int	10		√
special_holidays	id	int	10		√		unique identifier assigned by Koha
subscription_frequencies	id	int	10		√
subscription_numberpatterns	id	int	10		√
uploaded_files	id	int	10		√
vendor_edi_accounts	id	int	10		√
virtualshelfshares	id	int	10		√
z3950servers	id	int	10		√		unique identifier assigned by Koha
zebraqueue	id	int	10		√
opac_news	idnew	int unsigned	10		√		unique identifier for the news article
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	mediumtext	16777215	√		null
import_records	import_error	mediumtext	16777215	√		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	text	65535	√		null	information about the action (usually includes SQL statement)
borrower_modifications	initials	text	65535	√		null
borrowers	initials	text	65535	√		null	initials for your patron/borrower
deletedborrowers	initials	text	65535	√		null	initials for your patron/borrower
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	mediumtext	16777215
aqbooksellers	invoiceprice	varchar	10	√		null	currency code for invoice prices
subscription	irregularity	text	65535	√		null	any irregularities in the subscription
biblioitems	isbn	mediumtext	16777215	√		null	ISBN (MARC21 020$a)
deletedbiblioitems	isbn	mediumtext	16777215	√		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	mediumtext	16777215	√		null	ISSN (MARC21 022$a)
deletedbiblioitems	issn	mediumtext	16777215	√		null	ISSN (MARC21 022$a)
import_biblios	issn	varchar	9	√		null
article_requests	issue	text	65535	√		null
accountlines	issue_id	int	10	√		null
issues	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	mediumtext	16777215	√		null	public notes on this item (MARC21 952$x)
items	itemnotes	mediumtext	16777215	√		null	public notes on this item (MARC21 952$x)
deleteditems	itemnotes_nonpublic	mediumtext	16777215	√		null
items	itemnotes_nonpublic	mediumtext	16777215	√		null
accountlines	itemnumber	int	10	√		null
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 seed (connected at the OPAC or staff interface)
deletedborrowers	lastseen	datetime	19	√		null	last time a patron has been seed (connected at the OPAC or staff interface)
borrower_sync	lastsync	varchar	50	√		null	Date of the last successfull sync. The date format might be different depending on the service that is being used, so no special date format is being enforced here.
subscription	lastvalue1	int	10	√		null
subscription	lastvalue2	int	10	√		null
subscription	lastvalue3	int	10	√		null
creator_layouts	layout_id	int	10		√
creator_layouts	layout_xml	text	65535
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)
borrower_modifications	lost	bit	0	√		null
borrowers	lost	bit	0	√		null	set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card
deletedborrowers	lost	bit	0	√		null	set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card
old_reserves	lowestPriority	bit	0				has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
reserves	lowestPriority	bit	0
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
oai_sets_mappings	marcsubfield	char	1
oai_sets_mappings	marcvalue	varchar	80
auth_header	marcxml	longtext	2147483647
biblioitems	marcxml	longtext	2147483647	√		null	full bibliographic MARC record in MARCXML
deletedbiblioitems	marcxml	longtext	2147483647	√		null	full bibliographic MARC record in MARCXML
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	text	65535	√		null	materials specified (MARC21 952$3)
items	materials	text	65535	√		null	materials specified (MARC21 952$3)
branch_borrower_circ_rules	maxissueqty	int	10	√		null	the maximum number of checkouts this patron category can have at this branch
default_borrower_circ_rules	maxissueqty	int	10	√		null
default_branch_circ_rules	maxissueqty	int	10	√		null
default_circ_rules	maxissueqty	int	10	√		null
issuingrules	maxissueqty	int	10	√		null	total number of checkouts allowed
branch_borrower_circ_rules	maxonsiteissueqty	int	10	√		null	the maximum number of on-site checkouts this patron category can have at this branch
default_borrower_circ_rules	maxonsiteissueqty	int	10	√		null
default_branch_circ_rules	maxonsiteissueqty	int	10	√		null
default_circ_rules	maxonsiteissueqty	int	10	√		null
issuingrules	maxonsiteissueqty	int	10	√		null	total number of on-site checkouts allowed
issuingrules	maxsuspensiondays	int	10	√		null	max suspension days
messages	message	text	65535				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)
message_queue	metadata	text	65535	√		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	text	65535	√		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	mediumtext	16777215				vendor name
aqcontacts	name	varchar	100	√		null	name of contact at vendor
items_search_fields	name	varchar	255
marc_modification_templates	name	text	65535
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
opac_news	new	text	65535				the body of your news article
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	norenewalbefore	int	10	√		null	no renewal allowed until X days or hours before due date.
accountlines	note	text	65535	√		null
aqbasket	note	mediumtext	16777215	√		null	the internal note added at basket creation
suggestions	note	mediumtext	16777215	√		null	note entered on the suggestion
aqbooksellers	notes	mediumtext	16777215	√		null	order notes
aqcontacts	notes	mediumtext	16777215	√		null	notes related to the contact
article_requests	notes	text	65535	√		null
biblio	notes	mediumtext	16777215	√		null	values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
biblioitems	notes	mediumtext	16777215	√		null
deletedbiblio	notes	mediumtext	16777215	√		null	values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
deletedbiblioitems	notes	mediumtext	16777215	√		null
housebound_profile	notes	text	65535	√		null	Free text for additional notes.
saved_sql	notes	text	65535	√		null	the notes or description given to this report
serial	notes	text	65535	√		null	notes
subscription	notes	mediumtext	16777215	√		null	notes
tmp_holdsqueue	notes	text	65535	√		null
itemtypes	notforloan	smallint	5	√		null	1 if the item is not for loan, 0 if the item is available for loan
item_circulation_alert_preferences	notification	varchar	16
old_reserves	notificationdate	date	10	√		null	currently unused
reserves	notificationdate	date	10	√		null	currently unused
notifys	notify_date	date	10	√		null
notifys	notify_send_date	date	10	√		null
social_data	num_critics	int	10	√		null
social_data	num_critics_pro	int	10	√		null
social_data	num_quotations	int	10	√		null
social_data	num_scores	int	10	√		null
social_data	num_videos	int	10	√		null
biblioitems	number	mediumtext	16777215	√		null
browser	number	bigint	19
deletedbiblioitems	number	mediumtext	16777215	√		null
opac_news	number	int	10	√		null	the order in which this article appears in that specific location
subscription_numberpatterns	numbering1	varchar	255	√		null
subscription_numberpatterns	numbering2	varchar	255	√		null
subscription_numberpatterns	numbering3	varchar	255	√		null
subscription_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)
accountoffsets	offsetamount	decimal	28,6	√		null
deleteditems	onloan	date	10	√		null	defines if item is checked out (NULL for not checked out, and checkout date for checked out)
items	onloan	date	10	√		null	defines if item is checked out (NULL for not checked out, and checkout date for checked out)
branches	opac_info	text	65535	√		null	HTML that displays in OPAC
subscription	opacdisplaycount	varchar	10	√		null	how many issues to show to the public
borrower_modifications	opacnote	mediumtext	16777215	√		null
borrowers	opacnote	mediumtext	16777215	√		null	a note on the patron/borrower's account that is visible in the OPAC and staff client
deletedborrowers	opacnote	mediumtext	16777215	√		null	a note on the patron/borrower's account that is visible in the OPAC and staff client
pending_offline_operations	operationid	int	10		√
systempreferences	options	mediumtext	16777215	√		null	options for multiple choice system preferences
aqorders	order_internalnote	mediumtext	16777215	√		null	notes related to this order line, made for staff
aqorders	order_vendornote	mediumtext	16777215	√		null	notes related to this order line, made for vendor
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	mediumtext	16777215	√		null	used by SIP
borrower_modifications	othernames	mediumtext	16777215	√		null
borrowers	othernames	mediumtext	16777215	√		null	any other names associated with the patron/borrower
deletedborrowers	othernames	mediumtext	16777215	√		null	any other names associated with the patron/borrower
aqbooksellers	othersupplier	mediumtext	16777215	√		null
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	text	65535	√		null
biblioitems	pages	varchar	255	√		null	number of pages (MARC21 300$c)
deletedbiblioitems	pages	varchar	255	√		null	number of pages (MARC21 300$c)
deleteditems	paidfor	mediumtext	16777215	√		null
items	paidfor	mediumtext	16777215	√		null
aqorders	parent_ordernumber	int	10	√		null	ordernumber of parent order line, or same as ordernumber if no parent
borrower_modifications	password	varchar	30	√		null
borrowers	password	varchar	60	√		null	patron/borrower's 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
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	text	65535	√		null
suggestions	patronreason	text	65535	√		null	reason for making the suggestion
subscription	periodicity	int	10	√		null	frequency type links to subscription_frequencies.id
uploaded_files	permanent	tinyint	3	√		null
deleteditems	permanent_location	varchar	80	√		null	linked to the CART and PROC temporary locations feature, stores the permanent shelving location
items	permanent_location	varchar	80	√		null	linked to the CART and PROC temporary locations feature, stores the permanent shelving location
aqbooksellers	phone	varchar	30	√		null	vendor phone number
aqcontacts	phone	varchar	100	√		null	contact's phone number
borrower_modifications	phone	text	65535	√		null
borrowers	phone	text	65535	√		null	the primary phone number for your patron/borrower's primary address
deletedborrowers	phone	text	65535	√		null	the primary phone number for your patron/borrower's primary address
tmp_holdsqueue	phone	text	65535	√		null
borrower_modifications	phonepro	text	65535	√		null
borrowers	phonepro	text	65535	√		null	the secondary phone number for your patron/borrower's primary address
deletedborrowers	phonepro	text	65535	√		null	the secondary phone number for your patron/borrower's primary address
tmp_holdsqueue	pickbranch	varchar	10	√		null
biblioitems	place	varchar	255	√		null	publication place (MARC21 260$a)
deletedbiblioitems	place	varchar	255	√		null	publication place (MARC21 260$a)
suggestions	place	varchar	255	√		null	publication place of the suggested item
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	text	65535	√		null
z3950servers	port	int	10	√		null	port number used to connect to target
aqcontacts	position	varchar	100	√		null	contact person's position
aqbooksellers	postal	mediumtext	16777215	√		null	vendor postal address (all lines)
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)
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	mediumtext	16777215	√		null	public, OPAC visible note
courses	public_note	mediumtext	16777215	√		null	the text of the public / opac note
biblioitems	publicationyear	text	65535	√		null
deletedbiblioitems	publicationyear	text	65535	√		null
serial	publisheddate	date	10	√		null	date published
serial	publisheddatetext	varchar	100	√		null	date published (descriptive)
biblioitems	publishercode	varchar	255	√		null	publisher (MARC21 260$b)
deletedbiblioitems	publishercode	varchar	255	√		null	publisher (MARC21 260$b)
suggestions	publishercode	varchar	255	√		null	publisher of the suggested item
aqorders	purchaseordernumber	mediumtext	16777215	√		null	not used? always NULL
aqorders	quantity	smallint	5	√		null	the quantity ordered
suggestions	quantity	smallint	5	√		null	suggested quantity to be purchased
search_history	query_cgi	text	65535				the string to append to the search url to rerun the search
search_history	query_desc	varchar	255				the search that was performed
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	mediumtext	16777215	√		null
suggestions	reason	text	65535	√		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	text	65535	√		null	Free text indicating how the borrower was added to the service.
suggestions	rejectedby	int	10	√		null	borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table
suggestions	rejecteddate	date	10	√		null	date the suggestion was marked as rejected
borrower_modifications	relationship	varchar	100	√		null
borrowers	relationship	varchar	100	√		null	used for children to include the relationship to their guarentor
deletedborrowers	relationship	varchar	100	√		null	used for children to include the relationship to their guarentor
old_reserves	reminderdate	date	10	√		null	currently unused
reserves	reminderdate	date	10	√		null	currently unused
issuingrules	renewalperiod	int	10	√		null	renewal period in the unit set in issuingrules.lengthunit
deleteditems	renewals	smallint	5	√		null	number of times this item has been renewed
issues	renewals	tinyint	3	√		null	lists the number of times the item was renewed
items	renewals	smallint	5	√		null	number of times this item has been renewed
old_issues	renewals	tinyint	3	√		null	lists the number of times the item was renewed
subscription	reneweddate	date	10	√		null	date of last renewal for the subscription
itemtypes	rentalcharge	double	16,4	√		null	the amount charged when this item is checked out/issued
issuingrules	rentaldiscount	decimal	28,6	√		null	percent discount on the rental charge for this item
deleteditems	replacementprice	decimal	8,2	√		null	cost the library charges to replace the item if it has been marked lost (MARC21 952$v)
items	replacementprice	decimal	8,2	√		null	cost the library charges to replace the item if it has been marked lost (MARC21 952$v)
deleteditems	replacementpricedate	date	10	√		null	the date the price is effective from (MARC21 952$w)
items	replacementpricedate	date	10	√		null	the date the price is effective from (MARC21 952$w)
saved_reports	report	longtext	2147483647	√		null
reports_dictionary	report_area	varchar	6	√		null	Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts)
saved_sql	report_area	varchar	6	√		null
saved_sql	report_group	varchar	80	√		null
saved_reports	report_id	int	10	√		null
saved_sql	report_subgroup	varchar	80	√		null
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	mediumtext	16777215	√		null	notes related to this hold
reserves	reservenotes	mediumtext	16777215	√		null	notes related to this hold
deleteditems	reserves	smallint	5	√		null	number of times this item has been placed on hold/reserved
items	reserves	smallint	5	√		null	number of times this item has been placed on hold/reserved
deleteditems	restricted	bit	0	√		null	authorized value defining use restrictions for this item (MARC21 952$5)
items	restricted	bit	0	√		null	authorized value defining use restrictions for this item (MARC21 952$5)
issuingrules	restrictedtype	bit	0	√		null	not used? always NULL
issues	return	varchar	4	√		null
old_issues	return	varchar	4	√		null
branch_item_rules	returnbranch	varchar	15	√		null	the branch the item returns to (homebranch, holdingbranch, noreturn)
default_branch_circ_rules	returnbranch	varchar	15	√		null
default_branch_item_rules	returnbranch	varchar	15	√		null
default_circ_rules	returnbranch	varchar	15	√		null
issues	returndate	datetime	19	√		null	date the item was returned, will be NULL until moved to old_issues
old_issues	returndate	datetime	19	√		null	date the item was returned
reviews	review	text	65535	√		null	the body of the comment
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	text	65535	√		null	notes from the routing list
aqorders	rrp	decimal	13,2	√		null	the replacement cost for this line item
aqorders	rrp_tax_excluded	decimal	28,6	√		null	the replacement cost excluding tax
aqorders	rrp_tax_included	decimal	28,6	√		null	the replacement cost including tax
vendor_edi_accounts	san	varchar	20	√		null
reports_dictionary	saved_sql	text	65535	√		null	SQL snippet for us in reports
saved_sql	savedsql	text	65535	√		null	the SQL for this report
social_data	score_avg	decimal	5,2	√		null
language_script_mapping	script_subtag	varchar	25	√		null
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
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	mediumtext	16777215	√		null
deletedbiblio	seriestitle	mediumtext	16777215	√		null
z3950servers	servername	mediumtext	16777215				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 SNS turned on)
deletedborrowers	smsalertnumber	varchar	50	√		null	the mobile phone number where the patron/borrower would like to receive notices (if SNS 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	text	65535	√		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	mediumtext	16777215	√		null	contains the mapping between the Z3950 search fields and the specific SRU server indexes
z3950servers	sru_options	varchar	255	√		null	options like sru=get, sru_version=1.1; will be passed to the server via ZOOM
deleteditems	stack	bit	0	√		null
items	stack	bit	0	√		null
course_reserves	staff_note	mediumtext	16777215	√		null	staff only note
courses	staff_note	mediumtext	16777215	√		null	the text of the staff only note
subscription	staffdisplaycount	varchar	10	√		null	how many issues to show to the staff
subscription	startdate	date	10	√		null	start date for this subscription
borrower_modifications	state	text	65535	√		null
borrowers	state	text	65535	√		null	the state or province for your patron/borrower's primary address
deletedborrowers	state	text	65535	√		null	the state or province for your patron/borrower's primary address
edifact_messages	status	text	65535	√		null
deleteditems	stocknumber	varchar	32	√		null	inventory number (MARC21 952$i)
items	stocknumber	varchar	32	√		null	inventory number (MARC21 952$i)
borrower_modifications	streetnumber	varchar	10	√		null
borrowers	streetnumber	varchar	10	√		null	the house number for your patron/borrower's primary address
deletedborrowers	streetnumber	varchar	10	√		null	the house number for your patron/borrower's primary address
borrower_modifications	streettype	varchar	50	√		null
borrowers	streettype	varchar	50	√		null	the street type (Rd., Blvd, etc) for your patron/borrower's primary address
deletedborrowers	streettype	varchar	50	√		null	the street type (Rd., Blvd, etc) for your patron/borrower's primary address
courses	students_count	varchar	20	√		null	how many students will be taking this course/section
export_format	subfield_separator	varchar	2
fieldmapping	subfieldcode	char	1				marc subfield associated with the fieldcode to map to this keyword
message_queue	subject	text	65535	√		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	mediumtext	16777215
itemtypes	summary	text	65535	√		null	information from the summary field, may include HTML
aqorders	suppliers_reference_number	varchar	35	√		null	Suppliers unique edifact quote ref
aqorders	suppliers_reference_qualifier	varchar	3	√		null	Type of number above usually 'QLI'
aqorders	suppliers_report	text	65535	√		null	reports received from suppliers
borrower_modifications	surname	mediumtext	16777215	√		null
borrowers	surname	mediumtext	16777215				patron/borrower's last name (surname)
deletedborrowers	surname	mediumtext	16777215				patron/borrower's last name (surname)
tmp_holdsqueue	surname	mediumtext	16777215
old_reserves	suspend_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	255				the tag
tags_index	term	varchar	255				the tag
quotes	text	mediumtext	16777215				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	text	65535	√		null
biblio	title	mediumtext	16777215	√		null	title (without the subtitle) from the MARC record (245$a in MARC21)
borrower_modifications	title	mediumtext	16777215	√		null
borrowers	title	mediumtext	16777215	√		null	patron/borrower's title, for example: Mr. or Mrs.
deletedbiblio	title	mediumtext	16777215	√		null	title (without the subtitle) from the MARC record (245$a in MARC21)
deletedborrowers	title	mediumtext	16777215	√		null	patron/borrower's title, for example: Mr. or Mrs.
import_biblios	title	varchar	128	√		null
suggestions	title	varchar	255	√		null	title of the suggested item
tmp_holdsqueue	title	mediumtext	16777215	√		null
message_queue	to_address	mediumtext	16777215	√		null
marc_modification_template_actions	to_field	varchar	3	√		null
marc_modification_template_actions	to_regex_replace	text	65535	√		null
marc_modification_template_actions	to_regex_search	text	65535	√		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	text	65535	√		null
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	mediumtext	16777215	√		null	uniform title (without the subtitle) from the MARC record (240$a in MARC21)
deletedbiblio	unititle	mediumtext	16777215	√		null	uniform title (without the subtitle) from the MARC record (240$a in MARC21)
aqorders	unitprice	decimal	28,6	√		null	the actual cost entered when receiving this line item
aqorders	unitprice_tax_excluded	decimal	28,6	√		null	the unit price excluding tax (on receiving)
aqorders	unitprice_tax_included	decimal	28,6	√		null	the unit price including tax (on receiving)
borrower_debarments	updated	timestamp	19	√		null	date the restriction was updated
article_requests	updated_on	timestamp	19	√		null
vendor_edi_accounts	upload_directory	text	65535	√		null
uploaded_files	uploadcategorycode	tinytext	255	√		null
categories	upperagelimit	smallint	5	√		null	age limit for the patron
deleteditems	uri	varchar	255	√		null	URL for the item (MARC21 952$u)
items	uri	varchar	255	√		null	URL for the item (MARC21 952$u)
aqbooksellers	url	varchar	255	√		null	vendor web address
biblioitems	url	text	65535	√		null	url (MARC21 856$u)
deletedbiblioitems	url	text	65535	√		null	url (MARC21 856$u)
linktracker	url	text	65535	√		null	the link itself
statistics	usercode	varchar	10	√		null	unused in Koha
borrower_modifications	userid	varchar	75	√		null
borrowers	userid	varchar	75	√		null	patron/borrower's opac and/or staff client log in
deletedborrowers	userid	varchar	75	√		null	patron/borrower's opac and/or staff client log in
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
statistics	value	double	16,4	√		null	monetary value associated with the transaction
systempreferences	value	text	65535	√		null	system preference values
auth_subfield_structure	value_builder	varchar	80	√		null
marc_subfield_structure	value_builder	varchar	80	√		null
edifact_messages	vendor_id	int	10	√		null
vendor_edi_accounts	vendor_id	int	10	√		null
article_requests	volume	text	65535	√		null
biblioitems	volume	mediumtext	16777215	√		null
deletedbiblioitems	volume	mediumtext	16777215	√		null
biblioitems	volumedate	date	10	√		null
deletedbiblioitems	volumedate	date	10	√		null
biblioitems	volumedesc	text	65535	√		null	volume information (MARC21 362$a)
deletedbiblioitems	volumedesc	text	65535	√		null	volume information (MARC21 362$a)
suggestions	volumedesc	varchar	255	√		null
old_reserves	waitingdate	date	10	√		null	the date the item was marked as waiting for the patron at the library
reserves	waitingdate	date	10	√		null	the date the item was marked as waiting for the patron at the library
repeatable_holidays	weekday	smallint	5	√		null	day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on
subscription_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
courses	enabled	enum	4			yes	determines whether the course is active
z3950servers	servertype	enum	4			zed	zed means z39.50 server