Attachment #164877 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 bookable

  data_type: 'tinyint'

  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: 80

=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 => 80 },
  "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-11-24 14:12:38
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VQ+9kNL/sX6fAbtY9NW8ZQ

__PACKAGE__->add_columns(
    '+bookable'                          => { 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 bookable

  data_type: 'tinyint'

  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: 80

=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 => 80 },
  "onloan",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "cn_source",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-24 14:12:38
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X1201tjCWPb5wFpL/fir6A

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

- 

Return to bug 34142

Lines 29-60 __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 bookable	50	=head2 bookable
59		51
60	data_type: 'tinyint'	52	data_type: 'tinyint'
Lines 69-131 boolean value defining whether this 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-259 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'
217	is_nullable: 1	173	is_nullable: 1
218		174
219	number of times this item has been renewed
220
221	=head2 reserves	175	=head2 reserves
222		176
223	data_type: 'smallint'	177	data_type: 'smallint'
224	is_nullable: 1	178	is_nullable: 1
225		179
226	number of times this item has been placed on hold/reserved
227
228	=head2 restricted	180	=head2 restricted
229		181
230	data_type: 'tinyint'	182	data_type: 'tinyint'
231	is_nullable: 1	183	is_nullable: 1
232		184
233	authorized value defining use restrictions for this item (MARC21 952$5)
234
235	=head2 itemnotes	185	=head2 itemnotes
236		186
237	data_type: 'longtext'	187	data_type: 'longtext'
238	is_nullable: 1	188	is_nullable: 1
239		189
240	public notes on this item (MARC21 952$z)
241
242	=head2 itemnotes_nonpublic	190	=head2 itemnotes_nonpublic
243		191
244	data_type: 'longtext'	192	data_type: 'longtext'
245	is_nullable: 1	193	is_nullable: 1
246		194
247	non-public notes on this item (MARC21 952$x)
248
249	=head2 holdingbranch	195	=head2 holdingbranch
250		196
251	data_type: 'varchar'	197	data_type: 'varchar'
252	is_nullable: 1	198	is_nullable: 1
253	size: 10	199	size: 10
254		200
255	foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
256
257	=head2 timestamp	201	=head2 timestamp
258		202
259	data_type: 'timestamp'	203	data_type: 'timestamp'
Lines 261-268 foreign key from the branches table for the library that is currently in possess Link Here
261	default_value: current_timestamp	205	default_value: current_timestamp
262	is_nullable: 0	206	is_nullable: 0
263		207
264	date and time this item was last altered
265
266	=head2 deleted_on	208	=head2 deleted_on
267		209
268	data_type: 'datetime'	210	data_type: 'datetime'
Lines 277-291 date/time of deletion Link Here
277	is_nullable: 1	219	is_nullable: 1
278	size: 80	220	size: 80
279		221
280	authorized value for the shelving location for this item (MARC21 952$c)
281
282	=head2 permanent_location	222	=head2 permanent_location
283		223
284	data_type: 'varchar'	224	data_type: 'varchar'
285	is_nullable: 1	225	is_nullable: 1
286	size: 80	226	size: 80
287		227
288	linked to the CART and PROC temporary locations feature, stores the permanent shelving location	228	=head2 sub_location
		229
		230	data_type: 'varchar'
		231	is_nullable: 1
		232	size: 80
289		233
290	=head2 onloan	234	=head2 onloan
291		235
Lines 293-391 linked to the CART and PROC temporary locations feature, stores the permanent sh Link Here
293	datetime_undef_if_invalid: 1	237	datetime_undef_if_invalid: 1
294	is_nullable: 1	238	is_nullable: 1
295		239
296	defines if item is checked out (NULL for not checked out, and due date for checked out)
297
298	=head2 cn_source	240	=head2 cn_source
299		241
300	data_type: 'varchar'	242	data_type: 'varchar'
301	is_nullable: 1	243	is_nullable: 1
302	size: 10	244	size: 10
303		245
304	classification source used on this item (MARC21 952$2)
305
306	=head2 cn_sort	246	=head2 cn_sort
307		247
308	data_type: 'varchar'	248	data_type: 'varchar'
309	is_nullable: 1	249	is_nullable: 1
310	size: 255	250	size: 255
311		251
312	normalized form of the call number (MARC21 952$o) used for sorting
313
314	=head2 ccode	252	=head2 ccode
315		253
316	data_type: 'varchar'	254	data_type: 'varchar'
317	is_nullable: 1	255	is_nullable: 1
318	size: 80	256	size: 80
319		257
320	authorized value for the collection code associated with this item (MARC21 952$8)
321
322	=head2 materials	258	=head2 materials
323		259
324	data_type: 'mediumtext'	260	data_type: 'mediumtext'
325	is_nullable: 1	261	is_nullable: 1
326		262
327	materials specified (MARC21 952$3)
328
329	=head2 uri	263	=head2 uri
330		264
331	data_type: 'mediumtext'	265	data_type: 'mediumtext'
332	is_nullable: 1	266	is_nullable: 1
333		267
334	URL for the item (MARC21 952$u)
335
336	=head2 itype	268	=head2 itype
337		269
338	data_type: 'varchar'	270	data_type: 'varchar'
339	is_nullable: 1	271	is_nullable: 1
340	size: 10	272	size: 10
341		273
342	foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
343
344	=head2 more_subfields_xml	274	=head2 more_subfields_xml
345		275
346	data_type: 'longtext'	276	data_type: 'longtext'
347	is_nullable: 1	277	is_nullable: 1
348		278
349	additional 952 subfields in XML format
350
351	=head2 enumchron	279	=head2 enumchron
352		280
353	data_type: 'mediumtext'	281	data_type: 'mediumtext'
354	is_nullable: 1	282	is_nullable: 1
355		283
356	serial enumeration/chronology for the item (MARC21 952$h)
357
358	=head2 copynumber	284	=head2 copynumber
359		285
360	data_type: 'varchar'	286	data_type: 'varchar'
361	is_nullable: 1	287	is_nullable: 1
362	size: 32	288	size: 32
363		289
364	copy number (MARC21 952$t)
365
366	=head2 stocknumber	290	=head2 stocknumber
367		291
368	data_type: 'varchar'	292	data_type: 'varchar'
369	is_nullable: 1	293	is_nullable: 1
370	size: 32	294	size: 32
371		295
372	inventory number (MARC21 952$i)
373
374	=head2 new_status	296	=head2 new_status
375		297
376	data_type: 'varchar'	298	data_type: 'varchar'
377	is_nullable: 1	299	is_nullable: 1
378	size: 32	300	size: 32
379		301
380	'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
381
382	=head2 exclude_from_local_holds_priority	302	=head2 exclude_from_local_holds_priority
383		303
384	data_type: 'tinyint'	304	data_type: 'tinyint'
385	is_nullable: 1	305	is_nullable: 1
386		306
387	Exclude this item from local holds priority
388
389	=cut	307	=cut
390		308
391	__PACKAGE__->add_columns(	309	__PACKAGE__->add_columns(
Lines 482-487 __PACKAGE__->add_columns( Link Here
482	{ data_type => "varchar", is_nullable => 1, size => 80 },	400	{ data_type => "varchar", is_nullable => 1, size => 80 },
483	"permanent_location",	401	"permanent_location",
484	{ data_type => "varchar", is_nullable => 1, size => 80 },	402	{ data_type => "varchar", is_nullable => 1, size => 80 },
		403	"sub_location",
		404	{ data_type => "varchar", is_nullable => 1, size => 80 },
485	"onloan",	405	"onloan",
486	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	406	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
487	"cn_source",	407	"cn_source",
Lines 523-530 __PACKAGE__->add_columns( Link Here
523	__PACKAGE__->set_primary_key("itemnumber");	443	__PACKAGE__->set_primary_key("itemnumber");
524		444
525		445
526	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-02 11:06:29	446	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-24 14:12:38
527	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Afgr1jl6aeSy/rS9RJGq2g	447	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VQ+9kNL/sX6fAbtY9NW8ZQ
528		448
529	__PACKAGE__->add_columns(	449	__PACKAGE__->add_columns(
530	'+bookable' => { is_boolean => 1 },	450	'+bookable' => { 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-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 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-254 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'
220	is_nullable: 1	176	is_nullable: 1
221		177
222	number of times this item has been renewed
223
224	=head2 reserves	178	=head2 reserves
225		179
226	data_type: 'smallint'	180	data_type: 'smallint'
227	is_nullable: 1	181	is_nullable: 1
228		182
229	number of times this item has been placed on hold/reserved
230
231	=head2 restricted	183	=head2 restricted
232		184
233	data_type: 'tinyint'	185	data_type: 'tinyint'
234	is_nullable: 1	186	is_nullable: 1
235		187
236	authorized value defining use restrictions for this item (MARC21 952$5)
237
238	=head2 itemnotes	188	=head2 itemnotes
239		189
240	data_type: 'longtext'	190	data_type: 'longtext'
241	is_nullable: 1	191	is_nullable: 1
242		192
243	public notes on this item (MARC21 952$z)
244
245	=head2 itemnotes_nonpublic	193	=head2 itemnotes_nonpublic
246		194
247	data_type: 'longtext'	195	data_type: 'longtext'
248	is_nullable: 1	196	is_nullable: 1
249		197
250	non-public notes on this item (MARC21 952$x)
251
252	=head2 holdingbranch	198	=head2 holdingbranch
253		199
254	data_type: 'varchar'	200	data_type: 'varchar'
Lines 256-263 non-public notes on this item (MARC21 952$x) Link Here
256	is_nullable: 1	202	is_nullable: 1
257	size: 10	203	size: 10
258		204
259	foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
260
261	=head2 timestamp	205	=head2 timestamp
262		206
263	data_type: 'timestamp'	207	data_type: 'timestamp'
Lines 265-272 foreign key from the branches table for the library that is currently in possess Link Here
265	default_value: current_timestamp	209	default_value: current_timestamp
266	is_nullable: 0	210	is_nullable: 0
267		211
268	date and time this item was last altered
269
270	=head2 deleted_on	212	=head2 deleted_on
271		213
272	data_type: 'datetime'	214	data_type: 'datetime'
Lines 281-295 date/time of deletion Link Here
281	is_nullable: 1	223	is_nullable: 1
282	size: 80	224	size: 80
283		225
284	authorized value for the shelving location for this item (MARC21 952$c)
285
286	=head2 permanent_location	226	=head2 permanent_location
287		227
288	data_type: 'varchar'	228	data_type: 'varchar'
289	is_nullable: 1	229	is_nullable: 1
290	size: 80	230	size: 80
291		231
292	linked to the CART and PROC temporary locations feature, stores the permanent shelving location	232	=head2 sub_location
		233
		234	data_type: 'varchar'
		235	is_nullable: 1
		236	size: 80
293		237
294	=head2 onloan	238	=head2 onloan
295		239
Lines 297-395 linked to the CART and PROC temporary locations feature, stores the permanent sh Link Here
297	datetime_undef_if_invalid: 1	241	datetime_undef_if_invalid: 1
298	is_nullable: 1	242	is_nullable: 1
299		243
300	defines if item is checked out (NULL for not checked out, and due date for checked out)
301
302	=head2 cn_source	244	=head2 cn_source
303		245
304	data_type: 'varchar'	246	data_type: 'varchar'
305	is_nullable: 1	247	is_nullable: 1
306	size: 10	248	size: 10
307		249
308	classification source used on this item (MARC21 952$2)
309
310	=head2 cn_sort	250	=head2 cn_sort
311		251
312	data_type: 'varchar'	252	data_type: 'varchar'
313	is_nullable: 1	253	is_nullable: 1
314	size: 255	254	size: 255
315		255
316	normalized form of the call number (MARC21 952$o) used for sorting
317
318	=head2 ccode	256	=head2 ccode
319		257
320	data_type: 'varchar'	258	data_type: 'varchar'
321	is_nullable: 1	259	is_nullable: 1
322	size: 80	260	size: 80
323		261
324	authorized value for the collection code associated with this item (MARC21 952$8)
325
326	=head2 materials	262	=head2 materials
327		263
328	data_type: 'mediumtext'	264	data_type: 'mediumtext'
329	is_nullable: 1	265	is_nullable: 1
330		266
331	materials specified (MARC21 952$3)
332
333	=head2 uri	267	=head2 uri
334		268
335	data_type: 'mediumtext'	269	data_type: 'mediumtext'
336	is_nullable: 1	270	is_nullable: 1
337		271
338	URL for the item (MARC21 952$u)
339
340	=head2 itype	272	=head2 itype
341		273
342	data_type: 'varchar'	274	data_type: 'varchar'
343	is_nullable: 1	275	is_nullable: 1
344	size: 10	276	size: 10
345		277
346	foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
347
348	=head2 more_subfields_xml	278	=head2 more_subfields_xml
349		279
350	data_type: 'longtext'	280	data_type: 'longtext'
351	is_nullable: 1	281	is_nullable: 1
352		282
353	additional 952 subfields in XML format
354
355	=head2 enumchron	283	=head2 enumchron
356		284
357	data_type: 'mediumtext'	285	data_type: 'mediumtext'
358	is_nullable: 1	286	is_nullable: 1
359		287
360	serial enumeration/chronology for the item (MARC21 952$h)
361
362	=head2 copynumber	288	=head2 copynumber
363		289
364	data_type: 'varchar'	290	data_type: 'varchar'
365	is_nullable: 1	291	is_nullable: 1
366	size: 32	292	size: 32
367		293
368	copy number (MARC21 952$t)
369
370	=head2 stocknumber	294	=head2 stocknumber
371		295
372	data_type: 'varchar'	296	data_type: 'varchar'
373	is_nullable: 1	297	is_nullable: 1
374	size: 32	298	size: 32
375		299
376	inventory number (MARC21 952$i)
377
378	=head2 new_status	300	=head2 new_status
379		301
380	data_type: 'varchar'	302	data_type: 'varchar'
381	is_nullable: 1	303	is_nullable: 1
382	size: 32	304	size: 32
383		305
384	'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
385
386	=head2 exclude_from_local_holds_priority	306	=head2 exclude_from_local_holds_priority
387		307
388	data_type: 'tinyint'	308	data_type: 'tinyint'
389	is_nullable: 1	309	is_nullable: 1
390		310
391	Exclude this item from local holds priority
392
393	=cut	311	=cut
394		312
395	__PACKAGE__->add_columns(	313	__PACKAGE__->add_columns(
Lines 496-501 __PACKAGE__->add_columns( Link Here
496	{ data_type => "varchar", is_nullable => 1, size => 80 },	414	{ data_type => "varchar", is_nullable => 1, size => 80 },
497	"permanent_location",	415	"permanent_location",
498	{ data_type => "varchar", is_nullable => 1, size => 80 },	416	{ data_type => "varchar", is_nullable => 1, size => 80 },
		417	"sub_location",
		418	{ data_type => "varchar", is_nullable => 1, size => 80 },
499	"onloan",	419	"onloan",
500	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	420	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
501	"cn_source",	421	"cn_source",
Lines 983-990 __PACKAGE__->might_have( Link Here
983	);	903	);
984		904
985		905
986	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-03 14:18:06	906	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-24 14:12:38
987	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0jargxEw3HZOK57+ijsMHA	907	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X1201tjCWPb5wFpL/fir6A
988		908
989	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );	909	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
990		910
991	-