Lines 862-867
CREATE TABLE `deleteditems` (
Link Here
|
862 |
`replacementpricedate` date default NULL, -- the date the price is effective from (MARC21 952$w) |
862 |
`replacementpricedate` date default NULL, -- the date the price is effective from (MARC21 952$w) |
863 |
`datelastborrowed` date default NULL, -- the date the item was last checked out |
863 |
`datelastborrowed` date default NULL, -- the date the item was last checked out |
864 |
`datelastseen` date default NULL, -- the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
864 |
`datelastseen` date default NULL, -- the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
|
|
865 |
`last_returned_by` int(11) DEFAULT NULL, -- the last borrower to return an item |
865 |
`stack` tinyint(1) default NULL, |
866 |
`stack` tinyint(1) default NULL, |
866 |
`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) |
867 |
`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) |
867 |
`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) |
868 |
`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) |
Lines 899-904
CREATE TABLE `deleteditems` (
Link Here
|
899 |
KEY `delhomebranch` (`homebranch`), |
900 |
KEY `delhomebranch` (`homebranch`), |
900 |
KEY `delholdingbranch` (`holdingbranch`), |
901 |
KEY `delholdingbranch` (`holdingbranch`), |
901 |
KEY `itype_idx` (`itype`) |
902 |
KEY `itype_idx` (`itype`) |
|
|
903 |
KEY `del_last_returned_by` (`last_returned_by`) |
902 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
904 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
903 |
|
905 |
|
904 |
-- |
906 |
-- |
Lines 1154-1159
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1154 |
`replacementpricedate` date default NULL, -- the date the price is effective from (MARC21 952$w) |
1156 |
`replacementpricedate` date default NULL, -- the date the price is effective from (MARC21 952$w) |
1155 |
`datelastborrowed` date default NULL, -- the date the item was last checked out/issued |
1157 |
`datelastborrowed` date default NULL, -- the date the item was last checked out/issued |
1156 |
`datelastseen` date default NULL, -- the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
1158 |
`datelastseen` date default NULL, -- the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
|
|
1159 |
`last_returned_by` int(11) DEFAULT NULL, -- the last borrower to return an item |
1157 |
`stack` tinyint(1) default NULL, |
1160 |
`stack` tinyint(1) default NULL, |
1158 |
`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) |
1161 |
`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) |
1159 |
`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) |
1162 |
`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) |
Lines 1193-1198
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1193 |
KEY `items_location` (`location`), |
1196 |
KEY `items_location` (`location`), |
1194 |
KEY `items_ccode` (`ccode`), |
1197 |
KEY `items_ccode` (`ccode`), |
1195 |
KEY `itype_idx` (`itype`), |
1198 |
KEY `itype_idx` (`itype`), |
|
|
1199 |
KEY `last_returned_by` (`last_returned_by`), |
1196 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1200 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1197 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
1201 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
1198 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE |
1202 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE |