branches

12 rows


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
additional_contents.branchcode additional_contents_branchcode_ibfk C
aqbasket.branch aqbasket_ibfk_4 N
article_requests.branchcode article_requests_ibfk_4 N
authorised_values_branches.branchcode authorised_values_branches_ibfk_2 C
bookings.pickup_library_id bookings_ibfk_4 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
curbside_pickup_policy.branchcode curbside_pickup_policy_ibfk_1 C
curbside_pickups.branchcode curbside_pickups_ibfk_1 C
desks.branchcode fk_desks_branchcode C
edifact_ean.branchcode efk_branchcode R
hold_fill_targets.source_branchcode hold_fill_targets_ibfk_4 C
identity_provider_domains.default_library_id identity_provider_domain_ibfk_2 C
illbatches.library_id illbatches_bcfk N
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
library_hours.library_id library_hours C
library_smtp_servers.library_id library_smtp_servers_library_fk C
old_reserves.branchcode old_reserves_ibfk_branchcode N
problem_reports.branchcode problem_reports_ibfk2 C
recalls.pickup_library_id recalls_ibfk_4 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
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
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 BOOLEAN 3 1

the ability to act as a pickup location
public BOOLEAN 3 1

whether this library should show in the opac
opacuserjs LONGTEXT 2147483647 √ NULL

branch specific javascript for the OPAC
opacusercss LONGTEXT 2147483647 √ NULL

branch specific css for the OPAC

Indexes

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

Relationships

Close relationships within degrees of separation