BETYdb: /schemas

Legend: Primary key columns Indexed columns

Column	Type	Size	Nulls	Auto	Default
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

Energy Biosciences Institute BETYdb Biofuel Ecophysiological Traits and Yields Database