|
Lines 951-956
CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
Link Here
|
| 951 |
`datearrived` datetime default NULL, -- the date the transfer arrived at its destination |
951 |
`datearrived` datetime default NULL, -- the date the transfer arrived at its destination |
| 952 |
`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to |
952 |
`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to |
| 953 |
`comments` LONGTEXT, -- any comments related to the transfer |
953 |
`comments` LONGTEXT, -- any comments related to the transfer |
|
|
954 |
`reason` ENUM('Manual'), -- what triggered the transfer |
| 954 |
PRIMARY KEY (`branchtransfer_id`), |
955 |
PRIMARY KEY (`branchtransfer_id`), |
| 955 |
KEY `frombranch` (`frombranch`), |
956 |
KEY `frombranch` (`frombranch`), |
| 956 |
KEY `tobranch` (`tobranch`), |
957 |
KEY `tobranch` (`tobranch`), |
| 957 |
- |
|
|