2 package Koha::Schema::Result::Serial;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Serial
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<serial>
22 __PACKAGE__->table("serial");
32 unique key for the issue
40 foreign key for the biblio.biblionumber that this issue is attached to
48 foreign key to the subscription.subscriptionid that this issue is part of
53 default_value: (empty string)
57 issue information (volume, number, etc)
65 first part of issue information
73 second part of issue information
81 third part of issue information
89 status code for this issue (see manual for full descriptions)
94 datetime_undef_if_invalid: 1
101 data_type: 'mediumtext'
109 datetime_undef_if_invalid: 1
114 =head2 publisheddatetext
120 date published (descriptive)
125 datetime_undef_if_invalid: 1
136 number of claims made related to this issue
140 data_type: 'mediumtext'
143 notes from the routing list
147 __PACKAGE__->add_columns(
149 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
151 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
153 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
155 { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
157 { data_type => "varchar", is_nullable => 1, size => 100 },
159 { data_type => "varchar", is_nullable => 1, size => 100 },
161 { data_type => "varchar", is_nullable => 1, size => 100 },
163 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
165 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
167 { data_type => "mediumtext", is_nullable => 1 },
169 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
171 { data_type => "varchar", is_nullable => 1, size => 100 },
173 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
175 { data_type => "integer", default_value => 0, is_nullable => 1 },
177 { data_type => "mediumtext", is_nullable => 1 },
190 __PACKAGE__->set_primary_key("serialid");
198 Related object: L<Koha::Schema::Result::Biblio>
202 __PACKAGE__->belongs_to(
204 "Koha::Schema::Result::Biblio",
205 { biblionumber => "biblionumber" },
206 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
213 Related object: L<Koha::Schema::Result::Serialitem>
217 __PACKAGE__->has_many(
219 "Koha::Schema::Result::Serialitem",
220 { "foreign.serialid" => "self.serialid" },
221 { cascade_copy => 0, cascade_delete => 0 },
224 =head2 subscriptionid
228 Related object: L<Koha::Schema::Result::Subscription>
232 __PACKAGE__->belongs_to(
234 "Koha::Schema::Result::Subscription",
235 { subscriptionid => "subscriptionid" },
236 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
240 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
241 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SD7llCvCO+/67cXetzRKPQ
244 # You can replace this text with custom code or comments, and it will be preserved on regeneration