Koha/Schema/Result/Aqbookseller.pm

   1 use utf8;
   2 package Koha::Schema::Result::Aqbookseller;
   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::Aqbookseller
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<aqbooksellers>
  19
  20 =cut
  21
  22 __PACKAGE__->table("aqbooksellers");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 id
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 name
  33
  34   data_type: 'mediumtext'
  35   is_nullable: 0
  36
  37 =head2 address1
  38
  39   data_type: 'mediumtext'
  40   is_nullable: 1
  41
  42 =head2 address2
  43
  44   data_type: 'mediumtext'
  45   is_nullable: 1
  46
  47 =head2 address3
  48
  49   data_type: 'mediumtext'
  50   is_nullable: 1
  51
  52 =head2 address4
  53
  54   data_type: 'mediumtext'
  55   is_nullable: 1
  56
  57 =head2 phone
  58
  59   data_type: 'varchar'
  60   is_nullable: 1
  61   size: 30
  62
  63 =head2 accountnumber
  64
  65   data_type: 'mediumtext'
  66   is_nullable: 1
  67
  68 =head2 othersupplier
  69
  70   data_type: 'mediumtext'
  71   is_nullable: 1
  72
  73 =head2 currency
  74
  75   data_type: 'varchar'
  76   default_value: (empty string)
  77   is_nullable: 0
  78   size: 3
  79
  80 =head2 booksellerfax
  81
  82   data_type: 'mediumtext'
  83   is_nullable: 1
  84
  85 =head2 notes
  86
  87   data_type: 'mediumtext'
  88   is_nullable: 1
  89
  90 =head2 bookselleremail
  91
  92   data_type: 'mediumtext'
  93   is_nullable: 1
  94
  95 =head2 booksellerurl
  96
  97   data_type: 'mediumtext'
  98   is_nullable: 1
  99
 100 =head2 postal
 101
 102   data_type: 'mediumtext'
 103   is_nullable: 1
 104
 105 =head2 url
 106
 107   data_type: 'varchar'
 108   is_nullable: 1
 109   size: 255
 110
 111 =head2 active
 112
 113   data_type: 'tinyint'
 114   is_nullable: 1
 115
 116 =head2 listprice
 117
 118   data_type: 'varchar'
 119   is_foreign_key: 1
 120   is_nullable: 1
 121   size: 10
 122
 123 =head2 invoiceprice
 124
 125   data_type: 'varchar'
 126   is_foreign_key: 1
 127   is_nullable: 1
 128   size: 10
 129
 130 =head2 gstreg
 131
 132   data_type: 'tinyint'
 133   is_nullable: 1
 134
 135 =head2 listincgst
 136
 137   data_type: 'tinyint'
 138   is_nullable: 1
 139
 140 =head2 invoiceincgst
 141
 142   data_type: 'tinyint'
 143   is_nullable: 1
 144
 145 =head2 gstrate
 146
 147   data_type: 'decimal'
 148   is_nullable: 1
 149   size: [6,4]
 150
 151 =head2 discount
 152
 153   data_type: 'float'
 154   is_nullable: 1
 155   size: [6,4]
 156
 157 =head2 fax
 158
 159   data_type: 'varchar'
 160   is_nullable: 1
 161   size: 50
 162
 163 =head2 deliverytime
 164
 165   data_type: 'integer'
 166   is_nullable: 1
 167
 168 =cut
 169
 170 __PACKAGE__->add_columns(
 171   "id",
 172   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 173   "name",
 174   { data_type => "mediumtext", is_nullable => 0 },
 175   "address1",
 176   { data_type => "mediumtext", is_nullable => 1 },
 177   "address2",
 178   { data_type => "mediumtext", is_nullable => 1 },
 179   "address3",
 180   { data_type => "mediumtext", is_nullable => 1 },
 181   "address4",
 182   { data_type => "mediumtext", is_nullable => 1 },
 183   "phone",
 184   { data_type => "varchar", is_nullable => 1, size => 30 },
 185   "accountnumber",
 186   { data_type => "mediumtext", is_nullable => 1 },
 187   "othersupplier",
 188   { data_type => "mediumtext", is_nullable => 1 },
 189   "currency",
 190   { data_type => "varchar", default_value => "", is_nullable => 0, size => 3 },
 191   "booksellerfax",
 192   { data_type => "mediumtext", is_nullable => 1 },
 193   "notes",
 194   { data_type => "mediumtext", is_nullable => 1 },
 195   "bookselleremail",
 196   { data_type => "mediumtext", is_nullable => 1 },
 197   "booksellerurl",
 198   { data_type => "mediumtext", is_nullable => 1 },
 199   "postal",
 200   { data_type => "mediumtext", is_nullable => 1 },
 201   "url",
 202   { data_type => "varchar", is_nullable => 1, size => 255 },
 203   "active",
 204   { data_type => "tinyint", is_nullable => 1 },
 205   "listprice",
 206   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 207   "invoiceprice",
 208   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 209   "gstreg",
 210   { data_type => "tinyint", is_nullable => 1 },
 211   "listincgst",
 212   { data_type => "tinyint", is_nullable => 1 },
 213   "invoiceincgst",
 214   { data_type => "tinyint", is_nullable => 1 },
 215   "gstrate",
 216   { data_type => "decimal", is_nullable => 1, size => [6, 4] },
 217   "discount",
 218   { data_type => "float", is_nullable => 1, size => [6, 4] },
 219   "fax",
 220   { data_type => "varchar", is_nullable => 1, size => 50 },
 221   "deliverytime",
 222   { data_type => "integer", is_nullable => 1 },
 223 );
 224
 225 =head1 PRIMARY KEY
 226
 227 =over 4
 228
 229 =item * L</id>
 230
 231 =back
 232
 233 =cut
 234
 235 __PACKAGE__->set_primary_key("id");
 236
 237 =head1 RELATIONS
 238
 239 =head2 aqbasketgroups
 240
 241 Type: has_many
 242
 243 Related object: L<Koha::Schema::Result::Aqbasketgroup>
 244
 245 =cut
 246
 247 __PACKAGE__->has_many(
 248   "aqbasketgroups",
 249   "Koha::Schema::Result::Aqbasketgroup",
 250   { "foreign.booksellerid" => "self.id" },
 251   { cascade_copy => 0, cascade_delete => 0 },
 252 );
 253
 254 =head2 aqbaskets
 255
 256 Type: has_many
 257
 258 Related object: L<Koha::Schema::Result::Aqbasket>
 259
 260 =cut
 261
 262 __PACKAGE__->has_many(
 263   "aqbaskets",
 264   "Koha::Schema::Result::Aqbasket",
 265   { "foreign.booksellerid" => "self.id" },
 266   { cascade_copy => 0, cascade_delete => 0 },
 267 );
 268
 269 =head2 aqcontacts
 270
 271 Type: has_many
 272
 273 Related object: L<Koha::Schema::Result::Aqcontact>
 274
 275 =cut
 276
 277 __PACKAGE__->has_many(
 278   "aqcontacts",
 279   "Koha::Schema::Result::Aqcontact",
 280   { "foreign.booksellerid" => "self.id" },
 281   { cascade_copy => 0, cascade_delete => 0 },
 282 );
 283
 284 =head2 aqcontracts
 285
 286 Type: has_many
 287
 288 Related object: L<Koha::Schema::Result::Aqcontract>
 289
 290 =cut
 291
 292 __PACKAGE__->has_many(
 293   "aqcontracts",
 294   "Koha::Schema::Result::Aqcontract",
 295   { "foreign.booksellerid" => "self.id" },
 296   { cascade_copy => 0, cascade_delete => 0 },
 297 );
 298
 299 =head2 aqinvoices
 300
 301 Type: has_many
 302
 303 Related object: L<Koha::Schema::Result::Aqinvoice>
 304
 305 =cut
 306
 307 __PACKAGE__->has_many(
 308   "aqinvoices",
 309   "Koha::Schema::Result::Aqinvoice",
 310   { "foreign.booksellerid" => "self.id" },
 311   { cascade_copy => 0, cascade_delete => 0 },
 312 );
 313
 314 =head2 invoiceprice
 315
 316 Type: belongs_to
 317
 318 Related object: L<Koha::Schema::Result::Currency>
 319
 320 =cut
 321
 322 __PACKAGE__->belongs_to(
 323   "invoiceprice",
 324   "Koha::Schema::Result::Currency",
 325   { currency => "invoiceprice" },
 326   {
 327     is_deferrable => 1,
 328     join_type     => "LEFT",
 329     on_delete     => "CASCADE",
 330     on_update     => "CASCADE",
 331   },
 332 );
 333
 334 =head2 listprice
 335
 336 Type: belongs_to
 337
 338 Related object: L<Koha::Schema::Result::Currency>
 339
 340 =cut
 341
 342 __PACKAGE__->belongs_to(
 343   "listprice",
 344   "Koha::Schema::Result::Currency",
 345   { currency => "listprice" },
 346   {
 347     is_deferrable => 1,
 348     join_type     => "LEFT",
 349     on_delete     => "CASCADE",
 350     on_update     => "CASCADE",
 351   },
 352 );
 353
 354
 355 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-26 11:53:50
 356 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kz1tuPJihENyV6OyCwyX/A
 357
 358
 359 # You can replace this text with custom content, and it will be preserved on regeneration
 360 1;