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
Implied relationships
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.itemnumber branchtransfers_ibfk_3 C
the itemnumber that it is in transit (items.itemnumber)
datesent datetime 19  √  null the date the transfer was initialized
frombranch varchar 10
branches.branchcode branchtransfers_ibfk_1 C
the branch the transfer is coming from
datearrived datetime 19  √  null the date the transfer arrived at its destination
tobranch varchar 10
branches.branchcode branchtransfers_ibfk_2 C
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 Constraint Name
branchtransfer_id Primary key Asc PRIMARY
frombranch Performance Asc frombranch
itemnumber Performance Asc itemnumber
tobranch Performance Asc tobranch

Close relationships  within of separation: