lib/SGN/Schema/Organism.pm

   1 package SGN::Schema::Organism;
   2
   3 use strict;
   4 use warnings;
   5
   6 use base 'DBIx::Class';
   7
   8 __PACKAGE__->load_components("Core");
   9 __PACKAGE__->table("organism");
  10 __PACKAGE__->add_columns(
  11   "organism_id",
  12   {
  13     data_type => "integer",
  14     default_value => "nextval('organism_organism_id_seq'::regclass)",
  15     is_auto_increment => 1,
  16     is_nullable => 0,
  17     size => 4,
  18   },
  19   "organism_name",
  20   {
  21     data_type => "character varying",
  22     default_value => undef,
  23     is_nullable => 1,
  24     size => 80,
  25   },
  26   "common_name_id",
  27   {
  28     data_type => "bigint",
  29     default_value => undef,
  30     is_foreign_key => 1,
  31     is_nullable => 0,
  32     size => 8,
  33   },
  34   "organism_descrip",
  35   {
  36     data_type => "text",
  37     default_value => undef,
  38     is_nullable => 1,
  39     size => undef,
  40   },
  41   "specie_tax",
  42   {
  43     data_type => "character varying",
  44     default_value => undef,
  45     is_nullable => 1,
  46     size => 80,
  47   },
  48   "genus_tax",
  49   {
  50     data_type => "integer",
  51     default_value => undef,
  52     is_foreign_key => 1,
  53     is_nullable => 1,
  54     size => 4,
  55   },
  56   "subfamily_tax",
  57   {
  58     data_type => "integer",
  59     default_value => undef,
  60     is_foreign_key => 1,
  61     is_nullable => 1,
  62     size => 4,
  63   },
  64   "family_tax",
  65   {
  66     data_type => "integer",
  67     default_value => undef,
  68     is_foreign_key => 1,
  69     is_nullable => 1,
  70     size => 4,
  71   },
  72   "order_tax",
  73   {
  74     data_type => "integer",
  75     default_value => undef,
  76     is_foreign_key => 1,
  77     is_nullable => 1,
  78     size => 4,
  79   },
  80   "chr_n_gnmc",
  81   { data_type => "integer", default_value => undef, is_nullable => 1, size => 4 },
  82   "polypl_gnmc",
  83   {
  84     data_type => "character varying",
  85     default_value => undef,
  86     is_nullable => 1,
  87     size => 50,
  88   },
  89   "genom_size_gnmc",
  90   {
  91     data_type => "character varying",
  92     default_value => undef,
  93     is_nullable => 1,
  94     size => 50,
  95   },
  96   "genom_proj_gnmc",
  97   {
  98     data_type => "text",
  99     default_value => undef,
 100     is_nullable => 1,
 101     size => undef,
 102   },
 103   "est_attribution_tqmc",
 104   {
 105     data_type => "text",
 106     default_value => undef,
 107     is_nullable => 1,
 108     size => undef,
 109   },
 110 );
 111 __PACKAGE__->set_primary_key("organism_id");
 112 __PACKAGE__->add_unique_constraint("unique_organism_name", ["organism_name"]);
 113 __PACKAGE__->has_many(
 114   "accessions",
 115   "SGN::Schema::Accession",
 116   { "foreign.organism_id" => "self.organism_id" },
 117 );
 118 __PACKAGE__->has_many(
 119   "deprecated_map_crosses",
 120   "SGN::Schema::DeprecatedMapCross",
 121   { "foreign.organism_id" => "self.organism_id" },
 122 );
 123 __PACKAGE__->belongs_to(
 124   "order_tax",
 125   "SGN::Schema::Taxonomy",
 126   { tax_id => "order_tax" },
 127   { join_type => "LEFT" },
 128 );
 129 __PACKAGE__->belongs_to(
 130   "family_tax",
 131   "SGN::Schema::Taxonomy",
 132   { tax_id => "family_tax" },
 133   { join_type => "LEFT" },
 134 );
 135 __PACKAGE__->belongs_to(
 136   "genus_tax",
 137   "SGN::Schema::Taxonomy",
 138   { tax_id => "genus_tax" },
 139   { join_type => "LEFT" },
 140 );
 141 __PACKAGE__->belongs_to(
 142   "subfamily_tax",
 143   "SGN::Schema::Taxonomy",
 144   { tax_id => "subfamily_tax" },
 145   { join_type => "LEFT" },
 146 );
 147 __PACKAGE__->belongs_to(
 148   "common_name",
 149   "SGN::Schema::CommonName",
 150   { common_name_id => "common_name_id" },
 151 );
 152
 153
 154 # Created by DBIx::Class::Schema::Loader v0.04999_07 @ 2009-09-04 13:21:55
 155 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hIsxt1nQ/SSj6bkmAl7lzg
 156
 157
 158 # You can replace this text with custom content, and it will be preserved on regeneration
 159 1;