batch

787 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)

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_fkR
batch_sample.batch_id batch_batch_sample_fkR
data_source_batch.batch_id batch_data_source_batch_fkR

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

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

Date of registration of the batch.
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

Indexes

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

Relationships

Close relationships within degrees of separation