2 package Koha::Schema::Result::ProblemReport;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::ProblemReport
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<problem_reports>
22 __PACKAGE__->table("problem_reports");
32 unique identifier assigned by Koha
37 default_value: (empty string)
48 report message content
57 the user who created the problem report
62 default_value: (empty string)
82 page the user triggered the problem report form from
87 default_value: 'library'
88 extra: {list => ["admin","library"]}
91 the 'to-address' of the problem report
95 data_type: 'timestamp'
96 datetime_undef_if_invalid: 1
97 default_value: current_timestamp
100 timestamp of report submission
109 status of the report. New, Viewed, Closed
113 __PACKAGE__->add_columns(
115 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
117 { data_type => "varchar", default_value => "", is_nullable => 0, size => 40 },
119 { data_type => "text", is_nullable => 0 },
122 data_type => "integer",
129 data_type => "varchar",
136 { data_type => "varchar", is_nullable => 1, size => 75 },
138 { data_type => "text", is_nullable => 1 },
142 default_value => "library",
143 extra => { list => ["admin", "library"] },
148 data_type => "timestamp",
149 datetime_undef_if_invalid => 1,
150 default_value => \"current_timestamp",
154 { data_type => "varchar", default_value => "New", is_nullable => 0, size => 6 },
167 __PACKAGE__->set_primary_key("reportid");
171 =head2 borrowernumber
175 Related object: L<Koha::Schema::Result::Borrower>
179 __PACKAGE__->belongs_to(
181 "Koha::Schema::Result::Borrower",
182 { borrowernumber => "borrowernumber" },
183 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
190 Related object: L<Koha::Schema::Result::Branch>
194 __PACKAGE__->belongs_to(
196 "Koha::Schema::Result::Branch",
197 { branchcode => "branchcode" },
198 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
202 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-04-12 13:27:06
203 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YdCX1Hak6UwiJo1iBJqqzg
206 # You can replace this text with custom code or comments, and it will be preserved on regeneration