branchtransfers

0 rows


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)
daterequested TIMESTAMP 19 current_timestamp()

the date the transfer was requested
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
datecancelled DATETIME 19 √ NULL

the date the transfer was cancelled
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', 'TransferCancellation', 'Recall', 'RecallCancellation') 25 √ NULL

what triggered the transfer
cancellation_reason enum('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'ItemLost', 'WrongTransfer', 'RecallCancellation') 25 √ NULL

what triggered the transfer cancellation

Indexes

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

Relationships

Close relationships within degrees of separation