Bug 21395: Fix creation of PO file
[koha.git] / Koha / Schema / Result / Illrequest.pm
blob4260a8d2df9d736e410b3aba437ca75252ba0560
1 use utf8;
2 package Koha::Schema::Result::Illrequest;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
7 =head1 NAME
9 Koha::Schema::Result::Illrequest
11 =cut
13 use strict;
14 use warnings;
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<illrequests>
20 =cut
22 __PACKAGE__->table("illrequests");
24 =head1 ACCESSORS
26 =head2 illrequest_id
28 data_type: 'bigint'
29 extra: {unsigned => 1}
30 is_auto_increment: 1
31 is_nullable: 0
33 =head2 borrowernumber
35 data_type: 'integer'
36 is_foreign_key: 1
37 is_nullable: 1
39 =head2 biblio_id
41 data_type: 'integer'
42 is_nullable: 1
44 =head2 branchcode
46 data_type: 'varchar'
47 is_foreign_key: 1
48 is_nullable: 0
49 size: 50
51 =head2 status
53 data_type: 'varchar'
54 is_nullable: 1
55 size: 50
57 =head2 status_alias
59 data_type: 'varchar'
60 is_foreign_key: 1
61 is_nullable: 1
62 size: 80
64 =head2 placed
66 data_type: 'date'
67 datetime_undef_if_invalid: 1
68 is_nullable: 1
70 =head2 replied
72 data_type: 'date'
73 datetime_undef_if_invalid: 1
74 is_nullable: 1
76 =head2 updated
78 data_type: 'timestamp'
79 datetime_undef_if_invalid: 1
80 default_value: current_timestamp
81 is_nullable: 0
83 =head2 completed
85 data_type: 'date'
86 datetime_undef_if_invalid: 1
87 is_nullable: 1
89 =head2 medium
91 data_type: 'varchar'
92 is_nullable: 1
93 size: 30
95 =head2 accessurl
97 data_type: 'varchar'
98 is_nullable: 1
99 size: 500
101 =head2 cost
103 data_type: 'varchar'
104 is_nullable: 1
105 size: 20
107 =head2 price_paid
109 data_type: 'varchar'
110 is_nullable: 1
111 size: 20
113 =head2 notesopac
115 data_type: 'mediumtext'
116 is_nullable: 1
118 =head2 notesstaff
120 data_type: 'mediumtext'
121 is_nullable: 1
123 =head2 orderid
125 data_type: 'varchar'
126 is_nullable: 1
127 size: 50
129 =head2 backend
131 data_type: 'varchar'
132 is_nullable: 1
133 size: 20
135 =cut
137 __PACKAGE__->add_columns(
138 "illrequest_id",
140 data_type => "bigint",
141 extra => { unsigned => 1 },
142 is_auto_increment => 1,
143 is_nullable => 0,
145 "borrowernumber",
146 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
147 "biblio_id",
148 { data_type => "integer", is_nullable => 1 },
149 "branchcode",
150 { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },
151 "status",
152 { data_type => "varchar", is_nullable => 1, size => 50 },
153 "status_alias",
154 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
155 "placed",
156 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
157 "replied",
158 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
159 "updated",
161 data_type => "timestamp",
162 datetime_undef_if_invalid => 1,
163 default_value => \"current_timestamp",
164 is_nullable => 0,
166 "completed",
167 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
168 "medium",
169 { data_type => "varchar", is_nullable => 1, size => 30 },
170 "accessurl",
171 { data_type => "varchar", is_nullable => 1, size => 500 },
172 "cost",
173 { data_type => "varchar", is_nullable => 1, size => 20 },
174 "price_paid",
175 { data_type => "varchar", is_nullable => 1, size => 20 },
176 "notesopac",
177 { data_type => "mediumtext", is_nullable => 1 },
178 "notesstaff",
179 { data_type => "mediumtext", is_nullable => 1 },
180 "orderid",
181 { data_type => "varchar", is_nullable => 1, size => 50 },
182 "backend",
183 { data_type => "varchar", is_nullable => 1, size => 20 },
186 =head1 PRIMARY KEY
188 =over 4
190 =item * L</illrequest_id>
192 =back
194 =cut
196 __PACKAGE__->set_primary_key("illrequest_id");
198 =head1 RELATIONS
200 =head2 borrowernumber
202 Type: belongs_to
204 Related object: L<Koha::Schema::Result::Borrower>
206 =cut
208 __PACKAGE__->belongs_to(
209 "borrowernumber",
210 "Koha::Schema::Result::Borrower",
211 { borrowernumber => "borrowernumber" },
213 is_deferrable => 1,
214 join_type => "LEFT",
215 on_delete => "CASCADE",
216 on_update => "CASCADE",
220 =head2 branchcode
222 Type: belongs_to
224 Related object: L<Koha::Schema::Result::Branch>
226 =cut
228 __PACKAGE__->belongs_to(
229 "branchcode",
230 "Koha::Schema::Result::Branch",
231 { branchcode => "branchcode" },
232 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
235 =head2 illcomments
237 Type: has_many
239 Related object: L<Koha::Schema::Result::Illcomment>
241 =cut
243 __PACKAGE__->has_many(
244 "illcomments",
245 "Koha::Schema::Result::Illcomment",
246 { "foreign.illrequest_id" => "self.illrequest_id" },
247 { cascade_copy => 0, cascade_delete => 0 },
250 =head2 illrequestattributes
252 Type: has_many
254 Related object: L<Koha::Schema::Result::Illrequestattribute>
256 =cut
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 },
265 =head2 status_alias
267 Type: belongs_to
269 Related object: L<Koha::Schema::Result::AuthorisedValue>
271 =cut
273 __PACKAGE__->belongs_to(
274 "status_alias",
275 "Koha::Schema::Result::AuthorisedValue",
276 { authorised_value => "status_alias" },
278 is_deferrable => 1,
279 join_type => "LEFT",
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