|
Lines 439-450
CREATE TABLE `branchrelations` ( -- this table links libraries/branches to group
Link Here
|
| 439 |
|
439 |
|
| 440 |
DROP TABLE IF EXISTS `branchtransfers`; |
440 |
DROP TABLE IF EXISTS `branchtransfers`; |
| 441 |
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches |
441 |
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches |
|
|
442 |
`branchtransfer_id` int(12) NOT NULL auto_increment, -- primary key |
| 442 |
`itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber) |
443 |
`itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber) |
| 443 |
`datesent` datetime default NULL, -- the date the transfer was initialized |
444 |
`datesent` datetime default NULL, -- the date the transfer was initialized |
| 444 |
`frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from |
445 |
`frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from |
| 445 |
`datearrived` datetime default NULL, -- the date the transfer arrived at its destination |
446 |
`datearrived` datetime default NULL, -- the date the transfer arrived at its destination |
| 446 |
`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to |
447 |
`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to |
| 447 |
`comments` mediumtext, -- any comments related to the transfer |
448 |
`comments` mediumtext, -- any comments related to the transfer |
|
|
449 |
PRIMARY KEY (`branchtransfer_id`), |
| 448 |
KEY `frombranch` (`frombranch`), |
450 |
KEY `frombranch` (`frombranch`), |
| 449 |
KEY `tobranch` (`tobranch`), |
451 |
KEY `tobranch` (`tobranch`), |
| 450 |
KEY `itemnumber` (`itemnumber`), |
452 |
KEY `itemnumber` (`itemnumber`), |