branches


Columns

Column Type Size Nulls Auto Default Children Parents Comments
branchcode VARCHAR 10
account_credit_types_branches.branchcode account_credit_types_branches_ibfk_2 C
account_debit_types_branches.branchcode account_debit_types_branches_ibfk_2 C
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
branches_overdrive.branchcode branches_overdrive_ibfk_1 C
branchtransfers.frombranch branchtransfers_ibfk_1 C
branchtransfers.tobranch branchtransfers_ibfk_2 C
cash_registers.branch cash_registers_branch 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
course_items.homebranch fk_course_items_homebranch C
course_items.homebranch_storage fk_course_items_homebranch_storage C
creator_batches.branch_code creator_batches_ibfk_2 C
desks.branchcode fk_desks_branchcode 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
itemtypes_branches.branchcode itemtypes_branches_ibfk_2 C
library_groups.branchcode library_groups_ibfk_2 C
opac_news.branchcode opac_news_branchcode_ibfk C
problem_reports.branchcode problem_reports_ibfk2 C
repeatable_holidays.branchcode repeatable_holidays_ibfk_1 C
reserves.branchcode reserves_ibfk_4 C
special_holidays.branchcode special_holidays_ibfk_1 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

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