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