Lines 121-127
CREATE TABLE `biblio` ( -- table that stores bibliographic information
Link Here
|
121 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
121 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
122 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
122 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
123 |
`notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
123 |
`notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
124 |
`serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table |
124 |
`serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial |
125 |
`seriestitle` mediumtext, |
125 |
`seriestitle` mediumtext, |
126 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
126 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
127 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
127 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
Lines 710-716
CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records
Link Here
|
710 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
710 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
711 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
711 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
712 |
`notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
712 |
`notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) |
713 |
`serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table |
713 |
`serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial |
714 |
`seriestitle` mediumtext, |
714 |
`seriestitle` mediumtext, |
715 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
715 |
`copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record |
716 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
716 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
717 |
- |
|
|