| organism_id |
serial |
10 |
|
√ |
nextval('sgn.organism_organism_id_seq'::regclass) |
|
|
|
| organism_name |
varchar |
80 |
√ |
|
null |
|
|
|
| common_name_id |
int8 |
19 |
|
|
null |
|
|
|
| organism_descrip |
text |
2147483647 |
√ |
|
null |
|
|
|
| specie_tax |
varchar |
80 |
√ |
|
null |
|
|
|
| genus_tax |
int4 |
10 |
√ |
|
null |
|
| taxonomy.tax_id |
organism_genus_tax_fkey |
R |
|
|
| subfamily_tax |
int4 |
10 |
√ |
|
null |
|
| taxonomy.tax_id |
organism_subfamily_tax_fkey |
R |
|
|
| family_tax |
int4 |
10 |
√ |
|
null |
|
| taxonomy.tax_id |
organism_family_tax_fkey |
R |
|
|
| order_tax |
int4 |
10 |
√ |
|
null |
|
| taxonomy.tax_id |
organism_order_tax_fkey |
R |
|
|
| chr_n_gnmc |
int4 |
10 |
√ |
|
null |
|
|
|
