branches


Columns

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_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
suggestions.branchcode suggestions_ibfk_branchcode N
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 http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
pickup_location BIT 0 1

the ability to act as a pickup location

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation