Merge pull request #42 from solgenomics/topic/duplicate_image_warning
[cxgn-corelibs.git] / lib / SGN / Schema / FishResult.pm
blob07abdc4ea561eda6fcd97c443ecfb3fdad0c6f49
1 package SGN::Schema::FishResult;
3 # Created by DBIx::Class::Schema::Loader
4 # DO NOT MODIFY THE FIRST PART OF THIS FILE
6 use strict;
7 use warnings;
9 use base 'DBIx::Class::Core';
12 =head1 NAME
14 SGN::Schema::FishResult
16 =cut
18 __PACKAGE__->table("fish_result");
20 =head1 ACCESSORS
22 =head2 fish_result_id
24 data_type: 'bigint'
25 is_auto_increment: 1
26 is_nullable: 0
27 sequence: 'fish_result_fish_result_id_seq'
29 =head2 map_id
31 data_type: 'bigint'
32 is_foreign_key: 1
33 is_nullable: 0
35 =head2 fish_experimenter_id
37 data_type: 'integer'
38 is_foreign_key: 1
39 is_nullable: 0
41 =head2 experiment_name
43 data_type: 'varchar'
44 is_nullable: 0
45 size: 10
47 =head2 clone_id
49 data_type: 'bigint'
50 is_nullable: 0
52 =head2 chromo_num
54 data_type: 'smallint'
55 is_nullable: 0
57 =head2 chromo_arm
59 data_type: 'varchar'
60 is_nullable: 0
61 size: 1
63 =head2 percent_from_centromere
65 data_type: 'real'
66 is_nullable: 0
68 =head2 experiment_group
70 data_type: 'varchar'
71 is_nullable: 1
72 size: 12
74 =head2 attribution_id
76 data_type: 'bigint'
77 is_nullable: 1
79 =cut
81 __PACKAGE__->add_columns(
82 "fish_result_id",
84 data_type => "bigint",
85 is_auto_increment => 1,
86 is_nullable => 0,
87 sequence => "fish_result_fish_result_id_seq",
89 "map_id",
90 { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
91 "fish_experimenter_id",
92 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
93 "experiment_name",
94 { data_type => "varchar", is_nullable => 0, size => 10 },
95 "clone_id",
96 { data_type => "bigint", is_nullable => 0 },
97 "chromo_num",
98 { data_type => "smallint", is_nullable => 0 },
99 "chromo_arm",
100 { data_type => "varchar", is_nullable => 0, size => 1 },
101 "percent_from_centromere",
102 { data_type => "real", is_nullable => 0 },
103 "experiment_group",
104 { data_type => "varchar", is_nullable => 1, size => 12 },
105 "attribution_id",
106 { data_type => "bigint", is_nullable => 1 },
108 __PACKAGE__->set_primary_key("fish_result_id");
109 __PACKAGE__->add_unique_constraint(
110 "fish_result_fish_experimenter_clone_id_experiment_name",
111 ["fish_experimenter_id", "clone_id", "experiment_name"],
114 =head1 RELATIONS
116 =head2 fish_experimenter
118 Type: belongs_to
120 Related object: L<SGN::Schema::FishExperimenter>
122 =cut
124 __PACKAGE__->belongs_to(
125 "fish_experimenter",
126 "SGN::Schema::FishExperimenter",
127 { fish_experimenter_id => "fish_experimenter_id" },
128 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
131 =head2 map
133 Type: belongs_to
135 Related object: L<SGN::Schema::DeprecatedMap>
137 =cut
139 __PACKAGE__->belongs_to(
140 "map",
141 "SGN::Schema::DeprecatedMap",
142 { map_id => "map_id" },
143 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
146 =head2 fish_result_images
148 Type: has_many
150 Related object: L<SGN::Schema::FishResultImage>
152 =cut
154 __PACKAGE__->has_many(
155 "fish_result_images",
156 "SGN::Schema::FishResultImage",
157 { "foreign.fish_result_id" => "self.fish_result_id" },
158 { cascade_copy => 0, cascade_delete => 0 },
162 # Created by DBIx::Class::Schema::Loader v0.07002 @ 2012-03-03 12:35:39
163 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3Qs/Qm/jdBZo2BRoSH9EGg
166 # You can replace this text with custom content, and it will be preserved on regeneration