Table testsql_comments.subscriptionroutinglist 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
routingid int 10  √  unique identifier assigned by Koha
borrowernumber int 10
borrowers.borrowernumber subscriptionroutinglist_ibfk_1 C
foreign key from the borrowers table, defines with patron is on the routing list
ranking int 10  √  null where the patron stands in line to receive the serial
subscriptionid int 10
subscription.subscriptionid subscriptionroutinglist_ibfk_2 C
foreign key from the subscription table, defines which subscription this routing list is for

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

Indexes:
Column(s) Type Sort Constraint Name
routingid Primary key Asc PRIMARY
subscriptionid + borrowernumber Must be unique Asc/Asc subscriptionid
borrowernumber Performance Asc subscriptionroutinglist_ibfk_1

Close relationships  within of separation: