Legend:
Primary key columns
Indexed columns
Column |
Type |
Size |
Nulls |
Auto |
Default |
References |
result_type |
text |
2147483647 |
√ |
χ |
null |
|
id |
int4 |
10 |
√ |
χ |
null |
|
citation_id |
int4 |
10 |
√ |
χ |
null |
|
site_id |
int4 |
10 |
√ |
χ |
null |
|
treatment_id |
int4 |
10 |
√ |
χ |
null |
|
sitename |
varchar |
255 |
√ |
χ |
null |
|
city |
varchar |
255 |
√ |
χ |
null |
|
lat |
numeric |
9,6 |
√ |
χ |
null |
|
lon |
numeric |
9,6 |
√ |
χ |
null |
|
scientificname |
varchar |
255 |
√ |
χ |
null |
|
commonname |
varchar |
255 |
√ |
χ |
null |
|
genus |
varchar |
255 |
√ |
χ |
null |
|
species_id |
int4 |
10 |
√ |
χ |
null |
|
author |
varchar |
255 |
√ |
χ |
null |
|
citation_year |
int4 |
10 |
√ |
χ |
null |
|
treatment |
varchar |
255 |
√ |
χ |
null |
|
date |
timestamp |
29,6 |
√ |
χ |
null |
|
month |
float8 |
17,17 |
√ |
χ |
null |
|
year |
float8 |
17,17 |
√ |
χ |
null |
|
dateloc |
numeric |
4,2 |
√ |
χ |
null |
|
trait |
varchar |
255 |
√ |
χ |
null |
|
trait_description |
varchar |
255 |
√ |
χ |
null |
|
mean |
numeric |
16,4 |
√ |
χ |
null |
|
units |
varchar |
255 |
√ |
χ |
null |
|
n |
int4 |
10 |
√ |
χ |
null |
|
statname |
varchar |
255 |
√ |
χ |
null |
|
stat |
numeric |
16,4 |
√ |
χ |
null |
|
notes |
text |
2147483647 |
√ |
χ |
null |
|
access_level |
int4 |
10 |
√ |
χ |
null |
|