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

testsql_comments contains 1836 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
account_offset_types type varchar 16 The type of offset this is
account_offsets amount decimal 26,6 The amount of the change
account_offsets created_on timestamp 19 CURRENT_TIMESTAMP
account_offsets credit_id int 10  √  null The id of the accountline the increased the patron's balance
account_offsets debit_id int 10  √  null The id of the accountline that decreased the patron's balance
account_offsets id int 10  √  unique identifier for each offset
account_offsets type varchar 16 The type of offset this is
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 longtext 2147483647  √  null
accountlines dispute longtext 2147483647  √  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 mediumtext 16777215  √  null
accountlines payment_type varchar 80  √  null optional authorised value PAYMENT_TYPE
accountlines timestamp timestamp 19 CURRENT_TIMESTAMP
action_logs action mediumtext 16777215  √  null the action (includes things like DELETED, ADDED, MODIFY, etc)
action_logs action_id int 10  √  unique identifier for each action
action_logs info mediumtext 16777215  √  null information about the action (usually includes SQL statement)
action_logs interface varchar 30  √  null the context this action was taken in
action_logs module mediumtext 16777215  √  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
api_keys active bit 0 1
api_keys client_id varchar 191
api_keys description varchar 255
api_keys patron_id int 10
api_keys secret varchar 191
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 longtext 2147483647  √  null appears to always be NULL
aqbasket booksellernote longtext 2147483647  √  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 create_items enum 11  √  null when items should be created for orders in this basket
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 longtext 2147483647  √  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 mediumtext 16777215  √  null
aqbasketgroups id int 10  √ 
aqbasketgroups name varchar 50  √  null
aqbasketusers basketno int 10
aqbasketusers borrowernumber int 10
aqbooksellers accountnumber longtext 2147483647  √  null unused in Koha
aqbooksellers active tinyint 3  √  null is this vendor active (1 for yes, 0 for no)
aqbooksellers address1 longtext 2147483647  √  null first line of vendor physical address
aqbooksellers address2 longtext 2147483647  √  null second line of vendor physical address
aqbooksellers address3 longtext 2147483647  √  null third line of vendor physical address
aqbooksellers address4 longtext 2147483647  √  null fourth line of vendor physical address
aqbooksellers bookselleremail longtext 2147483647  √  null vendor email
aqbooksellers booksellerfax longtext 2147483647  √  null vendor fax number
aqbooksellers booksellerurl longtext 2147483647  √  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 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 longtext 2147483647 vendor name
aqbooksellers notes longtext 2147483647  √  null order notes
aqbooksellers othersupplier longtext 2147483647  √  null
aqbooksellers phone varchar 30  √  null vendor phone number
aqbooksellers postal longtext 2147483647  √  null vendor postal address (all lines)
aqbooksellers tax_rate decimal 6,4  √  null the tax rate the library is charged
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 longtext 2147483647  √  null description assigned to this budget
aqbudgetperiods budget_period_enddate date 10 date when the budget ends
aqbudgetperiods budget_period_id int 10  √  primary key and unique number assigned by Koha
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 longtext 2147483647  √  null notes related to this fund
aqbudgets budget_owner_id int 10  √  null borrowernumber of the person who owns this fund (borrowers.borrowernumber)
aqbudgets budget_parent_id int 10  √  null if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
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 longtext 2147483647  √  null notes related to the contact
aqcontacts orderacquisition bit 0 0 should this contact receive acquisition orders
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 longtext 2147483647  √  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 longtext 2147483647
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 mediumtext 16777215  √  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 replacement cost for this line item
aqorders ecost_tax_excluded decimal 28,6  √  null the estimated cost excluding tax
aqorders ecost_tax_included decimal 28,6  √  null the estimated cost including tax
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 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 longtext 2147483647  √  null notes related to this order line, made for staff
aqorders order_vendornote longtext 2147483647  √  null notes related to this order line, made for vendor
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 longtext 2147483647  √  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 rrp_tax_excluded decimal 28,6  √  null the replacement cost excluding tax
aqorders rrp_tax_included decimal 28,6  √  null the replacement cost including tax
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 mediumtext 16777215  √  null reports received from suppliers
aqorders tax_rate_bak decimal 6,4  √  null the tax rate for this line item (%)
aqorders tax_rate_on_ordering decimal 6,4  √  null the tax rate on ordering for this line item (%)
aqorders tax_rate_on_receiving decimal 6,4  √  null the tax rate on receiving for this line item (%)
aqorders tax_value_bak decimal 28,6  √  null the tax value for this line item
aqorders tax_value_on_ordering decimal 28,6  √  null the tax value on ordering for this line item
aqorders tax_value_on_receiving decimal 28,6  √  null the tax value on receiving for this line item
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 unitprice_tax_excluded decimal 28,6  √  null the unit price excluding tax (on receiving)
aqorders unitprice_tax_included decimal 28,6  √  null the unit price including tax (on receiving)
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
article_requests author mediumtext 16777215  √  null
article_requests biblionumber int 10
article_requests borrowernumber int 10
article_requests branchcode varchar 10  √  null
article_requests chapters mediumtext 16777215  √  null
article_requests created_on timestamp 19 CURRENT_TIMESTAMP
article_requests date mediumtext 16777215  √  null
article_requests id int 10  √ 
article_requests issue mediumtext 16777215  √  null
article_requests itemnumber int 10  √  null
article_requests notes mediumtext 16777215  √  null
article_requests pages mediumtext 16777215  √  null
article_requests patron_notes mediumtext 16777215  √  null
article_requests status enum 10 PENDING
article_requests title mediumtext 16777215  √  null
article_requests updated_on timestamp 19  √  null
article_requests volume mediumtext 16777215  √  null
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 longtext 2147483647  √  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 mediumtext 16777215  √  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 longtext 2147483647
authorised_value_categories category_name varchar 32
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 longtext 2147483647  √  null summary from the MARC record (520$a in MARC21)
biblio author longtext 2147483647  √  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 longtext 2147483647  √  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 longtext 2147483647  √  null
biblio timestamp timestamp 19 CURRENT_TIMESTAMP date and time this record was last touched
biblio title longtext 2147483647  √  null title (without the subtitle) from the MARC record (245$a in MARC21)
biblio unititle longtext 2147483647  √  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
biblio_metadata biblionumber int 10
biblio_metadata format varchar 16
biblio_metadata id int 10  √ 
biblio_metadata marcflavour varchar 16
biblio_metadata metadata longtext 2147483647
biblio_metadata timestamp timestamp 19 CURRENT_TIMESTAMP
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 mediumtext 16777215  √  null
biblioitems collectiontitle longtext 2147483647  √  null
biblioitems collectionvolume longtext 2147483647  √  null
biblioitems ean longtext 2147483647  √  null
biblioitems editionresponsibility mediumtext 16777215  √  null
biblioitems editionstatement mediumtext 16777215  √  null
biblioitems illus varchar 255  √  null illustrations (MARC21 300$b)
biblioitems isbn longtext 2147483647  √  null ISBN (MARC21 020$a)
biblioitems issn longtext 2147483647  √  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 notes longtext 2147483647  √  null
biblioitems number longtext 2147483647  √  null
biblioitems pages varchar 255  √  null number of pages (MARC21 300$c)
biblioitems place varchar 255  √  null publication place (MARC21 260$a)
biblioitems publicationyear mediumtext 16777215  √  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 mediumtext 16777215  √  null url (MARC21 856$u)
biblioitems volume longtext 2147483647  √  null
biblioitems volumedate date 10  √  null
biblioitems volumedesc mediumtext 16777215  √  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 opac_editable bit 0 0 defines if this field is editable by patrons on their account in the OPAC (1 for yes, 0 for no)
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_attributes id int 10  √  Row id field
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 mediumtext 16777215  √  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 longtext 2147483647  √  null
borrower_modifications address2 mediumtext 16777215  √  null
borrower_modifications altcontactaddress1 varchar 255  √  null
borrower_modifications altcontactaddress2 varchar 255  √  null
borrower_modifications altcontactaddress3 varchar 255  √  null
borrower_modifications altcontactcountry mediumtext 16777215  √  null
borrower_modifications altcontactfirstname varchar 255  √  null
borrower_modifications altcontactphone varchar 50  √  null
borrower_modifications altcontactstate mediumtext 16777215  √  null
borrower_modifications altcontactsurname varchar 255  √  null
borrower_modifications altcontactzipcode varchar 50  √  null
borrower_modifications B_address varchar 100  √  null
borrower_modifications B_address2 mediumtext 16777215  √  null
borrower_modifications B_city longtext 2147483647  √  null
borrower_modifications B_country mediumtext 16777215  √  null
borrower_modifications B_email mediumtext 16777215  √  null
borrower_modifications B_phone longtext 2147483647  √  null
borrower_modifications B_state mediumtext 16777215  √  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 longtext 2147483647  √  null
borrower_modifications borrowernumber int 10 0
borrower_modifications branchcode varchar 10  √  null
borrower_modifications cardnumber varchar 32  √  null
borrower_modifications categorycode varchar 10  √  null
borrower_modifications city longtext 2147483647  √  null
borrower_modifications contactfirstname mediumtext 16777215  √  null
borrower_modifications contactname longtext 2147483647  √  null
borrower_modifications contactnote varchar 255  √  null
borrower_modifications contacttitle mediumtext 16777215  √  null
borrower_modifications country mediumtext 16777215  √  null
borrower_modifications date_renewed date 10  √  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 longtext 2147483647  √  null
borrower_modifications emailpro mediumtext 16777215  √  null
borrower_modifications extended_attributes mediumtext 16777215  √  null
borrower_modifications fax longtext 2147483647  √  null
borrower_modifications firstname mediumtext 16777215  √  null
borrower_modifications flags int 10  √  null
borrower_modifications gonenoaddress bit 0  √  null
borrower_modifications guarantorid int 10  √  null
borrower_modifications initials mediumtext 16777215  √  null
borrower_modifications lost bit 0  √  null
borrower_modifications mobile varchar 50  √  null
borrower_modifications opacnote longtext 2147483647  √  null
borrower_modifications othernames longtext 2147483647  √  null
borrower_modifications password varchar 30  √  null
borrower_modifications phone mediumtext 16777215  √  null
borrower_modifications phonepro mediumtext 16777215  √  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 mediumtext 16777215  √  null
borrower_modifications streetnumber varchar 10  √  null
borrower_modifications streettype varchar 50  √  null
borrower_modifications surname longtext 2147483647  √  null
borrower_modifications timestamp timestamp 19 CURRENT_TIMESTAMP
borrower_modifications title longtext 2147483647  √  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 longtext 2147483647  √  null the first address line for your patron/borrower's primary address
borrowers address2 mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  null the second address line for your patron/borrower's alternate address
borrowers B_city longtext 2147483647  √  null the city or town for your patron/borrower's alternate address
borrowers B_country mediumtext 16777215  √  null the country for your patron/borrower's alternate address
borrowers B_email mediumtext 16777215  √  null the patron/borrower's alternate email address
borrowers B_phone longtext 2147483647  √  null the patron/borrower's alternate phone number
borrowers B_state mediumtext 16777215  √  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 longtext 2147483647  √  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 32  √  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 checkprevcheckout varchar 7 inherit produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
borrowers city longtext 2147483647  √  null the city or town for your patron/borrower's primary address
borrowers contactfirstname mediumtext 16777215  √  null used for children to include first name of guarantor
borrowers contactname longtext 2147483647  √  null used for children and profesionals to include surname or last name of guarantor or organization name
borrowers contactnote varchar 255  √  null a note related to the patron/borrower's alternate address
borrowers contacttitle mediumtext 16777215  √  null used for children to include title (Mr., Mrs., etc) of guarantor
borrowers country mediumtext 16777215  √  null the country for your patron/borrower's primary address
borrowers date_renewed date 10  √  null date the patron/borrower's card was last renewed
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 (YYYY-MM-DD)
borrowers debarredcomment varchar 255  √  null comment on the stop of the patron
borrowers email longtext 2147483647  √  null the primary email address for your patron/borrower's primary address
borrowers emailpro mediumtext 16777215  √  null the secondary email addres for your patron/borrower's primary address
borrowers fax longtext 2147483647  √  null the fax number for your patron/borrower's primary address
borrowers firstname mediumtext 16777215  √  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 guarantors or organizations
borrowers initials mediumtext 16777215  √  null initials for your patron/borrower
borrowers lang varchar 25 default lang to use to send notices to this patron
borrowers lastseen datetime 19  √  null last time a patron has been seen (connected at the OPAC or staff interface)
borrowers login_attempts int 10  √  0 number of failed login attemps
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 longtext 2147483647  √  null a note on the patron/borrower's account that is visible in the OPAC and staff client
borrowers othernames longtext 2147483647  √  null any other names associated with the patron/borrower
borrowers overdrive_auth_token mediumtext 16777215  √  null persist OverDrive auth token
borrowers password varchar 60  √  null patron/borrower's Bcrypt encrypted password
borrowers phone mediumtext 16777215  √  null the primary phone number for your patron/borrower's primary address
borrowers phonepro mediumtext 16777215  √  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 guarantor
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 SMS 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 mediumtext 16777215  √  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 longtext 2147483647  √  null patron/borrower's last name (surname)
borrowers title longtext 2147483647  √  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
branches branchaddress1 longtext 2147483647  √  null the first address line of for your library or branch
branches branchaddress2 longtext 2147483647  √  null the second address line of for your library or branch
branches branchaddress3 longtext 2147483647  √  null the third address line of for your library or branch
branches branchcity longtext 2147483647  √  null the city or province for your library or branch
branches branchcode varchar 10 a unique key assigned to each branch
branches branchcountry mediumtext 16777215  √  null the county for your library or branch
branches branchemail longtext 2147483647  √  null the primary email address for your library or branch
branches branchfax longtext 2147483647  √  null the fax number for your library or branch
branches branchip varchar 15  √  null the IP address for your library or branch
branches branchname longtext 2147483647 the name of your library or branch
branches branchnotes longtext 2147483647  √  null notes related to your library or branch
branches branchphone longtext 2147483647  √  null the primary phone for your library or branch
branches branchprinter varchar 100  √  null unused in Koha
branches branchreplyto longtext 2147483647  √  null the email to be used as a Reply-To
branches branchreturnpath longtext 2147483647  √  null the email to be used as Return-Path
branches branchstate longtext 2147483647  √  null the state for your library or branch
branches branchurl longtext 2147483647  √  null the URL for your library or branch's website
branches branchzip varchar 25  √  null the zip or postal code for your library or branch
branches geolocation varchar 255  √  null geolocation of your library
branches issuing tinyint 3  √  null unused in Koha
branches marcorgcode varchar 16  √  null MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
branches opac_info mediumtext 16777215  √  null HTML that displays in OPAC
branchtransfers branchtransfer_id int 10  √  primary key
branchtransfers comments longtext 2147483647  √  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 checkprevcheckout varchar 7 inherit produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'.
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 longtext 2147483647  √  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 longtext 2147483647  √  null
class_sort_rules sort_routine varchar 30
class_sources class_sort_rule varchar 10
class_sources cn_source varchar 10
class_sources description longtext 2147483647  √  null
class_sources used tinyint 3 0
club_enrollment_fields club_enrollment_id int 10
club_enrollment_fields club_template_enrollment_field_id int 10
club_enrollment_fields id int 10  √ 
club_enrollment_fields value mediumtext 16777215
club_enrollments borrowernumber int 10
club_enrollments branchcode varchar 10  √  null
club_enrollments club_id int 10
club_enrollments date_canceled timestamp 19  √  null
club_enrollments date_created timestamp 19  √  null
club_enrollments date_enrolled timestamp 19 CURRENT_TIMESTAMP
club_enrollments date_updated timestamp 19  √  null
club_enrollments id int 10  √ 
club_fields club_id int 10
club_fields club_template_field_id int 10
club_fields id int 10  √ 
club_fields value mediumtext 16777215  √  null
club_template_enrollment_fields authorised_value_category varchar 16  √  null
club_template_enrollment_fields club_template_id int 10
club_template_enrollment_fields description mediumtext 16777215  √  null
club_template_enrollment_fields id int 10  √ 
club_template_enrollment_fields name text 65535
club_template_fields authorised_value_category varchar 16  √  null
club_template_fields club_template_id int 10
club_template_fields description mediumtext 16777215  √  null
club_template_fields id int 10  √ 
club_template_fields name text 65535
club_templates branchcode varchar 10  √  null
club_templates date_created timestamp 19 CURRENT_TIMESTAMP
club_templates date_updated timestamp 19  √  null
club_templates description mediumtext 16777215  √  null
club_templates id int 10  √ 
club_templates is_deletable bit 0 1
club_templates is_email_required bit 0 0
club_templates is_enrollable_from_opac bit 0 0
club_templates name text 65535
clubs branchcode varchar 10  √  null
clubs club_template_id int 10
clubs date_created timestamp 19 CURRENT_TIMESTAMP
clubs date_end date 10  √  null
clubs date_start date 10  √  null
clubs date_updated timestamp 19  √  null
clubs description mediumtext 16777215  √  null
clubs id int 10  √ 
clubs name text 65535
collections colBranchcode varchar 10  √  null 'branchcode for branch where item should be held.'
collections colDesc mediumtext 16777215
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 longtext 2147483647  √  null public, OPAC visible note
course_reserves staff_note longtext 2147483647  √  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 longtext 2147483647  √  null the text of the public / opac note
courses section varchar 255  √  null the 'section' of a course
courses staff_note longtext 2147483647  √  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 mediumtext 16777215
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 p_sep_by_space bit 0  √  0
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 longtext 2147483647  √  null summary from the MARC record (520$a in MARC21)
deletedbiblio author longtext 2147483647  √  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 longtext 2147483647  √  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 longtext 2147483647  √  null
deletedbiblio timestamp timestamp 19 CURRENT_TIMESTAMP date and time this record was last touched
deletedbiblio title longtext 2147483647  √  null title (without the subtitle) from the MARC record (245$a in MARC21)
deletedbiblio unititle longtext 2147483647  √  null uniform title (without the subtitle) from the MARC record (240$a in MARC21)
deletedbiblio_metadata biblionumber int 10
deletedbiblio_metadata format varchar 16
deletedbiblio_metadata id int 10  √ 
deletedbiblio_metadata marcflavour varchar 16
deletedbiblio_metadata metadata longtext 2147483647
deletedbiblio_metadata timestamp timestamp 19 CURRENT_TIMESTAMP
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 mediumtext 16777215  √  null
deletedbiblioitems collectiontitle longtext 2147483647  √  null
deletedbiblioitems collectionvolume longtext 2147483647  √  null
deletedbiblioitems ean longtext 2147483647  √  null
deletedbiblioitems editionresponsibility mediumtext 16777215  √  null
deletedbiblioitems editionstatement mediumtext 16777215  √  null
deletedbiblioitems illus varchar 255  √  null illustrations (MARC21 300$b)
deletedbiblioitems isbn longtext 2147483647  √  null ISBN (MARC21 020$a)
deletedbiblioitems issn longtext 2147483647  √  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 notes longtext 2147483647  √  null
deletedbiblioitems number longtext 2147483647  √  null
deletedbiblioitems pages varchar 255  √  null number of pages (MARC21 300$c)
deletedbiblioitems place varchar 255  √  null publication place (MARC21 260$a)
deletedbiblioitems publicationyear mediumtext 16777215  √  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 mediumtext 16777215  √  null url (MARC21 856$u)
deletedbiblioitems volume longtext 2147483647  √  null
deletedbiblioitems volumedate date 10  √  null
deletedbiblioitems volumedesc mediumtext 16777215  √  null volume information (MARC21 362$a)
deletedborrowers address longtext 2147483647  √  null the first address line for your patron/borrower's primary address
deletedborrowers address2 mediumtext 16777215  √  null the second address line for your patron/borrower's primary address
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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  null the second address line for your patron/borrower's alternate address
deletedborrowers B_city longtext 2147483647  √  null the city or town for your patron/borrower's alternate address
deletedborrowers B_country mediumtext 16777215  √  null the country for your patron/borrower's alternate address
deletedborrowers B_email mediumtext 16777215  √  null the patron/borrower's alternate email address
deletedborrowers B_phone longtext 2147483647  √  null the patron/borrower's alternate phone number
deletedborrowers B_state mediumtext 16777215  √  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 longtext 2147483647  √  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 32  √  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 checkprevcheckout varchar 7 inherit produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
deletedborrowers city longtext 2147483647  √  null the city or town for your patron/borrower's primary address
deletedborrowers contactfirstname mediumtext 16777215  √  null used for children to include first name of guarantor
deletedborrowers contactname longtext 2147483647  √  null used for children and profesionals to include surname or last name of guarantor or organization name
deletedborrowers contactnote varchar 255  √  null a note related to the patron/borrower's alternate address
deletedborrowers contacttitle mediumtext 16777215  √  null used for children to include title (Mr., Mrs., etc) of guarantor
deletedborrowers country mediumtext 16777215  √  null the country for your patron/borrower's primary address
deletedborrowers date_renewed date 10  √  null date the patron/borrower's card was last renewed
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 (YYYY-MM-DD)
deletedborrowers debarredcomment varchar 255  √  null comment on the stop of patron
deletedborrowers email longtext 2147483647  √  null the primary email address for your patron/borrower's primary address
deletedborrowers emailpro mediumtext 16777215  √  null the secondary email addres for your patron/borrower's primary address
deletedborrowers fax longtext 2147483647  √  null the fax number for your patron/borrower's primary address
deletedborrowers firstname mediumtext 16777215  √  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 guarantors or organizations
deletedborrowers initials mediumtext 16777215  √  null initials for your patron/borrower
deletedborrowers lang varchar 25 default lang to use to send notices to this patron
deletedborrowers lastseen datetime 19  √  null last time a patron has been seen (connected at the OPAC or staff interface)
deletedborrowers login_attempts int 10  √  0 number of failed login attemps
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 longtext 2147483647  √  null a note on the patron/borrower's account that is visible in the OPAC and staff client
deletedborrowers othernames longtext 2147483647  √  null any other names associated with the patron/borrower
deletedborrowers overdrive_auth_token mediumtext 16777215  √  null persist OverDrive auth token
deletedborrowers password varchar 60  √  null patron/borrower's encrypted password
deletedborrowers phone mediumtext 16777215  √  null the primary phone number for your patron/borrower's primary address
deletedborrowers phonepro mediumtext 16777215  √  null the secondary phone number for your patron/borrower's primary address
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 guarantor
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 SMS 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 mediumtext 16777215  √  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 longtext 2147483647  √  null patron/borrower's last name (surname)
deletedborrowers title longtext 2147483647  √  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 longtext 2147483647  √  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 damaged_on datetime 19  √  null the date and time an item was last marked as damaged, NULL if not damaged
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 mediumtext 16777215  √  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 longtext 2147483647  √  null public notes on this item (MARC21 952$x)
deleteditems itemnotes_nonpublic longtext 2147483647  √  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 mediumtext 16777215  √  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 due date for checked out)
deleteditems paidfor longtext 2147483647  √  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 mediumtext 16777215  √  null
edifact_messages id int 10  √ 
edifact_messages message_type varchar 10
edifact_messages raw_msg longtext 2147483647  √  null
edifact_messages status mediumtext 16777215  √  null
edifact_messages transfer_date date 10  √  null
edifact_messages vendor_id int 10  √  null
export_format content longtext 2147483647
export_format csv_separator varchar 2 ,
export_format description longtext 2147483647
export_format encoding varchar 255 utf8
export_format export_format_id int 10  √ 
export_format field_separator varchar 2  √  null
export_format profile varchar 255
export_format subfield_separator varchar 2  √  null
export_format type varchar 255  √  marc
export_format used_for varchar 255  √  export_records
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
housebound_profile borrowernumber int 10 Number of the borrower associated with this profile.
housebound_profile day mediumtext 16777215
housebound_profile fav_authors mediumtext 16777215  √  null Free text describing preferred authors.
housebound_profile fav_itemtypes mediumtext 16777215  √  null Free text describing preferred itemtypes.
housebound_profile fav_subjects mediumtext 16777215  √  null Free text describing preferred subjects.
housebound_profile frequency mediumtext 16777215 The Authorised_Value definining the pattern for delivery.
housebound_profile notes mediumtext 16777215  √  null Free text for additional notes.
housebound_profile referral mediumtext 16777215  √  null Free text indicating how the borrower was added to the service.
housebound_role borrowernumber_id int 10 borrowernumber link
housebound_role housebound_chooser bit 0 0 set to 1 to indicate this patron is a housebound chooser volunteer
housebound_role housebound_deliverer bit 0 0 set to 1 to indicate this patron is a housebound deliverer volunteer
housebound_visit appointment_date date 10  √  null Date of visit.
housebound_visit borrowernumber int 10 Number of the borrower, & the profile, linked to this visit.
housebound_visit chooser_brwnumber int 10  √  null Number of the borrower to choose items for delivery.
housebound_visit day_segment varchar 10  √  null
housebound_visit deliverer_brwnumber int 10  √  null Number of the borrower to deliver items.
housebound_visit id int 10  √  ID of the visit.
illrequestattributes illrequest_id bigint unsigned 20 ILL request number
illrequestattributes type varchar 200
illrequestattributes value mediumtext 16777215
illrequests accessurl varchar 500  √  null
illrequests backend varchar 20  √  null
illrequests biblio_id int 10  √  null
illrequests borrowernumber int 10  √  null
illrequests branchcode varchar 50
illrequests completed date 10  √  null
illrequests cost varchar 20  √  null
illrequests illrequest_id bigint unsigned 20  √ 
illrequests medium varchar 30  √  null
illrequests notesopac mediumtext 16777215  √  null
illrequests notesstaff mediumtext 16777215  √  null
illrequests orderid varchar 50  √  null
illrequests placed date 10  √  null
illrequests replied date 10  √  null
illrequests status varchar 50  √  null
illrequests updated timestamp 19 CURRENT_TIMESTAMP
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 longtext 2147483647  √  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 longtext 2147483647  √  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 longtext 2147483647  √  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 auto_renew_error varchar 32  √  null automatic renewal error
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 note longtext 2147483647  √  null issue note text
issues notedate datetime 19  √  null datetime of issue note (yyyy-mm-dd hh:mm::ss)
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 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 article_requests enum 9 no allow article requests to be placed,
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 holds_per_record smallint 5 1 How many holds a patron can have on a given bib
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 no_auto_renewal_after int 10  √  null no auto renewal allowed after X days or hours after the issue date
issuingrules no_auto_renewal_after_hard_limit date 10  √  null no auto renewal allowed after a given date
issuingrules norenewalbefore int 10  √  null no renewal allowed until X days or hours before due date.
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
issuingrules suspension_chargeperiod int 10  √  1 how often the finedays is charged
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 longtext 2147483647  √  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 damaged_on datetime 19  √  null the date and time an item was last marked as damaged, NULL if not damaged
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 mediumtext 16777215  √  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 longtext 2147483647  √  null public notes on this item (MARC21 952$x)
items itemnotes_nonpublic longtext 2147483647  √  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 mediumtext 16777215  √  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 due date for checked out)
items paidfor longtext 2147483647  √  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 defaultreplacecost decimal 28,6  √  null default replacement cost
itemtypes description longtext 2147483647  √  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 processfee decimal 28,6  √  null default text be recorded in the column note when the processing fee is applied
itemtypes rentalcharge decimal 28,6  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 lang varchar 25 default lang of the notice
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
library_groups branchcode varchar 10  √  null The branchcode of a branch belonging to the parent group
library_groups created_on timestamp 19  √  null
library_groups description mediumtext 16777215  √  null
library_groups ft_hide_patron_info bit 0 0 Turn on the feature "Hide patron's info" for this group
library_groups ft_search_groups_opac bit 0 0 Use this group for staff side search groups
library_groups ft_search_groups_staff bit 0 0 Use this group for opac side search groups
library_groups id int 10  √ 
library_groups parent_id int 10  √  null
library_groups title varchar 100  √  null
library_groups updated_on timestamp 19 CURRENT_TIMESTAMP Date and time of last
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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  null
marc_modification_template_actions description mediumtext 16777215  √  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 mediumtext 16777215  √  null
marc_modification_template_actions to_regex_search mediumtext 16777215  √  null
marc_modification_template_actions to_subfield varchar 1  √  null
marc_modification_templates name mediumtext 16777215
marc_modification_templates template_id int 10  √ 
marc_subfield_structure authorised_value varchar 32  √  null
marc_subfield_structure authtypecode varchar 20  √  null
marc_subfield_structure defaultvalue mediumtext 16777215  √  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 ind1_defaultvalue varchar 1
marc_tag_structure ind2_defaultvalue varchar 1
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 mediumtext 16777215  √  null
message_queue content_type mediumtext 16777215  √  null
message_queue from_address longtext 2147483647  √  null
message_queue letter_code varchar 64  √  null
message_queue message_id int 10  √ 
message_queue message_transport_type varchar 20
message_queue metadata mediumtext 16777215  √  null
message_queue status enum 7 pending
message_queue subject mediumtext 16777215  √  null
message_queue time_queued timestamp 19 CURRENT_TIMESTAMP
message_queue to_address longtext 2147483647  √  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 manager_id int 10  √  null creator of message
messages message mediumtext 16777215 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 original authority record
need_merge_authorities authid_new bigint 19  √  null reference to optional new authority record
need_merge_authorities done tinyint 3  √  0
need_merge_authorities id int 10  √  unique id
need_merge_authorities reportxml mediumtext 16777215  √  null xml showing original reporting tag
need_merge_authorities timestamp timestamp 19 CURRENT_TIMESTAMP date and time last modified
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
oauth_access_tokens access_token varchar 191 generarated access token
oauth_access_tokens client_id varchar 191 the client id the access token belongs to
oauth_access_tokens expires int 10
old_issues auto_renew bit 0  √  0 automatic renewal
old_issues auto_renew_error varchar 32  √  null automatic renewal error
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 note longtext 2147483647  √  null issue note text
old_issues notedate datetime 19  √  null datetime of issue note (yyyy-mm-dd hh:mm::ss)
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 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 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 longtext 2147483647  √  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 content mediumtext 16777215 the body of your news article
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 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 32  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  null source/credit for the quote
quotes text longtext 2147483647 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
refund_lost_item_fee_rules branchcode varchar 10 the branch this rule is for (branches.branchcode)
refund_lost_item_fee_rules refund bit 0 0 control wether to refund lost item fees on return
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 mediumtext 16777215 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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 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 longtext 2147483647  √  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  √  0 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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215 the string to append to the search url to rerun the search
search_history query_desc varchar 255 the search that was performed
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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 longtext 2147483647
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 mediumtext 16777215 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 location varchar 80  √  null authorized value for the shelving location for this item (MARC21 952$c)
statistics other longtext 2147483647  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  null any irregularities in the subscription
subscription itemtype varchar 10  √  null
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 longtext 2147483647  √  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 previousitemtype varchar 10  √  null
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 mediumtext 16777215
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 mediumtext 16777215
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 mediumtext 16777215  √  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 longtext 2147483647  √  null note entered on the suggestion
suggestions patronreason mediumtext 16777215  √  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 mediumtext 16777215  √  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 mediumtext 16777215  √  null descriptive text for the system preference
systempreferences options longtext 2147483647  √  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 mediumtext 16777215  √  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 191 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 191 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 32  √  null
tmp_holdsqueue firstname mediumtext 16777215  √  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 mediumtext 16777215  √  null
tmp_holdsqueue phone mediumtext 16777215  √  null
tmp_holdsqueue pickbranch varchar 10  √  null
tmp_holdsqueue reservedate date 10  √  null
tmp_holdsqueue surname longtext 2147483647
tmp_holdsqueue title longtext 2147483647  √  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 mediumtext 16777215
uploaded_files dtcreated timestamp 19 CURRENT_TIMESTAMP
uploaded_files filename mediumtext 16777215
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 text 65535  √  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 mediumtext 16777215
vendor_edi_accounts download_directory mediumtext 16777215  √  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 mediumtext 16777215  √  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_change_from_others bit 0  √  0 can others change contents?
virtualshelves allow_change_from_owner bit 0  √  1 can owner change contents?
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 longtext 2147483647  √  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 mediumtext 16777215  √  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 longtext 2147483647 name given to the target by the library
z3950servers servertype enum 4 zed zed means z39.50 server
z3950servers sru_fields longtext 2147483647  √  null contains the mapping between the Z3950 search fields and the specific SRU server indexes
z3950servers sru_options varchar 255  √  null options like sru=get, sru_version=1.1; will be passed to the server via ZOOM
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