routingid |
INT |
10 |
|
√ |
null |
|
|
unique identifier assigned by Koha |
borrowernumber |
INT |
10 |
|
|
null |
|
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 |
|
|
null |
|
subscription.subscriptionid
|
subscriptionroutinglist_ibfk_2 C
|
|
foreign key from the subscription table, defines which subscription this routing list is for |