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 Tue Dec 27 17:18 NZDT 2016

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

Close relationships  within of separation: