Table testsql_comments.branches Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
branchcode varchar 10
aqbasket.branch aqbasket_ibfk_4 N
article_requests.branchcode article_requests_ibfk_4 N
authorised_values_branches.branchcode authorised_values_branches_ibfk_2 C
borrower_attribute_types_branches.b_branchcode borrower_attribute_types_branches_ibfk_2 C
borrowers.branchcode borrowers_ibfk_2 R
branch_borrower_circ_rules.branchcode branch_borrower_circ_rules_ibfk_2 C
branch_item_rules.branchcode branch_item_rules_ibfk_2 C
branchtransfers.frombranch branchtransfers_ibfk_1 C
branchtransfers.tobranch branchtransfers_ibfk_2 C
categories_branches.branchcode categories_branches_ibfk_2 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
creator_batches.branch_code creator_batches_ibfk_2 C
default_branch_circ_rules.branchcode default_branch_circ_rules_ibfk_1 C
edifact_ean.branchcode efk_branchcode R
hold_fill_targets.source_branchcode hold_fill_targets_ibfk_4 C
illrequests.branchcode illrequests_bcfk_2 C
items.holdingbranch items_ibfk_3 R
items.homebranch items_ibfk_2 R
library_groups.branchcode library_groups_ibfk_2 C
opac_news.branchcode opac_news_branchcode_ibfk C
reserves.branchcode reserves_ibfk_4 C
transport_cost.frombranch transport_cost_ibfk_1 C
transport_cost.tobranch transport_cost_ibfk_2 C
refund_lost_item_fee_rules.branchcode Implied Constraint R
a unique key assigned to each branch
branchname longtext 2147483647 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
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
branchprinter varchar 100  √  null unused in Koha
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

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: