Koha/Schema/Result/PseudonymizedTransaction.pm

   1 use utf8;
   2 package Koha::Schema::Result::PseudonymizedTransaction;
   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::PseudonymizedTransaction
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<pseudonymized_transactions>
  19
  20 =cut
  21
  22 __PACKAGE__->table("pseudonymized_transactions");
  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 hashed_borrowernumber
  33
  34   data_type: 'varchar'
  35   is_nullable: 0
  36   size: 60
  37
  38 =head2 has_cardnumber
  39
  40   data_type: 'tinyint'
  41   default_value: 0
  42   is_nullable: 0
  43
  44 =head2 title
  45
  46   data_type: 'longtext'
  47   is_nullable: 1
  48
  49 =head2 city
  50
  51   data_type: 'longtext'
  52   is_nullable: 1
  53
  54 =head2 state
  55
  56   data_type: 'mediumtext'
  57   is_nullable: 1
  58
  59 =head2 zipcode
  60
  61   data_type: 'varchar'
  62   is_nullable: 1
  63   size: 25
  64
  65 =head2 country
  66
  67   data_type: 'mediumtext'
  68   is_nullable: 1
  69
  70 =head2 branchcode
  71
  72   data_type: 'varchar'
  73   default_value: (empty string)
  74   is_foreign_key: 1
  75   is_nullable: 0
  76   size: 10
  77
  78 =head2 categorycode
  79
  80   data_type: 'varchar'
  81   default_value: (empty string)
  82   is_foreign_key: 1
  83   is_nullable: 0
  84   size: 10
  85
  86 =head2 dateenrolled
  87
  88   data_type: 'date'
  89   datetime_undef_if_invalid: 1
  90   is_nullable: 1
  91
  92 =head2 sex
  93
  94   data_type: 'varchar'
  95   is_nullable: 1
  96   size: 1
  97
  98 =head2 sort1
  99
 100   data_type: 'varchar'
 101   is_nullable: 1
 102   size: 80
 103
 104 =head2 sort2
 105
 106   data_type: 'varchar'
 107   is_nullable: 1
 108   size: 80
 109
 110 =head2 datetime
 111
 112   data_type: 'datetime'
 113   datetime_undef_if_invalid: 1
 114   is_nullable: 1
 115
 116 =head2 transaction_branchcode
 117
 118   data_type: 'varchar'
 119   is_foreign_key: 1
 120   is_nullable: 1
 121   size: 10
 122
 123 =head2 transaction_type
 124
 125   data_type: 'varchar'
 126   is_nullable: 1
 127   size: 16
 128
 129 =head2 itemnumber
 130
 131   data_type: 'integer'
 132   is_nullable: 1
 133
 134 =head2 itemtype
 135
 136   data_type: 'varchar'
 137   is_nullable: 1
 138   size: 10
 139
 140 =head2 holdingbranch
 141
 142   data_type: 'varchar'
 143   is_nullable: 1
 144   size: 10
 145
 146 =head2 location
 147
 148   data_type: 'varchar'
 149   is_nullable: 1
 150   size: 80
 151
 152 =head2 itemcallnumber
 153
 154   data_type: 'varchar'
 155   is_nullable: 1
 156   size: 255
 157
 158 =head2 ccode
 159
 160   data_type: 'varchar'
 161   is_nullable: 1
 162   size: 80
 163
 164 =cut
 165
 166 __PACKAGE__->add_columns(
 167   "id",
 168   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 169   "hashed_borrowernumber",
 170   { data_type => "varchar", is_nullable => 0, size => 60 },
 171   "has_cardnumber",
 172   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 173   "title",
 174   { data_type => "longtext", is_nullable => 1 },
 175   "city",
 176   { data_type => "longtext", is_nullable => 1 },
 177   "state",
 178   { data_type => "mediumtext", is_nullable => 1 },
 179   "zipcode",
 180   { data_type => "varchar", is_nullable => 1, size => 25 },
 181   "country",
 182   { data_type => "mediumtext", is_nullable => 1 },
 183   "branchcode",
 184   {
 185     data_type => "varchar",
 186     default_value => "",
 187     is_foreign_key => 1,
 188     is_nullable => 0,
 189     size => 10,
 190   },
 191   "categorycode",
 192   {
 193     data_type => "varchar",
 194     default_value => "",
 195     is_foreign_key => 1,
 196     is_nullable => 0,
 197     size => 10,
 198   },
 199   "dateenrolled",
 200   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 201   "sex",
 202   { data_type => "varchar", is_nullable => 1, size => 1 },
 203   "sort1",
 204   { data_type => "varchar", is_nullable => 1, size => 80 },
 205   "sort2",
 206   { data_type => "varchar", is_nullable => 1, size => 80 },
 207   "datetime",
 208   {
 209     data_type => "datetime",
 210     datetime_undef_if_invalid => 1,
 211     is_nullable => 1,
 212   },
 213   "transaction_branchcode",
 214   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 215   "transaction_type",
 216   { data_type => "varchar", is_nullable => 1, size => 16 },
 217   "itemnumber",
 218   { data_type => "integer", is_nullable => 1 },
 219   "itemtype",
 220   { data_type => "varchar", is_nullable => 1, size => 10 },
 221   "holdingbranch",
 222   { data_type => "varchar", is_nullable => 1, size => 10 },
 223   "location",
 224   { data_type => "varchar", is_nullable => 1, size => 80 },
 225   "itemcallnumber",
 226   { data_type => "varchar", is_nullable => 1, size => 255 },
 227   "ccode",
 228   { data_type => "varchar", is_nullable => 1, size => 80 },
 229 );
 230
 231 =head1 PRIMARY KEY
 232
 233 =over 4
 234
 235 =item * L</id>
 236
 237 =back
 238
 239 =cut
 240
 241 __PACKAGE__->set_primary_key("id");
 242
 243 =head1 RELATIONS
 244
 245 =head2 branchcode
 246
 247 Type: belongs_to
 248
 249 Related object: L<Koha::Schema::Result::Branch>
 250
 251 =cut
 252
 253 __PACKAGE__->belongs_to(
 254   "branchcode",
 255   "Koha::Schema::Result::Branch",
 256   { branchcode => "branchcode" },
 257   { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
 258 );
 259
 260 =head2 categorycode
 261
 262 Type: belongs_to
 263
 264 Related object: L<Koha::Schema::Result::Category>
 265
 266 =cut
 267
 268 __PACKAGE__->belongs_to(
 269   "categorycode",
 270   "Koha::Schema::Result::Category",
 271   { categorycode => "categorycode" },
 272   { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
 273 );
 274
 275 =head2 pseudonymized_borrower_attributes
 276
 277 Type: has_many
 278
 279 Related object: L<Koha::Schema::Result::PseudonymizedBorrowerAttribute>
 280
 281 =cut
 282
 283 __PACKAGE__->has_many(
 284   "pseudonymized_borrower_attributes",
 285   "Koha::Schema::Result::PseudonymizedBorrowerAttribute",
 286   { "foreign.transaction_id" => "self.id" },
 287   { cascade_copy => 0, cascade_delete => 0 },
 288 );
 289
 290 =head2 transaction_branchcode
 291
 292 Type: belongs_to
 293
 294 Related object: L<Koha::Schema::Result::Branch>
 295
 296 =cut
 297
 298 __PACKAGE__->belongs_to(
 299   "transaction_branchcode",
 300   "Koha::Schema::Result::Branch",
 301   { branchcode => "transaction_branchcode" },
 302   {
 303     is_deferrable => 1,
 304     join_type     => "LEFT",
 305     on_delete     => "RESTRICT",
 306     on_update     => "RESTRICT",
 307   },
 308 );
 309
 310
 311 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 17:12:17
 312 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bzHjcKCHYf+bixeA1dhKIQ
 313
 314
 315 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 316 1;