Lines 733-778
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
733 |
|
733 |
|
734 |
DROP TABLE IF EXISTS `deleteditems`; |
734 |
DROP TABLE IF EXISTS `deleteditems`; |
735 |
CREATE TABLE `deleteditems` ( |
735 |
CREATE TABLE `deleteditems` ( |
736 |
`itemnumber` int(11) NOT NULL default 0, |
736 |
`itemnumber` int(11) NOT NULL default 0, -- primary key and unique identifier added by Koha |
737 |
`biblionumber` int(11) NOT NULL default 0, |
737 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this item to the right bib record |
738 |
`biblioitemnumber` int(11) NOT NULL default 0, |
738 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
739 |
`barcode` varchar(20) default NULL, |
739 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
740 |
`dateaccessioned` date default NULL, |
740 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
741 |
`booksellerid` mediumtext default NULL, |
741 |
`booksellerid` mediumtext default NULL, -- where the item was purchased (MARC21 952$e) |
742 |
`homebranch` varchar(10) default NULL, |
742 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
743 |
`price` decimal(8,2) default NULL, |
743 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
744 |
`replacementprice` decimal(8,2) default NULL, |
744 |
`replacementprice` decimal(8,2) default NULL, -- cost the library charges to replace the item if it has been marked lost (MARC21 952$v) |
745 |
`replacementpricedate` date default NULL, |
745 |
`replacementpricedate` date default NULL, -- the date the price is effective from (MARC21 952$w) |
746 |
`datelastborrowed` date default NULL, |
746 |
`datelastborrowed` date default NULL, -- the date the item was last checked out |
747 |
`datelastseen` date default NULL, |
747 |
`datelastseen` date default NULL, -- the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
748 |
`stack` tinyint(1) default NULL, |
748 |
`stack` tinyint(1) default NULL, |
749 |
`notforloan` tinyint(1) NOT NULL default 0, |
749 |
`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) |
750 |
`damaged` tinyint(1) NOT NULL default 0, |
750 |
`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) |
751 |
`itemlost` tinyint(1) NOT NULL default 0, |
751 |
`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1) |
752 |
`wthdrawn` tinyint(1) NOT NULL default 0, |
752 |
`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) |
753 |
`itemcallnumber` varchar(255) default NULL, |
753 |
`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o) |
754 |
`issues` smallint(6) default NULL, |
754 |
`issues` smallint(6) default NULL, -- number of times this item has been checked out |
755 |
`renewals` smallint(6) default NULL, |
755 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
756 |
`reserves` smallint(6) default NULL, |
756 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
757 |
`restricted` tinyint(1) default NULL, |
757 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
758 |
`itemnotes` mediumtext, |
758 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
759 |
`holdingbranch` varchar(10) default NULL, |
759 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
760 |
`paidfor` mediumtext, |
760 |
`paidfor` mediumtext, |
761 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
761 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
762 |
`location` varchar(80) default NULL, |
762 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
763 |
`permanent_location` varchar(80) default NULL, |
763 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
764 |
`onloan` date default NULL, |
764 |
`onloan` date default NULL, -- defines if this item is currently checked out (1 for yes, 0 for no) |
765 |
`cn_source` varchar(10) default NULL, |
765 |
`cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) |
766 |
`cn_sort` varchar(30) default NULL, |
766 |
`cn_sort` varchar(30) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
767 |
`ccode` varchar(10) default NULL, |
767 |
`ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
768 |
`materials` varchar(10) default NULL, |
768 |
`materials` varchar(10) default NULL, -- materials specified (MARC21 952$3) |
769 |
`uri` varchar(255) default NULL, |
769 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
770 |
`itype` varchar(10) default NULL, |
770 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
771 |
`more_subfields_xml` longtext default NULL, |
771 |
`more_subfields_xml` longtext default NULL, -- additional 952 subfields in XML format |
772 |
`enumchron` text default NULL, |
772 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
773 |
`copynumber` varchar(32) default NULL, |
773 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
774 |
`stocknumber` varchar(32) default NULL, |
774 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
775 |
`marc` longblob, |
775 |
`marc` longblob, -- unused in Koha |
776 |
PRIMARY KEY (`itemnumber`), |
776 |
PRIMARY KEY (`itemnumber`), |
777 |
KEY `delitembarcodeidx` (`barcode`), |
777 |
KEY `delitembarcodeidx` (`barcode`), |
778 |
KEY `delitemstocknumberidx` (`stocknumber`), |
778 |
KEY `delitemstocknumberidx` (`stocknumber`), |
779 |
- |
|
|