Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
Table
testsql_comments
.
notifys
Generated by
SchemaSpy
Implied relationships
Related columns
Constraints
Comments
Legend
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
<
n
> number of related tables
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
notify_id
int
10
0
borrowernumber
int
10
0
patronimage
.borrowernumber
Implied Constraint
R
itemnumber
int
10
0
hold_fill_targets
.itemnumber
Implied Constraint
R
notify_date
date
10
√
null
notify_send_date
date
10
√
null
notify_level
int
10
0
method
varchar
20
Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016
Close relationships: