accession_quantity_history

0 rows


Description

Historical record of changes to remaining quantities of accessions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
accession_id int8 19 null
accessions.id accession_quantity_history_accession_id_fkeyC
history_type_id int4 10 null
accession_quantity_history_types.id accession_quantity_history_history_type_id_fkeyR
created_by int8 19 null
users.id accession_quantity_history_created_by_fkeyR
created_time timestamptz 35,6 null
remaining_quantity numeric 131089 null
remaining_units_id int4 10 null
seed_quantity_units.id accession_quantity_history_remaining_units_id_fkeyR
notes text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
accession_quantity_history_pkey Primary key Asc id
accession_quantity_history_accession_id_idx Performance Asc accession_id

Relationships

Close relationships within degrees of separation