View | Details | Raw Unified | Return to bug 34142
Collapse All | Expand All

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

Return to bug 34142