Constraints

20 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
seedlot_genet_worth_seedlot_fk
seedlot_genetic_worth.seedlot_number
seedlot.seedlot_number
Restrict delete
seedlot_parent_tree_seedlot_fk
seedlot_parent_tree.seedlot_number
seedlot.seedlot_number
Restrict delete
seedlot_orchard_seedlot_fk
seedlot_orchard.seedlot_number
seedlot.seedlot_number
Restrict delete
sl_ptree_genqly_sl_ptree_fk
seedlot_parent_tree_gen_qlty.seedlot_number
seedlot_parent_tree_gen_qlty.parent_tree_id
seedlot_parent_tree.seedlot_number
seedlot_parent_tree.parent_tree_id
Restrict delete
seedlot_owner_qty_seedlot_fk
seedlot_owner_quantity.seedlot_number
seedlot.seedlot_number
Restrict delete
seedlot_own_qnt_meth_pay_cd_fk
seedlot_owner_quantity.method_of_payment_code
method_of_payment_list.method_of_payment_code
Restrict delete
seedlot_smp_mix_seedlot_fk
seedlot_smp_mix.seedlot_number
seedlot.seedlot_number
Restrict delete
seedlot_cone_col_met_code_fk
seedlot_collection_method.cone_collection_method_code
cone_collection_method_list.cone_collection_method_code
Restrict delete
seedlot_coll_met_seedlot_fk
seedlot_collection_method.seedlot_number
seedlot.seedlot_number
Restrict delete
registration_form_a_class_seedlot_fk
seedlot_registration_a_class_save.seedlot_number
seedlot.seedlot_number
Restrict delete
smp_mix_gen_qlty_smp_mix_pk
smp_mix_gen_qlty.seedlot_number
smp_mix_gen_qlty.parent_tree_id
smp_mix.seedlot_number
smp_mix.parent_tree_id
Restrict delete
sl_ptree_smp_mix_sl_ptree_fk
seedlot_parent_tree_smp_mix.seedlot_number
seedlot_parent_tree_smp_mix.parent_tree_id
seedlot_parent_tree.seedlot_number
seedlot_parent_tree.parent_tree_id
Restrict delete
smp_mix_seedlot_fk
smp_mix.seedlot_number
seedlot.seedlot_number
Restrict delete
seedlot_male_game_mthd_cd_fk
seedlot.male_gametic_mthd_code
gametic_methodology_list.gametic_methodology_code
Restrict delete
seedlot_seedlot_source_code_fk
seedlot.seedlot_source_code
seedlot_source_list.seedlot_source_code
Restrict delete
seedlot_genetic_class_code_fk
seedlot.genetic_class_code
genetic_class_list.genetic_class_code
Restrict delete
seedlot_female_game_mthd_cd_fk
seedlot.female_gametic_mthd_code
gametic_methodology_list.gametic_methodology_code
Restrict delete
seedlot_seedlot_status_code_fk
seedlot.seedlot_status_code
seedlot_status_list.seedlot_status_code
Restrict delete
fk_genetic_class_code
seedlot_seed_plan_zone.genetic_class_code
genetic_class_list.genetic_class_code
Restrict delete
seedlot_seedplan_zn_seedlot_fk
seedlot_seed_plan_zone.seedlot_number
seedlot.seedlot_number
Restrict delete

Check Constraints

Table Constraint Name Constraint