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: 'longtext'
  35   is_nullable: 0
  36
  37 =head2 address1
  38
  39   data_type: 'longtext'
  40   is_nullable: 1
  41
  42 =head2 address2
  43
  44   data_type: 'longtext'
  45   is_nullable: 1
  46
  47 =head2 address3
  48
  49   data_type: 'longtext'
  50   is_nullable: 1
  51
  52 =head2 address4
  53
  54   data_type: 'longtext'
  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: 'longtext'
  66   is_nullable: 1
  67
  68 =head2 othersupplier
  69
  70   data_type: 'longtext'
  71   is_nullable: 1
  72
  73 =head2 currency
  74
  75   data_type: 'varchar'
  76   default_value: (empty string)
  77   is_nullable: 0
  78   size: 10
  79
  80 =head2 booksellerfax
  81
  82   data_type: 'longtext'
  83   is_nullable: 1
  84
  85 =head2 notes
  86
  87   data_type: 'longtext'
  88   is_nullable: 1
  89
  90 =head2 bookselleremail
  91
  92   data_type: 'longtext'
  93   is_nullable: 1
  94
  95 =head2 booksellerurl
  96
  97   data_type: 'longtext'
  98   is_nullable: 1
  99
 100 =head2 postal
 101
 102   data_type: 'longtext'
 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 tax_rate
 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 => "longtext", is_nullable => 0 },
 175   "address1",
 176   { data_type => "longtext", is_nullable => 1 },
 177   "address2",
 178   { data_type => "longtext", is_nullable => 1 },
 179   "address3",
 180   { data_type => "longtext", is_nullable => 1 },
 181   "address4",
 182   { data_type => "longtext", is_nullable => 1 },
 183   "phone",
 184   { data_type => "varchar", is_nullable => 1, size => 30 },
 185   "accountnumber",
 186   { data_type => "longtext", is_nullable => 1 },
 187   "othersupplier",
 188   { data_type => "longtext", is_nullable => 1 },
 189   "currency",
 190   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
 191   "booksellerfax",
 192   { data_type => "longtext", is_nullable => 1 },
 193   "notes",
 194   { data_type => "longtext", is_nullable => 1 },
 195   "bookselleremail",
 196   { data_type => "longtext", is_nullable => 1 },
 197   "booksellerurl",
 198   { data_type => "longtext", is_nullable => 1 },
 199   "postal",
 200   { data_type => "longtext", 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   "tax_rate",
 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 edifact_messages
 315
 316 Type: has_many
 317
 318 Related object: L<Koha::Schema::Result::EdifactMessage>
 319
 320 =cut
 321
 322 __PACKAGE__->has_many(
 323   "edifact_messages",
 324   "Koha::Schema::Result::EdifactMessage",
 325   { "foreign.vendor_id" => "self.id" },
 326   { cascade_copy => 0, cascade_delete => 0 },
 327 );
 328
 329 =head2 invoiceprice
 330
 331 Type: belongs_to
 332
 333 Related object: L<Koha::Schema::Result::Currency>
 334
 335 =cut
 336
 337 __PACKAGE__->belongs_to(
 338   "invoiceprice",
 339   "Koha::Schema::Result::Currency",
 340   { currency => "invoiceprice" },
 341   {
 342     is_deferrable => 1,
 343     join_type     => "LEFT",
 344     on_delete     => "CASCADE",
 345     on_update     => "CASCADE",
 346   },
 347 );
 348
 349 =head2 listprice
 350
 351 Type: belongs_to
 352
 353 Related object: L<Koha::Schema::Result::Currency>
 354
 355 =cut
 356
 357 __PACKAGE__->belongs_to(
 358   "listprice",
 359   "Koha::Schema::Result::Currency",
 360   { currency => "listprice" },
 361   {
 362     is_deferrable => 1,
 363     join_type     => "LEFT",
 364     on_delete     => "CASCADE",
 365     on_update     => "CASCADE",
 366   },
 367 );
 368
 369 =head2 vendor_edi_accounts
 370
 371 Type: has_many
 372
 373 Related object: L<Koha::Schema::Result::VendorEdiAccount>
 374
 375 =cut
 376
 377 __PACKAGE__->has_many(
 378   "vendor_edi_accounts",
 379   "Koha::Schema::Result::VendorEdiAccount",
 380   { "foreign.vendor_id" => "self.id" },
 381   { cascade_copy => 0, cascade_delete => 0 },
 382 );
 383
 384
 385 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
 386 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DyaF9RbcNAOjPQ1lrxHV3A
 387
 388 __PACKAGE__->add_columns(
 389     '+active' => { is_boolean => 1 },
 390     '+gstreg' => { is_boolean => 1 },
 391     '+listincgst' => { is_boolean => 1 },
 392     '+invoiceincgst' => { is_boolean => 1 },
 393 );
 394
 395 sub koha_object_class {
 396     'Koha::Acquisition::Bookseller';
 397 }
 398 sub koha_objects_class {
 399     'Koha::Acquisition::Booksellers';
 400 }
 401
 402 1;