Koha/Schema/Result/MarcSubfieldStructure.pm

   1 use utf8;
   2 package Koha::Schema::Result::MarcSubfieldStructure;
   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::MarcSubfieldStructure
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<marc_subfield_structure>
  19
  20 =cut
  21
  22 __PACKAGE__->table("marc_subfield_structure");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 tagfield
  27
  28   data_type: 'varchar'
  29   default_value: (empty string)
  30   is_nullable: 0
  31   size: 3
  32
  33 =head2 tagsubfield
  34
  35   data_type: 'varchar'
  36   default_value: (empty string)
  37   is_nullable: 0
  38   size: 1
  39
  40 =head2 liblibrarian
  41
  42   data_type: 'varchar'
  43   default_value: (empty string)
  44   is_nullable: 0
  45   size: 255
  46
  47 =head2 libopac
  48
  49   data_type: 'varchar'
  50   default_value: (empty string)
  51   is_nullable: 0
  52   size: 255
  53
  54 =head2 repeatable
  55
  56   data_type: 'tinyint'
  57   default_value: 0
  58   is_nullable: 0
  59
  60 =head2 mandatory
  61
  62   data_type: 'tinyint'
  63   default_value: 0
  64   is_nullable: 0
  65
  66 =head2 important
  67
  68   data_type: 'tinyint'
  69   default_value: 0
  70   is_nullable: 0
  71
  72 =head2 kohafield
  73
  74   data_type: 'varchar'
  75   is_nullable: 1
  76   size: 40
  77
  78 =head2 tab
  79
  80   data_type: 'tinyint'
  81   is_nullable: 1
  82
  83 =head2 authorised_value
  84
  85   data_type: 'varchar'
  86   is_foreign_key: 1
  87   is_nullable: 1
  88   size: 32
  89
  90 =head2 authtypecode
  91
  92   data_type: 'varchar'
  93   is_nullable: 1
  94   size: 20
  95
  96 =head2 value_builder
  97
  98   data_type: 'varchar'
  99   is_nullable: 1
 100   size: 80
 101
 102 =head2 isurl
 103
 104   data_type: 'tinyint'
 105   is_nullable: 1
 106
 107 =head2 hidden
 108
 109   data_type: 'tinyint'
 110   default_value: 8
 111   is_nullable: 0
 112
 113 =head2 frameworkcode
 114
 115   data_type: 'varchar'
 116   default_value: (empty string)
 117   is_nullable: 0
 118   size: 4
 119
 120 =head2 seealso
 121
 122   data_type: 'varchar'
 123   is_nullable: 1
 124   size: 1100
 125
 126 =head2 link
 127
 128   data_type: 'varchar'
 129   is_nullable: 1
 130   size: 80
 131
 132 =head2 defaultvalue
 133
 134   data_type: 'mediumtext'
 135   is_nullable: 1
 136
 137 =head2 maxlength
 138
 139   data_type: 'integer'
 140   default_value: 9999
 141   is_nullable: 0
 142
 143 =cut
 144
 145 __PACKAGE__->add_columns(
 146   "tagfield",
 147   { data_type => "varchar", default_value => "", is_nullable => 0, size => 3 },
 148   "tagsubfield",
 149   { data_type => "varchar", default_value => "", is_nullable => 0, size => 1 },
 150   "liblibrarian",
 151   { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
 152   "libopac",
 153   { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
 154   "repeatable",
 155   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 156   "mandatory",
 157   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 158   "important",
 159   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 160   "kohafield",
 161   { data_type => "varchar", is_nullable => 1, size => 40 },
 162   "tab",
 163   { data_type => "tinyint", is_nullable => 1 },
 164   "authorised_value",
 165   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 32 },
 166   "authtypecode",
 167   { data_type => "varchar", is_nullable => 1, size => 20 },
 168   "value_builder",
 169   { data_type => "varchar", is_nullable => 1, size => 80 },
 170   "isurl",
 171   { data_type => "tinyint", is_nullable => 1 },
 172   "hidden",
 173   { data_type => "tinyint", default_value => 8, is_nullable => 0 },
 174   "frameworkcode",
 175   { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
 176   "seealso",
 177   { data_type => "varchar", is_nullable => 1, size => 1100 },
 178   "link",
 179   { data_type => "varchar", is_nullable => 1, size => 80 },
 180   "defaultvalue",
 181   { data_type => "mediumtext", is_nullable => 1 },
 182   "maxlength",
 183   { data_type => "integer", default_value => 9999, is_nullable => 0 },
 184 );
 185
 186 =head1 PRIMARY KEY
 187
 188 =over 4
 189
 190 =item * L</frameworkcode>
 191
 192 =item * L</tagfield>
 193
 194 =item * L</tagsubfield>
 195
 196 =back
 197
 198 =cut
 199
 200 __PACKAGE__->set_primary_key("frameworkcode", "tagfield", "tagsubfield");
 201
 202 =head1 RELATIONS
 203
 204 =head2 authorised_value
 205
 206 Type: belongs_to
 207
 208 Related object: L<Koha::Schema::Result::AuthorisedValueCategory>
 209
 210 =cut
 211
 212 __PACKAGE__->belongs_to(
 213   "authorised_value",
 214   "Koha::Schema::Result::AuthorisedValueCategory",
 215   { category_name => "authorised_value" },
 216   {
 217     is_deferrable => 1,
 218     join_type     => "LEFT",
 219     on_delete     => "SET NULL",
 220     on_update     => "CASCADE",
 221   },
 222 );
 223
 224
 225 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-11 14:36:42
 226 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lCe1ZenRM/9rXnRHXhDuSw
 227
 228
 229 # You can replace this text with custom content, and it will be preserved on regeneration
 230 1;