|
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 |
- |
|
|