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

(-)a/Koha/Schema/Result/ArticleRequest.pm (-7 / +56 lines)
Lines 97-104 __PACKAGE__->table("article_requests"); Link Here
97
=head2 status
97
=head2 status
98
98
99
  data_type: 'enum'
99
  data_type: 'enum'
100
  default_value: 'PENDING'
100
  default_value: 'REQUESTED'
101
  extra: {list => ["PENDING","PROCESSING","COMPLETED","CANCELED"]}
101
  extra: {list => ["REQUESTED","PENDING","PROCESSING","COMPLETED","CANCELED"]}
102
  is_nullable: 0
102
  is_nullable: 0
103
103
104
=head2 notes
104
=head2 notes
Lines 106-111 __PACKAGE__->table("article_requests"); Link Here
106
  data_type: 'mediumtext'
106
  data_type: 'mediumtext'
107
  is_nullable: 1
107
  is_nullable: 1
108
108
109
=head2 debit_line_id
110
111
  data_type: 'integer'
112
  is_foreign_key: 1
113
  is_nullable: 1
114
115
Debit line with cost for article scan request
116
109
=head2 format
117
=head2 format
110
118
111
  data_type: 'enum'
119
  data_type: 'enum'
Lines 118-123 __PACKAGE__->table("article_requests"); Link Here
118
  data_type: 'mediumtext'
126
  data_type: 'mediumtext'
119
  is_nullable: 1
127
  is_nullable: 1
120
128
129
=head2 cancellation_reason
130
131
  data_type: 'varchar'
132
  is_nullable: 1
133
  size: 80
134
135
optional authorised value AR_CANCELLATION
136
121
=head2 created_on
137
=head2 created_on
122
138
123
  data_type: 'timestamp'
139
  data_type: 'timestamp'
Lines 133-138 Be careful with two timestamps in one table not allowing NULL Link Here
133
  default_value: current_timestamp
149
  default_value: current_timestamp
134
  is_nullable: 0
150
  is_nullable: 0
135
151
152
=head2 toc_request
153
154
  data_type: 'tinyint'
155
  default_value: 0
156
  is_nullable: 0
157
136
=cut
158
=cut
137
159
138
__PACKAGE__->add_columns(
160
__PACKAGE__->add_columns(
Lines 165-176 __PACKAGE__->add_columns( Link Here
165
  "status",
187
  "status",
166
  {
188
  {
167
    data_type => "enum",
189
    data_type => "enum",
168
    default_value => "PENDING",
190
    default_value => "REQUESTED",
169
    extra => { list => ["PENDING", "PROCESSING", "COMPLETED", "CANCELED"] },
191
    extra => {
192
      list => ["REQUESTED", "PENDING", "PROCESSING", "COMPLETED", "CANCELED"],
193
    },
170
    is_nullable => 0,
194
    is_nullable => 0,
171
  },
195
  },
172
  "notes",
196
  "notes",
173
  { data_type => "mediumtext", is_nullable => 1 },
197
  { data_type => "mediumtext", is_nullable => 1 },
198
  "debit_line_id",
199
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
174
  "format",
200
  "format",
175
  {
201
  {
176
    data_type => "enum",
202
    data_type => "enum",
Lines 180-185 __PACKAGE__->add_columns( Link Here
180
  },
206
  },
181
  "urls",
207
  "urls",
182
  { data_type => "mediumtext", is_nullable => 1 },
208
  { data_type => "mediumtext", is_nullable => 1 },
209
  "cancellation_reason",
210
  { data_type => "varchar", is_nullable => 1, size => 80 },
183
  "created_on",
211
  "created_on",
184
  {
212
  {
185
    data_type => "timestamp",
213
    data_type => "timestamp",
Lines 193-198 __PACKAGE__->add_columns( Link Here
193
    default_value => \"current_timestamp",
221
    default_value => \"current_timestamp",
194
    is_nullable => 0,
222
    is_nullable => 0,
195
  },
223
  },
224
  "toc_request",
225
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
196
);
226
);
197
227
198
=head1 PRIMARY KEY
228
=head1 PRIMARY KEY
Lines 259-264 __PACKAGE__->belongs_to( Link Here
259
  },
289
  },
260
);
290
);
261
291
292
=head2 debit_line
293
294
Type: belongs_to
295
296
Related object: L<Koha::Schema::Result::Accountline>
297
298
=cut
299
300
__PACKAGE__->belongs_to(
301
  "debit_line",
302
  "Koha::Schema::Result::Accountline",
303
  { accountlines_id => "debit_line_id" },
304
  {
305
    is_deferrable => 1,
306
    join_type     => "LEFT",
307
    on_delete     => "SET NULL",
308
    on_update     => "CASCADE",
309
  },
310
);
311
262
=head2 itemnumber
312
=head2 itemnumber
263
313
264
Type: belongs_to
314
Type: belongs_to
Lines 280-287 __PACKAGE__->belongs_to( Link Here
280
);
330
);
281
331
282
332
283
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:41:15
333
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-23 12:32:28
284
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GVaBsoeXb0EiuKTJYkWLEg
334
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MgIKxsOJtbpcT9ZT6iAShA
285
335
286
336
287
# You can replace this text with custom code or comments, and it will be preserved on regeneration
337
# You can replace this text with custom code or comments, and it will be preserved on regeneration
288
- 

Return to bug 29093