Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
biblioitemnumber | INT | 10 | 0 |
|
|
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) |
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 |
itemtype_idx | Performance | Asc | itemtype |
publishercode | Performance | Asc | publishercode |
timestamp | Performance | Asc | timestamp |