Skip to content

New SPAR tables explained

Ricardo Campos edited this page Jan 25, 2024 · 10 revisions

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

  1. active_orchard_spu

Seedlot tables

  1. seedlot_genetic_worth (data comes from oracle)
  2. seedlot_parent_tree (data comes from user's CSV, form step 5)
  3. seedlot_parent_tree_gen_qlty (data comes from oracle)
  4. seedlot_parent_tree_smp_mix (data comes from oracle)
  5. seedlot_smp_mix (data comes from calculation - SPZ)
  6. smp_mix (data comes from user input, form step 5)
  7. smp_mix_gen_qlty (data comes from calculations - after user uploading csv)
Clone this wiki locally