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

Close relationships within degrees of separation