1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
|
package Bio::Chado::Schema::Result::Mage::Elementresult;
BEGIN {
$Bio::Chado::Schema::Result::Mage::Elementresult::AUTHORITY = 'cpan:RBUELS';
}
{
$Bio::Chado::Schema::Result::Mage::Elementresult::VERSION = '0.20000';
}
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
use strict;
use warnings;
use base 'DBIx::Class::Core';
=head1 NAME
Bio::Chado::Schema::Result::Mage::Elementresult
=head1 DESCRIPTION
An element on an array produces a measurement when hybridized to a biomaterial (traceable through quantification_id). This is the base data from which tables that actually contain data inherit.
=cut
__PACKAGE__->table("elementresult");
=head1 ACCESSORS
=head2 elementresult_id
data_type: 'integer'
is_auto_increment: 1
is_nullable: 0
sequence: 'elementresult_elementresult_id_seq'
=head2 element_id
data_type: 'integer'
is_foreign_key: 1
is_nullable: 0
=head2 quantification_id
data_type: 'integer'
is_foreign_key: 1
is_nullable: 0
=head2 signal
data_type: 'double precision'
is_nullable: 0
=cut
__PACKAGE__->add_columns(
"elementresult_id",
{
data_type => "integer",
is_auto_increment => 1,
is_nullable => 0,
sequence => "elementresult_elementresult_id_seq",
},
"element_id",
{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
"quantification_id",
{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
"signal",
{ data_type => "double precision", is_nullable => 0 },
);
__PACKAGE__->set_primary_key("elementresult_id");
__PACKAGE__->add_unique_constraint("elementresult_c1", ["element_id", "quantification_id"]);
=head1 RELATIONS
=head2 element
Type: belongs_to
Related object: L<Bio::Chado::Schema::Result::Mage::Element>
=cut
__PACKAGE__->belongs_to(
"element",
"Bio::Chado::Schema::Result::Mage::Element",
{ element_id => "element_id" },
{
cascade_copy => 0,
cascade_delete => 0,
is_deferrable => 1,
on_delete => "CASCADE",
on_update => "CASCADE",
},
);
=head2 quantification
Type: belongs_to
Related object: L<Bio::Chado::Schema::Result::Mage::Quantification>
=cut
__PACKAGE__->belongs_to(
"quantification",
"Bio::Chado::Schema::Result::Mage::Quantification",
{ quantification_id => "quantification_id" },
{
cascade_copy => 0,
cascade_delete => 0,
is_deferrable => 1,
on_delete => "CASCADE",
on_update => "CASCADE",
},
);
=head2 elementresult_relationship_subjects
Type: has_many
Related object: L<Bio::Chado::Schema::Result::Mage::ElementresultRelationship>
=cut
__PACKAGE__->has_many(
"elementresult_relationship_subjects",
"Bio::Chado::Schema::Result::Mage::ElementresultRelationship",
{ "foreign.subject_id" => "self.elementresult_id" },
{ cascade_copy => 0, cascade_delete => 0 },
);
=head2 elementresult_relationship_objects
Type: has_many
Related object: L<Bio::Chado::Schema::Result::Mage::ElementresultRelationship>
=cut
__PACKAGE__->has_many(
"elementresult_relationship_objects",
"Bio::Chado::Schema::Result::Mage::ElementresultRelationship",
{ "foreign.object_id" => "self.elementresult_id" },
{ cascade_copy => 0, cascade_delete => 0 },
);
# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-03-16 23:09:58
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wi6GbvbN4ZZh1yF349Jgjw
# You can replace this text with custom content, and it will be preserved on regeneration
1;
|
