data

7972693 rows


Description

The primary data table in the database. Each occurrence of a Variable in a sample comprises a record in the Data table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dataid serial 10 nextval('ndb.seq_data_dataid'::regclass)
datataxonnotes.dataid fk_datataxonnotes_dataC
isometadata.dataid fk_isometadata_dataC
isosamplepretreatments.dataid fk_isosamplepretreatments_dataC
isospecimendata.dataid fk_isospecimendata_dataC
isostratdata.dataid fk_isostratdata_dataC
specimens.dataid fk_specimens_dataC
summarydatataphonomy.dataid fk_summarydatataphonomy_dataC
sampleid int4 10 null
samples.sampleid fk_data_samplesC
variableid int4 10 null
variables.variableid fk_data_variablesC
value float8 17,17 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
data_pkey Primary key Asc dataid
data_sample_idx Performance Asc sampleid

Relationships