Table testsql_comments.subscriptionroutinglist
information related to the routing lists attached to subscriptions

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
routingid int 10  √  unique identifier assigned by Koha
borrowernumber int 10
borrowers
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
foreign key from the subscription table, defines which subscription this routing list is for

Table contained 0 rows at Tue Dec 27 17:18 NZDT 2016

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

Close relationships  within of separation: