2 package Koha::Schema::Result::Biblioitem;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Biblioitem
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<biblioitems>
22 __PACKAGE__->table("biblioitems");
26 =head2 biblioitemnumber
32 primary key, unique identifier assigned by Koha
41 foreign key linking this table to the biblio table
59 biblio level item type (MARC21 942$c)
80 =head2 publicationyear
82 data_type: 'mediumtext'
90 publisher (MARC21 260$b and 246$b)
95 datetime_undef_if_invalid: 1
100 data_type: 'mediumtext'
103 volume information (MARC21 362$a)
105 =head2 collectiontitle
107 data_type: 'longtext'
110 =head2 collectionissn
112 data_type: 'mediumtext'
115 =head2 collectionvolume
117 data_type: 'longtext'
120 =head2 editionstatement
122 data_type: 'mediumtext'
125 =head2 editionresponsibility
127 data_type: 'mediumtext'
132 data_type: 'timestamp'
133 datetime_undef_if_invalid: 1
134 default_value: current_timestamp
142 illustrations (MARC21 300$b)
149 number of pages (MARC21 300$a)
153 data_type: 'longtext'
161 material size (MARC21 300$c)
168 publication place (MARC21 260$a and 264$a)
172 data_type: 'longtext'
175 library of congress control number (MARC21 010$a)
179 data_type: 'mediumtext'
190 classification source (MARC21 942$2)
216 normalized version of the call number used for sorting
218 =head2 agerestriction
224 target audience/age restriction from the bib record (MARC21 521$a)
233 __PACKAGE__->add_columns(
235 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
238 data_type => "integer",
244 { data_type => "longtext", is_nullable => 1 },
246 { data_type => "longtext", is_nullable => 1 },
248 { data_type => "varchar", is_nullable => 1, size => 10 },
250 { data_type => "longtext", is_nullable => 1 },
252 { data_type => "longtext", is_nullable => 1 },
254 { data_type => "longtext", is_nullable => 1 },
256 { data_type => "mediumtext", is_nullable => 1 },
258 { data_type => "text", is_nullable => 1 },
260 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
262 { data_type => "mediumtext", is_nullable => 1 },
264 { data_type => "longtext", is_nullable => 1 },
266 { data_type => "mediumtext", is_nullable => 1 },
268 { data_type => "longtext", is_nullable => 1 },
270 { data_type => "mediumtext", is_nullable => 1 },
271 "editionresponsibility",
272 { data_type => "mediumtext", is_nullable => 1 },
275 data_type => "timestamp",
276 datetime_undef_if_invalid => 1,
277 default_value => \"current_timestamp",
281 { data_type => "text", is_nullable => 1 },
283 { data_type => "text", is_nullable => 1 },
285 { data_type => "longtext", is_nullable => 1 },
287 { data_type => "text", is_nullable => 1 },
289 { data_type => "text", is_nullable => 1 },
291 { data_type => "longtext", is_nullable => 1 },
293 { data_type => "mediumtext", is_nullable => 1 },
295 { data_type => "varchar", is_nullable => 1, size => 10 },
297 { data_type => "varchar", is_nullable => 1, size => 30 },
299 { data_type => "varchar", is_nullable => 1, size => 10 },
301 { data_type => "varchar", is_nullable => 1, size => 10 },
303 { data_type => "varchar", is_nullable => 1, size => 255 },
305 { data_type => "varchar", is_nullable => 1, size => 255 },
307 { data_type => "integer", is_nullable => 1 },
314 =item * L</biblioitemnumber>
320 __PACKAGE__->set_primary_key("biblioitemnumber");
328 Related object: L<Koha::Schema::Result::Biblio>
332 __PACKAGE__->belongs_to(
334 "Koha::Schema::Result::Biblio",
335 { biblionumber => "biblionumber" },
336 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
343 Related object: L<Koha::Schema::Result::Item>
347 __PACKAGE__->has_many(
349 "Koha::Schema::Result::Item",
350 { "foreign.biblioitemnumber" => "self.biblioitemnumber" },
351 { cascade_copy => 0, cascade_delete => 0 },
355 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-06-26 12:47:08
356 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6a9kLpJoQrsMu+CIx7KMBg
358 __PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );