2 package Koha::Schema::Result::Review;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Review
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<reviews>
22 __PACKAGE__->table("reviews");
32 unique identifier for this comment
40 foreign key from the borrowers table defining which patron left this comment
48 foreign key from the biblio table defining which bibliographic record this comment is for
52 data_type: 'mediumtext'
55 the body of the comment
63 whether this comment has been approved by a librarian (1 for yes, 0 for no)
68 datetime_undef_if_invalid: 1
71 the date the comment was left
75 __PACKAGE__->add_columns(
77 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
79 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
81 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
83 { data_type => "mediumtext", is_nullable => 1 },
85 { data_type => "tinyint", default_value => 0, is_nullable => 1 },
88 data_type => "datetime",
89 datetime_undef_if_invalid => 1,
104 __PACKAGE__->set_primary_key("reviewid");
112 Related object: L<Koha::Schema::Result::Biblio>
116 __PACKAGE__->belongs_to(
118 "Koha::Schema::Result::Biblio",
119 { biblionumber => "biblionumber" },
123 on_delete => "CASCADE",
124 on_update => "CASCADE",
128 =head2 borrowernumber
132 Related object: L<Koha::Schema::Result::Borrower>
136 __PACKAGE__->belongs_to(
138 "Koha::Schema::Result::Borrower",
139 { borrowernumber => "borrowernumber" },
143 on_delete => "SET NULL",
144 on_update => "CASCADE",
149 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
150 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1Am1qqe4ETom7ylth3Tvpg
153 # You can replace this text with custom content, and it will be preserved on regeneration