Column Type Size Nulls Auto Default Children Parents Comments
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

Table contained 0 rows


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