branchtransfers


Columns

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
reason enum('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve') 25 √ null

what triggered the transfer

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation