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 | VARCHAR | 255 | √ | null |
|
|
publisher (MARC21 260$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 | VARCHAR | 255 | √ | null |
|
|
illustrations (MARC21 300$b) |
|||
| pages | VARCHAR | 255 | √ | null |
|
|
number of pages (MARC21 300$c) |
|||
| notes | LONGTEXT | 2147483647 | √ | null |
|
|
||||
| size | VARCHAR | 255 | √ | null |
|
|
material size (MARC21 300$c) |
|||
| place | VARCHAR | 255 | √ | null |
|
|
publication place (MARC21 260$a) |
|||
| lccn | VARCHAR | 25 | √ | 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) |
|---|---|---|---|
| PRIMARY | 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 |
| publishercode | Performance | Asc | publishercode |
| timestamp | Performance | Asc | timestamp |
Relationships
Close relationships within degrees of separation
