Column Type Size Nulls Auto Default Children Parents Comments
branchtransfer_id INT 10 null

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 LONGTEXT 2147483647 null

any comments related to the transfer

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc branchtransfer_id
frombranch Performance Asc frombranch
itemnumber Performance Asc itemnumber
tobranch Performance Asc tobranch