View | Details | Raw Unified | Return to bug 14697
Collapse All | Expand All

(-)a/Koha/Schema/Result/ReturnClaim.pm (-1 / +296 lines)
Line 0 Link Here
0
- 
1
use utf8;
2
package Koha::Schema::Result::ReturnClaim;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::ReturnClaim
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<return_claims>
19
20
=cut
21
22
__PACKAGE__->table("return_claims");
23
24
=head1 ACCESSORS
25
26
=head2 id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 itemnumber
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 issue_id
39
40
  data_type: 'integer'
41
  is_foreign_key: 1
42
  is_nullable: 1
43
44
=head2 old_issue_id
45
46
  data_type: 'integer'
47
  is_foreign_key: 1
48
  is_nullable: 1
49
50
=head2 borrowernumber
51
52
  data_type: 'integer'
53
  is_foreign_key: 1
54
  is_nullable: 0
55
56
=head2 notes
57
58
  data_type: 'mediumtext'
59
  is_nullable: 1
60
61
=head2 created_on
62
63
  data_type: 'timestamp'
64
  datetime_undef_if_invalid: 1
65
  is_nullable: 1
66
67
=head2 created_by
68
69
  data_type: 'integer'
70
  is_foreign_key: 1
71
  is_nullable: 1
72
73
=head2 updated_on
74
75
  data_type: 'timestamp'
76
  datetime_undef_if_invalid: 1
77
  is_nullable: 1
78
79
=head2 updated_by
80
81
  data_type: 'integer'
82
  is_foreign_key: 1
83
  is_nullable: 1
84
85
=head2 resolution
86
87
  data_type: 'varchar'
88
  is_nullable: 1
89
  size: 80
90
91
=head2 resolved_on
92
93
  data_type: 'timestamp'
94
  datetime_undef_if_invalid: 1
95
  is_nullable: 1
96
97
=head2 resolved_by
98
99
  data_type: 'integer'
100
  is_foreign_key: 1
101
  is_nullable: 1
102
103
=cut
104
105
__PACKAGE__->add_columns(
106
  "id",
107
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
108
  "itemnumber",
109
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
110
  "issue_id",
111
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
112
  "old_issue_id",
113
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
114
  "borrowernumber",
115
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
116
  "notes",
117
  { data_type => "mediumtext", is_nullable => 1 },
118
  "created_on",
119
  {
120
    data_type => "timestamp",
121
    datetime_undef_if_invalid => 1,
122
    is_nullable => 1,
123
  },
124
  "created_by",
125
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
126
  "updated_on",
127
  {
128
    data_type => "timestamp",
129
    datetime_undef_if_invalid => 1,
130
    is_nullable => 1,
131
  },
132
  "updated_by",
133
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
134
  "resolution",
135
  { data_type => "varchar", is_nullable => 1, size => 80 },
136
  "resolved_on",
137
  {
138
    data_type => "timestamp",
139
    datetime_undef_if_invalid => 1,
140
    is_nullable => 1,
141
  },
142
  "resolved_by",
143
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
144
);
145
146
=head1 PRIMARY KEY
147
148
=over 4
149
150
=item * L</id>
151
152
=back
153
154
=cut
155
156
__PACKAGE__->set_primary_key("id");
157
158
=head1 RELATIONS
159
160
=head2 borrowernumber
161
162
Type: belongs_to
163
164
Related object: L<Koha::Schema::Result::Borrower>
165
166
=cut
167
168
__PACKAGE__->belongs_to(
169
  "borrowernumber",
170
  "Koha::Schema::Result::Borrower",
171
  { borrowernumber => "borrowernumber" },
172
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
173
);
174
175
=head2 created_by
176
177
Type: belongs_to
178
179
Related object: L<Koha::Schema::Result::Borrower>
180
181
=cut
182
183
__PACKAGE__->belongs_to(
184
  "created_by",
185
  "Koha::Schema::Result::Borrower",
186
  { borrowernumber => "created_by" },
187
  {
188
    is_deferrable => 1,
189
    join_type     => "LEFT",
190
    on_delete     => "SET NULL",
191
    on_update     => "CASCADE",
192
  },
193
);
194
195
=head2 issue
196
197
Type: belongs_to
198
199
Related object: L<Koha::Schema::Result::Issue>
200
201
=cut
202
203
__PACKAGE__->belongs_to(
204
  "issue",
205
  "Koha::Schema::Result::Issue",
206
  { issue_id => "issue_id" },
207
  {
208
    is_deferrable => 1,
209
    join_type     => "LEFT",
210
    on_delete     => "SET NULL",
211
    on_update     => "CASCADE",
212
  },
213
);
214
215
=head2 itemnumber
216
217
Type: belongs_to
218
219
Related object: L<Koha::Schema::Result::Item>
220
221
=cut
222
223
__PACKAGE__->belongs_to(
224
  "itemnumber",
225
  "Koha::Schema::Result::Item",
226
  { itemnumber => "itemnumber" },
227
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
228
);
229
230
=head2 old_issue
231
232
Type: belongs_to
233
234
Related object: L<Koha::Schema::Result::Issue>
235
236
=cut
237
238
__PACKAGE__->belongs_to(
239
  "old_issue",
240
  "Koha::Schema::Result::Issue",
241
  { issue_id => "old_issue_id" },
242
  {
243
    is_deferrable => 1,
244
    join_type     => "LEFT",
245
    on_delete     => "SET NULL",
246
    on_update     => "CASCADE",
247
  },
248
);
249
250
=head2 resolved_by
251
252
Type: belongs_to
253
254
Related object: L<Koha::Schema::Result::Borrower>
255
256
=cut
257
258
__PACKAGE__->belongs_to(
259
  "resolved_by",
260
  "Koha::Schema::Result::Borrower",
261
  { borrowernumber => "resolved_by" },
262
  {
263
    is_deferrable => 1,
264
    join_type     => "LEFT",
265
    on_delete     => "SET NULL",
266
    on_update     => "CASCADE",
267
  },
268
);
269
270
=head2 updated_by
271
272
Type: belongs_to
273
274
Related object: L<Koha::Schema::Result::Borrower>
275
276
=cut
277
278
__PACKAGE__->belongs_to(
279
  "updated_by",
280
  "Koha::Schema::Result::Borrower",
281
  { borrowernumber => "updated_by" },
282
  {
283
    is_deferrable => 1,
284
    join_type     => "LEFT",
285
    on_delete     => "SET NULL",
286
    on_update     => "CASCADE",
287
  },
288
);
289
290
291
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-06-21 10:21:06
292
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MTy2jl5ksdYfSIpYr7q1yg
293
294
295
# You can replace this text with custom code or comments, and it will be preserved on regeneration
296
1;

Return to bug 14697