testsql_comments contains 1665 columns - click on heading to sort:

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