New SPAR tables explained

Support the user

1. favourite_activity
2. seedlot_registration_a_class_save
3. user_profile

Code Tables

1. cone_collection_method_code
2. gametic_methodology_list
3. genetic_class_code
4. genetic_worth_code
5. method_of_payment_code
6. seedlot_source_list
7. seedlot_status_list

New Orchard x SPU Relationship (one-to-one)

1. active_orchard_spu

Seedlot Tables

1. seedlot table

• Main table for a Seedlot
• Created when the users clicks "Create seedlot number"
• Updated when the user submit or modify the seedlot form.

2. seedlot_collection_method table

• Holds all collection methods selected by the user in the Seedlot registration form step 1 to a particular seedlot.
• I.e.: Aerial clipping/topping, Climbing, felled trees

3. seedlot_genetic_worth table

• Holds all Genetic Worth to a particular seedlot.
• This table stores calculated values for the seedlot, breeding values for each trait
• The calculation happens once the user submit the CSV with pollen and cone count and hits the "Calculate Genetic worth and Effective populations values" button.
• This table is populated when the user subbmit the form or modify it, not after the calculations.

4. seedlot_orchard (data from user)
5. seedlot_owner_quantity (data from user)
6. seedlot_parent_tree (data comes from user's CSV)
7. seedlot_parent_tree_gen_qlty (data from user, combined with data from Oracle)
8. seedlot_parent_tree_smp_mix (data from user, combined with data from Oracle)
9. seedlot_seed_plan_zone (data from calculations, after form submission)
10. seedlot_smp_mix (data from calculation - SPZ)
11. smp_mix (data from user)
12. smp_mix_gen_qlty (data comes from calculations - after user uploading CSV)