batch_details_history

-1 rows


Description

Record of changes of user-editable attributes of each nursery batch.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
batch_details_history_sub_locations.batch_details_history_id batch_details_history_sub_locatio_batch_details_history_id_fkey C
batch_id int8 19 null
batches.id batch_details_history_batch_id_fkey C
version int4 10 null
created_by int8 19 null
users.id batch_details_history_created_by_fkey R
created_time timestamptz 35,6 null
notes text 2147483647 √ null
ready_by_date date 13 √ null
project_id int8 19 √ null
projects.id batch_details_history_project_id_fkey N
project_name text 2147483647 √ null

Name of project as of the time the batch was edited. Not updated if project is later renamed.
substrate_id int4 10 √ null
batch_substrates.id batch_details_history_substrate_id_fkey R
substrate_notes text 2147483647 √ null
treatment_id int4 10 √ null
seed_treatments.id batch_details_history_treatment_id_fkey R
treatment_notes text 2147483647 √ null
germination_started_date date 13 √ null
seeds_sown_date date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
batch_details_history_pkey Primary key Asc id
batch_details_history_batch_id_version_key Must be unique Asc/Asc batch_id + version
batch_details_history_created_by_idx Performance Asc created_by
batch_details_history_project_id_idx Performance Asc project_id

Relationships

Close relationships within degrees of separation