Koha/Schema/Result/ErmAgreement.pm

   1 use utf8;
   2 package Koha::Schema::Result::ErmAgreement;
   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::ErmAgreement
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<erm_agreements>
  19
  20 =cut
  21
  22 __PACKAGE__->table("erm_agreements");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 agreement_id
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 primary key
  33
  34 =head2 vendor_id
  35
  36   data_type: 'integer'
  37   is_foreign_key: 1
  38   is_nullable: 1
  39
  40 foreign key to aqbooksellers
  41
  42 =head2 name
  43
  44   data_type: 'varchar'
  45   is_nullable: 0
  46   size: 255
  47
  48 name of the agreement
  49
  50 =head2 description
  51
  52   data_type: 'longtext'
  53   is_nullable: 1
  54
  55 description of the agreement
  56
  57 =head2 status
  58
  59   data_type: 'varchar'
  60   is_nullable: 0
  61   size: 80
  62
  63 current status of the agreement
  64
  65 =head2 closure_reason
  66
  67   data_type: 'varchar'
  68   is_nullable: 1
  69   size: 80
  70
  71 reason of the closure
  72
  73 =head2 is_perpetual
  74
  75   data_type: 'tinyint'
  76   default_value: 0
  77   is_nullable: 0
  78
  79 is the agreement perpetual
  80
  81 =head2 renewal_priority
  82
  83   data_type: 'varchar'
  84   is_nullable: 1
  85   size: 80
  86
  87 priority of the renewal
  88
  89 =head2 license_info
  90
  91   data_type: 'varchar'
  92   is_nullable: 1
  93   size: 80
  94
  95 info about the license
  96
  97 =cut
  98
  99 __PACKAGE__->add_columns(
 100   "agreement_id",
 101   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 102   "vendor_id",
 103   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 104   "name",
 105   { data_type => "varchar", is_nullable => 0, size => 255 },
 106   "description",
 107   { data_type => "longtext", is_nullable => 1 },
 108   "status",
 109   { data_type => "varchar", is_nullable => 0, size => 80 },
 110   "closure_reason",
 111   { data_type => "varchar", is_nullable => 1, size => 80 },
 112   "is_perpetual",
 113   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 114   "renewal_priority",
 115   { data_type => "varchar", is_nullable => 1, size => 80 },
 116   "license_info",
 117   { data_type => "varchar", is_nullable => 1, size => 80 },
 118 );
 119
 120 =head1 PRIMARY KEY
 121
 122 =over 4
 123
 124 =item * L</agreement_id>
 125
 126 =back
 127
 128 =cut
 129
 130 __PACKAGE__->set_primary_key("agreement_id");
 131
 132 =head1 RELATIONS
 133
 134 =head2 erm_agreement_licenses
 135
 136 Type: has_many
 137
 138 Related object: L<Koha::Schema::Result::ErmAgreementLicense>
 139
 140 =cut
 141
 142 __PACKAGE__->has_many(
 143   "erm_agreement_licenses",
 144   "Koha::Schema::Result::ErmAgreementLicense",
 145   { "foreign.agreement_id" => "self.agreement_id" },
 146   { cascade_copy => 0, cascade_delete => 0 },
 147 );
 148
 149 =head2 erm_agreement_periods
 150
 151 Type: has_many
 152
 153 Related object: L<Koha::Schema::Result::ErmAgreementPeriod>
 154
 155 =cut
 156
 157 __PACKAGE__->has_many(
 158   "erm_agreement_periods",
 159   "Koha::Schema::Result::ErmAgreementPeriod",
 160   { "foreign.agreement_id" => "self.agreement_id" },
 161   { cascade_copy => 0, cascade_delete => 0 },
 162 );
 163
 164 =head2 erm_agreement_relationships_agreements
 165
 166 Type: has_many
 167
 168 Related object: L<Koha::Schema::Result::ErmAgreementRelationship>
 169
 170 =cut
 171
 172 __PACKAGE__->has_many(
 173   "erm_agreement_relationships_agreements",
 174   "Koha::Schema::Result::ErmAgreementRelationship",
 175   { "foreign.agreement_id" => "self.agreement_id" },
 176   { cascade_copy => 0, cascade_delete => 0 },
 177 );
 178
 179 =head2 erm_agreement_relationships_related_agreements
 180
 181 Type: has_many
 182
 183 Related object: L<Koha::Schema::Result::ErmAgreementRelationship>
 184
 185 =cut
 186
 187 __PACKAGE__->has_many(
 188   "erm_agreement_relationships_related_agreements",
 189   "Koha::Schema::Result::ErmAgreementRelationship",
 190   { "foreign.related_agreement_id" => "self.agreement_id" },
 191   { cascade_copy => 0, cascade_delete => 0 },
 192 );
 193
 194 =head2 erm_documents
 195
 196 Type: has_many
 197
 198 Related object: L<Koha::Schema::Result::ErmDocument>
 199
 200 =cut
 201
 202 __PACKAGE__->has_many(
 203   "erm_documents",
 204   "Koha::Schema::Result::ErmDocument",
 205   { "foreign.agreement_id" => "self.agreement_id" },
 206   { cascade_copy => 0, cascade_delete => 0 },
 207 );
 208
 209 =head2 erm_eholdings_packages_agreements
 210
 211 Type: has_many
 212
 213 Related object: L<Koha::Schema::Result::ErmEholdingsPackagesAgreement>
 214
 215 =cut
 216
 217 __PACKAGE__->has_many(
 218   "erm_eholdings_packages_agreements",
 219   "Koha::Schema::Result::ErmEholdingsPackagesAgreement",
 220   { "foreign.agreement_id" => "self.agreement_id" },
 221   { cascade_copy => 0, cascade_delete => 0 },
 222 );
 223
 224 =head2 erm_user_roles
 225
 226 Type: has_many
 227
 228 Related object: L<Koha::Schema::Result::ErmUserRole>
 229
 230 =cut
 231
 232 __PACKAGE__->has_many(
 233   "erm_user_roles",
 234   "Koha::Schema::Result::ErmUserRole",
 235   { "foreign.agreement_id" => "self.agreement_id" },
 236   { cascade_copy => 0, cascade_delete => 0 },
 237 );
 238
 239 =head2 vendor
 240
 241 Type: belongs_to
 242
 243 Related object: L<Koha::Schema::Result::Aqbookseller>
 244
 245 =cut
 246
 247 __PACKAGE__->belongs_to(
 248   "vendor",
 249   "Koha::Schema::Result::Aqbookseller",
 250   { id => "vendor_id" },
 251   {
 252     is_deferrable => 1,
 253     join_type     => "LEFT",
 254     on_delete     => "SET NULL",
 255     on_update     => "CASCADE",
 256   },
 257 );
 258
 259
 260 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-11-01 07:44:13
 261 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rdLbabpHCgb4l88Gmgst+g
 262
 263
 264 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 265 1;