aqorder_users

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ordernumber INT 10 null
aqorders.ordernumber aqorder_users_ibfk_1C

the order this patrons receive notifications from (aqorders.ordernumber)

borrowernumber INT 10 null
borrowers.borrowernumber aqorder_users_ibfk_2C

the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ordernumber + borrowernumber
aqorder_users_ibfk_2 Performance Asc borrowernumber

Relationships