neotoma
.ndb
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
dsageranges
0
rows
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
datasetid
int4
10
√
null
datasets
.datasetid
Implied Constraint
R
younger
float8
17,17
√
null
older
float8
17,17
√
null
agetypeid
int4
10
√
null
agetypes
.agetypeid
Implied Constraint
R
Relationships
Close relationships within degrees of separation
One
One implied
Two implied
View Definition
SELECT ageranges.datasetid, min(ageranges.younger) AS younger, max(ageranges.older) AS older, ageranges.agetypeid FROM ( SELECT ds.datasetid, CASE WHEN (ages.ageyounger IS NULL) THEN ages.age ELSE ages.ageyounger END AS younger, CASE WHEN (ages.ageolder IS NULL) THEN ages.age ELSE ages.ageolder END AS older, chrons.agetypeid FROM (((ndb.samples samples LEFT JOIN ndb.datasets ds ON ((samples.datasetid = ds.datasetid))) LEFT JOIN ndb.sampleages ages ON ((ages.sampleid = samples.sampleid))) LEFT JOIN ndb.chronologies chrons ON ((ages.chronologyid = chrons.chronologyid))) WHERE (chrons.isdefault = (1)::boolean)) ageranges GROUP BY ageranges.datasetid, ageranges.agetypeid;
Possibly Referenced Tables/Views
samples