Database Properties
Database Type: PostgreSQL - 13.8 (Debian 13.8-1.pgdg110+1)
Catalog postgres
default administrative connection database
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| seedlot_genetic_worth | 0 | 1 | 9 | 0 | Table | A subclassification of Genetic Quality for “A” class Seedlots. |
| genetic_class_list | 3 | 0 | 5 | 0 | Table | A list of valid Genetic Class Codes that indicate if a lot is collected from Parent Trees in an Orchard or from a natural stand. |
| etl_execution_log_hist | 0 | 1 | 18 | 0 | Table | ETL Tool monitoring table to store all executed instances of batch processing interfaces |
| seedlot_parent_tree | 4 | 1 | 13 | 0 | Table | The contribution of Parent Trees (with their cone and pollen quantity of each Parent Tree) to an Orchard Seedlot (Genetic Class = “A”) |
| seedlot_orchard | 0 | 1 | 8 | 0 | Table | Orchard location where cuttings or A class seed is produced. |
| seedlot_parent_tree_gen_qlty | 0 | 2 | 12 | 0 | Table | The Genetic Worth value(s) for an Orchard Seedlot (Genetic Class = “A”) calculated from the Genetic Quality (Breeding Values) of the Parent Trees contributing to the Seedlot. |
| seedlot_owner_quantity | 0 | 2 | 13 | 0 | Table | A Seedlot may be owned by more than one owner. Each owner owns a specific quantity of seed which may be reserved for the use of that owner and/or surplus and available for use by others. |
| seedlot_smp_mix | 0 | 1 | 8 | 0 | Table | |
| cone_collection_method_list | 1 | 0 | 5 | 0 | Table | A list of valid Cone based Collection Method Codes. |
| method_of_payment_list | 1 | 0 | 6 | 0 | Table | A list of valid Method of Payment Codes. |
| user_profile | 1 | 0 | 2 | 0 | Table | |
| active_orchard_spu | 0 | 0 | 5 | 260 | Table | It is used to control which orchard can be used in the Seedlot registration process and also to indicate which legacy seed plan unit id should to be used. |
| genetic_worth_list | 0 | 0 | 5 | 0 | Table | A list of valid codes that describe the genetic trait(s) of Parent Trees, Seedlots and Vegetative Lots. |
| gametic_methodology_list | 2 | 0 | 7 | 0 | Table | A list of valid codes indicating the methods used in a seed Orchard to estimate the female or male component of gamete contributions to a Seedlot. |
| seedlot_collection_method | 0 | 2 | 8 | 0 | Table | The collection methods in which the cones of a Seedlot were collected. |
| seedlot_registration_a_class_save | 0 | 1 | 8 | 0 | Table | |
| etl_execution_schedule | 0 | 0 | 6 | 0 | Table | ETL Tool schedule table to define what delta time should be used in the next execution |
| smp_mix_gen_qlty | 0 | 2 | 11 | 0 | Table | The calculated Genetic Worth value(s) for the Supplemental Mass Pollination mix that contributed to an Orchard Seedlot (Genetic Class = “A”) the Parent Trees contributing to a Seedlot. |
| seedlot_status_list | 2 | 0 | 5 | 0 | Table | A list of valid Seedlot based Status Codes. |
| seedlot_audit | 0 | 3 | 99 | 0 | Table | |
| favourite_activity | 2 | 1 | 6 | 0 | Table | |
| seedlot_parent_tree_smp_mix | 0 | 2 | 10 | 0 | Table | Supplemental Mass Polination for a given Seedlot, Parent Tree, Genetic Type and Genetic worth combination. |
| etl_execution_map | 0 | 1 | 17 | 0 | Table | ETL Tool monitoring table to store execution details of batch processing interfaces |
| smp_mix | 2 | 1 | 10 | 0 | Table | A table listing the individual Parent Trees that contributed to the Supplemental Mass Pollination mix of an Orchard Seedlot (Genetic Class = “A”). |
| seedlot | 9 | 5 | 95 | 0 | Table | A quantity of seed of a particular species and quality collected from either a natural stand or seed Orchard in a given time period. |
| seedlot_seed_plan_zone | 0 | 2 | 11 | 0 | Table | |
| seedlot_source_list | 2 | 0 | 6 | 3 | Table | A list of valid Lot Source Codes. |