2 package Koha::Schema::Result::Subscription;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Subscription
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<subscription>
22 __PACKAGE__->table("subscription");
41 default_value: (empty string)
48 datetime_undef_if_invalid: 1
93 =head2 countissuesperunit
101 data_type: 'mediumtext'
107 default_value: (empty string)
144 =head2 firstacquidate
147 datetime_undef_if_invalid: 1
161 =head2 skip_serialseq
192 data_type: 'longtext'
203 default_value: (empty string)
210 default_value: (empty string)
220 =head2 serialsadditems
226 =head2 staffdisplaycount
232 =head2 opacdisplaycount
247 datetime_undef_if_invalid: 1
259 datetime_undef_if_invalid: 1
268 =head2 previousitemtype
276 __PACKAGE__->add_columns(
278 { data_type => "integer", default_value => 0, is_nullable => 0 },
280 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
282 { data_type => "varchar", default_value => "", is_nullable => 1, size => 100 },
284 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
286 { data_type => "integer", default_value => 0, is_nullable => 1 },
288 { data_type => "integer", default_value => 0, is_nullable => 1 },
290 { data_type => "integer", default_value => 0, is_nullable => 1 },
292 { data_type => "integer", default_value => 0, is_nullable => 1 },
294 { data_type => "integer", default_value => 0, is_nullable => 1 },
296 { data_type => "integer", default_value => 0, is_nullable => 1 },
298 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
299 "countissuesperunit",
300 { data_type => "integer", default_value => 1, is_nullable => 0 },
302 { data_type => "mediumtext", is_nullable => 1 },
304 { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
306 { data_type => "integer", is_nullable => 1 },
308 { data_type => "integer", default_value => 0, is_nullable => 1 },
310 { data_type => "integer", is_nullable => 1 },
312 { data_type => "integer", default_value => 0, is_nullable => 1 },
314 { data_type => "integer", is_nullable => 1 },
316 { data_type => "integer", default_value => 0, is_nullable => 1 },
318 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
320 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
322 { data_type => "text", is_nullable => 1 },
324 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
326 { data_type => "varchar", is_nullable => 1, size => 20 },
328 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
330 { data_type => "varchar", is_nullable => 1, size => 80 },
332 { data_type => "text", is_nullable => 1 },
334 { data_type => "longtext", is_nullable => 1 },
336 { data_type => "text", is_nullable => 1 },
338 { data_type => "varchar", default_value => "", is_nullable => 1, size => 80 },
340 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
342 { data_type => "varchar", is_nullable => 1, size => 10 },
344 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
346 { data_type => "varchar", is_nullable => 1, size => 10 },
348 { data_type => "varchar", is_nullable => 1, size => 10 },
350 { data_type => "integer", default_value => 0, is_nullable => 0 },
352 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
354 { data_type => "integer", default_value => 0, is_nullable => 0 },
356 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
358 { data_type => "varchar", is_nullable => 1, size => 10 },
360 { data_type => "varchar", is_nullable => 1, size => 10 },
367 =item * L</subscriptionid>
373 __PACKAGE__->set_primary_key("subscriptionid");
381 Related object: L<Koha::Schema::Result::Aqorder>
385 __PACKAGE__->has_many(
387 "Koha::Schema::Result::Aqorder",
388 { "foreign.subscriptionid" => "self.subscriptionid" },
389 { cascade_copy => 0, cascade_delete => 0 },
396 Related object: L<Koha::Schema::Result::SubscriptionNumberpattern>
400 __PACKAGE__->belongs_to(
402 "Koha::Schema::Result::SubscriptionNumberpattern",
403 { id => "numberpattern" },
407 on_delete => "SET NULL",
408 on_update => "CASCADE",
416 Related object: L<Koha::Schema::Result::SubscriptionFrequency>
420 __PACKAGE__->belongs_to(
422 "Koha::Schema::Result::SubscriptionFrequency",
423 { id => "periodicity" },
427 on_delete => "SET NULL",
428 on_update => "CASCADE",
432 =head2 subscriptionroutinglists
436 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
440 __PACKAGE__->has_many(
441 "subscriptionroutinglists",
442 "Koha::Schema::Result::Subscriptionroutinglist",
443 { "foreign.subscriptionid" => "self.subscriptionid" },
444 { cascade_copy => 0, cascade_delete => 0 },
448 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-12 09:39:32
449 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jAZGa1b6DkY8Sr12reD4nw
452 # You can replace this text with custom content, and it will be preserved on regeneration