branches

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
branchcode VARCHAR 10
account_credit_types_branches.branchcode account_credit_types_branches_ibfk_2C
account_debit_types_branches.branchcode account_debit_types_branches_ibfk_2C
accountlines.branchcode accountlines_ibfk_branchesN
aqbasket.branch aqbasket_ibfk_4N
article_requests.branchcode article_requests_ibfk_4N
authorised_values_branches.branchcode authorised_values_branches_ibfk_2C
borrower_attribute_types_branches.b_branchcode borrower_attribute_types_branches_ibfk_2C
borrowers.branchcode borrowers_ibfk_2R
branches_overdrive.branchcode branches_overdrive_ibfk_1C
branchtransfers.frombranch branchtransfers_ibfk_1C
branchtransfers.tobranch branchtransfers_ibfk_2C
cash_registers.branch cash_registers_branchC
categories_branches.branchcode categories_branches_ibfk_2C
circulation_rules.branchcode circ_rules_ibfk_1C
club_enrollments.branchcode club_enrollments_ibfk_3N
club_templates.branchcode club_templates_ibfk_1C
clubs.branchcode clubs_ibfk_2R
collections.colBranchcode collections_ibfk_1C
course_items.holdingbranch course_items_ibfk_2C
course_items.homebranch fk_course_items_homebranchC
course_items.homebranch_storage fk_course_items_homebranch_storageC
creator_batches.branch_code creator_batches_ibfk_2C
desks.branchcode fk_desks_branchcodeC
edifact_ean.branchcode efk_branchcodeR
hold_fill_targets.source_branchcode hold_fill_targets_ibfk_4C
illrequests.branchcode illrequests_bcfk_2C
items.holdingbranch items_ibfk_3R
items.homebranch items_ibfk_2R
itemtypes_branches.branchcode itemtypes_branches_ibfk_2C
library_groups.branchcode library_groups_ibfk_2C
library_smtp_servers.library_id library_smtp_servers_library_fkC
opac_news.branchcode opac_news_branchcode_ibfkC
problem_reports.branchcode problem_reports_ibfk2C
pseudonymized_transactions.branchcode pseudonymized_transactions_borrowers_ibfk_2R
pseudonymized_transactions.transaction_branchcode pseudonymized_transactions_borrowers_ibfk_3R
repeatable_holidays.branchcode repeatable_holidays_ibfk_1C
reserves.branchcode reserves_ibfk_4C
special_holidays.branchcode special_holidays_ibfk_1C
stockrotationstages.branchcode_id stockrotationstages_bifkC
suggestions.branchcode suggestions_ibfk_branchcodeN
transport_cost.frombranch transport_cost_ibfk_1C
transport_cost.tobranch transport_cost_ibfk_2C

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

branchillemail LONGTEXT 2147483647 null

the ILL staff 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

Indexes

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

Relationships