Column Type Size Nulls Auto Default Children Parents Comments
branchcode VARCHAR 10
accountlines.branchcode accountlines_ibfk_branches N
aqbasket.branch aqbasket_ibfk_4 N
article_requests.branchcode article_requests_ibfk_4 N
authorised_values_branches.branchcode authorised_values_branches_ibfk_2 C
borrower_attribute_types_branches.b_branchcode borrower_attribute_types_branches_ibfk_2 C
borrowers.branchcode borrowers_ibfk_2 R
branch_borrower_circ_rules.branchcode branch_borrower_circ_rules_ibfk_2 C
branch_item_rules.branchcode branch_item_rules_ibfk_2 C
branches_overdrive.branchcode branches_overdrive_ibfk_1 C
branchtransfers.frombranch branchtransfers_ibfk_1 C
branchtransfers.tobranch branchtransfers_ibfk_2 C
categories_branches.branchcode categories_branches_ibfk_2 C
circulation_rules.branchcode circ_rules_ibfk_1 C
club_enrollments.branchcode club_enrollments_ibfk_3 N
club_templates.branchcode club_templates_ibfk_1 C
clubs.branchcode clubs_ibfk_2 R
collections.colBranchcode collections_ibfk_1 C
course_items.holdingbranch course_items_ibfk_2 C
creator_batches.branch_code creator_batches_ibfk_2 C
default_branch_circ_rules.branchcode default_branch_circ_rules_ibfk_1 C
edifact_ean.branchcode efk_branchcode R
hold_fill_targets.source_branchcode hold_fill_targets_ibfk_4 C
illrequests.branchcode illrequests_bcfk_2 C
items.holdingbranch items_ibfk_3 R
items.homebranch items_ibfk_2 R
library_groups.branchcode library_groups_ibfk_2 C
opac_news.branchcode opac_news_branchcode_ibfk C
reserves.branchcode reserves_ibfk_4 C
stockrotationstages.branchcode_id stockrotationstages_bifk C
transport_cost.frombranch transport_cost_ibfk_1 C
transport_cost.tobranch transport_cost_ibfk_2 C

a unique key assigned to each branch

branchname LONGTEXT 2147483647 null

the name of your library or branch

branchaddress1 LONGTEXT 2147483647 null

the first address line of for your library or branch

branchaddress2 LONGTEXT 2147483647 null

the second address line of for your library or branch

branchaddress3 LONGTEXT 2147483647 null

the third address line of for your library or branch

branchzip VARCHAR 25 null

the zip or postal code for your library or branch

branchcity LONGTEXT 2147483647 null

the city or province for your library or branch

branchstate LONGTEXT 2147483647 null

the state for your library or branch

branchcountry MEDIUMTEXT 16777215 null

the county for your library or branch

branchphone LONGTEXT 2147483647 null

the primary phone for your library or branch

branchfax LONGTEXT 2147483647 null

the fax number for your library or branch

branchemail LONGTEXT 2147483647 null

the primary email address for your library or branch

branchreplyto LONGTEXT 2147483647 null

the email to be used as a Reply-To

branchreturnpath LONGTEXT 2147483647 null

the email to be used as Return-Path

branchurl LONGTEXT 2147483647 null

the URL for your library or branch's website

issuing TINYINT 3 null

unused in Koha

branchip VARCHAR 15 null

the IP address for your library or branch

branchprinter VARCHAR 100 null

unused in Koha

branchnotes LONGTEXT 2147483647 null

notes related to your library or branch

opac_info MEDIUMTEXT 16777215 null

HTML that displays in OPAC

geolocation VARCHAR 255 null

geolocation of your library

marcorgcode VARCHAR 16 null

MARC Organization Code, see, when empty defaults to syspref MARCOrgCode

pickup_location BIT 0 1

the ability to act as a pickup location

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc branchcode