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. |
|||||
| orchard_id | varchar | 3 | null |
|
|
A unique identifier which is assigned to a location where cuttings or A class seed is produced. |
|||||
| entry_userid | varchar | 30 | null |
|
|
The userid of the individual that entered the Seedlot Orchard. |
|||||
| entry_timestamp | timestamp | 29,6 | null |
|
|
The time and date a Seedlot Orchard was entered onto the system. |
|||||
| update_userid | varchar | 30 | null |
|
|
The userid of the individual that changed the Seedlot Orchard. |
|||||
| update_timestamp | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
The time and date a Seedlot Orchard 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. |
|||||
| primary_ind | bool | 1 | false |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| seedlot_orchard_pkey | Primary key | Asc/Asc | seedlot_number + primary_ind |
| unique_seedlot_orchard_key | Must be unique | Asc/Asc | seedlot_number + orchard_id |
Relationships
Close relationships within degrees of separation
