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. |
|||||
| seed_plan_zone_code | varchar | 3 | null |
|
|
A code describing various Seed Planning Zones. |
|||||
| entry_userid | varchar | 30 | null |
|
|
The userid of the individual that entered the Seedlot collection method. |
|||||
| entry_timestamp | timestamp | 29,6 | √ | CURRENT_TIMESTAMP |
|
|
The time and date a Seedlot collection method was entered onto the system. |
||||
| update_userid | varchar | 30 | null |
|
|
The userid of the individual that changed the Seedlot collection method. |
|||||
| update_timestamp | timestamp | 29,6 | √ | CURRENT_TIMESTAMP |
|
|
The time and date a Seedlot collection method 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. |
|||||
| seed_plan_zone_id | int2 | 5 | √ | null |
|
|
A unique identifier for a combination of Seed Plan Zone Code, Genetic Class and Vegetation Code |
||||
| genetic_class_code | varchar | 1 | √ | null |
|
|
A code describing various Genetic Classes. |
||||
| primary_ind | bool | 1 | √ | false |
|
|
|||||
| seed_plan_zone_description | varchar | 120 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| seedlot_seed_plan_zone_pk | Primary key | Asc/Asc | seedlot_number + seed_plan_zone_code |
Relationships
Close relationships within degrees of separation
