fix foreign key name in blast_db_blast_db_group table schema.
[cxgn-corelibs.git] / lib / SGN / Schema / RflpMarker.pm
blob917dba24fee21fc03d2a3207d57ce12ace2003a1
1 package SGN::Schema::RflpMarker;
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::RflpMarker
16 =cut
18 __PACKAGE__->table("rflp_markers");
20 =head1 ACCESSORS
22 =head2 rflp_id
24 data_type: 'integer'
25 is_auto_increment: 1
26 is_nullable: 0
27 sequence: 'rflp_markers_rflp_id_seq'
29 =head2 marker_id
31 data_type: 'bigint'
32 default_value: '0)::bigint'
33 is_foreign_key: 1
34 is_nullable: 0
36 =head2 rflp_name
38 data_type: 'varchar'
39 default_value: (empty string)
40 is_nullable: 0
41 size: 64
43 =head2 library_name
45 data_type: 'varchar'
46 is_nullable: 1
47 size: 64
49 =head2 clone_name
51 data_type: 'varchar'
52 is_nullable: 1
53 size: 16
55 =head2 vector
57 data_type: 'varchar'
58 is_nullable: 1
59 size: 32
61 =head2 cutting_site
63 data_type: 'varchar'
64 is_nullable: 1
65 size: 32
67 =head2 forward_seq_id
69 data_type: 'bigint'
70 is_foreign_key: 1
71 is_nullable: 1
73 =head2 reverse_seq_id
75 data_type: 'bigint'
76 is_foreign_key: 1
77 is_nullable: 1
79 =head2 insert_size
81 data_type: 'bigint'
82 default_value: '0)::bigint'
83 is_nullable: 0
85 =head2 drug_resistance
87 data_type: 'varchar'
88 is_nullable: 1
89 size: 16
91 =head2 marker_prefix
93 data_type: 'varchar'
94 is_nullable: 1
95 size: 8
97 =head2 marker_suffix
99 data_type: 'smallint'
100 is_nullable: 1
102 =cut
104 __PACKAGE__->add_columns(
105 "rflp_id",
107 data_type => "integer",
108 is_auto_increment => 1,
109 is_nullable => 0,
110 sequence => "rflp_markers_rflp_id_seq",
112 "marker_id",
114 data_type => "bigint",
115 default_value => "0)::bigint",
116 is_foreign_key => 1,
117 is_nullable => 0,
119 "rflp_name",
120 { data_type => "varchar", default_value => "", is_nullable => 0, size => 64 },
121 "library_name",
122 { data_type => "varchar", is_nullable => 1, size => 64 },
123 "clone_name",
124 { data_type => "varchar", is_nullable => 1, size => 16 },
125 "vector",
126 { data_type => "varchar", is_nullable => 1, size => 32 },
127 "cutting_site",
128 { data_type => "varchar", is_nullable => 1, size => 32 },
129 "forward_seq_id",
130 { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
131 "reverse_seq_id",
132 { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
133 "insert_size",
134 { data_type => "bigint", default_value => "0)::bigint", is_nullable => 0 },
135 "drug_resistance",
136 { data_type => "varchar", is_nullable => 1, size => 16 },
137 "marker_prefix",
138 { data_type => "varchar", is_nullable => 1, size => 8 },
139 "marker_suffix",
140 { data_type => "smallint", is_nullable => 1 },
142 __PACKAGE__->set_primary_key("rflp_id");
144 =head1 RELATIONS
146 =head2 marker_experiments
148 Type: has_many
150 Related object: L<SGN::Schema::MarkerExperiment>
152 =cut
154 __PACKAGE__->has_many(
155 "marker_experiments",
156 "SGN::Schema::MarkerExperiment",
157 { "foreign.rflp_experiment_id" => "self.rflp_id" },
158 { cascade_copy => 0, cascade_delete => 0 },
161 =head2 reverse_seq
163 Type: belongs_to
165 Related object: L<SGN::Schema::RflpSequence>
167 =cut
169 __PACKAGE__->belongs_to(
170 "reverse_seq",
171 "SGN::Schema::RflpSequence",
172 { seq_id => "reverse_seq_id" },
174 is_deferrable => 1,
175 join_type => "LEFT",
176 on_delete => "CASCADE",
177 on_update => "CASCADE",
181 =head2 marker
183 Type: belongs_to
185 Related object: L<SGN::Schema::Marker>
187 =cut
189 __PACKAGE__->belongs_to(
190 "marker",
191 "SGN::Schema::Marker",
192 { marker_id => "marker_id" },
193 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
196 =head2 forward_seq
198 Type: belongs_to
200 Related object: L<SGN::Schema::RflpSequence>
202 =cut
204 __PACKAGE__->belongs_to(
205 "forward_seq",
206 "SGN::Schema::RflpSequence",
207 { seq_id => "forward_seq_id" },
209 is_deferrable => 1,
210 join_type => "LEFT",
211 on_delete => "CASCADE",
212 on_update => "CASCADE",
217 # Created by DBIx::Class::Schema::Loader v0.07002 @ 2012-03-03 12:35:39
218 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wLUUV2wuSGLIcP3pr3Gbbw
221 # You can replace this text with custom content, and it will be preserved on regeneration