Lines 639-645
CREATE TABLE `deleteditems` (
Link Here
|
639 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
639 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
640 |
`ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
640 |
`ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
641 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
641 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
642 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
642 |
`uri` MEDIUMTEXT default NULL, -- URL for the item (MARC21 952$u) |
643 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
643 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
644 |
`more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format |
644 |
`more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format |
645 |
`enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
645 |
`enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
Lines 844-850
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
844 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
844 |
`cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting |
845 |
`ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
845 |
`ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) |
846 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
846 |
`materials` MEDIUMTEXT default NULL, -- materials specified (MARC21 952$3) |
847 |
`uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u) |
847 |
`uri` MEDIUMTEXT default NULL, -- URL for the item (MARC21 952$u) |
848 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
848 |
`itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
849 |
`more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format |
849 |
`more_subfields_xml` LONGTEXT default NULL, -- additional 952 subfields in XML format |
850 |
`enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
850 |
`enumchron` MEDIUMTEXT default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
851 |
- |
|
|