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'
91 publisher (MARC21 260$b)
96 datetime_undef_if_invalid: 1
101 data_type: 'mediumtext'
104 volume information (MARC21 362$a)
106 =head2 collectiontitle
108 data_type: 'longtext'
111 =head2 collectionissn
113 data_type: 'mediumtext'
116 =head2 collectionvolume
118 data_type: 'longtext'
121 =head2 editionstatement
123 data_type: 'mediumtext'
126 =head2 editionresponsibility
128 data_type: 'mediumtext'
133 data_type: 'timestamp'
134 datetime_undef_if_invalid: 1
135 default_value: current_timestamp
144 illustrations (MARC21 300$b)
152 number of pages (MARC21 300$c)
156 data_type: 'longtext'
165 material size (MARC21 300$c)
173 publication place (MARC21 260$a)
181 library of congress control number (MARC21 010$a)
185 data_type: 'mediumtext'
196 classification source (MARC21 942$2)
222 normalized version of the call number used for sorting
224 =head2 agerestriction
230 target audience/age restriction from the bib record (MARC21 521$a)
239 __PACKAGE__->add_columns(
241 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
244 data_type => "integer",
250 { data_type => "longtext", is_nullable => 1 },
252 { data_type => "longtext", is_nullable => 1 },
254 { data_type => "varchar", is_nullable => 1, size => 10 },
256 { data_type => "longtext", is_nullable => 1 },
258 { data_type => "longtext", is_nullable => 1 },
260 { data_type => "longtext", is_nullable => 1 },
262 { data_type => "mediumtext", is_nullable => 1 },
264 { data_type => "varchar", is_nullable => 1, size => 255 },
266 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
268 { data_type => "mediumtext", is_nullable => 1 },
270 { data_type => "longtext", is_nullable => 1 },
272 { data_type => "mediumtext", is_nullable => 1 },
274 { data_type => "longtext", is_nullable => 1 },
276 { data_type => "mediumtext", is_nullable => 1 },
277 "editionresponsibility",
278 { data_type => "mediumtext", is_nullable => 1 },
281 data_type => "timestamp",
282 datetime_undef_if_invalid => 1,
283 default_value => \"current_timestamp",
287 { data_type => "varchar", is_nullable => 1, size => 255 },
289 { data_type => "varchar", is_nullable => 1, size => 255 },
291 { data_type => "longtext", is_nullable => 1 },
293 { data_type => "varchar", is_nullable => 1, size => 255 },
295 { data_type => "varchar", is_nullable => 1, size => 255 },
297 { data_type => "varchar", is_nullable => 1, size => 25 },
299 { data_type => "mediumtext", is_nullable => 1 },
301 { data_type => "varchar", is_nullable => 1, size => 10 },
303 { data_type => "varchar", is_nullable => 1, size => 30 },
305 { data_type => "varchar", is_nullable => 1, size => 10 },
307 { data_type => "varchar", is_nullable => 1, size => 10 },
309 { data_type => "varchar", is_nullable => 1, size => 255 },
311 { data_type => "varchar", is_nullable => 1, size => 255 },
313 { data_type => "integer", is_nullable => 1 },
320 =item * L</biblioitemnumber>
326 __PACKAGE__->set_primary_key("biblioitemnumber");
334 Related object: L<Koha::Schema::Result::Biblio>
338 __PACKAGE__->belongs_to(
340 "Koha::Schema::Result::Biblio",
341 { biblionumber => "biblionumber" },
342 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
349 Related object: L<Koha::Schema::Result::Item>
353 __PACKAGE__->has_many(
355 "Koha::Schema::Result::Item",
356 { "foreign.biblioitemnumber" => "self.biblioitemnumber" },
357 { cascade_copy => 0, cascade_delete => 0 },
361 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
362 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Q5VdRYkLa95Kc96wiwLh/g
364 __PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );