subscriptionroutinglist


Columns

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

Indexes

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

Relationships

Close relationships within degrees of separation