seedlot_parent_tree_gen_qlty

0 rows


Description

The Genetic Worth value(s) for an Orchard Seedlot (Genetic Class = “A”) calculated from the Genetic Quality (Breeding Values) of the Parent Trees contributing to the Seedlot.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
seedlot_number varchar 5 null
seedlot_parent_tree.seedlot_number sl_ptree_genqly_sl_ptree_fk 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
seedlot_parent_tree.parent_tree_id sl_ptree_genqly_sl_ptree_fk 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

Indicates whether or not the test result was estimated. A Genetic Quality value of 2.0 is estimated for Untested Parent Trees (i.e. Parent Trees without an Area of Use) or for Tested Parent Trees (i.e. Parent Trees with an Area of Use) without a Genetic.
untested_ind bool 1 √ null

Indicates whether or not the test result was estimated for an untested Parent Tree.
entry_userid varchar 30 null

The userid of the individual that entered the Seedlot Parent Tree Genetic Quality.
entry_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The time and date a Seedlot Parent Tree Genetic Quality was entered onto the system.
update_userid varchar 30 null

The userid of the individual that changed the Seedlot Parent Tree Genetic Quality.
update_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The time and date a Seedlot Parent Tree 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)
seedlot_parent_tree_gen_qlt_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