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

Return to bug 34142