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

(-)a/Koha/Schema/Result/ReturnClaim.pm (-1 / +261 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_nullable: 1
42
43
=head2 borrowernumber
44
45
  data_type: 'integer'
46
  is_foreign_key: 1
47
  is_nullable: 0
48
49
=head2 notes
50
51
  data_type: 'mediumtext'
52
  is_nullable: 1
53
54
=head2 created_on
55
56
  data_type: 'timestamp'
57
  datetime_undef_if_invalid: 1
58
  is_nullable: 1
59
60
=head2 created_by
61
62
  data_type: 'integer'
63
  is_foreign_key: 1
64
  is_nullable: 1
65
66
=head2 updated_on
67
68
  data_type: 'timestamp'
69
  datetime_undef_if_invalid: 1
70
  is_nullable: 1
71
72
=head2 updated_by
73
74
  data_type: 'integer'
75
  is_foreign_key: 1
76
  is_nullable: 1
77
78
=head2 resolution
79
80
  data_type: 'varchar'
81
  is_nullable: 1
82
  size: 80
83
84
=head2 resolved_on
85
86
  data_type: 'timestamp'
87
  datetime_undef_if_invalid: 1
88
  is_nullable: 1
89
90
=head2 resolved_by
91
92
  data_type: 'integer'
93
  is_foreign_key: 1
94
  is_nullable: 1
95
96
=cut
97
98
__PACKAGE__->add_columns(
99
  "id",
100
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
101
  "itemnumber",
102
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
103
  "issue_id",
104
  { data_type => "integer", is_nullable => 1 },
105
  "borrowernumber",
106
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
107
  "notes",
108
  { data_type => "mediumtext", is_nullable => 1 },
109
  "created_on",
110
  {
111
    data_type => "timestamp",
112
    datetime_undef_if_invalid => 1,
113
    is_nullable => 1,
114
  },
115
  "created_by",
116
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
117
  "updated_on",
118
  {
119
    data_type => "timestamp",
120
    datetime_undef_if_invalid => 1,
121
    is_nullable => 1,
122
  },
123
  "updated_by",
124
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
125
  "resolution",
126
  { data_type => "varchar", is_nullable => 1, size => 80 },
127
  "resolved_on",
128
  {
129
    data_type => "timestamp",
130
    datetime_undef_if_invalid => 1,
131
    is_nullable => 1,
132
  },
133
  "resolved_by",
134
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
135
);
136
137
=head1 PRIMARY KEY
138
139
=over 4
140
141
=item * L</id>
142
143
=back
144
145
=cut
146
147
__PACKAGE__->set_primary_key("id");
148
149
=head1 UNIQUE CONSTRAINTS
150
151
=head2 C<issue_id>
152
153
=over 4
154
155
=item * L</issue_id>
156
157
=back
158
159
=cut
160
161
__PACKAGE__->add_unique_constraint("issue_id", ["issue_id"]);
162
163
=head1 RELATIONS
164
165
=head2 borrowernumber
166
167
Type: belongs_to
168
169
Related object: L<Koha::Schema::Result::Borrower>
170
171
=cut
172
173
__PACKAGE__->belongs_to(
174
  "borrowernumber",
175
  "Koha::Schema::Result::Borrower",
176
  { borrowernumber => "borrowernumber" },
177
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
178
);
179
180
=head2 created_by
181
182
Type: belongs_to
183
184
Related object: L<Koha::Schema::Result::Borrower>
185
186
=cut
187
188
__PACKAGE__->belongs_to(
189
  "created_by",
190
  "Koha::Schema::Result::Borrower",
191
  { borrowernumber => "created_by" },
192
  {
193
    is_deferrable => 1,
194
    join_type     => "LEFT",
195
    on_delete     => "SET NULL",
196
    on_update     => "CASCADE",
197
  },
198
);
199
200
=head2 itemnumber
201
202
Type: belongs_to
203
204
Related object: L<Koha::Schema::Result::Item>
205
206
=cut
207
208
__PACKAGE__->belongs_to(
209
  "itemnumber",
210
  "Koha::Schema::Result::Item",
211
  { itemnumber => "itemnumber" },
212
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
213
);
214
215
=head2 resolved_by
216
217
Type: belongs_to
218
219
Related object: L<Koha::Schema::Result::Borrower>
220
221
=cut
222
223
__PACKAGE__->belongs_to(
224
  "resolved_by",
225
  "Koha::Schema::Result::Borrower",
226
  { borrowernumber => "resolved_by" },
227
  {
228
    is_deferrable => 1,
229
    join_type     => "LEFT",
230
    on_delete     => "SET NULL",
231
    on_update     => "CASCADE",
232
  },
233
);
234
235
=head2 updated_by
236
237
Type: belongs_to
238
239
Related object: L<Koha::Schema::Result::Borrower>
240
241
=cut
242
243
__PACKAGE__->belongs_to(
244
  "updated_by",
245
  "Koha::Schema::Result::Borrower",
246
  { borrowernumber => "updated_by" },
247
  {
248
    is_deferrable => 1,
249
    join_type     => "LEFT",
250
    on_delete     => "SET NULL",
251
    on_update     => "CASCADE",
252
  },
253
);
254
255
256
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-24 18:12:09
257
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ojrbFpQoVSmUMFJdNb6wTw
258
259
260
# You can replace this text with custom code or comments, and it will be preserved on regeneration
261
1;

Return to bug 14697