Bug 19618: DBRev 19.06.00.030
[koha.git] / Koha / Schema / Result / Biblio.pm
blob43fa26af468bdba42c4286d781273adbd59a1c2b
1 use utf8;
2 package Koha::Schema::Result::Biblio;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
7 =head1 NAME
9 Koha::Schema::Result::Biblio
11 =cut
13 use strict;
14 use warnings;
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<biblio>
20 =cut
22 __PACKAGE__->table("biblio");
24 =head1 ACCESSORS
26 =head2 biblionumber
28 data_type: 'integer'
29 is_auto_increment: 1
30 is_nullable: 0
32 =head2 frameworkcode
34 data_type: 'varchar'
35 default_value: (empty string)
36 is_nullable: 0
37 size: 4
39 =head2 author
41 data_type: 'longtext'
42 is_nullable: 1
44 =head2 title
46 data_type: 'longtext'
47 is_nullable: 1
49 =head2 medium
51 data_type: 'longtext'
52 is_nullable: 1
54 =head2 subtitle
56 data_type: 'longtext'
57 is_nullable: 1
59 =head2 part_number
61 data_type: 'longtext'
62 is_nullable: 1
64 =head2 part_name
66 data_type: 'longtext'
67 is_nullable: 1
69 =head2 unititle
71 data_type: 'longtext'
72 is_nullable: 1
74 =head2 notes
76 data_type: 'longtext'
77 is_nullable: 1
79 =head2 serial
81 data_type: 'tinyint'
82 is_nullable: 1
84 =head2 seriestitle
86 data_type: 'longtext'
87 is_nullable: 1
89 =head2 copyrightdate
91 data_type: 'smallint'
92 is_nullable: 1
94 =head2 timestamp
96 data_type: 'timestamp'
97 datetime_undef_if_invalid: 1
98 default_value: current_timestamp
99 is_nullable: 0
101 =head2 datecreated
103 data_type: 'date'
104 datetime_undef_if_invalid: 1
105 is_nullable: 0
107 =head2 abstract
109 data_type: 'longtext'
110 is_nullable: 1
112 =cut
114 __PACKAGE__->add_columns(
115 "biblionumber",
116 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
117 "frameworkcode",
118 { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
119 "author",
120 { data_type => "longtext", is_nullable => 1 },
121 "title",
122 { data_type => "longtext", is_nullable => 1 },
123 "medium",
124 { data_type => "longtext", is_nullable => 1 },
125 "subtitle",
126 { data_type => "longtext", is_nullable => 1 },
127 "part_number",
128 { data_type => "longtext", is_nullable => 1 },
129 "part_name",
130 { data_type => "longtext", is_nullable => 1 },
131 "unititle",
132 { data_type => "longtext", is_nullable => 1 },
133 "notes",
134 { data_type => "longtext", is_nullable => 1 },
135 "serial",
136 { data_type => "tinyint", is_nullable => 1 },
137 "seriestitle",
138 { data_type => "longtext", is_nullable => 1 },
139 "copyrightdate",
140 { data_type => "smallint", is_nullable => 1 },
141 "timestamp",
143 data_type => "timestamp",
144 datetime_undef_if_invalid => 1,
145 default_value => \"current_timestamp",
146 is_nullable => 0,
148 "datecreated",
149 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
150 "abstract",
151 { data_type => "longtext", is_nullable => 1 },
154 =head1 PRIMARY KEY
156 =over 4
158 =item * L</biblionumber>
160 =back
162 =cut
164 __PACKAGE__->set_primary_key("biblionumber");
166 =head1 RELATIONS
168 =head2 aqorders
170 Type: has_many
172 Related object: L<Koha::Schema::Result::Aqorder>
174 =cut
176 __PACKAGE__->has_many(
177 "aqorders",
178 "Koha::Schema::Result::Aqorder",
179 { "foreign.biblionumber" => "self.biblionumber" },
180 { cascade_copy => 0, cascade_delete => 0 },
183 =head2 article_requests
185 Type: has_many
187 Related object: L<Koha::Schema::Result::ArticleRequest>
189 =cut
191 __PACKAGE__->has_many(
192 "article_requests",
193 "Koha::Schema::Result::ArticleRequest",
194 { "foreign.biblionumber" => "self.biblionumber" },
195 { cascade_copy => 0, cascade_delete => 0 },
198 =head2 biblio_metadatas
200 Type: has_many
202 Related object: L<Koha::Schema::Result::BiblioMetadata>
204 =cut
206 __PACKAGE__->has_many(
207 "biblio_metadatas",
208 "Koha::Schema::Result::BiblioMetadata",
209 { "foreign.biblionumber" => "self.biblionumber" },
210 { cascade_copy => 0, cascade_delete => 0 },
213 =head2 biblioimages
215 Type: has_many
217 Related object: L<Koha::Schema::Result::Biblioimage>
219 =cut
221 __PACKAGE__->has_many(
222 "biblioimages",
223 "Koha::Schema::Result::Biblioimage",
224 { "foreign.biblionumber" => "self.biblionumber" },
225 { cascade_copy => 0, cascade_delete => 0 },
228 =head2 biblioitems
230 Type: has_many
232 Related object: L<Koha::Schema::Result::Biblioitem>
234 =cut
236 __PACKAGE__->has_many(
237 "biblioitems",
238 "Koha::Schema::Result::Biblioitem",
239 { "foreign.biblionumber" => "self.biblionumber" },
240 { cascade_copy => 0, cascade_delete => 0 },
243 =head2 club_holds
245 Type: has_many
247 Related object: L<Koha::Schema::Result::ClubHold>
249 =cut
251 __PACKAGE__->has_many(
252 "club_holds",
253 "Koha::Schema::Result::ClubHold",
254 { "foreign.biblio_id" => "self.biblionumber" },
255 { cascade_copy => 0, cascade_delete => 0 },
258 =head2 hold_fill_targets
260 Type: has_many
262 Related object: L<Koha::Schema::Result::HoldFillTarget>
264 =cut
266 __PACKAGE__->has_many(
267 "hold_fill_targets",
268 "Koha::Schema::Result::HoldFillTarget",
269 { "foreign.biblionumber" => "self.biblionumber" },
270 { cascade_copy => 0, cascade_delete => 0 },
273 =head2 items
275 Type: has_many
277 Related object: L<Koha::Schema::Result::Item>
279 =cut
281 __PACKAGE__->has_many(
282 "items",
283 "Koha::Schema::Result::Item",
284 { "foreign.biblionumber" => "self.biblionumber" },
285 { cascade_copy => 0, cascade_delete => 0 },
288 =head2 old_reserves
290 Type: has_many
292 Related object: L<Koha::Schema::Result::OldReserve>
294 =cut
296 __PACKAGE__->has_many(
297 "old_reserves",
298 "Koha::Schema::Result::OldReserve",
299 { "foreign.biblionumber" => "self.biblionumber" },
300 { cascade_copy => 0, cascade_delete => 0 },
303 =head2 ratings
305 Type: has_many
307 Related object: L<Koha::Schema::Result::Rating>
309 =cut
311 __PACKAGE__->has_many(
312 "ratings",
313 "Koha::Schema::Result::Rating",
314 { "foreign.biblionumber" => "self.biblionumber" },
315 { cascade_copy => 0, cascade_delete => 0 },
318 =head2 reserves
320 Type: has_many
322 Related object: L<Koha::Schema::Result::Reserve>
324 =cut
326 __PACKAGE__->has_many(
327 "reserves",
328 "Koha::Schema::Result::Reserve",
329 { "foreign.biblionumber" => "self.biblionumber" },
330 { cascade_copy => 0, cascade_delete => 0 },
333 =head2 reviews
335 Type: has_many
337 Related object: L<Koha::Schema::Result::Review>
339 =cut
341 __PACKAGE__->has_many(
342 "reviews",
343 "Koha::Schema::Result::Review",
344 { "foreign.biblionumber" => "self.biblionumber" },
345 { cascade_copy => 0, cascade_delete => 0 },
348 =head2 suggestions
350 Type: has_many
352 Related object: L<Koha::Schema::Result::Suggestion>
354 =cut
356 __PACKAGE__->has_many(
357 "suggestions",
358 "Koha::Schema::Result::Suggestion",
359 { "foreign.biblionumber" => "self.biblionumber" },
360 { cascade_copy => 0, cascade_delete => 0 },
363 =head2 tags_all
365 Type: has_many
367 Related object: L<Koha::Schema::Result::TagAll>
369 =cut
371 __PACKAGE__->has_many(
372 "tags_all",
373 "Koha::Schema::Result::TagAll",
374 { "foreign.biblionumber" => "self.biblionumber" },
375 { cascade_copy => 0, cascade_delete => 0 },
378 =head2 tags_indexes
380 Type: has_many
382 Related object: L<Koha::Schema::Result::TagsIndex>
384 =cut
386 __PACKAGE__->has_many(
387 "tags_indexes",
388 "Koha::Schema::Result::TagsIndex",
389 { "foreign.biblionumber" => "self.biblionumber" },
390 { cascade_copy => 0, cascade_delete => 0 },
393 =head2 virtualshelfcontents
395 Type: has_many
397 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
399 =cut
401 __PACKAGE__->has_many(
402 "virtualshelfcontents",
403 "Koha::Schema::Result::Virtualshelfcontent",
404 { "foreign.biblionumber" => "self.biblionumber" },
405 { cascade_copy => 0, cascade_delete => 0 },
409 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47
410 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:otCex8qzJmZyc+JXpKNdpQ
413 __PACKAGE__->has_one(
414 "metadata",
415 "Koha::Schema::Result::BiblioMetadata",
416 { "foreign.biblionumber" => "self.biblionumber" },
417 { cascade_copy => 0, cascade_delete => 0 },