aggregatesamples

234 rows


Description

This table stores the samples in Aggregate Datasets.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
aggregatedatasetid int4 10 null
aggregatedatasets.aggregatedatasetid fk_aggregatesamples_aggregatedatasetsC

An arbitrary Aggregate Dataset identification number. Field links to the AggregateDatasets table.

sampleid int4 10 null
samples.sampleid fk_aggregatesamples_samplesC

Sample ID number. Field links to the Samples table.

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

Indexes

Constraint Name Type Sort Column(s)
aggregatesamples_pkey Primary key Asc/Asc aggregatedatasetid + sampleid

Relationships