2 package Koha::Schema::Result::Issue;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Issue
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<issues>
22 __PACKAGE__->table("issues");
47 datetime_undef_if_invalid: 1
59 datetime_undef_if_invalid: 1
62 =head2 lastreneweddate
65 datetime_undef_if_invalid: 1
80 =head2 auto_renew_error
88 data_type: 'timestamp'
89 datetime_undef_if_invalid: 1
90 default_value: current_timestamp
96 datetime_undef_if_invalid: 1
99 =head2 onsite_checkout
107 data_type: 'longtext'
112 data_type: 'datetime'
113 datetime_undef_if_invalid: 1
123 __PACKAGE__->add_columns(
125 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
127 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
129 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
132 data_type => "datetime",
133 datetime_undef_if_invalid => 1,
137 { data_type => "varchar", is_nullable => 1, size => 10 },
140 data_type => "datetime",
141 datetime_undef_if_invalid => 1,
146 data_type => "datetime",
147 datetime_undef_if_invalid => 1,
151 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
153 { data_type => "tinyint", default_value => 0, is_nullable => 1 },
155 { data_type => "varchar", is_nullable => 1, size => 32 },
158 data_type => "timestamp",
159 datetime_undef_if_invalid => 1,
160 default_value => \"current_timestamp",
165 data_type => "datetime",
166 datetime_undef_if_invalid => 1,
170 { data_type => "integer", default_value => 0, is_nullable => 0 },
172 { data_type => "longtext", is_nullable => 1 },
175 data_type => "datetime",
176 datetime_undef_if_invalid => 1,
180 { data_type => "integer", is_nullable => 1 },
193 __PACKAGE__->set_primary_key("issue_id");
195 =head1 UNIQUE CONSTRAINTS
201 =item * L</itemnumber>
207 __PACKAGE__->add_unique_constraint("itemnumber", ["itemnumber"]);
211 =head2 borrowernumber
215 Related object: L<Koha::Schema::Result::Borrower>
219 __PACKAGE__->belongs_to(
221 "Koha::Schema::Result::Borrower",
222 { borrowernumber => "borrowernumber" },
226 on_delete => "RESTRICT",
227 on_update => "CASCADE",
235 Related object: L<Koha::Schema::Result::Item>
239 __PACKAGE__->belongs_to(
241 "Koha::Schema::Result::Item",
242 { itemnumber => "itemnumber" },
246 on_delete => "RESTRICT",
247 on_update => "CASCADE",
252 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-10 19:55:44
253 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PUF5X7X9K44BC0d43Rat7w
255 __PACKAGE__->add_columns(
256 '+auto_renew' => { is_boolean => 1 },
257 '+onsite_checkout' => { is_boolean => 1 }
260 __PACKAGE__->belongs_to(
262 "Koha::Schema::Result::Borrower",
263 { borrowernumber => "borrowernumber" },
264 { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
267 __PACKAGE__->belongs_to(
269 "Koha::Schema::Result::Item",
270 { itemnumber => "itemnumber" },
274 on_delete => "CASCADE",
275 on_update => "CASCADE",
279 __PACKAGE__->belongs_to(
281 "Koha::Schema::Result::Branch",
282 { branchcode => "branchcode" },
286 on_delete => "CASCADE",
287 on_update => "CASCADE",