Koha/Schema/Result/Illcomment.pm

   1 use utf8;
   2 package Koha::Schema::Result::Illcomment;
   3
   4 # Created by DBIx::Class::Schema::Loader
   5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
   6
   7 =head1 NAME
   8
   9 Koha::Schema::Result::Illcomment
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<illcomments>
  19
  20 =cut
  21
  22 __PACKAGE__->table("illcomments");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 illcomment_id
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 Unique ID of the comment
  33
  34 =head2 illrequest_id
  35
  36   data_type: 'bigint'
  37   extra: {unsigned => 1}
  38   is_foreign_key: 1
  39   is_nullable: 0
  40
  41 ILL request number
  42
  43 =head2 borrowernumber
  44
  45   data_type: 'integer'
  46   is_foreign_key: 1
  47   is_nullable: 1
  48
  49 Link to the user who made the comment (could be librarian, patron or ILL partner library)
  50
  51 =head2 comment
  52
  53   data_type: 'text'
  54   is_nullable: 1
  55
  56 The text of the comment
  57
  58 =head2 timestamp
  59
  60   data_type: 'timestamp'
  61   datetime_undef_if_invalid: 1
  62   default_value: current_timestamp
  63   is_nullable: 0
  64
  65 Date and time when the comment was made
  66
  67 =cut
  68
  69 __PACKAGE__->add_columns(
  70   "illcomment_id",
  71   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  72   "illrequest_id",
  73   {
  74     data_type => "bigint",
  75     extra => { unsigned => 1 },
  76     is_foreign_key => 1,
  77     is_nullable => 0,
  78   },
  79   "borrowernumber",
  80   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  81   "comment",
  82   { data_type => "text", is_nullable => 1 },
  83   "timestamp",
  84   {
  85     data_type => "timestamp",
  86     datetime_undef_if_invalid => 1,
  87     default_value => \"current_timestamp",
  88     is_nullable => 0,
  89   },
  90 );
  91
  92 =head1 PRIMARY KEY
  93
  94 =over 4
  95
  96 =item * L</illcomment_id>
  97
  98 =back
  99
 100 =cut
 101
 102 __PACKAGE__->set_primary_key("illcomment_id");
 103
 104 =head1 RELATIONS
 105
 106 =head2 borrowernumber
 107
 108 Type: belongs_to
 109
 110 Related object: L<Koha::Schema::Result::Borrower>
 111
 112 =cut
 113
 114 __PACKAGE__->belongs_to(
 115   "borrowernumber",
 116   "Koha::Schema::Result::Borrower",
 117   { borrowernumber => "borrowernumber" },
 118   {
 119     is_deferrable => 1,
 120     join_type     => "LEFT",
 121     on_delete     => "CASCADE",
 122     on_update     => "CASCADE",
 123   },
 124 );
 125
 126 =head2 illrequest
 127
 128 Type: belongs_to
 129
 130 Related object: L<Koha::Schema::Result::Illrequest>
 131
 132 =cut
 133
 134 __PACKAGE__->belongs_to(
 135   "illrequest",
 136   "Koha::Schema::Result::Illrequest",
 137   { illrequest_id => "illrequest_id" },
 138   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 139 );
 140
 141
 142 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
 143 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:z5Y6mVTLtrYxmqmyAc/E7A
 144
 145
 146 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 147 1;