Koha/Schema/Result/ProblemReport.pm

   1 use utf8;
   2 package Koha::Schema::Result::ProblemReport;
   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::ProblemReport
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<problem_reports>
  19
  20 =cut
  21
  22 __PACKAGE__->table("problem_reports");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 reportid
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 title
  33
  34   data_type: 'varchar'
  35   default_value: (empty string)
  36   is_nullable: 0
  37   size: 40
  38
  39 =head2 content
  40
  41   data_type: 'varchar'
  42   default_value: (empty string)
  43   is_nullable: 0
  44   size: 255
  45
  46 =head2 borrowernumber
  47
  48   data_type: 'integer'
  49   default_value: 0
  50   is_foreign_key: 1
  51   is_nullable: 0
  52
  53 =head2 branchcode
  54
  55   data_type: 'varchar'
  56   default_value: (empty string)
  57   is_foreign_key: 1
  58   is_nullable: 0
  59   size: 10
  60
  61 =head2 username
  62
  63   data_type: 'varchar'
  64   is_nullable: 1
  65   size: 75
  66
  67 =head2 problempage
  68
  69   data_type: 'text'
  70   is_nullable: 1
  71
  72 =head2 recipient
  73
  74   data_type: 'enum'
  75   default_value: 'library'
  76   extra: {list => ["admin","library"]}
  77   is_nullable: 0
  78
  79 =head2 created_on
  80
  81   data_type: 'timestamp'
  82   datetime_undef_if_invalid: 1
  83   default_value: current_timestamp
  84   is_nullable: 0
  85
  86 =head2 status
  87
  88   data_type: 'varchar'
  89   default_value: 'New'
  90   is_nullable: 0
  91   size: 6
  92
  93 =cut
  94
  95 __PACKAGE__->add_columns(
  96   "reportid",
  97   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  98   "title",
  99   { data_type => "varchar", default_value => "", is_nullable => 0, size => 40 },
 100   "content",
 101   { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
 102   "borrowernumber",
 103   {
 104     data_type      => "integer",
 105     default_value  => 0,
 106     is_foreign_key => 1,
 107     is_nullable    => 0,
 108   },
 109   "branchcode",
 110   {
 111     data_type => "varchar",
 112     default_value => "",
 113     is_foreign_key => 1,
 114     is_nullable => 0,
 115     size => 10,
 116   },
 117   "username",
 118   { data_type => "varchar", is_nullable => 1, size => 75 },
 119   "problempage",
 120   { data_type => "text", is_nullable => 1 },
 121   "recipient",
 122   {
 123     data_type => "enum",
 124     default_value => "library",
 125     extra => { list => ["admin", "library"] },
 126     is_nullable => 0,
 127   },
 128   "created_on",
 129   {
 130     data_type => "timestamp",
 131     datetime_undef_if_invalid => 1,
 132     default_value => \"current_timestamp",
 133     is_nullable => 0,
 134   },
 135   "status",
 136   { data_type => "varchar", default_value => "New", is_nullable => 0, size => 6 },
 137 );
 138
 139 =head1 PRIMARY KEY
 140
 141 =over 4
 142
 143 =item * L</reportid>
 144
 145 =back
 146
 147 =cut
 148
 149 __PACKAGE__->set_primary_key("reportid");
 150
 151 =head1 RELATIONS
 152
 153 =head2 borrowernumber
 154
 155 Type: belongs_to
 156
 157 Related object: L<Koha::Schema::Result::Borrower>
 158
 159 =cut
 160
 161 __PACKAGE__->belongs_to(
 162   "borrowernumber",
 163   "Koha::Schema::Result::Borrower",
 164   { borrowernumber => "borrowernumber" },
 165   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 166 );
 167
 168 =head2 branchcode
 169
 170 Type: belongs_to
 171
 172 Related object: L<Koha::Schema::Result::Branch>
 173
 174 =cut
 175
 176 __PACKAGE__->belongs_to(
 177   "branchcode",
 178   "Koha::Schema::Result::Branch",
 179   { branchcode => "branchcode" },
 180   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 181 );
 182
 183
 184 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-03 12:13:26
 185 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ho9ENAxH51/ZlZO9KD4KOQ
 186
 187
 188 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 189 1;