Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| orchard_id | varchar | 3 | null |
|
|
A unique identifier which is assigned to a location where cuttings or A class seed is produced. |
||
| seed_plan_unit_id | int4 | 10 | null |
|
|
A unique identifier which is assigned to a legacy Seed Planning Unit. It is used for historical porpuse and to link data to Oracle database. A -1 indicates that the orchard has no SPU associated with it. |
||
| active_ind | bool | 1 | null |
|
|
Indicates if the combined orchard and SPU are the ones to be used and are active. |
||
| retired_ind | bool | 1 | null |
|
|
Indicates retired orchards that should only be used to show legacy information. |
||
| no_spu_ind | bool | 1 | null |
|
|
Indicates a new orchard that has not a SPU assigned yet. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| active_orchard_spu_pk | Primary key | Asc/Asc | orchard_id + seed_plan_unit_id |
Relationships
Close relationships within degrees of separation
