Koha/Schema/Result/Virtualshelve.pm

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