Table testsql_comments.branchtransfers
information for items that are in transit between branches

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
itemnumber int 10 0
items
the itemnumber that it is in transit (items.itemnumber)
datesent datetime 19  √  null the date the transfer was initialized
frombranch varchar 10
branches
the branch the transfer is coming from
datearrived datetime 19  √  null the date the transfer arrived at its destination
tobranch varchar 10
branches
the branch the transfer was going to
comments mediumtext 16777215  √  null any comments related to the transfer

Table contained 0 rows at Tue Dec 27 17:18 NZDT 2016

Indexes:
Column(s) Type Sort
frombranch Performance Asc
itemnumber Performance Asc
tobranch Performance Asc

Close relationships  within of separation: