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