Attachment #157300 for bug #34142

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




  default_value: 0
  is_nullable: 0

primary key and unique identifier added by Koha

=head2 biblionumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

foreign key from biblio table used to link this item to the right bib record

=head2 biblioitemnumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

foreign key from the biblioitems table to link to item to additional information

=head2 barcode

  data_type: 'varchar'
  is_nullable: 1
  size: 20

item barcode (MARC21 952$p)

=head2 dateaccessioned

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the item was acquired or added to Koha (MARC21 952$d)

=head2 booksellerid

  data_type: 'longtext'
  is_nullable: 1

where the item was purchased (MARC21 952$e)

=head2 homebranch

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key from the branches table for the library that owns this item (MARC21 952$a)

=head2 price

  data_type: 'decimal'
  is_nullable: 1
  size: [8,2]

purchase price (MARC21 952$g)

=head2 replacementprice

  data_type: 'decimal'
  is_nullable: 1
  size: [8,2]

cost the library charges to replace the item if it has been marked lost (MARC21 952$v)

=head2 replacementpricedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the price is effective from (MARC21 952$w)

=head2 datelastborrowed

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the item was last checked out

=head2 datelastseen

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the item was last see (usually the last time the barcode was scanned or inventory was done)

=head2 stack

  data_type: 'tinyint'

  default_value: 0
  is_nullable: 0

authorized value defining why this item is not for loan (MARC21 952$7)

=head2 damaged

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as damaged (MARC21 952$4)

=head2 damaged_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as damaged, NULL if not damaged

=head2 itemlost

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as lost (MARC21 952$1)

=head2 itemlost_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as lost, NULL if not lost

=head2 withdrawn

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as withdrawn (MARC21 952$0)

=head2 withdrawn_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as withdrawn, NULL if not withdrawn

=head2 itemcallnumber

  data_type: 'varchar'
  is_nullable: 1
  size: 255

call number for this item (MARC21 952$o)

=head2 coded_location_qualifier

  data_type: 'varchar'
  is_nullable: 1
  size: 10

coded location qualifier(MARC21 952$f)

=head2 issues

  data_type: 'smallint'
  default_value: 0
  is_nullable: 1

number of times this item has been checked out

=head2 renewals

  data_type: 'smallint'
  is_nullable: 1

number of times this item has been renewed

=head2 reserves

  data_type: 'smallint'
  is_nullable: 1

number of times this item has been placed on hold/reserved

=head2 restricted

  data_type: 'tinyint'
  is_nullable: 1

authorized value defining use restrictions for this item (MARC21 952$5)

=head2 itemnotes

  data_type: 'longtext'
  is_nullable: 1

public notes on this item (MARC21 952$z)

=head2 itemnotes_nonpublic

  data_type: 'longtext'
  is_nullable: 1

non-public notes on this item (MARC21 952$x)

=head2 holdingbranch

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)

=head2 timestamp

  data_type: 'timestamp'

  default_value: current_timestamp
  is_nullable: 0

date and time this item was last altered

=head2 deleted_on

  data_type: 'datetime'

  is_nullable: 1
  size: 80

authorized value for the shelving location for this item (MARC21 952$c)

=head2 permanent_location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

=head2 sub_location

  data_type: 'varchar'
  is_nullable: 1
  size: 10

=head2 onloan


  datetime_undef_if_invalid: 1
  is_nullable: 1

defines if item is checked out (NULL for not checked out, and due date for checked out)

=head2 cn_source

  data_type: 'varchar'
  is_nullable: 1
  size: 10

classification source used on this item (MARC21 952$2)

=head2 cn_sort

  data_type: 'varchar'
  is_nullable: 1
  size: 255

normalized form of the call number (MARC21 952$o) used for sorting

=head2 ccode

  data_type: 'varchar'
  is_nullable: 1
  size: 80

authorized value for the collection code associated with this item (MARC21 952$8)

=head2 materials

  data_type: 'mediumtext'
  is_nullable: 1

materials specified (MARC21 952$3)

=head2 uri

  data_type: 'mediumtext'
  is_nullable: 1

URL for the item (MARC21 952$u)

=head2 itype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

=head2 more_subfields_xml

  data_type: 'longtext'
  is_nullable: 1

additional 952 subfields in XML format

=head2 enumchron

  data_type: 'mediumtext'
  is_nullable: 1

serial enumeration/chronology for the item (MARC21 952$h)

=head2 copynumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

copy number (MARC21 952$t)

=head2 stocknumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

inventory number (MARC21 952$i)

=head2 new_status

  data_type: 'varchar'
  is_nullable: 1
  size: 32

'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.

=head2 exclude_from_local_holds_priority

  data_type: 'tinyint'
  is_nullable: 1

Exclude this item from local holds priority

=cut

__PACKAGE__->add_columns(

  { data_type => "varchar", is_nullable => 1, size => 80 },
  "permanent_location",
  { data_type => "varchar", is_nullable => 1, size => 80 },
  "sub_location",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "onloan",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "cn_source",

__PACKAGE__->set_primary_key("itemnumber");


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-17 14:37:52
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HU9jxoKR5UQnUr8OQ9Uppg

__PACKAGE__->add_columns(
    '+exclude_from_local_holds_priority' => { is_boolean => 1 },




  is_auto_increment: 1
  is_nullable: 0

primary key and unique identifier added by Koha

=head2 biblionumber

  data_type: 'integer'

  is_foreign_key: 1
  is_nullable: 0

foreign key from biblio table used to link this item to the right bib record

=head2 biblioitemnumber

  data_type: 'integer'

  is_foreign_key: 1
  is_nullable: 0

foreign key from the biblioitems table to link to item to additional information

=head2 barcode

  data_type: 'varchar'
  is_nullable: 1
  size: 20

item barcode (MARC21 952$p)

=head2 dateaccessioned

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the item was acquired or added to Koha (MARC21 952$d)

=head2 booksellerid

  data_type: 'longtext'
  is_nullable: 1

where the item was purchased (MARC21 952$e)

=head2 homebranch

  data_type: 'varchar'

  is_nullable: 1
  size: 10

foreign key from the branches table for the library that owns this item (MARC21 952$a)

=head2 price

  data_type: 'decimal'
  is_nullable: 1
  size: [8,2]

purchase price (MARC21 952$g)

=head2 replacementprice

  data_type: 'decimal'
  is_nullable: 1
  size: [8,2]

cost the library charges to replace the item if it has been marked lost (MARC21 952$v)

=head2 replacementpricedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the price is effective from (MARC21 952$w)

=head2 datelastborrowed

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the item was last checked out/issued

=head2 datelastseen

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the item was last see (usually the last time the barcode was scanned or inventory was done)

=head2 stack

  data_type: 'tinyint'

  default_value: 0
  is_nullable: 0

authorized value defining why this item is not for loan (MARC21 952$7)

=head2 damaged

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as damaged (MARC21 952$4)

=head2 damaged_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as damaged, NULL if not damaged

=head2 itemlost

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as lost (MARC21 952$1)

=head2 itemlost_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as lost, NULL if not lost

=head2 withdrawn

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as withdrawn (MARC21 952$0)

=head2 withdrawn_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as withdrawn, NULL if not withdrawn

=head2 itemcallnumber

  data_type: 'varchar'
  is_nullable: 1
  size: 255

call number for this item (MARC21 952$o)

=head2 coded_location_qualifier

  data_type: 'varchar'
  is_nullable: 1
  size: 10

coded location qualifier(MARC21 952$f)

=head2 issues

  data_type: 'smallint'
  default_value: 0
  is_nullable: 1

number of times this item has been checked out/issued

=head2 renewals

  data_type: 'smallint'
  is_nullable: 1

number of times this item has been renewed

=head2 reserves

  data_type: 'smallint'
  is_nullable: 1

number of times this item has been placed on hold/reserved

=head2 restricted

  data_type: 'tinyint'
  is_nullable: 1

authorized value defining use restrictions for this item (MARC21 952$5)

=head2 itemnotes

  data_type: 'longtext'
  is_nullable: 1

public notes on this item (MARC21 952$z)

=head2 itemnotes_nonpublic

  data_type: 'longtext'
  is_nullable: 1

non-public notes on this item (MARC21 952$x)

=head2 holdingbranch

  data_type: 'varchar'

  is_nullable: 1
  size: 10

foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)

=head2 timestamp

  data_type: 'timestamp'

  default_value: current_timestamp
  is_nullable: 0

date and time this item was last altered

=head2 deleted_on

  data_type: 'datetime'

  is_nullable: 1
  size: 80

authorized value for the shelving location for this item (MARC21 952$c)

=head2 permanent_location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

=head2 sub_location

  data_type: 'varchar'
  is_nullable: 1
  size: 10

=head2 onloan


  datetime_undef_if_invalid: 1
  is_nullable: 1

defines if item is checked out (NULL for not checked out, and due date for checked out)

=head2 cn_source

  data_type: 'varchar'
  is_nullable: 1
  size: 10

classification source used on this item (MARC21 952$2)

=head2 cn_sort

  data_type: 'varchar'
  is_nullable: 1
  size: 255

normalized form of the call number (MARC21 952$o) used for sorting

=head2 ccode

  data_type: 'varchar'
  is_nullable: 1
  size: 80

authorized value for the collection code associated with this item (MARC21 952$8)

=head2 materials

  data_type: 'mediumtext'
  is_nullable: 1

materials specified (MARC21 952$3)

=head2 uri

  data_type: 'mediumtext'
  is_nullable: 1

URL for the item (MARC21 952$u)

=head2 itype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

=head2 more_subfields_xml

  data_type: 'longtext'
  is_nullable: 1

additional 952 subfields in XML format

=head2 enumchron

  data_type: 'mediumtext'
  is_nullable: 1

serial enumeration/chronology for the item (MARC21 952$h)

=head2 copynumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

copy number (MARC21 952$t)

=head2 stocknumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

inventory number (MARC21 952$i)

=head2 new_status

  data_type: 'varchar'
  is_nullable: 1
  size: 32

'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.

=head2 exclude_from_local_holds_priority

  data_type: 'tinyint'
  is_nullable: 1

Exclude this item from local holds priority

=cut

__PACKAGE__->add_columns(

  { data_type => "varchar", is_nullable => 1, size => 80 },
  "permanent_location",
  { data_type => "varchar", is_nullable => 1, size => 80 },
  "sub_location",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "onloan",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "cn_source",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-17 14:44:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hDg9F34X/pDlWz0K6L447g

__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );

- 

Return to bug 34142

Lines 29-123 __PACKAGE__->table("deleteditems"); Link Here

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

Lines 29-36 __PACKAGE__->table("items"); Link Here

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