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. |
|||||
| genetic_worth_code | varchar | 3 | null |
|
|
A code which represents a subclassification of Genetic Quality for “A” class seedlots. |
|||||
| genetic_quality_value | numeric | 4,1 | null |
|
|
The rating for a subclassification of Genetic Quality for “A” class seedlots. |
|||||
| tested_parent_tree_cont_pct | numeric | 6,2 | √ | null |
|
|
Percentage of parent trees that were tested for the trait and contributed to the seedlot |
||||
| entry_userid | varchar | 30 | null |
|
|
The userid of the individual that entered the Seedlot Genetic Worth. |
|||||
| entry_timestamp | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
The time and date a Seedlot Genetic Worth was entered onto the system. |
|||||
| update_userid | varchar | 30 | null |
|
|
The userid of the individual that changed the Seedlot Genetic Worth. |
|||||
| update_timestamp | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
The time and date a Seedlot Genetic Worth 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_genetic_worth_pk | Primary key | Asc/Asc | seedlot_number + genetic_worth_code |
Relationships
Close relationships within degrees of separation
