Lines 29-60
__PACKAGE__->table("deleteditems");
Link Here
|
29 |
default_value: 0 |
29 |
default_value: 0 |
30 |
is_nullable: 0 |
30 |
is_nullable: 0 |
31 |
|
31 |
|
32 |
primary key and unique identifier added by Koha |
|
|
33 |
|
34 |
=head2 biblionumber |
32 |
=head2 biblionumber |
35 |
|
33 |
|
36 |
data_type: 'integer' |
34 |
data_type: 'integer' |
37 |
default_value: 0 |
35 |
default_value: 0 |
38 |
is_nullable: 0 |
36 |
is_nullable: 0 |
39 |
|
37 |
|
40 |
foreign key from biblio table used to link this item to the right bib record |
|
|
41 |
|
42 |
=head2 biblioitemnumber |
38 |
=head2 biblioitemnumber |
43 |
|
39 |
|
44 |
data_type: 'integer' |
40 |
data_type: 'integer' |
45 |
default_value: 0 |
41 |
default_value: 0 |
46 |
is_nullable: 0 |
42 |
is_nullable: 0 |
47 |
|
43 |
|
48 |
foreign key from the biblioitems table to link to item to additional information |
|
|
49 |
|
50 |
=head2 barcode |
44 |
=head2 barcode |
51 |
|
45 |
|
52 |
data_type: 'varchar' |
46 |
data_type: 'varchar' |
53 |
is_nullable: 1 |
47 |
is_nullable: 1 |
54 |
size: 20 |
48 |
size: 20 |
55 |
|
49 |
|
56 |
item barcode (MARC21 952$p) |
|
|
57 |
|
58 |
=head2 bookable |
50 |
=head2 bookable |
59 |
|
51 |
|
60 |
data_type: 'tinyint' |
52 |
data_type: 'tinyint' |
Lines 69-131
boolean value defining whether this item is available for bookings or not
Link Here
|
69 |
datetime_undef_if_invalid: 1 |
61 |
datetime_undef_if_invalid: 1 |
70 |
is_nullable: 1 |
62 |
is_nullable: 1 |
71 |
|
63 |
|
72 |
date the item was acquired or added to Koha (MARC21 952$d) |
|
|
73 |
|
74 |
=head2 booksellerid |
64 |
=head2 booksellerid |
75 |
|
65 |
|
76 |
data_type: 'longtext' |
66 |
data_type: 'longtext' |
77 |
is_nullable: 1 |
67 |
is_nullable: 1 |
78 |
|
68 |
|
79 |
where the item was purchased (MARC21 952$e) |
|
|
80 |
|
81 |
=head2 homebranch |
69 |
=head2 homebranch |
82 |
|
70 |
|
83 |
data_type: 'varchar' |
71 |
data_type: 'varchar' |
84 |
is_nullable: 1 |
72 |
is_nullable: 1 |
85 |
size: 10 |
73 |
size: 10 |
86 |
|
74 |
|
87 |
foreign key from the branches table for the library that owns this item (MARC21 952$a) |
|
|
88 |
|
89 |
=head2 price |
75 |
=head2 price |
90 |
|
76 |
|
91 |
data_type: 'decimal' |
77 |
data_type: 'decimal' |
92 |
is_nullable: 1 |
78 |
is_nullable: 1 |
93 |
size: [8,2] |
79 |
size: [8,2] |
94 |
|
80 |
|
95 |
purchase price (MARC21 952$g) |
|
|
96 |
|
97 |
=head2 replacementprice |
81 |
=head2 replacementprice |
98 |
|
82 |
|
99 |
data_type: 'decimal' |
83 |
data_type: 'decimal' |
100 |
is_nullable: 1 |
84 |
is_nullable: 1 |
101 |
size: [8,2] |
85 |
size: [8,2] |
102 |
|
86 |
|
103 |
cost the library charges to replace the item if it has been marked lost (MARC21 952$v) |
|
|
104 |
|
105 |
=head2 replacementpricedate |
87 |
=head2 replacementpricedate |
106 |
|
88 |
|
107 |
data_type: 'date' |
89 |
data_type: 'date' |
108 |
datetime_undef_if_invalid: 1 |
90 |
datetime_undef_if_invalid: 1 |
109 |
is_nullable: 1 |
91 |
is_nullable: 1 |
110 |
|
92 |
|
111 |
the date the price is effective from (MARC21 952$w) |
|
|
112 |
|
113 |
=head2 datelastborrowed |
93 |
=head2 datelastborrowed |
114 |
|
94 |
|
115 |
data_type: 'date' |
95 |
data_type: 'date' |
116 |
datetime_undef_if_invalid: 1 |
96 |
datetime_undef_if_invalid: 1 |
117 |
is_nullable: 1 |
97 |
is_nullable: 1 |
118 |
|
98 |
|
119 |
the date the item was last checked out |
|
|
120 |
|
121 |
=head2 datelastseen |
99 |
=head2 datelastseen |
122 |
|
100 |
|
123 |
data_type: 'datetime' |
101 |
data_type: 'datetime' |
124 |
datetime_undef_if_invalid: 1 |
102 |
datetime_undef_if_invalid: 1 |
125 |
is_nullable: 1 |
103 |
is_nullable: 1 |
126 |
|
104 |
|
127 |
the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
|
|
128 |
|
129 |
=head2 stack |
105 |
=head2 stack |
130 |
|
106 |
|
131 |
data_type: 'tinyint' |
107 |
data_type: 'tinyint' |
Lines 137-216
the date the item was last see (usually the last time the barcode was scanned or
Link Here
|
137 |
default_value: 0 |
113 |
default_value: 0 |
138 |
is_nullable: 0 |
114 |
is_nullable: 0 |
139 |
|
115 |
|
140 |
authorized value defining why this item is not for loan (MARC21 952$7) |
|
|
141 |
|
142 |
=head2 damaged |
116 |
=head2 damaged |
143 |
|
117 |
|
144 |
data_type: 'tinyint' |
118 |
data_type: 'tinyint' |
145 |
default_value: 0 |
119 |
default_value: 0 |
146 |
is_nullable: 0 |
120 |
is_nullable: 0 |
147 |
|
121 |
|
148 |
authorized value defining this item as damaged (MARC21 952$4) |
|
|
149 |
|
150 |
=head2 damaged_on |
122 |
=head2 damaged_on |
151 |
|
123 |
|
152 |
data_type: 'datetime' |
124 |
data_type: 'datetime' |
153 |
datetime_undef_if_invalid: 1 |
125 |
datetime_undef_if_invalid: 1 |
154 |
is_nullable: 1 |
126 |
is_nullable: 1 |
155 |
|
127 |
|
156 |
the date and time an item was last marked as damaged, NULL if not damaged |
|
|
157 |
|
158 |
=head2 itemlost |
128 |
=head2 itemlost |
159 |
|
129 |
|
160 |
data_type: 'tinyint' |
130 |
data_type: 'tinyint' |
161 |
default_value: 0 |
131 |
default_value: 0 |
162 |
is_nullable: 0 |
132 |
is_nullable: 0 |
163 |
|
133 |
|
164 |
authorized value defining this item as lost (MARC21 952$1) |
|
|
165 |
|
166 |
=head2 itemlost_on |
134 |
=head2 itemlost_on |
167 |
|
135 |
|
168 |
data_type: 'datetime' |
136 |
data_type: 'datetime' |
169 |
datetime_undef_if_invalid: 1 |
137 |
datetime_undef_if_invalid: 1 |
170 |
is_nullable: 1 |
138 |
is_nullable: 1 |
171 |
|
139 |
|
172 |
the date and time an item was last marked as lost, NULL if not lost |
|
|
173 |
|
174 |
=head2 withdrawn |
140 |
=head2 withdrawn |
175 |
|
141 |
|
176 |
data_type: 'tinyint' |
142 |
data_type: 'tinyint' |
177 |
default_value: 0 |
143 |
default_value: 0 |
178 |
is_nullable: 0 |
144 |
is_nullable: 0 |
179 |
|
145 |
|
180 |
authorized value defining this item as withdrawn (MARC21 952$0) |
|
|
181 |
|
182 |
=head2 withdrawn_on |
146 |
=head2 withdrawn_on |
183 |
|
147 |
|
184 |
data_type: 'datetime' |
148 |
data_type: 'datetime' |
185 |
datetime_undef_if_invalid: 1 |
149 |
datetime_undef_if_invalid: 1 |
186 |
is_nullable: 1 |
150 |
is_nullable: 1 |
187 |
|
151 |
|
188 |
the date and time an item was last marked as withdrawn, NULL if not withdrawn |
|
|
189 |
|
190 |
=head2 itemcallnumber |
152 |
=head2 itemcallnumber |
191 |
|
153 |
|
192 |
data_type: 'varchar' |
154 |
data_type: 'varchar' |
193 |
is_nullable: 1 |
155 |
is_nullable: 1 |
194 |
size: 255 |
156 |
size: 255 |
195 |
|
157 |
|
196 |
call number for this item (MARC21 952$o) |
|
|
197 |
|
198 |
=head2 coded_location_qualifier |
158 |
=head2 coded_location_qualifier |
199 |
|
159 |
|
200 |
data_type: 'varchar' |
160 |
data_type: 'varchar' |
201 |
is_nullable: 1 |
161 |
is_nullable: 1 |
202 |
size: 10 |
162 |
size: 10 |
203 |
|
163 |
|
204 |
coded location qualifier(MARC21 952$f) |
|
|
205 |
|
206 |
=head2 issues |
164 |
=head2 issues |
207 |
|
165 |
|
208 |
data_type: 'smallint' |
166 |
data_type: 'smallint' |
209 |
default_value: 0 |
167 |
default_value: 0 |
210 |
is_nullable: 1 |
168 |
is_nullable: 1 |
211 |
|
169 |
|
212 |
number of times this item has been checked out |
|
|
213 |
|
214 |
=head2 renewals |
170 |
=head2 renewals |
215 |
|
171 |
|
216 |
data_type: 'smallint' |
172 |
data_type: 'smallint' |
Lines 230-266
number of times this item has been recorded as localuse
Link Here
|
230 |
data_type: 'smallint' |
186 |
data_type: 'smallint' |
231 |
is_nullable: 1 |
187 |
is_nullable: 1 |
232 |
|
188 |
|
233 |
number of times this item has been placed on hold/reserved |
|
|
234 |
|
235 |
=head2 restricted |
189 |
=head2 restricted |
236 |
|
190 |
|
237 |
data_type: 'tinyint' |
191 |
data_type: 'tinyint' |
238 |
is_nullable: 1 |
192 |
is_nullable: 1 |
239 |
|
193 |
|
240 |
authorized value defining use restrictions for this item (MARC21 952$5) |
|
|
241 |
|
242 |
=head2 itemnotes |
194 |
=head2 itemnotes |
243 |
|
195 |
|
244 |
data_type: 'longtext' |
196 |
data_type: 'longtext' |
245 |
is_nullable: 1 |
197 |
is_nullable: 1 |
246 |
|
198 |
|
247 |
public notes on this item (MARC21 952$z) |
|
|
248 |
|
249 |
=head2 itemnotes_nonpublic |
199 |
=head2 itemnotes_nonpublic |
250 |
|
200 |
|
251 |
data_type: 'longtext' |
201 |
data_type: 'longtext' |
252 |
is_nullable: 1 |
202 |
is_nullable: 1 |
253 |
|
203 |
|
254 |
non-public notes on this item (MARC21 952$x) |
|
|
255 |
|
256 |
=head2 holdingbranch |
204 |
=head2 holdingbranch |
257 |
|
205 |
|
258 |
data_type: 'varchar' |
206 |
data_type: 'varchar' |
259 |
is_nullable: 1 |
207 |
is_nullable: 1 |
260 |
size: 10 |
208 |
size: 10 |
261 |
|
209 |
|
262 |
foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
|
|
263 |
|
264 |
=head2 timestamp |
210 |
=head2 timestamp |
265 |
|
211 |
|
266 |
data_type: 'timestamp' |
212 |
data_type: 'timestamp' |
Lines 268-275
foreign key from the branches table for the library that is currently in possess
Link Here
|
268 |
default_value: current_timestamp |
214 |
default_value: current_timestamp |
269 |
is_nullable: 0 |
215 |
is_nullable: 0 |
270 |
|
216 |
|
271 |
date and time this item was last altered |
|
|
272 |
|
273 |
=head2 deleted_on |
217 |
=head2 deleted_on |
274 |
|
218 |
|
275 |
data_type: 'datetime' |
219 |
data_type: 'datetime' |
Lines 284-298
date/time of deletion
Link Here
|
284 |
is_nullable: 1 |
228 |
is_nullable: 1 |
285 |
size: 80 |
229 |
size: 80 |
286 |
|
230 |
|
287 |
authorized value for the shelving location for this item (MARC21 952$c) |
|
|
288 |
|
289 |
=head2 permanent_location |
231 |
=head2 permanent_location |
290 |
|
232 |
|
291 |
data_type: 'varchar' |
233 |
data_type: 'varchar' |
292 |
is_nullable: 1 |
234 |
is_nullable: 1 |
293 |
size: 80 |
235 |
size: 80 |
294 |
|
236 |
|
295 |
linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
237 |
=head2 sub_location |
|
|
238 |
|
239 |
data_type: 'varchar' |
240 |
is_nullable: 1 |
241 |
size: 80 |
296 |
|
242 |
|
297 |
=head2 onloan |
243 |
=head2 onloan |
298 |
|
244 |
|
Lines 300-398
linked to the CART and PROC temporary locations feature, stores the permanent sh
Link Here
|
300 |
datetime_undef_if_invalid: 1 |
246 |
datetime_undef_if_invalid: 1 |
301 |
is_nullable: 1 |
247 |
is_nullable: 1 |
302 |
|
248 |
|
303 |
defines if item is checked out (NULL for not checked out, and due date for checked out) |
|
|
304 |
|
305 |
=head2 cn_source |
249 |
=head2 cn_source |
306 |
|
250 |
|
307 |
data_type: 'varchar' |
251 |
data_type: 'varchar' |
308 |
is_nullable: 1 |
252 |
is_nullable: 1 |
309 |
size: 10 |
253 |
size: 10 |
310 |
|
254 |
|
311 |
classification source used on this item (MARC21 952$2) |
|
|
312 |
|
313 |
=head2 cn_sort |
255 |
=head2 cn_sort |
314 |
|
256 |
|
315 |
data_type: 'varchar' |
257 |
data_type: 'varchar' |
316 |
is_nullable: 1 |
258 |
is_nullable: 1 |
317 |
size: 255 |
259 |
size: 255 |
318 |
|
260 |
|
319 |
normalized form of the call number (MARC21 952$o) used for sorting |
|
|
320 |
|
321 |
=head2 ccode |
261 |
=head2 ccode |
322 |
|
262 |
|
323 |
data_type: 'varchar' |
263 |
data_type: 'varchar' |
324 |
is_nullable: 1 |
264 |
is_nullable: 1 |
325 |
size: 80 |
265 |
size: 80 |
326 |
|
266 |
|
327 |
authorized value for the collection code associated with this item (MARC21 952$8) |
|
|
328 |
|
329 |
=head2 materials |
267 |
=head2 materials |
330 |
|
268 |
|
331 |
data_type: 'mediumtext' |
269 |
data_type: 'mediumtext' |
332 |
is_nullable: 1 |
270 |
is_nullable: 1 |
333 |
|
271 |
|
334 |
materials specified (MARC21 952$3) |
|
|
335 |
|
336 |
=head2 uri |
272 |
=head2 uri |
337 |
|
273 |
|
338 |
data_type: 'mediumtext' |
274 |
data_type: 'mediumtext' |
339 |
is_nullable: 1 |
275 |
is_nullable: 1 |
340 |
|
276 |
|
341 |
URL for the item (MARC21 952$u) |
|
|
342 |
|
343 |
=head2 itype |
277 |
=head2 itype |
344 |
|
278 |
|
345 |
data_type: 'varchar' |
279 |
data_type: 'varchar' |
346 |
is_nullable: 1 |
280 |
is_nullable: 1 |
347 |
size: 10 |
281 |
size: 10 |
348 |
|
282 |
|
349 |
foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
|
|
350 |
|
351 |
=head2 more_subfields_xml |
283 |
=head2 more_subfields_xml |
352 |
|
284 |
|
353 |
data_type: 'longtext' |
285 |
data_type: 'longtext' |
354 |
is_nullable: 1 |
286 |
is_nullable: 1 |
355 |
|
287 |
|
356 |
additional 952 subfields in XML format |
|
|
357 |
|
358 |
=head2 enumchron |
288 |
=head2 enumchron |
359 |
|
289 |
|
360 |
data_type: 'mediumtext' |
290 |
data_type: 'mediumtext' |
361 |
is_nullable: 1 |
291 |
is_nullable: 1 |
362 |
|
292 |
|
363 |
serial enumeration/chronology for the item (MARC21 952$h) |
|
|
364 |
|
365 |
=head2 copynumber |
293 |
=head2 copynumber |
366 |
|
294 |
|
367 |
data_type: 'varchar' |
295 |
data_type: 'varchar' |
368 |
is_nullable: 1 |
296 |
is_nullable: 1 |
369 |
size: 32 |
297 |
size: 32 |
370 |
|
298 |
|
371 |
copy number (MARC21 952$t) |
|
|
372 |
|
373 |
=head2 stocknumber |
299 |
=head2 stocknumber |
374 |
|
300 |
|
375 |
data_type: 'varchar' |
301 |
data_type: 'varchar' |
376 |
is_nullable: 1 |
302 |
is_nullable: 1 |
377 |
size: 32 |
303 |
size: 32 |
378 |
|
304 |
|
379 |
inventory number (MARC21 952$i) |
|
|
380 |
|
381 |
=head2 new_status |
305 |
=head2 new_status |
382 |
|
306 |
|
383 |
data_type: 'varchar' |
307 |
data_type: 'varchar' |
384 |
is_nullable: 1 |
308 |
is_nullable: 1 |
385 |
size: 32 |
309 |
size: 32 |
386 |
|
310 |
|
387 |
'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
|
|
388 |
|
389 |
=head2 exclude_from_local_holds_priority |
311 |
=head2 exclude_from_local_holds_priority |
390 |
|
312 |
|
391 |
data_type: 'tinyint' |
313 |
data_type: 'tinyint' |
392 |
is_nullable: 1 |
314 |
is_nullable: 1 |
393 |
|
315 |
|
394 |
Exclude this item from local holds priority |
|
|
395 |
|
396 |
=cut |
316 |
=cut |
397 |
|
317 |
|
398 |
__PACKAGE__->add_columns( |
318 |
__PACKAGE__->add_columns( |
Lines 491-496
__PACKAGE__->add_columns(
Link Here
|
491 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
411 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
492 |
"permanent_location", |
412 |
"permanent_location", |
493 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
413 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
|
|
414 |
"sub_location", |
415 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
494 |
"onloan", |
416 |
"onloan", |
495 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
417 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
496 |
"cn_source", |
418 |
"cn_source", |