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
additional_contents.branchcode additional_contents_branchcode_ibfkC
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
curbside_pickup_policy.branchcode curbside_pickup_policy_ibfk_1C
curbside_pickups.branchcode curbside_pickups_ibfk_1C
desks.branchcode fk_desks_branchcodeC
edifact_ean.branchcode efk_branchcodeR
hold_fill_targets.source_branchcode hold_fill_targets_ibfk_4C
identity_provider_domains.default_library_id identity_provider_domain_ibfk_2C
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
problem_reports.branchcode problem_reports_ibfk2C
recalls.pickup_library_id recalls_ibfk_4C
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

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

public BIT 0 1

whether this library should show in the opac

Indexes

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

Relationships