aggregatesampleages

162 rows


Description

This table stores the links to the ages of samples in an Aggregate Dataset. The table is necessary because samples may be from Collection Units with multiple chronologies, and this table stores the links to the sample ages desired for the Aggregate Dataset.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
aggregatedatasetid int4 10 null
aggregatedatasets.aggregatedatasetid fk_aggregatesampleages_aggregatedatasetsC
aggregatechronid int4 10 null
aggregatechronologies.aggregatechronid fk_aggregatesampleages_aggregatechronologiesR
sampleageid int4 10 null
sampleages.sampleageid fk_aggregatesampleages_sampleagesC
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
aggregatesampleages_pkey Primary key Asc/Asc/Asc aggregatedatasetid + aggregatechronid + sampleageid

Relationships