use utf8; package Koha::Schema::Result::ArticleRequest; # Created by DBIx::Class::Schema::Loader # DO NOT MODIFY THE FIRST PART OF THIS FILE =head1 NAME Koha::Schema::Result::ArticleRequest =cut use strict; use warnings; use base 'DBIx::Class::Core'; =head1 TABLE: C =cut __PACKAGE__->table("article_requests"); =head1 ACCESSORS =head2 id data_type: 'integer' is_auto_increment: 1 is_nullable: 0 =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 =head2 branchcode data_type: 'varchar' is_foreign_key: 1 is_nullable: 1 size: 10 =head2 title data_type: 'mediumtext' is_nullable: 1 =head2 author data_type: 'mediumtext' is_nullable: 1 =head2 volume data_type: 'mediumtext' is_nullable: 1 =head2 issue data_type: 'mediumtext' is_nullable: 1 =head2 date data_type: 'mediumtext' is_nullable: 1 =head2 pages data_type: 'mediumtext' is_nullable: 1 =head2 chapters data_type: 'mediumtext' is_nullable: 1 =head2 patron_notes data_type: 'mediumtext' is_nullable: 1 =head2 status data_type: 'enum' default_value: 'REQUESTED' extra: {list => ["REQUESTED","PENDING","PROCESSING","COMPLETED","CANCELED"]} is_nullable: 0 =head2 notes data_type: 'mediumtext' is_nullable: 1 =head2 format data_type: 'enum' default_value: 'PHOTOCOPY' extra: {list => ["PHOTOCOPY","SCAN"]} is_nullable: 0 =head2 urls data_type: 'mediumtext' is_nullable: 1 =head2 cancellation_reason data_type: 'varchar' is_nullable: 1 size: 80 optional authorised value AR_CANCELLATION =head2 debit_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 Debit line with cost for article scan request =head2 created_on data_type: 'timestamp' datetime_undef_if_invalid: 1 is_nullable: 1 Be careful with two timestamps in one table not allowing NULL =head2 updated_on data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0 =head2 toc_request data_type: 'tinyint' default_value: 0 is_nullable: 0 borrower requested table of contents =cut __PACKAGE__->add_columns( "id", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "borrowernumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "biblionumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "itemnumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "branchcode", { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, "title", { data_type => "mediumtext", is_nullable => 1 }, "author", { data_type => "mediumtext", is_nullable => 1 }, "volume", { data_type => "mediumtext", is_nullable => 1 }, "issue", { data_type => "mediumtext", is_nullable => 1 }, "date", { data_type => "mediumtext", is_nullable => 1 }, "pages", { data_type => "mediumtext", is_nullable => 1 }, "chapters", { data_type => "mediumtext", is_nullable => 1 }, "patron_notes", { data_type => "mediumtext", is_nullable => 1 }, "status", { data_type => "enum", default_value => "REQUESTED", extra => { list => ["REQUESTED", "PENDING", "PROCESSING", "COMPLETED", "CANCELED"], }, is_nullable => 0, }, "notes", { data_type => "mediumtext", is_nullable => 1 }, "format", { data_type => "enum", default_value => "PHOTOCOPY", extra => { list => ["PHOTOCOPY", "SCAN"] }, is_nullable => 0, }, "urls", { data_type => "mediumtext", is_nullable => 1 }, "cancellation_reason", { data_type => "varchar", is_nullable => 1, size => 80 }, "debit_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "created_on", { data_type => "timestamp", datetime_undef_if_invalid => 1, is_nullable => 1, }, "updated_on", { data_type => "timestamp", datetime_undef_if_invalid => 1, default_value => \"current_timestamp", is_nullable => 0, }, "toc_request", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, ); =head1 PRIMARY KEY =over 4 =item * L =back =cut __PACKAGE__->set_primary_key("id"); =head1 RELATIONS =head2 biblionumber Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "biblionumber", "Koha::Schema::Result::Biblio", { biblionumber => "biblionumber" }, { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 borrowernumber Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "borrowernumber", "Koha::Schema::Result::Borrower", { borrowernumber => "borrowernumber" }, { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 branchcode Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "branchcode", "Koha::Schema::Result::Branch", { branchcode => "branchcode" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); =head2 debit Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "debit", "Koha::Schema::Result::Accountline", { accountlines_id => "debit_id" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); =head2 itemnumber Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "itemnumber", "Koha::Schema::Result::Item", { itemnumber => "itemnumber" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-01-28 20:21:02 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/mPsUO8VPK6DVIX7Rynk0A # You can replace this text with custom code or comments, and it will be preserved on regeneration 1;