items
| 欄位 | 型態 | 範例 |
| itemnumber | int(11) | |
| biblionumber | int(11) | |
| multivolumepart | varchar(30) | |
| biblioitemnumber | int(11) | |
| barcode | varchar(20) | |
| dateaccessioned | date | |
| booksellerid | varchar(10) | |
| homebranch | varchar(255) | |
| price | decimal(8,2) | |
| replacementprice | decimal(8,2) | |
| replacementpricedate | date | |
| datelastborrowed | date | |
| datelastseen | date | |
| multivolume | tinyint(1) | |
| stack | tinyint(1) | |
| notforloan | tinyint(1) | |
| itemlost | tinyint(1) | |
| wthdrawn | tinyint(1) | |
| itemcallnumber | varchar(30) | |
| issues | smallint(6) | |
| renewals | smallint(6) | |
| reserves | smallint(6) | |
| restricted | tinyint(1) | |
| binding | decimal(28,6) | |
| itemnotes | text | |
| holdingbranch | varchar(255) | |
| paidfor | text | |
| timestamp | timestamp | |
| location | varchar(80) | |
| cmarcclass | varchar(30) | |
| cmarcbook | varchar(30) | |
| marc21class | varchar(30) | |
| marc21item | varchar(30) | |
| cmarcplaces | varchar(255) |
