2 package Koha::Schema::Result::Illrequest;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Illrequest
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<illrequests>
22 __PACKAGE__->table("illrequests");
29 extra: {unsigned => 1}
67 datetime_undef_if_invalid: 1
73 datetime_undef_if_invalid: 1
78 data_type: 'timestamp'
79 datetime_undef_if_invalid: 1
80 default_value: current_timestamp
86 datetime_undef_if_invalid: 1
115 data_type: 'mediumtext'
120 data_type: 'mediumtext'
137 __PACKAGE__->add_columns(
140 data_type => "bigint",
141 extra => { unsigned => 1 },
142 is_auto_increment => 1,
146 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
148 { data_type => "integer", is_nullable => 1 },
150 { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },
152 { data_type => "varchar", is_nullable => 1, size => 50 },
154 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
156 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
158 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
161 data_type => "timestamp",
162 datetime_undef_if_invalid => 1,
163 default_value => \"current_timestamp",
167 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
169 { data_type => "varchar", is_nullable => 1, size => 30 },
171 { data_type => "varchar", is_nullable => 1, size => 500 },
173 { data_type => "varchar", is_nullable => 1, size => 20 },
175 { data_type => "varchar", is_nullable => 1, size => 20 },
177 { data_type => "mediumtext", is_nullable => 1 },
179 { data_type => "mediumtext", is_nullable => 1 },
181 { data_type => "varchar", is_nullable => 1, size => 50 },
183 { data_type => "varchar", is_nullable => 1, size => 20 },
190 =item * L</illrequest_id>
196 __PACKAGE__->set_primary_key("illrequest_id");
200 =head2 borrowernumber
204 Related object: L<Koha::Schema::Result::Borrower>
208 __PACKAGE__->belongs_to(
210 "Koha::Schema::Result::Borrower",
211 { borrowernumber => "borrowernumber" },
215 on_delete => "CASCADE",
216 on_update => "CASCADE",
224 Related object: L<Koha::Schema::Result::Branch>
228 __PACKAGE__->belongs_to(
230 "Koha::Schema::Result::Branch",
231 { branchcode => "branchcode" },
232 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
239 Related object: L<Koha::Schema::Result::Illcomment>
243 __PACKAGE__->has_many(
245 "Koha::Schema::Result::Illcomment",
246 { "foreign.illrequest_id" => "self.illrequest_id" },
247 { cascade_copy => 0, cascade_delete => 0 },
250 =head2 illrequestattributes
254 Related object: L<Koha::Schema::Result::Illrequestattribute>
258 __PACKAGE__->has_many(
259 "illrequestattributes",
260 "Koha::Schema::Result::Illrequestattribute",
261 { "foreign.illrequest_id" => "self.illrequest_id" },
262 { cascade_copy => 0, cascade_delete => 0 },
269 Related object: L<Koha::Schema::Result::AuthorisedValue>
273 __PACKAGE__->belongs_to(
275 "Koha::Schema::Result::AuthorisedValue",
276 { authorised_value => "status_alias" },
280 on_delete => "SET NULL",
281 on_update => "CASCADE",
286 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-02-22 14:32:49
287 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I6fY8XRfEmRxSzOeVT9Krw
290 # You can replace this text with custom code or comments, and it will be preserved on regeneration