Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
biblioitemnumber |
int |
10 |
|
√ |
|
items.biblioitemnumber
|
items_ibfk_1 C |
|
|
biblionumber |
int |
10 |
|
|
0 |
|
biblio.biblionumber
|
biblioitems_ibfk_1 C |
|
volume |
mediumtext |
16777215 |
√ |
|
null |
|
|
number |
mediumtext |
16777215 |
√ |
|
null |
|
|
itemtype |
varchar |
10 |
√ |
|
null |
|
|
isbn |
mediumtext |
16777215 |
√ |
|
null |
|
|
issn |
mediumtext |
16777215 |
√ |
|
null |
|
|
ean |
varchar |
13 |
√ |
|
null |
|
|
publicationyear |
text |
65535 |
√ |
|
null |
|
|
publishercode |
varchar |
255 |
√ |
|
null |
|
|
volumedate |
date |
10 |
√ |
|
null |
|
|
volumedesc |
text |
65535 |
√ |
|
null |
|
|
collectiontitle |
mediumtext |
16777215 |
√ |
|
null |
|
|
collectionissn |
text |
65535 |
√ |
|
null |
|
|
collectionvolume |
mediumtext |
16777215 |
√ |
|
null |
|
|
editionstatement |
text |
65535 |
√ |
|
null |
|
|
editionresponsibility |
text |
65535 |
√ |
|
null |
|
|
timestamp |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
illus |
varchar |
255 |
√ |
|
null |
|
|
pages |
varchar |
255 |
√ |
|
null |
|
|
notes |
mediumtext |
16777215 |
√ |
|
null |
|
|
size |
varchar |
255 |
√ |
|
null |
|
|
place |
varchar |
255 |
√ |
|
null |
|
|
lccn |
varchar |
25 |
√ |
|
null |
|
|
marc |
longblob |
2147483647 |
√ |
|
null |
|
|
url |
text |
65535 |
√ |
|
null |
|
|
cn_source |
varchar |
10 |
√ |
|
null |
|
|
cn_class |
varchar |
30 |
√ |
|
null |
|
|
cn_item |
varchar |
10 |
√ |
|
null |
|
|
cn_suffix |
varchar |
10 |
√ |
|
null |
|
|
cn_sort |
varchar |
255 |
√ |
|
null |
|
|
agerestriction |
varchar |
255 |
√ |
|
null |
|
|
totalissues |
int |
10 |
√ |
|
null |
|
|
marcxml |
longtext |
2147483647 |
√ |
|
null |
|
|
Table contained 0 rows at Tue Dec 27 16:10 NZDT 2016
|