Table testsql_comments.aqorder_users
Mapping orders to patrons for notification sending

 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
ordernumber int 10
aqorders
the order this patrons receive notifications from (aqorders.ordernumber)
borrowernumber int 10
borrowers
the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber)

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort
ordernumber + borrowernumber Primary key Asc/Asc
borrowernumber Performance Asc

Close relationships  within of separation: