Koha/Schema/Result/Biblioitem.pm

   1 use utf8;
   2 package Koha::Schema::Result::Biblioitem;
   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::Biblioitem
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<biblioitems>
  19
  20 =cut
  21
  22 __PACKAGE__->table("biblioitems");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 biblioitemnumber
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 biblionumber
  33
  34   data_type: 'integer'
  35   default_value: 0
  36   is_foreign_key: 1
  37   is_nullable: 0
  38
  39 =head2 volume
  40
  41   data_type: 'mediumtext'
  42   is_nullable: 1
  43
  44 =head2 number
  45
  46   data_type: 'mediumtext'
  47   is_nullable: 1
  48
  49 =head2 itemtype
  50
  51   data_type: 'varchar'
  52   is_nullable: 1
  53   size: 10
  54
  55 =head2 isbn
  56
  57   data_type: 'mediumtext'
  58   is_nullable: 1
  59
  60 =head2 issn
  61
  62   data_type: 'mediumtext'
  63   is_nullable: 1
  64
  65 =head2 ean
  66
  67   data_type: 'varchar'
  68   is_nullable: 1
  69   size: 13
  70
  71 =head2 publicationyear
  72
  73   data_type: 'text'
  74   is_nullable: 1
  75
  76 =head2 publishercode
  77
  78   data_type: 'varchar'
  79   is_nullable: 1
  80   size: 255
  81
  82 =head2 volumedate
  83
  84   data_type: 'date'
  85   datetime_undef_if_invalid: 1
  86   is_nullable: 1
  87
  88 =head2 volumedesc
  89
  90   data_type: 'text'
  91   is_nullable: 1
  92
  93 =head2 collectiontitle
  94
  95   data_type: 'mediumtext'
  96   is_nullable: 1
  97
  98 =head2 collectionissn
  99
 100   data_type: 'text'
 101   is_nullable: 1
 102
 103 =head2 collectionvolume
 104
 105   data_type: 'mediumtext'
 106   is_nullable: 1
 107
 108 =head2 editionstatement
 109
 110   data_type: 'text'
 111   is_nullable: 1
 112
 113 =head2 editionresponsibility
 114
 115   data_type: 'text'
 116   is_nullable: 1
 117
 118 =head2 timestamp
 119
 120   data_type: 'timestamp'
 121   datetime_undef_if_invalid: 1
 122   default_value: current_timestamp
 123   is_nullable: 0
 124
 125 =head2 illus
 126
 127   data_type: 'varchar'
 128   is_nullable: 1
 129   size: 255
 130
 131 =head2 pages
 132
 133   data_type: 'varchar'
 134   is_nullable: 1
 135   size: 255
 136
 137 =head2 notes
 138
 139   data_type: 'mediumtext'
 140   is_nullable: 1
 141
 142 =head2 size
 143
 144   data_type: 'varchar'
 145   is_nullable: 1
 146   size: 255
 147
 148 =head2 place
 149
 150   data_type: 'varchar'
 151   is_nullable: 1
 152   size: 255
 153
 154 =head2 lccn
 155
 156   data_type: 'varchar'
 157   is_nullable: 1
 158   size: 25
 159
 160 =head2 marc
 161
 162   data_type: 'longblob'
 163   is_nullable: 1
 164
 165 =head2 url
 166
 167   data_type: 'text'
 168   is_nullable: 1
 169
 170 =head2 cn_source
 171
 172   data_type: 'varchar'
 173   is_nullable: 1
 174   size: 10
 175
 176 =head2 cn_class
 177
 178   data_type: 'varchar'
 179   is_nullable: 1
 180   size: 30
 181
 182 =head2 cn_item
 183
 184   data_type: 'varchar'
 185   is_nullable: 1
 186   size: 10
 187
 188 =head2 cn_suffix
 189
 190   data_type: 'varchar'
 191   is_nullable: 1
 192   size: 10
 193
 194 =head2 cn_sort
 195
 196   data_type: 'varchar'
 197   is_nullable: 1
 198   size: 255
 199
 200 =head2 agerestriction
 201
 202   data_type: 'varchar'
 203   is_nullable: 1
 204   size: 255
 205
 206 =head2 totalissues
 207
 208   data_type: 'integer'
 209   is_nullable: 1
 210
 211 =head2 marcxml
 212
 213   data_type: 'longtext'
 214   is_nullable: 1
 215
 216 =cut
 217
 218 __PACKAGE__->add_columns(
 219   "biblioitemnumber",
 220   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 221   "biblionumber",
 222   {
 223     data_type      => "integer",
 224     default_value  => 0,
 225     is_foreign_key => 1,
 226     is_nullable    => 0,
 227   },
 228   "volume",
 229   { data_type => "mediumtext", is_nullable => 1 },
 230   "number",
 231   { data_type => "mediumtext", is_nullable => 1 },
 232   "itemtype",
 233   { data_type => "varchar", is_nullable => 1, size => 10 },
 234   "isbn",
 235   { data_type => "mediumtext", is_nullable => 1 },
 236   "issn",
 237   { data_type => "mediumtext", is_nullable => 1 },
 238   "ean",
 239   { data_type => "varchar", is_nullable => 1, size => 13 },
 240   "publicationyear",
 241   { data_type => "text", is_nullable => 1 },
 242   "publishercode",
 243   { data_type => "varchar", is_nullable => 1, size => 255 },
 244   "volumedate",
 245   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 246   "volumedesc",
 247   { data_type => "text", is_nullable => 1 },
 248   "collectiontitle",
 249   { data_type => "mediumtext", is_nullable => 1 },
 250   "collectionissn",
 251   { data_type => "text", is_nullable => 1 },
 252   "collectionvolume",
 253   { data_type => "mediumtext", is_nullable => 1 },
 254   "editionstatement",
 255   { data_type => "text", is_nullable => 1 },
 256   "editionresponsibility",
 257   { data_type => "text", is_nullable => 1 },
 258   "timestamp",
 259   {
 260     data_type => "timestamp",
 261     datetime_undef_if_invalid => 1,
 262     default_value => \"current_timestamp",
 263     is_nullable => 0,
 264   },
 265   "illus",
 266   { data_type => "varchar", is_nullable => 1, size => 255 },
 267   "pages",
 268   { data_type => "varchar", is_nullable => 1, size => 255 },
 269   "notes",
 270   { data_type => "mediumtext", is_nullable => 1 },
 271   "size",
 272   { data_type => "varchar", is_nullable => 1, size => 255 },
 273   "place",
 274   { data_type => "varchar", is_nullable => 1, size => 255 },
 275   "lccn",
 276   { data_type => "varchar", is_nullable => 1, size => 25 },
 277   "marc",
 278   { data_type => "longblob", is_nullable => 1 },
 279   "url",
 280   { data_type => "text", is_nullable => 1 },
 281   "cn_source",
 282   { data_type => "varchar", is_nullable => 1, size => 10 },
 283   "cn_class",
 284   { data_type => "varchar", is_nullable => 1, size => 30 },
 285   "cn_item",
 286   { data_type => "varchar", is_nullable => 1, size => 10 },
 287   "cn_suffix",
 288   { data_type => "varchar", is_nullable => 1, size => 10 },
 289   "cn_sort",
 290   { data_type => "varchar", is_nullable => 1, size => 255 },
 291   "agerestriction",
 292   { data_type => "varchar", is_nullable => 1, size => 255 },
 293   "totalissues",
 294   { data_type => "integer", is_nullable => 1 },
 295   "marcxml",
 296   { data_type => "longtext", is_nullable => 1 },
 297 );
 298
 299 =head1 PRIMARY KEY
 300
 301 =over 4
 302
 303 =item * L</biblioitemnumber>
 304
 305 =back
 306
 307 =cut
 308
 309 __PACKAGE__->set_primary_key("biblioitemnumber");
 310
 311 =head1 RELATIONS
 312
 313 =head2 biblionumber
 314
 315 Type: belongs_to
 316
 317 Related object: L<Koha::Schema::Result::Biblio>
 318
 319 =cut
 320
 321 __PACKAGE__->belongs_to(
 322   "biblionumber",
 323   "Koha::Schema::Result::Biblio",
 324   { biblionumber => "biblionumber" },
 325   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 326 );
 327
 328 =head2 items
 329
 330 Type: has_many
 331
 332 Related object: L<Koha::Schema::Result::Item>
 333
 334 =cut
 335
 336 __PACKAGE__->has_many(
 337   "items",
 338   "Koha::Schema::Result::Item",
 339   { "foreign.biblioitemnumber" => "self.biblioitemnumber" },
 340   { cascade_copy => 0, cascade_delete => 0 },
 341 );
 342
 343
 344 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-02-24 14:19:57
 345 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A/4lKYlKWWd8TcMVzMRtCg
 346
 347 __PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" );
 348
 349 1;