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 contact
 101
 102   data_type: 'varchar'
 103   is_nullable: 1
 104   size: 100
 105
 106 =head2 postal
 107
 108   data_type: 'mediumtext'
 109   is_nullable: 1
 110
 111 =head2 url
 112
 113   data_type: 'varchar'
 114   is_nullable: 1
 115   size: 255
 116
 117 =head2 contpos
 118
 119   data_type: 'varchar'
 120   is_nullable: 1
 121   size: 100
 122
 123 =head2 contphone
 124
 125   data_type: 'varchar'
 126   is_nullable: 1
 127   size: 100
 128
 129 =head2 contfax
 130
 131   data_type: 'varchar'
 132   is_nullable: 1
 133   size: 100
 134
 135 =head2 contaltphone
 136
 137   data_type: 'varchar'
 138   is_nullable: 1
 139   size: 100
 140
 141 =head2 contemail
 142
 143   data_type: 'varchar'
 144   is_nullable: 1
 145   size: 100
 146
 147 =head2 contnotes
 148
 149   data_type: 'mediumtext'
 150   is_nullable: 1
 151
 152 =head2 active
 153
 154   data_type: 'tinyint'
 155   is_nullable: 1
 156
 157 =head2 listprice
 158
 159   data_type: 'varchar'
 160   is_foreign_key: 1
 161   is_nullable: 1
 162   size: 10
 163
 164 =head2 invoiceprice
 165
 166   data_type: 'varchar'
 167   is_foreign_key: 1
 168   is_nullable: 1
 169   size: 10
 170
 171 =head2 gstreg
 172
 173   data_type: 'tinyint'
 174   is_nullable: 1
 175
 176 =head2 listincgst
 177
 178   data_type: 'tinyint'
 179   is_nullable: 1
 180
 181 =head2 invoiceincgst
 182
 183   data_type: 'tinyint'
 184   is_nullable: 1
 185
 186 =head2 gstrate
 187
 188   data_type: 'decimal'
 189   is_nullable: 1
 190   size: [6,4]
 191
 192 =head2 discount
 193
 194   data_type: 'float'
 195   is_nullable: 1
 196   size: [6,4]
 197
 198 =head2 fax
 199
 200   data_type: 'varchar'
 201   is_nullable: 1
 202   size: 50
 203
 204 =head2 deliverytime
 205
 206   data_type: 'integer'
 207   is_nullable: 1
 208
 209 =cut
 210
 211 __PACKAGE__->add_columns(
 212   "id",
 213   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 214   "name",
 215   { data_type => "mediumtext", is_nullable => 0 },
 216   "address1",
 217   { data_type => "mediumtext", is_nullable => 1 },
 218   "address2",
 219   { data_type => "mediumtext", is_nullable => 1 },
 220   "address3",
 221   { data_type => "mediumtext", is_nullable => 1 },
 222   "address4",
 223   { data_type => "mediumtext", is_nullable => 1 },
 224   "phone",
 225   { data_type => "varchar", is_nullable => 1, size => 30 },
 226   "accountnumber",
 227   { data_type => "mediumtext", is_nullable => 1 },
 228   "othersupplier",
 229   { data_type => "mediumtext", is_nullable => 1 },
 230   "currency",
 231   { data_type => "varchar", default_value => "", is_nullable => 0, size => 3 },
 232   "booksellerfax",
 233   { data_type => "mediumtext", is_nullable => 1 },
 234   "notes",
 235   { data_type => "mediumtext", is_nullable => 1 },
 236   "bookselleremail",
 237   { data_type => "mediumtext", is_nullable => 1 },
 238   "booksellerurl",
 239   { data_type => "mediumtext", is_nullable => 1 },
 240   "contact",
 241   { data_type => "varchar", is_nullable => 1, size => 100 },
 242   "postal",
 243   { data_type => "mediumtext", is_nullable => 1 },
 244   "url",
 245   { data_type => "varchar", is_nullable => 1, size => 255 },
 246   "contpos",
 247   { data_type => "varchar", is_nullable => 1, size => 100 },
 248   "contphone",
 249   { data_type => "varchar", is_nullable => 1, size => 100 },
 250   "contfax",
 251   { data_type => "varchar", is_nullable => 1, size => 100 },
 252   "contaltphone",
 253   { data_type => "varchar", is_nullable => 1, size => 100 },
 254   "contemail",
 255   { data_type => "varchar", is_nullable => 1, size => 100 },
 256   "contnotes",
 257   { data_type => "mediumtext", is_nullable => 1 },
 258   "active",
 259   { data_type => "tinyint", is_nullable => 1 },
 260   "listprice",
 261   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 262   "invoiceprice",
 263   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 264   "gstreg",
 265   { data_type => "tinyint", is_nullable => 1 },
 266   "listincgst",
 267   { data_type => "tinyint", is_nullable => 1 },
 268   "invoiceincgst",
 269   { data_type => "tinyint", is_nullable => 1 },
 270   "gstrate",
 271   { data_type => "decimal", is_nullable => 1, size => [6, 4] },
 272   "discount",
 273   { data_type => "float", is_nullable => 1, size => [6, 4] },
 274   "fax",
 275   { data_type => "varchar", is_nullable => 1, size => 50 },
 276   "deliverytime",
 277   { data_type => "integer", is_nullable => 1 },
 278 );
 279
 280 =head1 PRIMARY KEY
 281
 282 =over 4
 283
 284 =item * L</id>
 285
 286 =back
 287
 288 =cut
 289
 290 __PACKAGE__->set_primary_key("id");
 291
 292 =head1 RELATIONS
 293
 294 =head2 aqbasketgroups
 295
 296 Type: has_many
 297
 298 Related object: L<Koha::Schema::Result::Aqbasketgroup>
 299
 300 =cut
 301
 302 __PACKAGE__->has_many(
 303   "aqbasketgroups",
 304   "Koha::Schema::Result::Aqbasketgroup",
 305   { "foreign.booksellerid" => "self.id" },
 306   { cascade_copy => 0, cascade_delete => 0 },
 307 );
 308
 309 =head2 aqbaskets
 310
 311 Type: has_many
 312
 313 Related object: L<Koha::Schema::Result::Aqbasket>
 314
 315 =cut
 316
 317 __PACKAGE__->has_many(
 318   "aqbaskets",
 319   "Koha::Schema::Result::Aqbasket",
 320   { "foreign.booksellerid" => "self.id" },
 321   { cascade_copy => 0, cascade_delete => 0 },
 322 );
 323
 324 =head2 aqcontracts
 325
 326 Type: has_many
 327
 328 Related object: L<Koha::Schema::Result::Aqcontract>
 329
 330 =cut
 331
 332 __PACKAGE__->has_many(
 333   "aqcontracts",
 334   "Koha::Schema::Result::Aqcontract",
 335   { "foreign.booksellerid" => "self.id" },
 336   { cascade_copy => 0, cascade_delete => 0 },
 337 );
 338
 339 =head2 aqinvoices
 340
 341 Type: has_many
 342
 343 Related object: L<Koha::Schema::Result::Aqinvoice>
 344
 345 =cut
 346
 347 __PACKAGE__->has_many(
 348   "aqinvoices",
 349   "Koha::Schema::Result::Aqinvoice",
 350   { "foreign.booksellerid" => "self.id" },
 351   { cascade_copy => 0, cascade_delete => 0 },
 352 );
 353
 354 =head2 invoiceprice
 355
 356 Type: belongs_to
 357
 358 Related object: L<Koha::Schema::Result::Currency>
 359
 360 =cut
 361
 362 __PACKAGE__->belongs_to(
 363   "invoiceprice",
 364   "Koha::Schema::Result::Currency",
 365   { currency => "invoiceprice" },
 366   {
 367     is_deferrable => 1,
 368     join_type     => "LEFT",
 369     on_delete     => "CASCADE",
 370     on_update     => "CASCADE",
 371   },
 372 );
 373
 374 =head2 listprice
 375
 376 Type: belongs_to
 377
 378 Related object: L<Koha::Schema::Result::Currency>
 379
 380 =cut
 381
 382 __PACKAGE__->belongs_to(
 383   "listprice",
 384   "Koha::Schema::Result::Currency",
 385   { currency => "listprice" },
 386   {
 387     is_deferrable => 1,
 388     join_type     => "LEFT",
 389     on_delete     => "CASCADE",
 390     on_update     => "CASCADE",
 391   },
 392 );
 393
 394
 395 # Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
 396 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Pqq5chHLUwm5Ss5CCQBL2g
 397
 398
 399 # You can replace this text with custom content, and it will be preserved on regeneration
 400 1;