batch_sample

400003 rows


Description

Linking table to record which samples were batched together for analysis. Informal groups created for published data where exact location and dates of analyses are not available.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
batch_id int4 10 null
analyte_determination.batch_id batch_sample_analyte_determination_fk R
batch.batch_id batch_batch_sample_fk R

PK/FK. ID for a batch. Links to the batch table. Part of composite primary key.
sample_id int4 10 null
analyte_determination.sample_id batch_sample_analyte_determination_fk R
sample.sample_id sample_batch_sample_fk R

PK/FK. ID for the sample. Links to the sample table. Part of composite primary key.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
batch_sample_id Primary key Asc/Asc batch_id + sample_id
batch_sample_batch_id_idx Performance Asc batch_id
batch_sample_sample_id_idx Performance Asc sample_id

Relationships

Close relationships within degrees of separation