Line 0
Link Here
|
|
|
1 |
use utf8; |
2 |
package Koha::Schema::Result::CurbsidePickup; |
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::CurbsidePickup |
10 |
|
11 |
=cut |
12 |
|
13 |
use strict; |
14 |
use warnings; |
15 |
|
16 |
use base 'DBIx::Class::Core'; |
17 |
|
18 |
=head1 TABLE: C<curbside_pickups> |
19 |
|
20 |
=cut |
21 |
|
22 |
__PACKAGE__->table("curbside_pickups"); |
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 borrowernumber |
33 |
|
34 |
data_type: 'integer' |
35 |
is_foreign_key: 1 |
36 |
is_nullable: 0 |
37 |
|
38 |
=head2 branchcode |
39 |
|
40 |
data_type: 'varchar' |
41 |
is_foreign_key: 1 |
42 |
is_nullable: 0 |
43 |
size: 10 |
44 |
|
45 |
=head2 scheduled_pickup_datetime |
46 |
|
47 |
data_type: 'datetime' |
48 |
datetime_undef_if_invalid: 1 |
49 |
is_nullable: 0 |
50 |
|
51 |
=head2 staged_datetime |
52 |
|
53 |
data_type: 'datetime' |
54 |
datetime_undef_if_invalid: 1 |
55 |
is_nullable: 1 |
56 |
|
57 |
=head2 staged_by |
58 |
|
59 |
data_type: 'integer' |
60 |
is_foreign_key: 1 |
61 |
is_nullable: 1 |
62 |
|
63 |
=head2 arrival_datetime |
64 |
|
65 |
data_type: 'datetime' |
66 |
datetime_undef_if_invalid: 1 |
67 |
is_nullable: 1 |
68 |
|
69 |
=head2 delivered_datetime |
70 |
|
71 |
data_type: 'datetime' |
72 |
datetime_undef_if_invalid: 1 |
73 |
is_nullable: 1 |
74 |
|
75 |
=head2 delivered_by |
76 |
|
77 |
data_type: 'integer' |
78 |
is_nullable: 1 |
79 |
|
80 |
=head2 notes |
81 |
|
82 |
data_type: 'text' |
83 |
is_nullable: 1 |
84 |
|
85 |
=cut |
86 |
|
87 |
__PACKAGE__->add_columns( |
88 |
"id", |
89 |
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, |
90 |
"borrowernumber", |
91 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, |
92 |
"branchcode", |
93 |
{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 }, |
94 |
"scheduled_pickup_datetime", |
95 |
{ |
96 |
data_type => "datetime", |
97 |
datetime_undef_if_invalid => 1, |
98 |
is_nullable => 0, |
99 |
}, |
100 |
"staged_datetime", |
101 |
{ |
102 |
data_type => "datetime", |
103 |
datetime_undef_if_invalid => 1, |
104 |
is_nullable => 1, |
105 |
}, |
106 |
"staged_by", |
107 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
108 |
"arrival_datetime", |
109 |
{ |
110 |
data_type => "datetime", |
111 |
datetime_undef_if_invalid => 1, |
112 |
is_nullable => 1, |
113 |
}, |
114 |
"delivered_datetime", |
115 |
{ |
116 |
data_type => "datetime", |
117 |
datetime_undef_if_invalid => 1, |
118 |
is_nullable => 1, |
119 |
}, |
120 |
"delivered_by", |
121 |
{ data_type => "integer", is_nullable => 1 }, |
122 |
"notes", |
123 |
{ data_type => "text", is_nullable => 1 }, |
124 |
); |
125 |
|
126 |
=head1 PRIMARY KEY |
127 |
|
128 |
=over 4 |
129 |
|
130 |
=item * L</id> |
131 |
|
132 |
=back |
133 |
|
134 |
=cut |
135 |
|
136 |
__PACKAGE__->set_primary_key("id"); |
137 |
|
138 |
=head1 RELATIONS |
139 |
|
140 |
=head2 borrowernumber |
141 |
|
142 |
Type: belongs_to |
143 |
|
144 |
Related object: L<Koha::Schema::Result::Borrower> |
145 |
|
146 |
=cut |
147 |
|
148 |
__PACKAGE__->belongs_to( |
149 |
"borrowernumber", |
150 |
"Koha::Schema::Result::Borrower", |
151 |
{ borrowernumber => "borrowernumber" }, |
152 |
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, |
153 |
); |
154 |
|
155 |
=head2 branchcode |
156 |
|
157 |
Type: belongs_to |
158 |
|
159 |
Related object: L<Koha::Schema::Result::Branch> |
160 |
|
161 |
=cut |
162 |
|
163 |
__PACKAGE__->belongs_to( |
164 |
"branchcode", |
165 |
"Koha::Schema::Result::Branch", |
166 |
{ branchcode => "branchcode" }, |
167 |
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, |
168 |
); |
169 |
|
170 |
=head2 curbside_pickup_issues |
171 |
|
172 |
Type: has_many |
173 |
|
174 |
Related object: L<Koha::Schema::Result::CurbsidePickupIssue> |
175 |
|
176 |
=cut |
177 |
|
178 |
__PACKAGE__->has_many( |
179 |
"curbside_pickup_issues", |
180 |
"Koha::Schema::Result::CurbsidePickupIssue", |
181 |
{ "foreign.curbside_pickup_id" => "self.id" }, |
182 |
{ cascade_copy => 0, cascade_delete => 0 }, |
183 |
); |
184 |
|
185 |
=head2 staged_by |
186 |
|
187 |
Type: belongs_to |
188 |
|
189 |
Related object: L<Koha::Schema::Result::Borrower> |
190 |
|
191 |
=cut |
192 |
|
193 |
__PACKAGE__->belongs_to( |
194 |
"staged_by", |
195 |
"Koha::Schema::Result::Borrower", |
196 |
{ borrowernumber => "staged_by" }, |
197 |
{ |
198 |
is_deferrable => 1, |
199 |
join_type => "LEFT", |
200 |
on_delete => "SET NULL", |
201 |
on_update => "CASCADE", |
202 |
}, |
203 |
); |
204 |
|
205 |
|
206 |
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-27 11:58:44 |
207 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8gt7Vqurdid0rwmBMPI5yg |
208 |
|
209 |
|
210 |
# You can replace this text with custom code or comments, and it will be preserved on regeneration |
211 |
1; |