Line 0
Link Here
|
0 |
- |
1 |
use utf8; |
|
|
2 |
package Koha::Schema::Result::PseudonymizedTransaction; |
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::PseudonymizedTransaction |
10 |
|
11 |
=cut |
12 |
|
13 |
use strict; |
14 |
use warnings; |
15 |
|
16 |
use base 'DBIx::Class::Core'; |
17 |
|
18 |
=head1 TABLE: C<pseudonymized_transactions> |
19 |
|
20 |
=cut |
21 |
|
22 |
__PACKAGE__->table("pseudonymized_transactions"); |
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 hashed_borrowernumber |
33 |
|
34 |
data_type: 'varchar' |
35 |
is_nullable: 0 |
36 |
size: 60 |
37 |
|
38 |
=head2 has_cardnumber |
39 |
|
40 |
data_type: 'tinyint' |
41 |
default_value: 0 |
42 |
is_nullable: 0 |
43 |
|
44 |
=head2 title |
45 |
|
46 |
data_type: 'longtext' |
47 |
is_nullable: 1 |
48 |
|
49 |
=head2 city |
50 |
|
51 |
data_type: 'longtext' |
52 |
is_nullable: 1 |
53 |
|
54 |
=head2 state |
55 |
|
56 |
data_type: 'mediumtext' |
57 |
is_nullable: 1 |
58 |
|
59 |
=head2 zipcode |
60 |
|
61 |
data_type: 'varchar' |
62 |
is_nullable: 1 |
63 |
size: 25 |
64 |
|
65 |
=head2 country |
66 |
|
67 |
data_type: 'mediumtext' |
68 |
is_nullable: 1 |
69 |
|
70 |
=head2 branchcode |
71 |
|
72 |
data_type: 'varchar' |
73 |
default_value: (empty string) |
74 |
is_foreign_key: 1 |
75 |
is_nullable: 0 |
76 |
size: 10 |
77 |
|
78 |
=head2 categorycode |
79 |
|
80 |
data_type: 'varchar' |
81 |
default_value: (empty string) |
82 |
is_foreign_key: 1 |
83 |
is_nullable: 0 |
84 |
size: 10 |
85 |
|
86 |
=head2 dateenrolled |
87 |
|
88 |
data_type: 'date' |
89 |
datetime_undef_if_invalid: 1 |
90 |
is_nullable: 1 |
91 |
|
92 |
=head2 sex |
93 |
|
94 |
data_type: 'varchar' |
95 |
is_nullable: 1 |
96 |
size: 1 |
97 |
|
98 |
=head2 sort1 |
99 |
|
100 |
data_type: 'varchar' |
101 |
is_nullable: 1 |
102 |
size: 80 |
103 |
|
104 |
=head2 sort2 |
105 |
|
106 |
data_type: 'varchar' |
107 |
is_nullable: 1 |
108 |
size: 80 |
109 |
|
110 |
=head2 datetime |
111 |
|
112 |
data_type: 'datetime' |
113 |
datetime_undef_if_invalid: 1 |
114 |
is_nullable: 1 |
115 |
|
116 |
=head2 transaction_branchcode |
117 |
|
118 |
data_type: 'varchar' |
119 |
is_foreign_key: 1 |
120 |
is_nullable: 1 |
121 |
size: 10 |
122 |
|
123 |
=head2 transaction_type |
124 |
|
125 |
data_type: 'varchar' |
126 |
is_nullable: 1 |
127 |
size: 16 |
128 |
|
129 |
=head2 itemnumber |
130 |
|
131 |
data_type: 'integer' |
132 |
is_nullable: 1 |
133 |
|
134 |
=head2 itemtype |
135 |
|
136 |
data_type: 'varchar' |
137 |
is_nullable: 1 |
138 |
size: 10 |
139 |
|
140 |
=head2 holdingbranch |
141 |
|
142 |
data_type: 'varchar' |
143 |
is_nullable: 1 |
144 |
size: 10 |
145 |
|
146 |
=head2 location |
147 |
|
148 |
data_type: 'varchar' |
149 |
is_nullable: 1 |
150 |
size: 80 |
151 |
|
152 |
=head2 itemcallnumber |
153 |
|
154 |
data_type: 'varchar' |
155 |
is_nullable: 1 |
156 |
size: 255 |
157 |
|
158 |
=head2 ccode |
159 |
|
160 |
data_type: 'varchar' |
161 |
is_nullable: 1 |
162 |
size: 80 |
163 |
|
164 |
=cut |
165 |
|
166 |
__PACKAGE__->add_columns( |
167 |
"id", |
168 |
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, |
169 |
"hashed_borrowernumber", |
170 |
{ data_type => "varchar", is_nullable => 0, size => 60 }, |
171 |
"has_cardnumber", |
172 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
173 |
"title", |
174 |
{ data_type => "longtext", is_nullable => 1 }, |
175 |
"city", |
176 |
{ data_type => "longtext", is_nullable => 1 }, |
177 |
"state", |
178 |
{ data_type => "mediumtext", is_nullable => 1 }, |
179 |
"zipcode", |
180 |
{ data_type => "varchar", is_nullable => 1, size => 25 }, |
181 |
"country", |
182 |
{ data_type => "mediumtext", is_nullable => 1 }, |
183 |
"branchcode", |
184 |
{ |
185 |
data_type => "varchar", |
186 |
default_value => "", |
187 |
is_foreign_key => 1, |
188 |
is_nullable => 0, |
189 |
size => 10, |
190 |
}, |
191 |
"categorycode", |
192 |
{ |
193 |
data_type => "varchar", |
194 |
default_value => "", |
195 |
is_foreign_key => 1, |
196 |
is_nullable => 0, |
197 |
size => 10, |
198 |
}, |
199 |
"dateenrolled", |
200 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
201 |
"sex", |
202 |
{ data_type => "varchar", is_nullable => 1, size => 1 }, |
203 |
"sort1", |
204 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
205 |
"sort2", |
206 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
207 |
"datetime", |
208 |
{ |
209 |
data_type => "datetime", |
210 |
datetime_undef_if_invalid => 1, |
211 |
is_nullable => 1, |
212 |
}, |
213 |
"transaction_branchcode", |
214 |
{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, |
215 |
"transaction_type", |
216 |
{ data_type => "varchar", is_nullable => 1, size => 16 }, |
217 |
"itemnumber", |
218 |
{ data_type => "integer", is_nullable => 1 }, |
219 |
"itemtype", |
220 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
221 |
"holdingbranch", |
222 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
223 |
"location", |
224 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
225 |
"itemcallnumber", |
226 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
227 |
"ccode", |
228 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
229 |
); |
230 |
|
231 |
=head1 PRIMARY KEY |
232 |
|
233 |
=over 4 |
234 |
|
235 |
=item * L</id> |
236 |
|
237 |
=back |
238 |
|
239 |
=cut |
240 |
|
241 |
__PACKAGE__->set_primary_key("id"); |
242 |
|
243 |
=head1 RELATIONS |
244 |
|
245 |
=head2 branchcode |
246 |
|
247 |
Type: belongs_to |
248 |
|
249 |
Related object: L<Koha::Schema::Result::Branch> |
250 |
|
251 |
=cut |
252 |
|
253 |
__PACKAGE__->belongs_to( |
254 |
"branchcode", |
255 |
"Koha::Schema::Result::Branch", |
256 |
{ branchcode => "branchcode" }, |
257 |
{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" }, |
258 |
); |
259 |
|
260 |
=head2 categorycode |
261 |
|
262 |
Type: belongs_to |
263 |
|
264 |
Related object: L<Koha::Schema::Result::Category> |
265 |
|
266 |
=cut |
267 |
|
268 |
__PACKAGE__->belongs_to( |
269 |
"categorycode", |
270 |
"Koha::Schema::Result::Category", |
271 |
{ categorycode => "categorycode" }, |
272 |
{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" }, |
273 |
); |
274 |
|
275 |
=head2 transaction_branchcode |
276 |
|
277 |
Type: belongs_to |
278 |
|
279 |
Related object: L<Koha::Schema::Result::Branch> |
280 |
|
281 |
=cut |
282 |
|
283 |
__PACKAGE__->belongs_to( |
284 |
"transaction_branchcode", |
285 |
"Koha::Schema::Result::Branch", |
286 |
{ branchcode => "transaction_branchcode" }, |
287 |
{ |
288 |
is_deferrable => 1, |
289 |
join_type => "LEFT", |
290 |
on_delete => "RESTRICT", |
291 |
on_update => "RESTRICT", |
292 |
}, |
293 |
); |
294 |
|
295 |
|
296 |
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 16:08:51 |
297 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r3YdoQ6TKEF0THmeXHvRwA |
298 |
|
299 |
|
300 |
# You can replace this text with custom code or comments, and it will be preserved on regeneration |
301 |
1; |