Table: yields
Legend: Primary key columns Indexed columns
Column Type Size Nulls Auto Default References Comments
id bigserial 19  χ   √  nextval('yields_id_seq'::regclass)
citation_id int8 19  √   χ  null citations.id Citation in which data originally reported.
site_id int8 19  √   χ  null sites.id Site at which crop was harvested.
specie_id int8 19  √   χ  null species.id Species for which yield was measured.
treatment_id int8 19  √   χ  null treatments.id Experimental treatment identification. Required, can indicate observational study.
cultivar_id int8 19  √   χ  null cultivars.id Cultivar information, if any.
date date 13  √   χ  null Date on which crop was harvested.
dateloc numeric 4,2  √   χ  null Level of confidence in harvest date. See documentation.
statname statnames 2147483647  χ   χ  ''::text Name of reported statistic.
stat float8 17,17  √   χ  null Value of reported statistic.
mean float8 17,17  χ   χ  Mean yield reported.
n int4 10  √   χ  null Number of replicates used to estimate mean and statistical summary.
notes text 2147483647  χ   χ  ''::text
created_at timestamp 29,6  √   χ  utc_now()
updated_at timestamp 29,6  √   χ  utc_now()
user_id int8 19  √   χ  null users.id ID of user who entered data.
checked int4 10  χ   χ  0 accepts values [-1, 0, 1]. 0 is default, and means that data have not been checked. 1 indicates that the data have been checked and are correct, -1 indicates that data have been checked and found to be incorrect or suspicious, e.g. outside of the acceptab
access_level level_of_access 2147483647  χ   χ  Level of access required to view data.
method_id int8 19  √   χ  null methods.id
entity_id int8 19  √   χ  null entities.id
date_year int4 10  √   χ  null
date_month int4 10  √   χ  null
date_day int4 10  √   χ  null
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc yields_pkey
citation_id Performance Asc index_yields_on_citation_id
cultivar_id Performance Asc index_yields_on_cultivar_id
method_id Performance Asc index_yields_on_method_id
site_id Performance Asc index_yields_on_site_id
specie_id Performance Asc index_yields_on_specie_id
treatment_id Performance Asc index_yields_on_treatment_id
user_id Performance Asc index_yields_on_user_id