Merge pull request #42 from solgenomics/topic/duplicate_image_warning
[cxgn-corelibs.git] / lib / SGN / Schema / Library.pm
blob5cec04cc0f58c9034732fc884ed10d2563703964
1 package SGN::Schema::Library;
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::Library
16 =cut
18 __PACKAGE__->table("library");
20 =head1 ACCESSORS
22 =head2 library_id
24 data_type: 'integer'
25 is_auto_increment: 1
26 is_nullable: 0
27 sequence: 'library_library_id_seq'
29 =head2 type
31 data_type: 'bigint'
32 is_foreign_key: 1
33 is_nullable: 1
35 =head2 submit_user_id
37 data_type: 'integer'
38 is_nullable: 1
40 =head2 library_name
42 data_type: 'varchar'
43 is_nullable: 1
44 size: 80
46 =head2 library_shortname
48 data_type: 'varchar'
49 is_nullable: 1
50 size: 16
52 =head2 authors
54 data_type: 'varchar'
55 is_nullable: 1
56 size: 255
58 =head2 organism_id
60 data_type: 'integer'
61 is_nullable: 1
63 =head2 cultivar
65 data_type: 'varchar'
66 is_nullable: 1
67 size: 255
69 =head2 accession
71 data_type: 'varchar'
72 is_nullable: 1
73 size: 255
75 =head2 tissue
77 data_type: 'varchar'
78 is_nullable: 1
79 size: 255
81 =head2 development_stage
83 data_type: 'varchar'
84 is_nullable: 1
85 size: 255
87 =head2 treatment_conditions
89 data_type: 'text'
90 is_nullable: 1
92 =head2 cloning_host
94 data_type: 'varchar'
95 is_nullable: 1
96 size: 80
98 =head2 vector
100 data_type: 'varchar'
101 is_nullable: 1
102 size: 80
104 =head2 rs1
106 data_type: 'varchar'
107 is_nullable: 1
108 size: 12
110 =head2 rs2
112 data_type: 'varchar'
113 is_nullable: 1
114 size: 12
116 =head2 cloning_kit
118 data_type: 'varchar'
119 is_nullable: 1
120 size: 255
122 =head2 comments
124 data_type: 'text'
125 is_nullable: 1
127 =head2 contact_information
129 data_type: 'text'
130 is_nullable: 1
132 =head2 order_routing_id
134 data_type: 'bigint'
135 is_nullable: 1
137 =head2 sp_person_id
139 data_type: 'integer'
140 is_nullable: 1
142 =head2 forward_adapter
144 data_type: 'text'
145 is_nullable: 1
146 original: {data_type => "varchar"}
148 =head2 reverse_adapter
150 data_type: 'text'
151 is_nullable: 1
152 original: {data_type => "varchar"}
154 =head2 obsolete
156 data_type: 'boolean'
157 is_nullable: 1
159 =head2 modified_date
161 data_type: 'timestamp with time zone'
162 is_nullable: 1
164 =head2 create_date
166 data_type: 'timestamp with time zone'
167 is_nullable: 1
169 =head2 chado_organism_id
171 data_type: 'integer'
172 is_nullable: 1
174 =cut
176 __PACKAGE__->add_columns(
177 "library_id",
179 data_type => "integer",
180 is_auto_increment => 1,
181 is_nullable => 0,
182 sequence => "library_library_id_seq",
184 "type",
185 { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
186 "submit_user_id",
187 { data_type => "integer", is_nullable => 1 },
188 "library_name",
189 { data_type => "varchar", is_nullable => 1, size => 80 },
190 "library_shortname",
191 { data_type => "varchar", is_nullable => 1, size => 16 },
192 "authors",
193 { data_type => "varchar", is_nullable => 1, size => 255 },
194 "organism_id",
195 { data_type => "integer", is_nullable => 1 },
196 "cultivar",
197 { data_type => "varchar", is_nullable => 1, size => 255 },
198 "accession",
199 { data_type => "varchar", is_nullable => 1, size => 255 },
200 "tissue",
201 { data_type => "varchar", is_nullable => 1, size => 255 },
202 "development_stage",
203 { data_type => "varchar", is_nullable => 1, size => 255 },
204 "treatment_conditions",
205 { data_type => "text", is_nullable => 1 },
206 "cloning_host",
207 { data_type => "varchar", is_nullable => 1, size => 80 },
208 "vector",
209 { data_type => "varchar", is_nullable => 1, size => 80 },
210 "rs1",
211 { data_type => "varchar", is_nullable => 1, size => 12 },
212 "rs2",
213 { data_type => "varchar", is_nullable => 1, size => 12 },
214 "cloning_kit",
215 { data_type => "varchar", is_nullable => 1, size => 255 },
216 "comments",
217 { data_type => "text", is_nullable => 1 },
218 "contact_information",
219 { data_type => "text", is_nullable => 1 },
220 "order_routing_id",
221 { data_type => "bigint", is_nullable => 1 },
222 "sp_person_id",
223 { data_type => "integer", is_nullable => 1 },
224 "forward_adapter",
226 data_type => "text",
227 is_nullable => 1,
228 original => { data_type => "varchar" },
230 "reverse_adapter",
232 data_type => "text",
233 is_nullable => 1,
234 original => { data_type => "varchar" },
236 "obsolete",
237 { data_type => "boolean", is_nullable => 1 },
238 "modified_date",
239 { data_type => "timestamp with time zone", is_nullable => 1 },
240 "create_date",
241 { data_type => "timestamp with time zone", is_nullable => 1 },
242 "chado_organism_id",
243 { data_type => "integer", is_nullable => 1 },
245 __PACKAGE__->set_primary_key("library_id");
246 __PACKAGE__->add_unique_constraint("library_shortname_idx", ["library_shortname"]);
248 =head1 RELATIONS
250 =head2 clones
252 Type: has_many
254 Related object: L<SGN::Schema::Clone>
256 =cut
258 __PACKAGE__->has_many(
259 "clones",
260 "SGN::Schema::Clone",
261 { "foreign.library_id" => "self.library_id" },
262 { cascade_copy => 0, cascade_delete => 0 },
265 =head2 type
267 Type: belongs_to
269 Related object: L<SGN::Schema::Type>
271 =cut
273 __PACKAGE__->belongs_to(
274 "type",
275 "SGN::Schema::Type",
276 { type_id => "type" },
278 is_deferrable => 1,
279 join_type => "LEFT",
280 on_delete => "CASCADE",
281 on_update => "CASCADE",
286 # Created by DBIx::Class::Schema::Loader v0.07002 @ 2012-03-03 12:35:39
287 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mEVMxr8tPb/rp+t5593leg
290 # You can replace this text with custom content, and it will be preserved on regeneration