lib/SGN/Schema/Organism.pm

   1 package SGN::Schema::Organism;
   2
   3 # Created by DBIx::Class::Schema::Loader
   4 # DO NOT MODIFY THE FIRST PART OF THIS FILE
   5
   6 use strict;
   7 use warnings;
   8
   9 use base 'DBIx::Class::Core';
  10
  11
  12 =head1 NAME
  13
  14 SGN::Schema::Organism
  15
  16 =cut
  17
  18 __PACKAGE__->table("organism");
  19
  20 =head1 ACCESSORS
  21
  22 =head2 organism_id
  23
  24   data_type: 'integer'
  25   is_auto_increment: 1
  26   is_nullable: 0
  27   sequence: 'organism_organism_id_seq'
  28
  29 =head2 organism_name
  30
  31   data_type: 'varchar'
  32   is_nullable: 1
  33   size: 80
  34
  35 =head2 common_name_id
  36
  37   data_type: 'bigint'
  38   is_foreign_key: 1
  39   is_nullable: 0
  40
  41 =head2 organism_descrip
  42
  43   data_type: 'text'
  44   is_nullable: 1
  45
  46 =head2 specie_tax
  47
  48   data_type: 'varchar'
  49   is_nullable: 1
  50   size: 80
  51
  52 =head2 genus_tax
  53
  54   data_type: 'integer'
  55   is_foreign_key: 1
  56   is_nullable: 1
  57
  58 =head2 subfamily_tax
  59
  60   data_type: 'integer'
  61   is_foreign_key: 1
  62   is_nullable: 1
  63
  64 =head2 family_tax
  65
  66   data_type: 'integer'
  67   is_foreign_key: 1
  68   is_nullable: 1
  69
  70 =head2 order_tax
  71
  72   data_type: 'integer'
  73   is_foreign_key: 1
  74   is_nullable: 1
  75
  76 =head2 chr_n_gnmc
  77
  78   data_type: 'integer'
  79   is_nullable: 1
  80
  81 =head2 polypl_gnmc
  82
  83   data_type: 'varchar'
  84   is_nullable: 1
  85   size: 50
  86
  87 =head2 genom_size_gnmc
  88
  89   data_type: 'varchar'
  90   is_nullable: 1
  91   size: 50
  92
  93 =head2 genom_proj_gnmc
  94
  95   data_type: 'text'
  96   is_nullable: 1
  97
  98 =head2 est_attribution_tqmc
  99
 100   data_type: 'text'
 101   is_nullable: 1
 102
 103 =head2 chado_organism_id
 104
 105   data_type: 'integer'
 106   is_nullable: 1
 107
 108 =cut
 109
 110 __PACKAGE__->add_columns(
 111   "organism_id",
 112   {
 113     data_type         => "integer",
 114     is_auto_increment => 1,
 115     is_nullable       => 0,
 116     sequence          => "organism_organism_id_seq",
 117   },
 118   "organism_name",
 119   { data_type => "varchar", is_nullable => 1, size => 80 },
 120   "common_name_id",
 121   { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
 122   "organism_descrip",
 123   { data_type => "text", is_nullable => 1 },
 124   "specie_tax",
 125   { data_type => "varchar", is_nullable => 1, size => 80 },
 126   "genus_tax",
 127   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 128   "subfamily_tax",
 129   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 130   "family_tax",
 131   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 132   "order_tax",
 133   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 134   "chr_n_gnmc",
 135   { data_type => "integer", is_nullable => 1 },
 136   "polypl_gnmc",
 137   { data_type => "varchar", is_nullable => 1, size => 50 },
 138   "genom_size_gnmc",
 139   { data_type => "varchar", is_nullable => 1, size => 50 },
 140   "genom_proj_gnmc",
 141   { data_type => "text", is_nullable => 1 },
 142   "est_attribution_tqmc",
 143   { data_type => "text", is_nullable => 1 },
 144   "chado_organism_id",
 145   { data_type => "integer", is_nullable => 1 },
 146 );
 147 __PACKAGE__->set_primary_key("organism_id");
 148 __PACKAGE__->add_unique_constraint("unique_organism_name", ["organism_name"]);
 149
 150 =head1 RELATIONS
 151
 152 =head2 accessions
 153
 154 Type: has_many
 155
 156 Related object: L<SGN::Schema::Accession>
 157
 158 =cut
 159
 160 __PACKAGE__->has_many(
 161   "accessions",
 162   "SGN::Schema::Accession",
 163   { "foreign.organism_id" => "self.organism_id" },
 164   { cascade_copy => 0, cascade_delete => 0 },
 165 );
 166
 167 =head2 deprecated_map_crosses
 168
 169 Type: has_many
 170
 171 Related object: L<SGN::Schema::DeprecatedMapCross>
 172
 173 =cut
 174
 175 __PACKAGE__->has_many(
 176   "deprecated_map_crosses",
 177   "SGN::Schema::DeprecatedMapCross",
 178   { "foreign.organism_id" => "self.organism_id" },
 179   { cascade_copy => 0, cascade_delete => 0 },
 180 );
 181
 182 =head2 order_tax
 183
 184 Type: belongs_to
 185
 186 Related object: L<SGN::Schema::Taxonomy>
 187
 188 =cut
 189
 190 __PACKAGE__->belongs_to(
 191   "order_tax",
 192   "SGN::Schema::Taxonomy",
 193   { tax_id => "order_tax" },
 194   {
 195     is_deferrable => 1,
 196     join_type     => "LEFT",
 197     on_delete     => "CASCADE",
 198     on_update     => "CASCADE",
 199   },
 200 );
 201
 202 =head2 family_tax
 203
 204 Type: belongs_to
 205
 206 Related object: L<SGN::Schema::Taxonomy>
 207
 208 =cut
 209
 210 __PACKAGE__->belongs_to(
 211   "family_tax",
 212   "SGN::Schema::Taxonomy",
 213   { tax_id => "family_tax" },
 214   {
 215     is_deferrable => 1,
 216     join_type     => "LEFT",
 217     on_delete     => "CASCADE",
 218     on_update     => "CASCADE",
 219   },
 220 );
 221
 222 =head2 genus_tax
 223
 224 Type: belongs_to
 225
 226 Related object: L<SGN::Schema::Taxonomy>
 227
 228 =cut
 229
 230 __PACKAGE__->belongs_to(
 231   "genus_tax",
 232   "SGN::Schema::Taxonomy",
 233   { tax_id => "genus_tax" },
 234   {
 235     is_deferrable => 1,
 236     join_type     => "LEFT",
 237     on_delete     => "CASCADE",
 238     on_update     => "CASCADE",
 239   },
 240 );
 241
 242 =head2 subfamily_tax
 243
 244 Type: belongs_to
 245
 246 Related object: L<SGN::Schema::Taxonomy>
 247
 248 =cut
 249
 250 __PACKAGE__->belongs_to(
 251   "subfamily_tax",
 252   "SGN::Schema::Taxonomy",
 253   { tax_id => "subfamily_tax" },
 254   {
 255     is_deferrable => 1,
 256     join_type     => "LEFT",
 257     on_delete     => "CASCADE",
 258     on_update     => "CASCADE",
 259   },
 260 );
 261
 262 =head2 common_name
 263
 264 Type: belongs_to
 265
 266 Related object: L<SGN::Schema::CommonName>
 267
 268 =cut
 269
 270 __PACKAGE__->belongs_to(
 271   "common_name",
 272   "SGN::Schema::CommonName",
 273   { common_name_id => "common_name_id" },
 274   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 275 );
 276
 277
 278 # Created by DBIx::Class::Schema::Loader v0.07002 @ 2012-03-03 12:35:39
 279 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:P659Eo8bylRSynQff1O2mg
 280
 281
 282 # You can replace this text with custom content, and it will be preserved on regeneration
 283 1;