Koha/Schema/Result/HouseboundVisit.pm

   1 use utf8;
   2 package Koha::Schema::Result::HouseboundVisit;
   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::HouseboundVisit
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<housebound_visit>
  19
  20 =cut
  21
  22 __PACKAGE__->table("housebound_visit");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 id
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 ID of the visit.
  33
  34 =head2 borrowernumber
  35
  36   data_type: 'integer'
  37   is_foreign_key: 1
  38   is_nullable: 0
  39
  40 Number of the borrower, & the profile, linked to this visit.
  41
  42 =head2 appointment_date
  43
  44   data_type: 'date'
  45   datetime_undef_if_invalid: 1
  46   is_nullable: 1
  47
  48 Date of visit.
  49
  50 =head2 day_segment
  51
  52   data_type: 'varchar'
  53   is_nullable: 1
  54   size: 10
  55
  56 Rough time frame: 'morning', 'afternoon' 'evening'
  57
  58 =head2 chooser_brwnumber
  59
  60   data_type: 'integer'
  61   is_foreign_key: 1
  62   is_nullable: 1
  63
  64 Number of the borrower to choose items  for delivery.
  65
  66 =head2 deliverer_brwnumber
  67
  68   data_type: 'integer'
  69   is_foreign_key: 1
  70   is_nullable: 1
  71
  72 Number of the borrower to deliver items.
  73
  74 =cut
  75
  76 __PACKAGE__->add_columns(
  77   "id",
  78   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  79   "borrowernumber",
  80   { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  81   "appointment_date",
  82   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  83   "day_segment",
  84   { data_type => "varchar", is_nullable => 1, size => 10 },
  85   "chooser_brwnumber",
  86   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  87   "deliverer_brwnumber",
  88   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  89 );
  90
  91 =head1 PRIMARY KEY
  92
  93 =over 4
  94
  95 =item * L</id>
  96
  97 =back
  98
  99 =cut
 100
 101 __PACKAGE__->set_primary_key("id");
 102
 103 =head1 RELATIONS
 104
 105 =head2 borrowernumber
 106
 107 Type: belongs_to
 108
 109 Related object: L<Koha::Schema::Result::HouseboundProfile>
 110
 111 =cut
 112
 113 __PACKAGE__->belongs_to(
 114   "borrowernumber",
 115   "Koha::Schema::Result::HouseboundProfile",
 116   { borrowernumber => "borrowernumber" },
 117   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 118 );
 119
 120 =head2 chooser_brwnumber
 121
 122 Type: belongs_to
 123
 124 Related object: L<Koha::Schema::Result::Borrower>
 125
 126 =cut
 127
 128 __PACKAGE__->belongs_to(
 129   "chooser_brwnumber",
 130   "Koha::Schema::Result::Borrower",
 131   { borrowernumber => "chooser_brwnumber" },
 132   {
 133     is_deferrable => 1,
 134     join_type     => "LEFT",
 135     on_delete     => "CASCADE",
 136     on_update     => "CASCADE",
 137   },
 138 );
 139
 140 =head2 deliverer_brwnumber
 141
 142 Type: belongs_to
 143
 144 Related object: L<Koha::Schema::Result::Borrower>
 145
 146 =cut
 147
 148 __PACKAGE__->belongs_to(
 149   "deliverer_brwnumber",
 150   "Koha::Schema::Result::Borrower",
 151   { borrowernumber => "deliverer_brwnumber" },
 152   {
 153     is_deferrable => 1,
 154     join_type     => "LEFT",
 155     on_delete     => "CASCADE",
 156     on_update     => "CASCADE",
 157   },
 158 );
 159
 160
 161 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
 162 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PJwWk4901BF+CG6AXgjffg
 163
 164 sub koha_object_class {
 165     'Koha::Patron::HouseboundVisit';
 166 }
 167 sub koha_objects_class {
 168     'Koha::Patron::HouseboundVisits';
 169 }
 170
 171 1;