seedlot_parent_tree

0 rows


Description

The contribution of Parent Trees (with their cone and pollen quantity of each Parent Tree) to an Orchard Seedlot (Genetic Class = “A”)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
seedlot_number varchar 5 null
seedlot_parent_tree_gen_qlty.seedlot_number sl_ptree_genqly_sl_ptree_fk R
seedlot_parent_tree_smp_mix.seedlot_number sl_ptree_smp_mix_sl_ptree_fk R
seedlot.seedlot_number seedlot_parent_tree_seedlot_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_gen_qlty.parent_tree_id sl_ptree_genqly_sl_ptree_fk R
seedlot_parent_tree_smp_mix.parent_tree_id sl_ptree_smp_mix_sl_ptree_fk R

A unique identifier for each Parent Tree.
parent_tree_number varchar 5 null

The original registration number given to a Parent Tree in conjunction with a Species Code.
cone_count numeric 20,10 null

The number of cones counted or estimated from each Parent Tree for a Seedlot.
pollen_count numeric 20,10 null

The amount of pollen counted or estimated for each Parent Tree in the Seedlot.
smp_success_pct int4 10 √ null

The estimated success (percent) of the supplemental mass pollination mix on the Parent Trees in the Orchard.
non_orchard_pollen_contam_pct int4 10 √ null

Non-orchard pollen contamination (%).
total_genetic_worth_contrib numeric 15,11 √ null

Total Parent (seed) genetic worth contribution to seedlot
entry_userid varchar 30 null

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

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

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

The time and date a Seedlot Parent Tree 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_pk Primary key Asc/Asc seedlot_number + parent_tree_id

Relationships

Close relationships within degrees of separation