Koha/Schema/Result/Aqbudget.pm

   1 use utf8;
   2 package Koha::Schema::Result::Aqbudget;
   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::Aqbudget
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<aqbudgets>
  19
  20 =cut
  21
  22 __PACKAGE__->table("aqbudgets");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 budget_id
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 budget_parent_id
  33
  34   data_type: 'integer'
  35   is_nullable: 1
  36
  37 =head2 budget_code
  38
  39   data_type: 'varchar'
  40   is_nullable: 1
  41   size: 30
  42
  43 =head2 budget_name
  44
  45   data_type: 'varchar'
  46   is_nullable: 1
  47   size: 80
  48
  49 =head2 budget_branchcode
  50
  51   data_type: 'varchar'
  52   is_nullable: 1
  53   size: 10
  54
  55 =head2 budget_amount
  56
  57   data_type: 'decimal'
  58   default_value: 0.000000
  59   is_nullable: 1
  60   size: [28,6]
  61
  62 =head2 budget_encumb
  63
  64   data_type: 'decimal'
  65   default_value: 0.000000
  66   is_nullable: 1
  67   size: [28,6]
  68
  69 =head2 budget_expend
  70
  71   data_type: 'decimal'
  72   default_value: 0.000000
  73   is_nullable: 1
  74   size: [28,6]
  75
  76 =head2 budget_notes
  77
  78   data_type: 'mediumtext'
  79   is_nullable: 1
  80
  81 =head2 timestamp
  82
  83   data_type: 'timestamp'
  84   datetime_undef_if_invalid: 1
  85   default_value: current_timestamp
  86   is_nullable: 0
  87
  88 =head2 budget_period_id
  89
  90   data_type: 'integer'
  91   is_nullable: 1
  92
  93 =head2 sort1_authcat
  94
  95   data_type: 'varchar'
  96   is_nullable: 1
  97   size: 80
  98
  99 =head2 sort2_authcat
 100
 101   data_type: 'varchar'
 102   is_nullable: 1
 103   size: 80
 104
 105 =head2 budget_owner_id
 106
 107   data_type: 'integer'
 108   is_nullable: 1
 109
 110 =head2 budget_permission
 111
 112   data_type: 'integer'
 113   default_value: 0
 114   is_nullable: 1
 115
 116 =cut
 117
 118 __PACKAGE__->add_columns(
 119   "budget_id",
 120   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 121   "budget_parent_id",
 122   { data_type => "integer", is_nullable => 1 },
 123   "budget_code",
 124   { data_type => "varchar", is_nullable => 1, size => 30 },
 125   "budget_name",
 126   { data_type => "varchar", is_nullable => 1, size => 80 },
 127   "budget_branchcode",
 128   { data_type => "varchar", is_nullable => 1, size => 10 },
 129   "budget_amount",
 130   {
 131     data_type => "decimal",
 132     default_value => "0.000000",
 133     is_nullable => 1,
 134     size => [28, 6],
 135   },
 136   "budget_encumb",
 137   {
 138     data_type => "decimal",
 139     default_value => "0.000000",
 140     is_nullable => 1,
 141     size => [28, 6],
 142   },
 143   "budget_expend",
 144   {
 145     data_type => "decimal",
 146     default_value => "0.000000",
 147     is_nullable => 1,
 148     size => [28, 6],
 149   },
 150   "budget_notes",
 151   { data_type => "mediumtext", is_nullable => 1 },
 152   "timestamp",
 153   {
 154     data_type => "timestamp",
 155     datetime_undef_if_invalid => 1,
 156     default_value => \"current_timestamp",
 157     is_nullable => 0,
 158   },
 159   "budget_period_id",
 160   { data_type => "integer", is_nullable => 1 },
 161   "sort1_authcat",
 162   { data_type => "varchar", is_nullable => 1, size => 80 },
 163   "sort2_authcat",
 164   { data_type => "varchar", is_nullable => 1, size => 80 },
 165   "budget_owner_id",
 166   { data_type => "integer", is_nullable => 1 },
 167   "budget_permission",
 168   { data_type => "integer", default_value => 0, is_nullable => 1 },
 169 );
 170
 171 =head1 PRIMARY KEY
 172
 173 =over 4
 174
 175 =item * L</budget_id>
 176
 177 =back
 178
 179 =cut
 180
 181 __PACKAGE__->set_primary_key("budget_id");
 182
 183 =head1 RELATIONS
 184
 185 =head2 aqbudgetborrowers
 186
 187 Type: has_many
 188
 189 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
 190
 191 =cut
 192
 193 __PACKAGE__->has_many(
 194   "aqbudgetborrowers",
 195   "Koha::Schema::Result::Aqbudgetborrower",
 196   { "foreign.budget_id" => "self.budget_id" },
 197   { cascade_copy => 0, cascade_delete => 0 },
 198 );
 199
 200 =head2 aqbudgets_plannings
 201
 202 Type: has_many
 203
 204 Related object: L<Koha::Schema::Result::AqbudgetsPlanning>
 205
 206 =cut
 207
 208 __PACKAGE__->has_many(
 209   "aqbudgets_plannings",
 210   "Koha::Schema::Result::AqbudgetsPlanning",
 211   { "foreign.budget_id" => "self.budget_id" },
 212   { cascade_copy => 0, cascade_delete => 0 },
 213 );
 214
 215 =head2 aqinvoices
 216
 217 Type: has_many
 218
 219 Related object: L<Koha::Schema::Result::Aqinvoice>
 220
 221 =cut
 222
 223 __PACKAGE__->has_many(
 224   "aqinvoices",
 225   "Koha::Schema::Result::Aqinvoice",
 226   { "foreign.shipmentcost_budgetid" => "self.budget_id" },
 227   { cascade_copy => 0, cascade_delete => 0 },
 228 );
 229
 230 =head2 borrowernumbers
 231
 232 Type: many_to_many
 233
 234 Composing rels: L</aqbudgetborrowers> -> borrowernumber
 235
 236 =cut
 237
 238 __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
 239
 240
 241 # Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
 242 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dxOTKpdIJ6ruJUE++4fC8w
 243
 244
 245 # You can replace this text with custom content, and it will be preserved on regeneration
 246 1;