Constraints
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDE
1
TableUniqueness Constraints: Tuples contained by parens must be unique in tableAnother Uniqueness ConstraintAdditional Rules
2
citations (author, year, title)
3
citations_sites (citation_id, site_id)
4
citations_treatments (citation_id, treatment_id)
5
covariates (trait_id, variable_id)
6
cultivars (specie_id, name)
7
dbfiles(file_name, file_path, machine_id)
8
ensembles
9
formats (name)
10
inputs (site_id, start_date, end_date, format_id)
11
inputs_runs (input_id, run_id)
12
inputs_variables (input_id, variable_id)
13
likelihoods (run_id, variable_id, input_id)
14
machines (hostname)
15
managements (date, mgmttype)
16
managements_treatments
(treatment_id, management_id)
17
methods (name, citation_id)
18
mimetypes (type_string)
19
models (model_path)
20
pfts (name)
21
pfts_priors (pft_id, prior_id)
22
pfts_species (pft_id, specie_id)
23
posteriors
24
priors (citation_id, variable_id, phylogeny)(variable_id, phylogeny, notes)
25
runs (model_id, site_id, start_time, finish_time, parameter_list, ensemble_id)
26
siteseither (lat, lon, sitename) or if (lat, lon) are null, lookup (geom, sitename)
27
species (scientificname)
28
traits
(site_id, specie_id, citation_id, cultivar_id, treatment_id, date, time, variable_id, entity_id, method_id, date_year, date_month, date_day, time_hour, time_minute)
29
treatments(citation_id, site_id, name)there must be a control for each (citation_id, site_id) tuple
30
users (apikey), (email), (login), (salt)
31
variables (name)
32
workflows (site_id, model_id, params, advanced_edit, start_date, end_date)
33
yields (citation_id, site_id, specie_id, treatment_id, cultivar_id, method_id, entity_id, date_year, date_month, date_day)
34
35
36
37
38
39
40
41
42
43
Loading...
Main menu