Lines 29-201
__PACKAGE__->table("borrowers");
Link Here
|
29 |
is_auto_increment: 1 |
29 |
is_auto_increment: 1 |
30 |
is_nullable: 0 |
30 |
is_nullable: 0 |
31 |
|
31 |
|
|
|
32 |
primary key, Koha assigned ID number for patrons/borrowers |
33 |
|
32 |
=head2 cardnumber |
34 |
=head2 cardnumber |
33 |
|
35 |
|
34 |
data_type: 'varchar' |
36 |
data_type: 'varchar' |
35 |
is_nullable: 1 |
37 |
is_nullable: 1 |
36 |
size: 32 |
38 |
size: 32 |
37 |
|
39 |
|
|
|
40 |
unique key, library assigned ID number for patrons/borrowers |
41 |
|
38 |
=head2 surname |
42 |
=head2 surname |
39 |
|
43 |
|
40 |
data_type: 'longtext' |
44 |
data_type: 'longtext' |
41 |
is_nullable: 1 |
45 |
is_nullable: 1 |
42 |
|
46 |
|
|
|
47 |
patron/borrower's last name (surname) |
48 |
|
43 |
=head2 firstname |
49 |
=head2 firstname |
44 |
|
50 |
|
45 |
data_type: 'mediumtext' |
51 |
data_type: 'mediumtext' |
46 |
is_nullable: 1 |
52 |
is_nullable: 1 |
47 |
|
53 |
|
|
|
54 |
patron/borrower's first name |
55 |
|
48 |
=head2 title |
56 |
=head2 title |
49 |
|
57 |
|
50 |
data_type: 'longtext' |
58 |
data_type: 'longtext' |
51 |
is_nullable: 1 |
59 |
is_nullable: 1 |
52 |
|
60 |
|
|
|
61 |
patron/borrower's title, for example: Mr. or Mrs. |
62 |
|
53 |
=head2 othernames |
63 |
=head2 othernames |
54 |
|
64 |
|
55 |
data_type: 'longtext' |
65 |
data_type: 'longtext' |
56 |
is_nullable: 1 |
66 |
is_nullable: 1 |
57 |
|
67 |
|
|
|
68 |
any other names associated with the patron/borrower |
69 |
|
58 |
=head2 initials |
70 |
=head2 initials |
59 |
|
71 |
|
60 |
data_type: 'mediumtext' |
72 |
data_type: 'mediumtext' |
61 |
is_nullable: 1 |
73 |
is_nullable: 1 |
62 |
|
74 |
|
|
|
75 |
initials for your patron/borrower |
76 |
|
63 |
=head2 streetnumber |
77 |
=head2 streetnumber |
64 |
|
78 |
|
65 |
data_type: 'tinytext' |
79 |
data_type: 'tinytext' |
66 |
is_nullable: 1 |
80 |
is_nullable: 1 |
67 |
|
81 |
|
|
|
82 |
the house number for your patron/borrower's primary address |
83 |
|
68 |
=head2 streettype |
84 |
=head2 streettype |
69 |
|
85 |
|
70 |
data_type: 'tinytext' |
86 |
data_type: 'tinytext' |
71 |
is_nullable: 1 |
87 |
is_nullable: 1 |
72 |
|
88 |
|
|
|
89 |
the street type (Rd., Blvd, etc) for your patron/borrower's primary address |
90 |
|
73 |
=head2 address |
91 |
=head2 address |
74 |
|
92 |
|
75 |
data_type: 'longtext' |
93 |
data_type: 'longtext' |
76 |
is_nullable: 1 |
94 |
is_nullable: 1 |
77 |
|
95 |
|
|
|
96 |
the first address line for your patron/borrower's primary address |
97 |
|
78 |
=head2 address2 |
98 |
=head2 address2 |
79 |
|
99 |
|
80 |
data_type: 'mediumtext' |
100 |
data_type: 'mediumtext' |
81 |
is_nullable: 1 |
101 |
is_nullable: 1 |
82 |
|
102 |
|
|
|
103 |
the second address line for your patron/borrower's primary address |
104 |
|
83 |
=head2 city |
105 |
=head2 city |
84 |
|
106 |
|
85 |
data_type: 'longtext' |
107 |
data_type: 'longtext' |
86 |
is_nullable: 1 |
108 |
is_nullable: 1 |
87 |
|
109 |
|
|
|
110 |
the city or town for your patron/borrower's primary address |
111 |
|
88 |
=head2 state |
112 |
=head2 state |
89 |
|
113 |
|
90 |
data_type: 'mediumtext' |
114 |
data_type: 'mediumtext' |
91 |
is_nullable: 1 |
115 |
is_nullable: 1 |
92 |
|
116 |
|
|
|
117 |
the state or province for your patron/borrower's primary address |
118 |
|
93 |
=head2 zipcode |
119 |
=head2 zipcode |
94 |
|
120 |
|
95 |
data_type: 'tinytext' |
121 |
data_type: 'tinytext' |
96 |
is_nullable: 1 |
122 |
is_nullable: 1 |
97 |
|
123 |
|
|
|
124 |
the zip or postal code for your patron/borrower's primary address |
125 |
|
98 |
=head2 country |
126 |
=head2 country |
99 |
|
127 |
|
100 |
data_type: 'mediumtext' |
128 |
data_type: 'mediumtext' |
101 |
is_nullable: 1 |
129 |
is_nullable: 1 |
102 |
|
130 |
|
|
|
131 |
the country for your patron/borrower's primary address |
132 |
|
103 |
=head2 email |
133 |
=head2 email |
104 |
|
134 |
|
105 |
data_type: 'longtext' |
135 |
data_type: 'longtext' |
106 |
is_nullable: 1 |
136 |
is_nullable: 1 |
107 |
|
137 |
|
|
|
138 |
the primary email address for your patron/borrower's primary address |
139 |
|
108 |
=head2 phone |
140 |
=head2 phone |
109 |
|
141 |
|
110 |
data_type: 'mediumtext' |
142 |
data_type: 'mediumtext' |
111 |
is_nullable: 1 |
143 |
is_nullable: 1 |
112 |
|
144 |
|
|
|
145 |
the primary phone number for your patron/borrower's primary address |
146 |
|
113 |
=head2 mobile |
147 |
=head2 mobile |
114 |
|
148 |
|
115 |
data_type: 'tinytext' |
149 |
data_type: 'tinytext' |
116 |
is_nullable: 1 |
150 |
is_nullable: 1 |
117 |
|
151 |
|
|
|
152 |
the other phone number for your patron/borrower's primary address |
153 |
|
118 |
=head2 fax |
154 |
=head2 fax |
119 |
|
155 |
|
120 |
data_type: 'longtext' |
156 |
data_type: 'longtext' |
121 |
is_nullable: 1 |
157 |
is_nullable: 1 |
122 |
|
158 |
|
|
|
159 |
the fax number for your patron/borrower's primary address |
160 |
|
123 |
=head2 emailpro |
161 |
=head2 emailpro |
124 |
|
162 |
|
125 |
data_type: 'mediumtext' |
163 |
data_type: 'mediumtext' |
126 |
is_nullable: 1 |
164 |
is_nullable: 1 |
127 |
|
165 |
|
|
|
166 |
the secondary email addres for your patron/borrower's primary address |
167 |
|
128 |
=head2 phonepro |
168 |
=head2 phonepro |
129 |
|
169 |
|
130 |
data_type: 'mediumtext' |
170 |
data_type: 'mediumtext' |
131 |
is_nullable: 1 |
171 |
is_nullable: 1 |
132 |
|
172 |
|
|
|
173 |
the secondary phone number for your patron/borrower's primary address |
174 |
|
133 |
=head2 B_streetnumber |
175 |
=head2 B_streetnumber |
134 |
|
176 |
|
135 |
accessor: 'b_streetnumber' |
177 |
accessor: 'b_streetnumber' |
136 |
data_type: 'tinytext' |
178 |
data_type: 'tinytext' |
137 |
is_nullable: 1 |
179 |
is_nullable: 1 |
138 |
|
180 |
|
|
|
181 |
the house number for your patron/borrower's alternate address |
182 |
|
139 |
=head2 B_streettype |
183 |
=head2 B_streettype |
140 |
|
184 |
|
141 |
accessor: 'b_streettype' |
185 |
accessor: 'b_streettype' |
142 |
data_type: 'tinytext' |
186 |
data_type: 'tinytext' |
143 |
is_nullable: 1 |
187 |
is_nullable: 1 |
144 |
|
188 |
|
|
|
189 |
the street type (Rd., Blvd, etc) for your patron/borrower's alternate address |
190 |
|
145 |
=head2 B_address |
191 |
=head2 B_address |
146 |
|
192 |
|
147 |
accessor: 'b_address' |
193 |
accessor: 'b_address' |
148 |
data_type: 'mediumtext' |
194 |
data_type: 'mediumtext' |
149 |
is_nullable: 1 |
195 |
is_nullable: 1 |
150 |
|
196 |
|
|
|
197 |
the first address line for your patron/borrower's alternate address |
198 |
|
151 |
=head2 B_address2 |
199 |
=head2 B_address2 |
152 |
|
200 |
|
153 |
accessor: 'b_address2' |
201 |
accessor: 'b_address2' |
154 |
data_type: 'mediumtext' |
202 |
data_type: 'mediumtext' |
155 |
is_nullable: 1 |
203 |
is_nullable: 1 |
156 |
|
204 |
|
|
|
205 |
the second address line for your patron/borrower's alternate address |
206 |
|
157 |
=head2 B_city |
207 |
=head2 B_city |
158 |
|
208 |
|
159 |
accessor: 'b_city' |
209 |
accessor: 'b_city' |
160 |
data_type: 'longtext' |
210 |
data_type: 'longtext' |
161 |
is_nullable: 1 |
211 |
is_nullable: 1 |
162 |
|
212 |
|
|
|
213 |
the city or town for your patron/borrower's alternate address |
214 |
|
163 |
=head2 B_state |
215 |
=head2 B_state |
164 |
|
216 |
|
165 |
accessor: 'b_state' |
217 |
accessor: 'b_state' |
166 |
data_type: 'mediumtext' |
218 |
data_type: 'mediumtext' |
167 |
is_nullable: 1 |
219 |
is_nullable: 1 |
168 |
|
220 |
|
|
|
221 |
the state for your patron/borrower's alternate address |
222 |
|
169 |
=head2 B_zipcode |
223 |
=head2 B_zipcode |
170 |
|
224 |
|
171 |
accessor: 'b_zipcode' |
225 |
accessor: 'b_zipcode' |
172 |
data_type: 'tinytext' |
226 |
data_type: 'tinytext' |
173 |
is_nullable: 1 |
227 |
is_nullable: 1 |
174 |
|
228 |
|
|
|
229 |
the zip or postal code for your patron/borrower's alternate address |
230 |
|
175 |
=head2 B_country |
231 |
=head2 B_country |
176 |
|
232 |
|
177 |
accessor: 'b_country' |
233 |
accessor: 'b_country' |
178 |
data_type: 'mediumtext' |
234 |
data_type: 'mediumtext' |
179 |
is_nullable: 1 |
235 |
is_nullable: 1 |
180 |
|
236 |
|
|
|
237 |
the country for your patron/borrower's alternate address |
238 |
|
181 |
=head2 B_email |
239 |
=head2 B_email |
182 |
|
240 |
|
183 |
accessor: 'b_email' |
241 |
accessor: 'b_email' |
184 |
data_type: 'mediumtext' |
242 |
data_type: 'mediumtext' |
185 |
is_nullable: 1 |
243 |
is_nullable: 1 |
186 |
|
244 |
|
|
|
245 |
the patron/borrower's alternate email address |
246 |
|
187 |
=head2 B_phone |
247 |
=head2 B_phone |
188 |
|
248 |
|
189 |
accessor: 'b_phone' |
249 |
accessor: 'b_phone' |
190 |
data_type: 'longtext' |
250 |
data_type: 'longtext' |
191 |
is_nullable: 1 |
251 |
is_nullable: 1 |
192 |
|
252 |
|
|
|
253 |
the patron/borrower's alternate phone number |
254 |
|
193 |
=head2 dateofbirth |
255 |
=head2 dateofbirth |
194 |
|
256 |
|
195 |
data_type: 'date' |
257 |
data_type: 'date' |
196 |
datetime_undef_if_invalid: 1 |
258 |
datetime_undef_if_invalid: 1 |
197 |
is_nullable: 1 |
259 |
is_nullable: 1 |
198 |
|
260 |
|
|
|
261 |
the patron/borrower's date of birth (YYYY-MM-DD) |
262 |
|
199 |
=head2 branchcode |
263 |
=head2 branchcode |
200 |
|
264 |
|
201 |
data_type: 'varchar' |
265 |
data_type: 'varchar' |
Lines 204-209
__PACKAGE__->table("borrowers");
Link Here
|
204 |
is_nullable: 0 |
268 |
is_nullable: 0 |
205 |
size: 10 |
269 |
size: 10 |
206 |
|
270 |
|
|
|
271 |
foreign key from the branches table, includes the code of the patron/borrower's home branch |
272 |
|
207 |
=head2 categorycode |
273 |
=head2 categorycode |
208 |
|
274 |
|
209 |
data_type: 'varchar' |
275 |
data_type: 'varchar' |
Lines 212-282
__PACKAGE__->table("borrowers");
Link Here
|
212 |
is_nullable: 0 |
278 |
is_nullable: 0 |
213 |
size: 10 |
279 |
size: 10 |
214 |
|
280 |
|
|
|
281 |
foreign key from the categories table, includes the code of the patron category |
282 |
|
215 |
=head2 dateenrolled |
283 |
=head2 dateenrolled |
216 |
|
284 |
|
217 |
data_type: 'date' |
285 |
data_type: 'date' |
218 |
datetime_undef_if_invalid: 1 |
286 |
datetime_undef_if_invalid: 1 |
219 |
is_nullable: 1 |
287 |
is_nullable: 1 |
220 |
|
288 |
|
|
|
289 |
date the patron was added to Koha (YYYY-MM-DD) |
290 |
|
221 |
=head2 dateexpiry |
291 |
=head2 dateexpiry |
222 |
|
292 |
|
223 |
data_type: 'date' |
293 |
data_type: 'date' |
224 |
datetime_undef_if_invalid: 1 |
294 |
datetime_undef_if_invalid: 1 |
225 |
is_nullable: 1 |
295 |
is_nullable: 1 |
226 |
|
296 |
|
|
|
297 |
date the patron/borrower's card is set to expire (YYYY-MM-DD) |
298 |
|
227 |
=head2 date_renewed |
299 |
=head2 date_renewed |
228 |
|
300 |
|
229 |
data_type: 'date' |
301 |
data_type: 'date' |
230 |
datetime_undef_if_invalid: 1 |
302 |
datetime_undef_if_invalid: 1 |
231 |
is_nullable: 1 |
303 |
is_nullable: 1 |
232 |
|
304 |
|
|
|
305 |
date the patron/borrower's card was last renewed |
306 |
|
233 |
=head2 gonenoaddress |
307 |
=head2 gonenoaddress |
234 |
|
308 |
|
235 |
data_type: 'tinyint' |
309 |
data_type: 'tinyint' |
236 |
is_nullable: 1 |
310 |
is_nullable: 1 |
237 |
|
311 |
|
|
|
312 |
set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
313 |
|
238 |
=head2 lost |
314 |
=head2 lost |
239 |
|
315 |
|
240 |
data_type: 'tinyint' |
316 |
data_type: 'tinyint' |
241 |
is_nullable: 1 |
317 |
is_nullable: 1 |
242 |
|
318 |
|
|
|
319 |
set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
320 |
|
243 |
=head2 debarred |
321 |
=head2 debarred |
244 |
|
322 |
|
245 |
data_type: 'date' |
323 |
data_type: 'date' |
246 |
datetime_undef_if_invalid: 1 |
324 |
datetime_undef_if_invalid: 1 |
247 |
is_nullable: 1 |
325 |
is_nullable: 1 |
248 |
|
326 |
|
|
|
327 |
until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) |
328 |
|
249 |
=head2 debarredcomment |
329 |
=head2 debarredcomment |
250 |
|
330 |
|
251 |
data_type: 'varchar' |
331 |
data_type: 'varchar' |
252 |
is_nullable: 1 |
332 |
is_nullable: 1 |
253 |
size: 255 |
333 |
size: 255 |
254 |
|
334 |
|
|
|
335 |
comment on the stop of the patron |
336 |
|
255 |
=head2 contactname |
337 |
=head2 contactname |
256 |
|
338 |
|
257 |
data_type: 'longtext' |
339 |
data_type: 'longtext' |
258 |
is_nullable: 1 |
340 |
is_nullable: 1 |
259 |
|
341 |
|
|
|
342 |
used for children and profesionals to include surname or last name of guarantor or organization name |
343 |
|
260 |
=head2 contactfirstname |
344 |
=head2 contactfirstname |
261 |
|
345 |
|
262 |
data_type: 'mediumtext' |
346 |
data_type: 'mediumtext' |
263 |
is_nullable: 1 |
347 |
is_nullable: 1 |
264 |
|
348 |
|
|
|
349 |
used for children to include first name of guarantor |
350 |
|
265 |
=head2 contacttitle |
351 |
=head2 contacttitle |
266 |
|
352 |
|
267 |
data_type: 'mediumtext' |
353 |
data_type: 'mediumtext' |
268 |
is_nullable: 1 |
354 |
is_nullable: 1 |
269 |
|
355 |
|
|
|
356 |
used for children to include title (Mr., Mrs., etc) of guarantor |
357 |
|
270 |
=head2 borrowernotes |
358 |
=head2 borrowernotes |
271 |
|
359 |
|
272 |
data_type: 'longtext' |
360 |
data_type: 'longtext' |
273 |
is_nullable: 1 |
361 |
is_nullable: 1 |
274 |
|
362 |
|
275 |
=head2 relationship |
363 |
a note on the patron/borrower's account that is only visible in the staff interface |
276 |
|
|
|
277 |
data_type: 'varchar' |
278 |
is_nullable: 1 |
279 |
size: 100 |
280 |
|
364 |
|
281 |
=head2 sex |
365 |
=head2 sex |
282 |
|
366 |
|
Lines 284-404
__PACKAGE__->table("borrowers");
Link Here
|
284 |
is_nullable: 1 |
368 |
is_nullable: 1 |
285 |
size: 1 |
369 |
size: 1 |
286 |
|
370 |
|
|
|
371 |
patron/borrower's gender |
372 |
|
287 |
=head2 password |
373 |
=head2 password |
288 |
|
374 |
|
289 |
data_type: 'varchar' |
375 |
data_type: 'varchar' |
290 |
is_nullable: 1 |
376 |
is_nullable: 1 |
291 |
size: 60 |
377 |
size: 60 |
292 |
|
378 |
|
|
|
379 |
patron/borrower's Bcrypt encrypted password |
380 |
|
293 |
=head2 flags |
381 |
=head2 flags |
294 |
|
382 |
|
295 |
data_type: 'integer' |
383 |
data_type: 'integer' |
296 |
is_nullable: 1 |
384 |
is_nullable: 1 |
297 |
|
385 |
|
|
|
386 |
will include a number associated with the staff member's permissions |
387 |
|
298 |
=head2 userid |
388 |
=head2 userid |
299 |
|
389 |
|
300 |
data_type: 'varchar' |
390 |
data_type: 'varchar' |
301 |
is_nullable: 1 |
391 |
is_nullable: 1 |
302 |
size: 75 |
392 |
size: 75 |
303 |
|
393 |
|
|
|
394 |
patron/borrower's opac and/or staff interface log in |
395 |
|
304 |
=head2 opacnote |
396 |
=head2 opacnote |
305 |
|
397 |
|
306 |
data_type: 'longtext' |
398 |
data_type: 'longtext' |
307 |
is_nullable: 1 |
399 |
is_nullable: 1 |
308 |
|
400 |
|
|
|
401 |
a note on the patron/borrower's account that is visible in the OPAC and staff interface |
402 |
|
309 |
=head2 contactnote |
403 |
=head2 contactnote |
310 |
|
404 |
|
311 |
data_type: 'varchar' |
405 |
data_type: 'varchar' |
312 |
is_nullable: 1 |
406 |
is_nullable: 1 |
313 |
size: 255 |
407 |
size: 255 |
314 |
|
408 |
|
|
|
409 |
a note related to the patron/borrower's alternate address |
410 |
|
315 |
=head2 sort1 |
411 |
=head2 sort1 |
316 |
|
412 |
|
317 |
data_type: 'varchar' |
413 |
data_type: 'varchar' |
318 |
is_nullable: 1 |
414 |
is_nullable: 1 |
319 |
size: 80 |
415 |
size: 80 |
320 |
|
416 |
|
|
|
417 |
a field that can be used for any information unique to the library |
418 |
|
321 |
=head2 sort2 |
419 |
=head2 sort2 |
322 |
|
420 |
|
323 |
data_type: 'varchar' |
421 |
data_type: 'varchar' |
324 |
is_nullable: 1 |
422 |
is_nullable: 1 |
325 |
size: 80 |
423 |
size: 80 |
326 |
|
424 |
|
|
|
425 |
a field that can be used for any information unique to the library |
426 |
|
327 |
=head2 altcontactfirstname |
427 |
=head2 altcontactfirstname |
328 |
|
428 |
|
329 |
data_type: 'mediumtext' |
429 |
data_type: 'mediumtext' |
330 |
is_nullable: 1 |
430 |
is_nullable: 1 |
331 |
|
431 |
|
|
|
432 |
first name of alternate contact for the patron/borrower |
433 |
|
332 |
=head2 altcontactsurname |
434 |
=head2 altcontactsurname |
333 |
|
435 |
|
334 |
data_type: 'mediumtext' |
436 |
data_type: 'mediumtext' |
335 |
is_nullable: 1 |
437 |
is_nullable: 1 |
336 |
|
438 |
|
|
|
439 |
surname or last name of the alternate contact for the patron/borrower |
440 |
|
337 |
=head2 altcontactaddress1 |
441 |
=head2 altcontactaddress1 |
338 |
|
442 |
|
339 |
data_type: 'mediumtext' |
443 |
data_type: 'mediumtext' |
340 |
is_nullable: 1 |
444 |
is_nullable: 1 |
341 |
|
445 |
|
|
|
446 |
the first address line for the alternate contact for the patron/borrower |
447 |
|
342 |
=head2 altcontactaddress2 |
448 |
=head2 altcontactaddress2 |
343 |
|
449 |
|
344 |
data_type: 'mediumtext' |
450 |
data_type: 'mediumtext' |
345 |
is_nullable: 1 |
451 |
is_nullable: 1 |
346 |
|
452 |
|
|
|
453 |
the second address line for the alternate contact for the patron/borrower |
454 |
|
347 |
=head2 altcontactaddress3 |
455 |
=head2 altcontactaddress3 |
348 |
|
456 |
|
349 |
data_type: 'mediumtext' |
457 |
data_type: 'mediumtext' |
350 |
is_nullable: 1 |
458 |
is_nullable: 1 |
351 |
|
459 |
|
|
|
460 |
the city for the alternate contact for the patron/borrower |
461 |
|
352 |
=head2 altcontactstate |
462 |
=head2 altcontactstate |
353 |
|
463 |
|
354 |
data_type: 'mediumtext' |
464 |
data_type: 'mediumtext' |
355 |
is_nullable: 1 |
465 |
is_nullable: 1 |
356 |
|
466 |
|
|
|
467 |
the state for the alternate contact for the patron/borrower |
468 |
|
357 |
=head2 altcontactzipcode |
469 |
=head2 altcontactzipcode |
358 |
|
470 |
|
359 |
data_type: 'mediumtext' |
471 |
data_type: 'mediumtext' |
360 |
is_nullable: 1 |
472 |
is_nullable: 1 |
361 |
|
473 |
|
|
|
474 |
the zipcode for the alternate contact for the patron/borrower |
475 |
|
362 |
=head2 altcontactcountry |
476 |
=head2 altcontactcountry |
363 |
|
477 |
|
364 |
data_type: 'mediumtext' |
478 |
data_type: 'mediumtext' |
365 |
is_nullable: 1 |
479 |
is_nullable: 1 |
366 |
|
480 |
|
|
|
481 |
the country for the alternate contact for the patron/borrower |
482 |
|
367 |
=head2 altcontactphone |
483 |
=head2 altcontactphone |
368 |
|
484 |
|
369 |
data_type: 'mediumtext' |
485 |
data_type: 'mediumtext' |
370 |
is_nullable: 1 |
486 |
is_nullable: 1 |
371 |
|
487 |
|
|
|
488 |
the phone number for the alternate contact for the patron/borrower |
489 |
|
372 |
=head2 smsalertnumber |
490 |
=head2 smsalertnumber |
373 |
|
491 |
|
374 |
data_type: 'varchar' |
492 |
data_type: 'varchar' |
375 |
is_nullable: 1 |
493 |
is_nullable: 1 |
376 |
size: 50 |
494 |
size: 50 |
377 |
|
495 |
|
|
|
496 |
the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
497 |
|
378 |
=head2 sms_provider_id |
498 |
=head2 sms_provider_id |
379 |
|
499 |
|
380 |
data_type: 'integer' |
500 |
data_type: 'integer' |
381 |
is_foreign_key: 1 |
501 |
is_foreign_key: 1 |
382 |
is_nullable: 1 |
502 |
is_nullable: 1 |
383 |
|
503 |
|
|
|
504 |
the provider of the mobile phone number defined in smsalertnumber |
505 |
|
384 |
=head2 privacy |
506 |
=head2 privacy |
385 |
|
507 |
|
386 |
data_type: 'integer' |
508 |
data_type: 'integer' |
387 |
default_value: 1 |
509 |
default_value: 1 |
388 |
is_nullable: 0 |
510 |
is_nullable: 0 |
389 |
|
511 |
|
|
|
512 |
patron/borrower's privacy settings related to their checkout history |
513 |
|
390 |
=head2 privacy_guarantor_fines |
514 |
=head2 privacy_guarantor_fines |
391 |
|
515 |
|
392 |
data_type: 'tinyint' |
516 |
data_type: 'tinyint' |
393 |
default_value: 0 |
517 |
default_value: 0 |
394 |
is_nullable: 0 |
518 |
is_nullable: 0 |
395 |
|
519 |
|
|
|
520 |
controls if relatives can see this patron's fines |
521 |
|
396 |
=head2 privacy_guarantor_checkouts |
522 |
=head2 privacy_guarantor_checkouts |
397 |
|
523 |
|
398 |
data_type: 'tinyint' |
524 |
data_type: 'tinyint' |
399 |
default_value: 0 |
525 |
default_value: 0 |
400 |
is_nullable: 0 |
526 |
is_nullable: 0 |
401 |
|
527 |
|
|
|
528 |
controls if relatives can see this patron's checkouts |
529 |
|
402 |
=head2 checkprevcheckout |
530 |
=head2 checkprevcheckout |
403 |
|
531 |
|
404 |
data_type: 'varchar' |
532 |
data_type: 'varchar' |
Lines 406-411
__PACKAGE__->table("borrowers");
Link Here
|
406 |
is_nullable: 0 |
534 |
is_nullable: 0 |
407 |
size: 7 |
535 |
size: 7 |
408 |
|
536 |
|
|
|
537 |
produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. |
538 |
|
409 |
=head2 updated_on |
539 |
=head2 updated_on |
410 |
|
540 |
|
411 |
data_type: 'timestamp' |
541 |
data_type: 'timestamp' |
Lines 413-424
__PACKAGE__->table("borrowers");
Link Here
|
413 |
default_value: current_timestamp |
543 |
default_value: current_timestamp |
414 |
is_nullable: 0 |
544 |
is_nullable: 0 |
415 |
|
545 |
|
|
|
546 |
time of last change could be useful for synchronization with external systems (among others) |
547 |
|
416 |
=head2 lastseen |
548 |
=head2 lastseen |
417 |
|
549 |
|
418 |
data_type: 'datetime' |
550 |
data_type: 'datetime' |
419 |
datetime_undef_if_invalid: 1 |
551 |
datetime_undef_if_invalid: 1 |
420 |
is_nullable: 1 |
552 |
is_nullable: 1 |
421 |
|
553 |
|
|
|
554 |
last time a patron has been seen (connected at the OPAC or staff interface) |
555 |
|
422 |
=head2 lang |
556 |
=head2 lang |
423 |
|
557 |
|
424 |
data_type: 'varchar' |
558 |
data_type: 'varchar' |
Lines 426-454
__PACKAGE__->table("borrowers");
Link Here
|
426 |
is_nullable: 0 |
560 |
is_nullable: 0 |
427 |
size: 25 |
561 |
size: 25 |
428 |
|
562 |
|
|
|
563 |
lang to use to send notices to this patron |
564 |
|
429 |
=head2 login_attempts |
565 |
=head2 login_attempts |
430 |
|
566 |
|
431 |
data_type: 'integer' |
567 |
data_type: 'integer' |
432 |
default_value: 0 |
568 |
default_value: 0 |
433 |
is_nullable: 0 |
569 |
is_nullable: 0 |
434 |
|
570 |
|
|
|
571 |
number of failed login attemps |
572 |
|
435 |
=head2 overdrive_auth_token |
573 |
=head2 overdrive_auth_token |
436 |
|
574 |
|
437 |
data_type: 'mediumtext' |
575 |
data_type: 'mediumtext' |
438 |
is_nullable: 1 |
576 |
is_nullable: 1 |
439 |
|
577 |
|
|
|
578 |
persist OverDrive auth token |
579 |
|
440 |
=head2 anonymized |
580 |
=head2 anonymized |
441 |
|
581 |
|
442 |
data_type: 'tinyint' |
582 |
data_type: 'tinyint' |
443 |
default_value: 0 |
583 |
default_value: 0 |
444 |
is_nullable: 0 |
584 |
is_nullable: 0 |
445 |
|
585 |
|
|
|
586 |
flag for data anonymization |
587 |
|
446 |
=head2 autorenew_checkouts |
588 |
=head2 autorenew_checkouts |
447 |
|
589 |
|
448 |
data_type: 'tinyint' |
590 |
data_type: 'tinyint' |
449 |
default_value: 1 |
591 |
default_value: 1 |
450 |
is_nullable: 0 |
592 |
is_nullable: 0 |
451 |
|
593 |
|
|
|
594 |
flag for allowing auto-renewal |
595 |
|
452 |
=cut |
596 |
=cut |
453 |
|
597 |
|
454 |
__PACKAGE__->add_columns( |
598 |
__PACKAGE__->add_columns( |
Lines 554-561
__PACKAGE__->add_columns(
Link Here
|
554 |
{ data_type => "mediumtext", is_nullable => 1 }, |
698 |
{ data_type => "mediumtext", is_nullable => 1 }, |
555 |
"borrowernotes", |
699 |
"borrowernotes", |
556 |
{ data_type => "longtext", is_nullable => 1 }, |
700 |
{ data_type => "longtext", is_nullable => 1 }, |
557 |
"relationship", |
|
|
558 |
{ data_type => "varchar", is_nullable => 1, size => 100 }, |
559 |
"sex", |
701 |
"sex", |
560 |
{ data_type => "varchar", is_nullable => 1, size => 1 }, |
702 |
{ data_type => "varchar", is_nullable => 1, size => 1 }, |
561 |
"password", |
703 |
"password", |
Lines 1713-1720
Composing rels: L</aqorder_users> -> ordernumber
Link Here
|
1713 |
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); |
1855 |
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); |
1714 |
|
1856 |
|
1715 |
|
1857 |
|
1716 |
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-09 19:12:25 |
1858 |
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 |
1717 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kp53XFs7tFIpzNSqm/WY8w |
1859 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p19R3ym2b7Es0K4bGRlYOw |
1718 |
|
1860 |
|
1719 |
__PACKAGE__->add_columns( |
1861 |
__PACKAGE__->add_columns( |
1720 |
'+anonymized' => { is_boolean => 1 }, |
1862 |
'+anonymized' => { is_boolean => 1 }, |