Table testsql_comments.branches
information about your libraries or branches are stored here

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
branchcode varchar 10
aqbasket
article_requests
authorised_values_branches
borrower_attribute_types_branches
borrowers
branch_borrower_circ_rules
branch_item_rules
branchrelations
branchtransfers
branchtransfers
categories_branches
club_enrollments
club_templates
clubs
collections
course_items
creator_batches
default_branch_circ_rules
edifact_ean
hold_fill_targets
items
items
opac_news
reserves
transport_cost
transport_cost
a unique key assigned to each branch
branchname mediumtext 16777215 the name of your library or branch
branchaddress1 mediumtext 16777215  √  null the first address line of for your library or branch
branchaddress2 mediumtext 16777215  √  null the second address line of for your library or branch
branchaddress3 mediumtext 16777215  √  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 mediumtext 16777215  √  null the city or province for your library or branch
branchstate mediumtext 16777215  √  null the state for your library or branch
branchcountry text 65535  √  null the county for your library or branch
branchphone mediumtext 16777215  √  null the primary phone for your library or branch
branchfax mediumtext 16777215  √  null the fax number for your library or branch
branchemail mediumtext 16777215  √  null the primary email address for your library or branch
branchreplyto mediumtext 16777215  √  null the email to be used as a Reply-To
branchreturnpath mediumtext 16777215  √  null the email to be used as Return-Path
branchurl mediumtext 16777215  √  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
branchprinter varchar 100  √  null unused in Koha
branchnotes mediumtext 16777215  √  null notes related to your library or branch
opac_info text 65535  √  null HTML that displays in OPAC
geolocation varchar 255  √  null geolocation of your library

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort
branchcode Primary key Asc

Close relationships  within of separation: