| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| speciescode |
varchar |
2 |
√ |
|
null |
|
|
| animalid |
varchar |
40 |
√ |
|
null |
|
|
| gender |
varchar |
20 |
√ |
|
null |
|
|
| identifyingfeatures |
varchar |
255 |
√ |
|
null |
|
|
| nickname |
varchar |
40 |
√ |
|
null |
|
|
| red |
int4 |
10 |
√ |
|
null |
|
|
| green |
int4 |
10 |
√ |
|
null |
|
|
| blue |
int4 |
10 |
√ |
|
null |
|
|
| speciesname |
varchar |
80 |
√ |
|
null |
|
|
| genus |
varchar |
80 |
√ |
|
null |
|
|
| species |
varchar |
80 |
√ |
|
null |
|
|
| taxongroup |
varchar |
80 |
√ |
|
null |
|
|
| workinggroup |
varchar |
80 |
√ |
|
null |
|
|
| abreviation |
varchar |
20 |
√ |
|
null |
|
|
| concatname |
text |
2147483647 |
√ |
|
null |
|
|
| toppid |
varchar |
20 |
√ |
|
null |
|
|
| projectid |
int4 |
10 |
√ |
|
null |
|
|
| name |
varchar |
80 |
√ |
|
null |
|
|
| casecomment |
text |
2147483647 |
√ |
|
null |
|
|
| ownerid |
int4 |
10 |
√ |
|
null |
|
|
| contactid |
int4 |
10 |
√ |
|
null |
|
|
| provisional |
bool |
1 |
√ |
|
null |
|
|
Analyzed at Wed Dec 27 13:25 PST 2017
|