Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| biblioitemnumber | INT | 10 | √ | null |
|
|
primary key, unique identifier assigned by Koha |
||||
| biblionumber | INT | 10 | 0 |
|
|
foreign key linking this table to the biblio table |
|||||
| volume | LONGTEXT | 2147483647 | √ | NULL |
|
|
|||||
| number | LONGTEXT | 2147483647 | √ | NULL |
|
|
|||||
| itemtype | VARCHAR | 10 | √ | NULL |
|
|
biblio level item type (MARC21 942$c) |
||||
| isbn | LONGTEXT | 2147483647 | √ | NULL |
|
|
ISBN (MARC21 020$a) |
||||
| issn | LONGTEXT | 2147483647 | √ | NULL |
|
|
ISSN (MARC21 022$a) |
||||
| ean | LONGTEXT | 2147483647 | √ | NULL |
|
|
|||||
| publicationyear | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
|||||
| publishercode | TEXT | 65535 | √ | NULL |
|
|
publisher (MARC21 260$b and 264$b) |
||||
| volumedate | DATE | 10 | √ | NULL |
|
|
|||||
| volumedesc | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
volume information (MARC21 362$a) |
||||
| collectiontitle | LONGTEXT | 2147483647 | √ | NULL |
|
|
|||||
| collectionissn | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
|||||
| collectionvolume | LONGTEXT | 2147483647 | √ | NULL |
|
|
|||||
| editionstatement | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
|||||
| editionresponsibility | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
|||||
| timestamp | TIMESTAMP | 19 | current_timestamp() |
|
|
||||||
| illus | TEXT | 65535 | √ | NULL |
|
|
illustrations (MARC21 300$b) |
||||
| pages | TEXT | 65535 | √ | NULL |
|
|
number of pages (MARC21 300$a) |
||||
| notes | LONGTEXT | 2147483647 | √ | NULL |
|
|
|||||
| size | TEXT | 65535 | √ | NULL |
|
|
material size (MARC21 300$c) |
||||
| place | TEXT | 65535 | √ | NULL |
|
|
publication place (MARC21 260$a and 264$a) |
||||
| lccn | LONGTEXT | 2147483647 | √ | NULL |
|
|
library of congress control number (MARC21 010$a) |
||||
| url | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
url (MARC21 856$u) |
||||
| cn_source | VARCHAR | 10 | √ | NULL |
|
|
classification source (MARC21 942$2) |
||||
| cn_class | VARCHAR | 30 | √ | NULL |
|
|
|||||
| cn_item | VARCHAR | 10 | √ | NULL |
|
|
|||||
| cn_suffix | VARCHAR | 10 | √ | NULL |
|
|
|||||
| cn_sort | VARCHAR | 255 | √ | NULL |
|
|
normalized version of the call number used for sorting |
||||
| agerestriction | VARCHAR | 255 | √ | NULL |
|
|
target audience/age restriction from the bib record (MARC21 521$a) |
||||
| totalissues | INT | 10 | √ | NULL |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| biblioitems_s_pk | Primary key | Asc | biblioitemnumber |
| bibinoidx | Performance | Asc | biblioitemnumber |
| bibnoidx | Performance | Asc | biblionumber |
| ean | Performance | Asc | ean |
| isbn | Performance | Asc | isbn |
| issn | Performance | Asc | issn |
| itemtype_idx | Performance | Asc | itemtype |
| PRIMARY | Must be unique | Asc | biblioitemnumber |
| publishercode | Performance | Asc | publishercode |
| timestamp | Performance | Asc | timestamp |
Relationships
Close relationships within degrees of separation
