Table bety.public.yields |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | serial | 10 | χ | √ | nextval('yields_id_seq'::regclass) | ||
citation_id | int4 | 10 | √ | χ | null | citations.id | Citation in which data originally reported. |
site_id | int4 | 10 | √ | χ | null | Site at which crop was harvested. | |
specie_id | int4 | 10 | √ | χ | null | species.id | Species for which yield was measured. |
treatment_id | int4 | 10 | √ | χ | null | treatments.id | Experimental treatment identification. Required, can indicate observational study. |
cultivar_id | int4 | 10 | √ | χ | null | 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 | varchar | 255 | √ | χ | null | Name of reported statistic. | |
stat | numeric | 16,4 | √ | χ | null | Value of reported statistic. | |
mean | numeric | 16,4 | √ | χ | null | Mean yield reported. | |
n | int4 | 10 | √ | χ | null | Number of replicates used to estimate mean and statistical summary. | |
notes | text | 2147483647 | √ | χ | null | ||
created_at | timestamp | 29,6 | √ | χ | null | ||
updated_at | timestamp | 29,6 | √ | χ | null | ||
user_id | int4 | 10 | √ | χ | null | users.id | ID of user who entered data. |
checked | int4 | 10 | √ | χ | null | 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 | int4 | 10 | √ | χ | null | Level of access required to view data. | |
method_id | int4 | 10 | √ | χ | null | methods.id |
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 |