Lines 1-415
Link Here
|
1 |
use utf8; |
|
|
2 |
package Koha::Schema::Result::Deleteditem; |
3 |
|
4 |
# Created by DBIx::Class::Schema::Loader |
5 |
# DO NOT MODIFY THE FIRST PART OF THIS FILE |
6 |
|
7 |
=head1 NAME |
8 |
|
9 |
Koha::Schema::Result::Deleteditem |
10 |
|
11 |
=cut |
12 |
|
13 |
use strict; |
14 |
use warnings; |
15 |
|
16 |
use base 'DBIx::Class::Core'; |
17 |
|
18 |
=head1 TABLE: C<deleteditems> |
19 |
|
20 |
=cut |
21 |
|
22 |
__PACKAGE__->table("deleteditems"); |
23 |
|
24 |
=head1 ACCESSORS |
25 |
|
26 |
=head2 itemnumber |
27 |
|
28 |
data_type: 'integer' |
29 |
default_value: 0 |
30 |
is_nullable: 0 |
31 |
|
32 |
=head2 biblionumber |
33 |
|
34 |
data_type: 'integer' |
35 |
default_value: 0 |
36 |
is_nullable: 0 |
37 |
|
38 |
=head2 biblioitemnumber |
39 |
|
40 |
data_type: 'integer' |
41 |
default_value: 0 |
42 |
is_nullable: 0 |
43 |
|
44 |
=head2 barcode |
45 |
|
46 |
data_type: 'varchar' |
47 |
is_nullable: 1 |
48 |
size: 20 |
49 |
|
50 |
=head2 dateaccessioned |
51 |
|
52 |
data_type: 'date' |
53 |
datetime_undef_if_invalid: 1 |
54 |
is_nullable: 1 |
55 |
|
56 |
=head2 booksellerid |
57 |
|
58 |
data_type: 'longtext' |
59 |
is_nullable: 1 |
60 |
|
61 |
=head2 homebranch |
62 |
|
63 |
data_type: 'varchar' |
64 |
is_nullable: 1 |
65 |
size: 10 |
66 |
|
67 |
=head2 price |
68 |
|
69 |
data_type: 'decimal' |
70 |
is_nullable: 1 |
71 |
size: [8,2] |
72 |
|
73 |
=head2 replacementprice |
74 |
|
75 |
data_type: 'decimal' |
76 |
is_nullable: 1 |
77 |
size: [8,2] |
78 |
|
79 |
=head2 replacementpricedate |
80 |
|
81 |
data_type: 'date' |
82 |
datetime_undef_if_invalid: 1 |
83 |
is_nullable: 1 |
84 |
|
85 |
=head2 datelastborrowed |
86 |
|
87 |
data_type: 'date' |
88 |
datetime_undef_if_invalid: 1 |
89 |
is_nullable: 1 |
90 |
|
91 |
=head2 datelastseen |
92 |
|
93 |
data_type: 'date' |
94 |
datetime_undef_if_invalid: 1 |
95 |
is_nullable: 1 |
96 |
|
97 |
=head2 stack |
98 |
|
99 |
data_type: 'tinyint' |
100 |
is_nullable: 1 |
101 |
|
102 |
=head2 notforloan |
103 |
|
104 |
data_type: 'tinyint' |
105 |
default_value: 0 |
106 |
is_nullable: 0 |
107 |
|
108 |
=head2 damaged |
109 |
|
110 |
data_type: 'tinyint' |
111 |
default_value: 0 |
112 |
is_nullable: 0 |
113 |
|
114 |
=head2 damaged_on |
115 |
|
116 |
data_type: 'datetime' |
117 |
datetime_undef_if_invalid: 1 |
118 |
is_nullable: 1 |
119 |
|
120 |
=head2 itemlost |
121 |
|
122 |
data_type: 'tinyint' |
123 |
default_value: 0 |
124 |
is_nullable: 0 |
125 |
|
126 |
=head2 itemlost_on |
127 |
|
128 |
data_type: 'datetime' |
129 |
datetime_undef_if_invalid: 1 |
130 |
is_nullable: 1 |
131 |
|
132 |
=head2 withdrawn |
133 |
|
134 |
data_type: 'tinyint' |
135 |
default_value: 0 |
136 |
is_nullable: 0 |
137 |
|
138 |
=head2 withdrawn_on |
139 |
|
140 |
data_type: 'datetime' |
141 |
datetime_undef_if_invalid: 1 |
142 |
is_nullable: 1 |
143 |
|
144 |
=head2 itemcallnumber |
145 |
|
146 |
data_type: 'varchar' |
147 |
is_nullable: 1 |
148 |
size: 255 |
149 |
|
150 |
=head2 coded_location_qualifier |
151 |
|
152 |
data_type: 'varchar' |
153 |
is_nullable: 1 |
154 |
size: 10 |
155 |
|
156 |
=head2 issues |
157 |
|
158 |
data_type: 'smallint' |
159 |
is_nullable: 1 |
160 |
|
161 |
=head2 renewals |
162 |
|
163 |
data_type: 'smallint' |
164 |
is_nullable: 1 |
165 |
|
166 |
=head2 reserves |
167 |
|
168 |
data_type: 'smallint' |
169 |
is_nullable: 1 |
170 |
|
171 |
=head2 restricted |
172 |
|
173 |
data_type: 'tinyint' |
174 |
is_nullable: 1 |
175 |
|
176 |
=head2 itemnotes |
177 |
|
178 |
data_type: 'longtext' |
179 |
is_nullable: 1 |
180 |
|
181 |
=head2 itemnotes_nonpublic |
182 |
|
183 |
data_type: 'longtext' |
184 |
is_nullable: 1 |
185 |
|
186 |
=head2 holdingbranch |
187 |
|
188 |
data_type: 'varchar' |
189 |
is_nullable: 1 |
190 |
size: 10 |
191 |
|
192 |
=head2 paidfor |
193 |
|
194 |
data_type: 'longtext' |
195 |
is_nullable: 1 |
196 |
|
197 |
=head2 timestamp |
198 |
|
199 |
data_type: 'timestamp' |
200 |
datetime_undef_if_invalid: 1 |
201 |
default_value: current_timestamp |
202 |
is_nullable: 0 |
203 |
|
204 |
=head2 location |
205 |
|
206 |
data_type: 'varchar' |
207 |
is_nullable: 1 |
208 |
size: 80 |
209 |
|
210 |
=head2 permanent_location |
211 |
|
212 |
data_type: 'varchar' |
213 |
is_nullable: 1 |
214 |
size: 80 |
215 |
|
216 |
=head2 onloan |
217 |
|
218 |
data_type: 'date' |
219 |
datetime_undef_if_invalid: 1 |
220 |
is_nullable: 1 |
221 |
|
222 |
=head2 cn_source |
223 |
|
224 |
data_type: 'varchar' |
225 |
is_nullable: 1 |
226 |
size: 10 |
227 |
|
228 |
=head2 cn_sort |
229 |
|
230 |
data_type: 'varchar' |
231 |
is_nullable: 1 |
232 |
size: 255 |
233 |
|
234 |
=head2 ccode |
235 |
|
236 |
data_type: 'varchar' |
237 |
is_nullable: 1 |
238 |
size: 10 |
239 |
|
240 |
=head2 materials |
241 |
|
242 |
data_type: 'mediumtext' |
243 |
is_nullable: 1 |
244 |
|
245 |
=head2 uri |
246 |
|
247 |
data_type: 'varchar' |
248 |
is_nullable: 1 |
249 |
size: 255 |
250 |
|
251 |
=head2 itype |
252 |
|
253 |
data_type: 'varchar' |
254 |
is_nullable: 1 |
255 |
size: 10 |
256 |
|
257 |
=head2 more_subfields_xml |
258 |
|
259 |
data_type: 'longtext' |
260 |
is_nullable: 1 |
261 |
|
262 |
=head2 enumchron |
263 |
|
264 |
data_type: 'mediumtext' |
265 |
is_nullable: 1 |
266 |
|
267 |
=head2 copynumber |
268 |
|
269 |
data_type: 'varchar' |
270 |
is_nullable: 1 |
271 |
size: 32 |
272 |
|
273 |
=head2 stocknumber |
274 |
|
275 |
data_type: 'varchar' |
276 |
is_nullable: 1 |
277 |
size: 32 |
278 |
|
279 |
=head2 new_status |
280 |
|
281 |
data_type: 'varchar' |
282 |
is_nullable: 1 |
283 |
size: 32 |
284 |
|
285 |
=cut |
286 |
|
287 |
__PACKAGE__->add_columns( |
288 |
"itemnumber", |
289 |
{ data_type => "integer", default_value => 0, is_nullable => 0 }, |
290 |
"biblionumber", |
291 |
{ data_type => "integer", default_value => 0, is_nullable => 0 }, |
292 |
"biblioitemnumber", |
293 |
{ data_type => "integer", default_value => 0, is_nullable => 0 }, |
294 |
"barcode", |
295 |
{ data_type => "varchar", is_nullable => 1, size => 20 }, |
296 |
"dateaccessioned", |
297 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
298 |
"booksellerid", |
299 |
{ data_type => "longtext", is_nullable => 1 }, |
300 |
"homebranch", |
301 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
302 |
"price", |
303 |
{ data_type => "decimal", is_nullable => 1, size => [8, 2] }, |
304 |
"replacementprice", |
305 |
{ data_type => "decimal", is_nullable => 1, size => [8, 2] }, |
306 |
"replacementpricedate", |
307 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
308 |
"datelastborrowed", |
309 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
310 |
"datelastseen", |
311 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
312 |
"stack", |
313 |
{ data_type => "tinyint", is_nullable => 1 }, |
314 |
"notforloan", |
315 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
316 |
"damaged", |
317 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
318 |
"damaged_on", |
319 |
{ |
320 |
data_type => "datetime", |
321 |
datetime_undef_if_invalid => 1, |
322 |
is_nullable => 1, |
323 |
}, |
324 |
"itemlost", |
325 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
326 |
"itemlost_on", |
327 |
{ |
328 |
data_type => "datetime", |
329 |
datetime_undef_if_invalid => 1, |
330 |
is_nullable => 1, |
331 |
}, |
332 |
"withdrawn", |
333 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
334 |
"withdrawn_on", |
335 |
{ |
336 |
data_type => "datetime", |
337 |
datetime_undef_if_invalid => 1, |
338 |
is_nullable => 1, |
339 |
}, |
340 |
"itemcallnumber", |
341 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
342 |
"coded_location_qualifier", |
343 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
344 |
"issues", |
345 |
{ data_type => "smallint", is_nullable => 1 }, |
346 |
"renewals", |
347 |
{ data_type => "smallint", is_nullable => 1 }, |
348 |
"reserves", |
349 |
{ data_type => "smallint", is_nullable => 1 }, |
350 |
"restricted", |
351 |
{ data_type => "tinyint", is_nullable => 1 }, |
352 |
"itemnotes", |
353 |
{ data_type => "longtext", is_nullable => 1 }, |
354 |
"itemnotes_nonpublic", |
355 |
{ data_type => "longtext", is_nullable => 1 }, |
356 |
"holdingbranch", |
357 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
358 |
"paidfor", |
359 |
{ data_type => "longtext", is_nullable => 1 }, |
360 |
"timestamp", |
361 |
{ |
362 |
data_type => "timestamp", |
363 |
datetime_undef_if_invalid => 1, |
364 |
default_value => \"current_timestamp", |
365 |
is_nullable => 0, |
366 |
}, |
367 |
"location", |
368 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
369 |
"permanent_location", |
370 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
371 |
"onloan", |
372 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
373 |
"cn_source", |
374 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
375 |
"cn_sort", |
376 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
377 |
"ccode", |
378 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
379 |
"materials", |
380 |
{ data_type => "mediumtext", is_nullable => 1 }, |
381 |
"uri", |
382 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
383 |
"itype", |
384 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
385 |
"more_subfields_xml", |
386 |
{ data_type => "longtext", is_nullable => 1 }, |
387 |
"enumchron", |
388 |
{ data_type => "mediumtext", is_nullable => 1 }, |
389 |
"copynumber", |
390 |
{ data_type => "varchar", is_nullable => 1, size => 32 }, |
391 |
"stocknumber", |
392 |
{ data_type => "varchar", is_nullable => 1, size => 32 }, |
393 |
"new_status", |
394 |
{ data_type => "varchar", is_nullable => 1, size => 32 }, |
395 |
); |
396 |
|
397 |
=head1 PRIMARY KEY |
398 |
|
399 |
=over 4 |
400 |
|
401 |
=item * L</itemnumber> |
402 |
|
403 |
=back |
404 |
|
405 |
=cut |
406 |
|
407 |
__PACKAGE__->set_primary_key("itemnumber"); |
408 |
|
409 |
|
410 |
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-18 16:41:11 |
411 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xb11fPjp5PyXU7yfFWHycw |
412 |
|
413 |
|
414 |
# You can replace this text with custom content, and it will be preserved on regeneration |
415 |
1; |