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
branchtransfer_id int 10  √  primary key
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 Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: