| 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 |
|
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 |
