8364360 rows


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


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

Sample identification number. Field links to Samples table.

variableid int4 10 null
variables.variableid fk_data_variablesC

Variable identification number. Field links to Variables table.

value float8 17,17 null

The value of the variable.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null


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