smp_mix_gen_qlty

0 rows


Description

The calculated Genetic Worth value(s) for the Supplemental Mass Pollination mix that contributed to an Orchard Seedlot (Genetic Class = “A”) the Parent Trees contributing to a Seedlot.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
seedlot_number varchar 5 null
smp_mix.seedlot_number smp_mix_gen_qlty_smp_mix_pk R

The unique number (key) assigned to a quantity of seed of a particular species and quality from a given location collected at a given time.
parent_tree_id int4 10 null
smp_mix.parent_tree_id smp_mix_gen_qlty_smp_mix_pk R

A unique identifier for each Parent Tree.
genetic_type_code varchar 2 null

Describes the comparative measure of genetic value for a specific genetic trait of a Parent Tree. Examples are BV (Breeding Value) and CV (Clonal Value).
genetic_worth_code varchar 3 null

A code describing various Genetic Worths.
genetic_quality_value numeric 4,1 null

The Genetic Quality value based on the test assessment for a Parent Tree from a test no. and series.
estimated_ind bool 1 √ null
entry_userid varchar 30 null

The userid of the individual that entered the SMP mix Genetic Quality.
entry_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The time and date a SMP mix Genetic Quality was entered onto the system.
update_userid varchar 30 null

The userid of the individual that changed the SMP mix Genetic Quality.
update_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The time and date a SMP mix Genetic Quality was last updated on the system.
revision_count int4 10 null

A counter used to ensure data integrity. This item should be incremented during each update.

Indexes

Constraint Name Type Sort Column(s)
smp_mix_gen_qlty_pk Primary key Asc/Asc/Asc/Asc seedlot_number + parent_tree_id + genetic_type_code + genetic_worth_code

Relationships

Close relationships within degrees of separation