Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| seedlot_number | varchar | 5 | null |
|
|
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 |
|
|
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. |
|||||
| entry_userid | varchar | 30 | null |
|
|
The userid of the individual that entered the Parent Tree SMP mix |
|||||
| entry_timestamp | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
The time and date a Parent Tree SMP mix was entered onto the system. |
|||||
| update_userid | varchar | 30 | null |
|
|
The userid of the individual that changed the Parent Tree SMP mix. |
|||||
| update_timestamp | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
The time and date a Parent Tree SMP mix 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_smp_mix_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
