Table testsql_comments.branchrelations
this table links libraries/branches to groups

 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
branches
foreign key from the branches table to identify the branch
categorycode varchar 10
branchcategories
foreign key from the branchcategories table to identify the group

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort
branchcode + categorycode Primary key Asc/Asc
branchcode Performance Asc
categorycode Performance Asc

Close relationships  within of separation: