|
Lines 35-41
primary key for issues table
Link Here
|
| 35 |
|
35 |
|
| 36 |
data_type: 'integer' |
36 |
data_type: 'integer' |
| 37 |
is_foreign_key: 1 |
37 |
is_foreign_key: 1 |
| 38 |
is_nullable: 1 |
38 |
is_nullable: 0 |
| 39 |
|
39 |
|
| 40 |
foreign key, linking this to the borrowers table for the patron this item was checked out to |
40 |
foreign key, linking this to the borrowers table for the patron this item was checked out to |
| 41 |
|
41 |
|
|
Lines 51-57
foreign key, linking this to the borrowers table for the user who checked out th
Link Here
|
| 51 |
|
51 |
|
| 52 |
data_type: 'integer' |
52 |
data_type: 'integer' |
| 53 |
is_foreign_key: 1 |
53 |
is_foreign_key: 1 |
| 54 |
is_nullable: 1 |
54 |
is_nullable: 0 |
| 55 |
|
55 |
|
| 56 |
foreign key, linking this to the items table for the item that was checked out |
56 |
foreign key, linking this to the items table for the item that was checked out |
| 57 |
|
57 |
|
|
Lines 172-182
__PACKAGE__->add_columns(
Link Here
|
| 172 |
"issue_id", |
172 |
"issue_id", |
| 173 |
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, |
173 |
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, |
| 174 |
"borrowernumber", |
174 |
"borrowernumber", |
| 175 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
175 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, |
| 176 |
"issuer_id", |
176 |
"issuer_id", |
| 177 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
177 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
| 178 |
"itemnumber", |
178 |
"itemnumber", |
| 179 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
179 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, |
| 180 |
"date_due", |
180 |
"date_due", |
| 181 |
{ |
181 |
{ |
| 182 |
data_type => "datetime", |
182 |
data_type => "datetime", |
|
Lines 272-283
__PACKAGE__->belongs_to(
Link Here
|
| 272 |
"borrowernumber", |
272 |
"borrowernumber", |
| 273 |
"Koha::Schema::Result::Borrower", |
273 |
"Koha::Schema::Result::Borrower", |
| 274 |
{ borrowernumber => "borrowernumber" }, |
274 |
{ borrowernumber => "borrowernumber" }, |
| 275 |
{ |
275 |
{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" }, |
| 276 |
is_deferrable => 1, |
|
|
| 277 |
join_type => "LEFT", |
| 278 |
on_delete => "RESTRICT", |
| 279 |
on_update => "CASCADE", |
| 280 |
}, |
| 281 |
); |
276 |
); |
| 282 |
|
277 |
|
| 283 |
=head2 issuer |
278 |
=head2 issuer |
|
Lines 312-328
__PACKAGE__->belongs_to(
Link Here
|
| 312 |
"itemnumber", |
307 |
"itemnumber", |
| 313 |
"Koha::Schema::Result::Item", |
308 |
"Koha::Schema::Result::Item", |
| 314 |
{ itemnumber => "itemnumber" }, |
309 |
{ itemnumber => "itemnumber" }, |
| 315 |
{ |
310 |
{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" }, |
| 316 |
is_deferrable => 1, |
|
|
| 317 |
join_type => "LEFT", |
| 318 |
on_delete => "RESTRICT", |
| 319 |
on_update => "CASCADE", |
| 320 |
}, |
| 321 |
); |
311 |
); |
| 322 |
|
312 |
|
| 323 |
|
313 |
|
| 324 |
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-11 15:10:14 |
314 |
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-08-16 13:40:46 |
| 325 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TERiBbm+B4jMEuNM2dVbfQ |
315 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:82k6dsQbnfsisYZSmpKyTg |
| 326 |
|
316 |
|
| 327 |
__PACKAGE__->add_columns( |
317 |
__PACKAGE__->add_columns( |
| 328 |
'+auto_renew' => { is_boolean => 1 }, |
318 |
'+auto_renew' => { is_boolean => 1 }, |
| 329 |
- |
|
|