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
264 __PACKAGE__->add_columns(
266 { data_type => "integer", default_value => 0, is_nullable => 0 },
268 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
270 { data_type => "varchar", default_value => "", is_nullable => 1, size => 100 },
272 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
274 { data_type => "integer", default_value => 0, is_nullable => 1 },
276 { data_type => "integer", default_value => 0, is_nullable => 1 },
278 { data_type => "integer", default_value => 0, is_nullable => 1 },
280 { data_type => "integer", default_value => 0, is_nullable => 1 },
282 { data_type => "integer", default_value => 0, is_nullable => 1 },
284 { data_type => "integer", default_value => 0, is_nullable => 1 },
286 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
287 "countissuesperunit",
288 { data_type => "integer", default_value => 1, is_nullable => 0 },
290 { data_type => "mediumtext", is_nullable => 1 },
292 { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
294 { data_type => "integer", is_nullable => 1 },
296 { data_type => "integer", default_value => 0, is_nullable => 1 },
298 { data_type => "integer", is_nullable => 1 },
300 { data_type => "integer", default_value => 0, is_nullable => 1 },
302 { data_type => "integer", is_nullable => 1 },
304 { data_type => "integer", default_value => 0, is_nullable => 1 },
306 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
308 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
310 { data_type => "text", is_nullable => 1 },
312 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
314 { data_type => "varchar", is_nullable => 1, size => 20 },
316 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
318 { data_type => "varchar", is_nullable => 1, size => 80 },
320 { data_type => "text", is_nullable => 1 },
322 { data_type => "longtext", is_nullable => 1 },
324 { data_type => "text", is_nullable => 1 },
326 { data_type => "varchar", default_value => "", is_nullable => 1, size => 80 },
328 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
330 { data_type => "varchar", is_nullable => 1, size => 10 },
332 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
334 { data_type => "varchar", is_nullable => 1, size => 10 },
336 { data_type => "varchar", is_nullable => 1, size => 10 },
338 { data_type => "integer", default_value => 0, is_nullable => 0 },
340 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
342 { data_type => "integer", default_value => 0, is_nullable => 0 },
344 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
351 =item * L</subscriptionid>
357 __PACKAGE__->set_primary_key("subscriptionid");
365 Related object: L<Koha::Schema::Result::Aqorder>
369 __PACKAGE__->has_many(
371 "Koha::Schema::Result::Aqorder",
372 { "foreign.subscriptionid" => "self.subscriptionid" },
373 { cascade_copy => 0, cascade_delete => 0 },
380 Related object: L<Koha::Schema::Result::SubscriptionNumberpattern>
384 __PACKAGE__->belongs_to(
386 "Koha::Schema::Result::SubscriptionNumberpattern",
387 { id => "numberpattern" },
391 on_delete => "SET NULL",
392 on_update => "CASCADE",
400 Related object: L<Koha::Schema::Result::SubscriptionFrequency>
404 __PACKAGE__->belongs_to(
406 "Koha::Schema::Result::SubscriptionFrequency",
407 { id => "periodicity" },
411 on_delete => "SET NULL",
412 on_update => "CASCADE",
416 =head2 subscriptionroutinglists
420 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
424 __PACKAGE__->has_many(
425 "subscriptionroutinglists",
426 "Koha::Schema::Result::Subscriptionroutinglist",
427 { "foreign.subscriptionid" => "self.subscriptionid" },
428 { cascade_copy => 0, cascade_delete => 0 },
432 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
433 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:57kc1/B3eNKQXAk9tlOy0A
436 # You can replace this text with custom content, and it will be preserved on regeneration