2 package Koha::Schema::Result::HouseboundVisit;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::HouseboundVisit
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<housebound_visit>
22 __PACKAGE__->table("housebound_visit");
40 Number of the borrower, & the profile, linked to this visit.
42 =head2 appointment_date
45 datetime_undef_if_invalid: 1
56 Rough time frame: 'morning', 'afternoon' 'evening'
58 =head2 chooser_brwnumber
64 Number of the borrower to choose items for delivery.
66 =head2 deliverer_brwnumber
72 Number of the borrower to deliver items.
76 __PACKAGE__->add_columns(
78 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
80 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
82 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
84 { data_type => "varchar", is_nullable => 1, size => 10 },
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 },
101 __PACKAGE__->set_primary_key("id");
105 =head2 borrowernumber
109 Related object: L<Koha::Schema::Result::HouseboundProfile>
113 __PACKAGE__->belongs_to(
115 "Koha::Schema::Result::HouseboundProfile",
116 { borrowernumber => "borrowernumber" },
117 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
120 =head2 chooser_brwnumber
124 Related object: L<Koha::Schema::Result::Borrower>
128 __PACKAGE__->belongs_to(
130 "Koha::Schema::Result::Borrower",
131 { borrowernumber => "chooser_brwnumber" },
135 on_delete => "CASCADE",
136 on_update => "CASCADE",
140 =head2 deliverer_brwnumber
144 Related object: L<Koha::Schema::Result::Borrower>
148 __PACKAGE__->belongs_to(
149 "deliverer_brwnumber",
150 "Koha::Schema::Result::Borrower",
151 { borrowernumber => "deliverer_brwnumber" },
155 on_delete => "CASCADE",
156 on_update => "CASCADE",
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
164 sub koha_object_class {
165 'Koha::Patron::HouseboundVisit';
167 sub koha_objects_class {
168 'Koha::Patron::HouseboundVisits';