neotoma
.ndb
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
dsdatasample
0
rows
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
datasetid
int4
10
√
null
datasets
.datasetid
Implied Constraint
R
sampleid
int4
10
√
null
samples
.sampleid
Implied Constraint
R
dataid
int4
10
√
null
variableid
int4
10
√
null
variables
.variableid
Implied Constraint
R
Relationships
Close relationships within degrees of separation
One
One implied
Two implied
View Definition
SELECT ds.datasetid, sm.sampleid, dt.dataid, vr.variableid FROM (((ndb.datasets ds JOIN ndb.samples sm ON ((ds.datasetid = sm.datasetid))) JOIN ndb.data dt ON ((sm.sampleid = dt.sampleid))) JOIN ndb.variables vr ON ((dt.variableid = vr.variableid)));
Possibly Referenced Tables/Views