|
Lines 117-123
CREATE TABLE `authorised_values` ( -- stores values for authorized values catego
Link Here
|
| 117 |
DROP TABLE IF EXISTS `biblio`; |
117 |
DROP TABLE IF EXISTS `biblio`; |
| 118 |
CREATE TABLE `biblio` ( -- table that stores bibliographic information |
118 |
CREATE TABLE `biblio` ( -- table that stores bibliographic information |
| 119 |
`biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record |
119 |
`biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record |
| 120 |
`frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record |
120 |
`frameworkcode` varchar(4) NOT NULL default '', -- foreign key from the biblio_framework table to identify which framework was used in cataloging this record |
| 121 |
`author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21) |
121 |
`author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21) |
| 122 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
122 |
`title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) |
| 123 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
123 |
`unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) |
| 124 |
- |
|
|