batch

1788 rows


Description

A batch of samples analysed at the same laboratory at roughly the same time. One batch of samples may go through multiple analyses, and samples may be associated with mutiple batches (see batch_sample table). Informal batches 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 serial 10 √ nextval('batch_batch_id_seq'::regclass)
analysis.batch_id batch_analysis_fk R
batch_sample.batch_id batch_batch_sample_fk R
data_source_batch.batch_id batch_data_source_batch_fk R

PK. Unique ID for a batch. Generated by the database.
lab_id int4 10 √ null
institution.institution_id institution_batch_fk R

FK. ID for the laboratory where the analysis was undertaken. Links to the institution table.
lab_batch_id varchar 50 √ null

The batch number issued by an analytical laboratory to identify the batch of samples, this will almost certainly be unique for each laboratory but may not be globally unique.
end_date date 13 √ null

End date of the analysis
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
batch_notes varchar 4000 null

Brief description of the batch
start_date date 13 √ null

Start date of the analysis

Indexes

Constraint Name Type Sort Column(s)
batch_id Primary key Asc batch_id

Relationships

Close relationships within degrees of separation