| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| library_id |
serial |
10 |
|
√ |
nextval('library_library_id_seq'::regclass) |
| clone.library_id
|
library_id_fk |
|
|
| type |
int8 |
19 |
√ |
|
null |
|
|
| submit_user_id |
int4 |
10 |
√ |
|
null |
|
|
| library_name |
varchar |
80 |
√ |
|
null |
|
|
| library_shortname |
varchar |
16 |
√ |
|
null |
|
|
| authors |
varchar |
255 |
√ |
|
null |
|
|
| organism_id |
int4 |
10 |
√ |
|
null |
|
|
| cultivar |
varchar |
255 |
√ |
|
null |
|
|
| accession |
varchar |
255 |
√ |
|
null |
|
|
| tissue |
varchar |
255 |
√ |
|
null |
|
|
| development_stage |
varchar |
255 |
√ |
|
null |
|
|
| treatment_conditions |
text |
2147483647 |
√ |
|
null |
|
|
| cloning_host |
varchar |
80 |
√ |
|
null |
|
|
| vector |
varchar |
80 |
√ |
|
null |
|
|
| rs1 |
varchar |
12 |
√ |
|
null |
|
|
| rs2 |
varchar |
12 |
√ |
|
null |
|
|
| cloning_kit |
varchar |
255 |
√ |
|
null |
|
|
| comments |
text |
2147483647 |
√ |
|
null |
|
|
| contact_information |
text |
2147483647 |
√ |
|
null |
|
|
| order_routing_id |
int8 |
19 |
√ |
|
null |
|
|
| sp_person_id |
int4 |
10 |
√ |
|
null |
|
|
| forward_adapter |
varchar |
2147483647 |
√ |
|
null |
|
|
| reverse_adapter |
varchar |
2147483647 |
√ |
|
null |
|
|
| obsolete |
bool |
1 |
√ |
|
null |
|
|
| modified_date |
timestamptz |
35,6 |
√ |
|
null |
|
|
| create_date |
timestamptz |
35,6 |
√ |
|
null |
|
|
Table contained 203 rows at Wed May 20 01:50 EDT 2009
|
