Table testsql_comments.aqorders_items
information on items entered in the acquisitions process

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 item is attached to (aqorders.ordernumber)
itemnumber int 10
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 Tue Dec 27 17:18 NZDT 2016

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

Close relationships  within of separation: