lib/SGN/Schema/Accession.pm

   1 package SGN::Schema::Accession;
   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::Accession
  15
  16 =cut
  17
  18 __PACKAGE__->table("accession");
  19
  20 =head1 ACCESSORS
  21
  22 =head2 accession_id
  23
  24   data_type: 'integer'
  25   is_auto_increment: 1
  26   is_nullable: 0
  27   sequence: 'accession_accession_id_seq'
  28
  29 =head2 organism_id
  30
  31   data_type: 'bigint'
  32   is_foreign_key: 1
  33   is_nullable: 1
  34
  35 =head2 common_name
  36
  37   data_type: 'varchar'
  38   is_nullable: 1
  39   size: 80
  40
  41 =head2 accession_name_id
  42
  43   data_type: 'bigint'
  44   is_foreign_key: 1
  45   is_nullable: 1
  46
  47 =head2 chado_organism_id
  48
  49   data_type: 'integer'
  50   is_nullable: 1
  51
  52 =head2 stock_id
  53
  54   data_type: 'integer'
  55   is_nullable: 1
  56
  57 =cut
  58
  59 __PACKAGE__->add_columns(
  60   "accession_id",
  61   {
  62     data_type         => "integer",
  63     is_auto_increment => 1,
  64     is_nullable       => 0,
  65     sequence          => "accession_accession_id_seq",
  66   },
  67   "organism_id",
  68   { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
  69   "common_name",
  70   { data_type => "varchar", is_nullable => 1, size => 80 },
  71   "accession_name_id",
  72   { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
  73   "chado_organism_id",
  74   { data_type => "integer", is_nullable => 1 },
  75   "stock_id",
  76   { data_type => "integer", is_nullable => 1 },
  77 );
  78 __PACKAGE__->set_primary_key("accession_id");
  79 __PACKAGE__->add_unique_constraint("unique_accession_name", ["accession_name_id"]);
  80
  81 =head1 RELATIONS
  82
  83 =head2 organism
  84
  85 Type: belongs_to
  86
  87 Related object: L<SGN::Schema::Organism>
  88
  89 =cut
  90
  91 __PACKAGE__->belongs_to(
  92   "organism",
  93   "SGN::Schema::Organism",
  94   { organism_id => "organism_id" },
  95   {
  96     is_deferrable => 1,
  97     join_type     => "LEFT",
  98     on_delete     => "CASCADE",
  99     on_update     => "CASCADE",
 100   },
 101 );
 102
 103 =head2 accession_name
 104
 105 Type: belongs_to
 106
 107 Related object: L<SGN::Schema::AccessionName>
 108
 109 =cut
 110
 111 __PACKAGE__->belongs_to(
 112   "accession_name",
 113   "SGN::Schema::AccessionName",
 114   { accession_name_id => "accession_name_id" },
 115   {
 116     is_deferrable => 1,
 117     join_type     => "LEFT",
 118     on_delete     => "CASCADE",
 119     on_update     => "CASCADE",
 120   },
 121 );
 122
 123 =head2 accession_names
 124
 125 Type: has_many
 126
 127 Related object: L<SGN::Schema::AccessionName>
 128
 129 =cut
 130
 131 __PACKAGE__->has_many(
 132   "accession_names",
 133   "SGN::Schema::AccessionName",
 134   { "foreign.accession_id" => "self.accession_id" },
 135   { cascade_copy => 0, cascade_delete => 0 },
 136 );
 137
 138 =head2 map_ancestors
 139
 140 Type: has_many
 141
 142 Related object: L<SGN::Schema::Map>
 143
 144 =cut
 145
 146 __PACKAGE__->has_many(
 147   "map_ancestors",
 148   "SGN::Schema::Map",
 149   { "foreign.ancestor" => "self.accession_id" },
 150   { cascade_copy => 0, cascade_delete => 0 },
 151 );
 152
 153 =head2 map_parent_2s
 154
 155 Type: has_many
 156
 157 Related object: L<SGN::Schema::Map>
 158
 159 =cut
 160
 161 __PACKAGE__->has_many(
 162   "map_parent_2s",
 163   "SGN::Schema::Map",
 164   { "foreign.parent_2" => "self.accession_id" },
 165   { cascade_copy => 0, cascade_delete => 0 },
 166 );
 167
 168 =head2 map_parent_1s
 169
 170 Type: has_many
 171
 172 Related object: L<SGN::Schema::Map>
 173
 174 =cut
 175
 176 __PACKAGE__->has_many(
 177   "map_parent_1s",
 178   "SGN::Schema::Map",
 179   { "foreign.parent_1" => "self.accession_id" },
 180   { cascade_copy => 0, cascade_delete => 0 },
 181 );
 182
 183 =head2 pcr_exp_accessions
 184
 185 Type: has_many
 186
 187 Related object: L<SGN::Schema::PcrExpAccession>
 188
 189 =cut
 190
 191 __PACKAGE__->has_many(
 192   "pcr_exp_accessions",
 193   "SGN::Schema::PcrExpAccession",
 194   { "foreign.accession_id" => "self.accession_id" },
 195   { cascade_copy => 0, cascade_delete => 0 },
 196 );
 197
 198
 199 # Created by DBIx::Class::Schema::Loader v0.07002 @ 2012-03-03 12:32:42
 200 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:838fnA2hrzzcn5PKEGLZRA
 201
 202
 203 # You can replace this text with custom content, and it will be preserved on regeneration
 204 1;