Table testsql_comments.aqorders_items Generated by
SchemaSpy
Legend: SourceForge.net
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
ordernumber int 10
aqorders.ordernumber aqorders_items_ibfk_1 C
the order this item is attached to (aqorders.ordernumber)
itemnumber int 10
hold_fill_targets.itemnumber Implied Constraint R
the item number for this item (items.itemnumber)
timestamp timestamp 19 CURRENT_TIMESTAMP the date and time this order item was last touched

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
itemnumber Primary key Asc PRIMARY
ordernumber Performance Asc ordernumber

Close relationships  within of separation: