Energy Biosciences Institute

Legend: Primary key columns Indexed columns

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

Energy Biosciences Institute BETYdb Biofuel Ecophysiological Traits and Yields Database