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

(-)a/Koha/Schema/Result/Aqbookseller.pm (-2 / +32 lines)
Lines 371-376 __PACKAGE__->belongs_to( Link Here
371
  },
371
  },
372
);
372
);
373
373
374
=head2 serials
375
376
Type: has_many
377
378
Related object: L<Koha::Schema::Result::Serial>
379
380
=cut
381
382
__PACKAGE__->has_many(
383
  "serials",
384
  "Koha::Schema::Result::Serial",
385
  { "foreign.aqbooksellerid" => "self.id" },
386
  { cascade_copy => 0, cascade_delete => 0 },
387
);
388
389
=head2 subscriptions
390
391
Type: has_many
392
393
Related object: L<Koha::Schema::Result::Subscription>
394
395
=cut
396
397
__PACKAGE__->has_many(
398
  "subscriptions",
399
  "Koha::Schema::Result::Subscription",
400
  { "foreign.aqbooksellerid" => "self.id" },
401
  { cascade_copy => 0, cascade_delete => 0 },
402
);
403
374
=head2 vendor_edi_accounts
404
=head2 vendor_edi_accounts
375
405
376
Type: has_many
406
Type: has_many
Lines 387-394 __PACKAGE__->has_many( Link Here
387
);
417
);
388
418
389
419
390
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
420
# Created by DBIx::Class::Schema::Loader v0.07048 @ 2022-07-31 21:00:40
391
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qu4OqSCsEKEeJD9VtOEd4g
421
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T5/SMpqTy9WLK3cqqL20jg
392
422
393
__PACKAGE__->add_columns(
423
__PACKAGE__->add_columns(
394
    '+active' => { is_boolean => 1 },
424
    '+active' => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Serial.pm (-2 / +32 lines)
Lines 47-52 foreign key for the biblio.biblionumber that this issue is attached to Link Here
47
47
48
foreign key to the subscription.subscriptionid that this issue is part of
48
foreign key to the subscription.subscriptionid that this issue is part of
49
49
50
=head2 aqbooksellerid
51
52
  data_type: 'integer'
53
  is_foreign_key: 1
54
  is_nullable: 1
55
56
the subscription's bookseller at the time of creation (used for claims)
57
50
=head2 serialseq
58
=head2 serialseq
51
59
52
  data_type: 'varchar'
60
  data_type: 'varchar'
Lines 151-156 __PACKAGE__->add_columns( Link Here
151
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
159
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
152
  "subscriptionid",
160
  "subscriptionid",
153
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
161
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
162
  "aqbooksellerid",
163
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
154
  "serialseq",
164
  "serialseq",
155
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
165
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
156
  "serialseq_x",
166
  "serialseq_x",
Lines 191-196 __PACKAGE__->set_primary_key("serialid"); Link Here
191
201
192
=head1 RELATIONS
202
=head1 RELATIONS
193
203
204
=head2 aqbooksellerid
205
206
Type: belongs_to
207
208
Related object: L<Koha::Schema::Result::Aqbookseller>
209
210
=cut
211
212
__PACKAGE__->belongs_to(
213
  "aqbooksellerid",
214
  "Koha::Schema::Result::Aqbookseller",
215
  { id => "aqbooksellerid" },
216
  {
217
    is_deferrable => 1,
218
    join_type     => "LEFT",
219
    on_delete     => "RESTRICT",
220
    on_update     => "RESTRICT",
221
  },
222
);
223
194
=head2 biblionumber
224
=head2 biblionumber
195
225
196
Type: belongs_to
226
Type: belongs_to
Lines 237-244 __PACKAGE__->belongs_to( Link Here
237
);
267
);
238
268
239
269
240
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
270
# Created by DBIx::Class::Schema::Loader v0.07048 @ 2022-07-31 21:00:41
241
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SD7llCvCO+/67cXetzRKPQ
271
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zqosYcct1Mu/MqsBKHWJmA
242
272
243
273
244
# You can replace this text with custom code or comments, and it will be preserved on regeneration
274
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Subscription.pm (-5 / +24 lines)
Lines 59-65 start date for this subscription Link Here
59
=head2 aqbooksellerid
59
=head2 aqbooksellerid
60
60
61
  data_type: 'integer'
61
  data_type: 'integer'
62
  default_value: 0
62
  is_foreign_key: 1
63
  is_nullable: 1
63
  is_nullable: 1
64
64
65
foreign key for aqbooksellers.id to link to the vendor
65
foreign key for aqbooksellers.id to link to the vendor
Lines 346-352 __PACKAGE__->add_columns( Link Here
346
  "startdate",
346
  "startdate",
347
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
347
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
348
  "aqbooksellerid",
348
  "aqbooksellerid",
349
  { data_type => "integer", default_value => 0, is_nullable => 1 },
349
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
350
  "cost",
350
  "cost",
351
  { data_type => "integer", default_value => 0, is_nullable => 1 },
351
  { data_type => "integer", default_value => 0, is_nullable => 1 },
352
  "aqbudgetid",
352
  "aqbudgetid",
Lines 441-446 __PACKAGE__->set_primary_key("subscriptionid"); Link Here
441
441
442
=head1 RELATIONS
442
=head1 RELATIONS
443
443
444
=head2 aqbooksellerid
445
446
Type: belongs_to
447
448
Related object: L<Koha::Schema::Result::Aqbookseller>
449
450
=cut
451
452
__PACKAGE__->belongs_to(
453
  "aqbooksellerid",
454
  "Koha::Schema::Result::Aqbookseller",
455
  { id => "aqbooksellerid" },
456
  {
457
    is_deferrable => 1,
458
    join_type     => "LEFT",
459
    on_delete     => "RESTRICT",
460
    on_update     => "CASCADE",
461
  },
462
);
463
444
=head2 aqorders
464
=head2 aqorders
445
465
446
Type: has_many
466
Type: has_many
Lines 557-564 __PACKAGE__->has_many( Link Here
557
);
577
);
558
578
559
579
560
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2022-07-05 17:45:12
580
# Created by DBIx::Class::Schema::Loader v0.07048 @ 2022-07-31 21:00:41
561
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MFOz3AKUVSPuQv6kMb1EbA
581
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+cpI7T2LKWUL+lSXD/nFeg
562
582
563
__PACKAGE__->has_many(
583
__PACKAGE__->has_many(
564
  "additional_field_values",
584
  "additional_field_values",
565
- 

Return to bug 18745