279 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||
|---|---|---|---|---|---|---|---|
| soil_amendment_task_method_id_foreign |
|
|
Restrict delete | ||||
| fertilizerlog_activity_id_foreign |
|
|
Cascade on delete | ||||
| default_animal_breed_default_type_id_foreign |
|
|
Restrict delete | ||||
| nomination_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| nomination_nomination_type_foreign |
|
|
Restrict delete | ||||
| nomination_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| nomination_farm_id_foreign |
|
|
Restrict delete | ||||
| water_valve_location_id_foreign |
|
|
Cascade on delete | ||||
| custom_animal_type_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| custom_animal_type_farm_id_foreign |
|
|
Restrict delete | ||||
| custom_animal_type_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| farmexpensetype_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| farmexpensetype_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| farmexpensetype_farm_id_foreign |
|
|
Cascade on delete | ||||
| farm_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| farm_country_id_foreign |
|
|
Restrict delete | ||||
| farm_default_initial_location_id_foreign |
|
|
Restrict delete | ||||
| farm_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| management_plan_management_plan_group_id_foreign |
|
|
Restrict delete | ||||
| management_plan_crop_variety_id_foreign |
|
|
Restrict delete | ||||
| management_plan_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| management_plan_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| nomination_type_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| nomination_type_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| tasktype_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| tasktype_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| tasktype_farm_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_sex_detail_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_sex_detail_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_sex_detail_sex_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_sex_detail_batch_id_foreign |
|
|
Restrict delete | ||||
| custom_location_location_id_foreign |
|
|
Restrict delete | ||||
| document_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| document_farm_id_foreign |
|
|
Cascade on delete | ||||
| document_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| broadcast_method_planting_management_plan_id_foreign |
|
|
Restrict delete | ||||
| cleaning_task_task_id_foreign |
|
|
Restrict delete | ||||
| cleaning_task_product_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_use_relationship_use_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_use_relationship_animal_batch_id_foreign |
|
|
Restrict delete | ||||
| soildatalog_activity_id_foreign |
|
|
Cascade on delete | ||||
| harvestlog_activity_id_foreign |
|
|
Cascade on delete | ||||
| farm_site_boundary_location_id_foreign |
|
|
Cascade on delete | ||||
| finance_report_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| finance_report_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| finance_report_farm_id_foreign |
|
|
Restrict delete | ||||
| planting_management_plan_location_id_foreign |
|
|
Restrict delete | ||||
| planting_management_plan_management_plan_id_foreign |
|
|
Restrict delete | ||||
| field_station_id_foreign |
|
|
Restrict delete | ||||
| field_field_id_foreign |
|
|
Restrict delete | ||||
| certifier_country_certifier_id_foreign |
|
|
Restrict delete | ||||
| certifier_country_country_id_foreign |
|
|
Restrict delete | ||||
| crop_management_plan_management_plan_id_foreign |
|
|
Restrict delete | ||||
| disease_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| disease_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| disease_farm_id_foreign |
|
|
Restrict delete | ||||
| users_status_foreign |
|
|
Restrict delete | ||||
| crop_variety_crop_id_foreign |
|
|
Restrict delete | ||||
| crop_variety_farm_id_foreign |
|
|
Restrict delete | ||||
| crop_variety_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| crop_variety_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| maintenance_task_task_id_foreign |
|
|
Restrict delete | ||||
| animal_movement_task_task_id_foreign |
|
|
Restrict delete | ||||
| location_farm_id_foreign |
|
|
Restrict delete | ||||
| location_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| location_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| irrigation_type_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| irrigation_type_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| rolepermissions_permission_id_foreign |
|
|
Cascade on delete | ||||
| rolepermissions_role_id_foreign |
|
|
Cascade on delete | ||||
| animal_use_relationship_use_id_foreign |
|
|
Restrict delete | ||||
| animal_use_relationship_animal_id_foreign |
|
|
Restrict delete | ||||
| buffer_zone_location_id_foreign |
|
|
Cascade on delete | ||||
| revenue_type_farm_id_foreign |
|
|
Restrict delete | ||||
| revenue_type_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| revenue_type_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| soil_sample_location_location_id_foreign |
|
|
Cascade on delete | ||||
| userfarm_role_id_foreign |
|
|
Restrict delete | ||||
| userfarm_farm_id_foreign |
|
|
Cascade on delete | ||||
| user_id |
|
|
Restrict delete | ||||
| waterbalance_field_id_foreign |
|
|
Cascade on delete | ||||
| waterbalance_crop_id_foreign |
|
|
Restrict delete | ||||
| management_plan_group_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| management_plan_group_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| residence_location_id_foreign |
|
|
Cascade on delete | ||||
| wash_and_pack_task_task_id_foreign |
|
|
Restrict delete | ||||
| crop_variety_sale_sale_id_foreign |
|
|
Restrict delete | ||||
| crop_variety_sale_crop_variety_id_foreign |
|
|
Restrict delete | ||||
| transport_task_task_id_foreign |
|
|
Restrict delete | ||||
| organic_history_location_id_foreign |
|
|
Restrict delete | ||||
| organic_history_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| organic_history_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| file_document_id_foreign |
|
|
Cascade on delete | ||||
| supportticket_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| supportticket_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| supportticket_farm_id_foreign |
|
|
Restrict delete | ||||
| animal_group_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| animal_group_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| animal_group_relationship_animal_group_id_foreign |
|
|
Restrict delete | ||||
| animal_group_relationship_animal_id_foreign |
|
|
Restrict delete | ||||
| ceremonial_area_location_id_foreign |
|
|
Cascade on delete | ||||
| fk_crop_sale_farm_id |
|
|
Restrict delete | ||||
| sale_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| sale_revenue_type_id_foreign |
|
|
Restrict delete | ||||
| sale_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| social_task_task_id_foreign |
|
|
Restrict delete | ||||
| weather_station_id_foreign |
|
|
Restrict delete | ||||
| transplant_task_prev_planting_management_plan_id_foreign |
|
|
Restrict delete | ||||
| transplant_task_task_id_foreign |
|
|
Restrict delete | ||||
| transplant_task_planting_management_plan_id_foreign |
|
|
Restrict delete | ||||
| yield_crop_id_foreign |
|
|
Restrict delete | ||||
| yield_farm_id_foreign |
|
|
Restrict delete | ||||
| animal_movement_task_purpose_relationship_purpose_id_foreign |
|
|
Restrict delete | ||||
| animal_movement_task_purpose_relationship_task_id_foreign |
|
|
Restrict delete | ||||
| nomination_workflow_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| nomination_workflow_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| nomination_workflow_type_group_foreign |
|
|
Restrict delete | ||||
| soil_sample_task_task_id_foreign |
|
|
Restrict delete | ||||
| farm_addon_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| farm_external_integration_partner_id_foreign |
|
|
Restrict delete | ||||
| farm_external_integration_farm_id_foreign |
|
|
Restrict delete | ||||
| farm_addon_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| notification_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| notification_farm_id_foreign |
|
|
Restrict delete | ||||
| notification_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| emailtoken_farm_id_foreign |
|
|
Cascade on delete | ||||
| emailtoken_user_id_foreign |
|
|
Cascade on delete | ||||
| harvestuse_harvest_use_type_id_foreign |
|
|
Cascade on delete | ||||
| harvestuse_activity_id_foreign |
|
|
Cascade on delete | ||||
| pin_location_id_foreign |
|
|
Cascade on delete | ||||
| soil_amendment_product_product_id_foreign |
|
|
Restrict delete | ||||
| soil_amendment_product_soil_amendment_fertiliser_type_id_foreig |
|
|
Restrict delete | ||||
| animal_batch_group_relationship_animal_batch_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_group_relationship_animal_group_id_foreign |
|
|
Restrict delete | ||||
| figure_location_id_foreign |
|
|
Restrict delete | ||||
| nomination_status_workflow_id_foreign |
|
|
Restrict delete | ||||
| nomination_status_nomination_id_foreign |
|
|
Restrict delete | ||||
| nomination_status_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| nomination_status_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| userlog_user_id_foreign |
|
|
Restrict delete | ||||
| userlog_farm_id_foreign |
|
|
Restrict delete | ||||
| shifttask_field_crop_id_foreign |
|
|
Cascade on delete | ||||
| shifttask_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| shifttask_field_id_foreign |
|
|
Restrict delete | ||||
| shifttask_task_id_foreign |
|
|
Restrict delete | ||||
| shifttask_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| shifttask_shift_id_foreign |
|
|
Restrict delete | ||||
| cropdisease_disease_id_foreign |
|
|
Restrict delete | ||||
| cropdisease_crop_id_foreign |
|
|
Restrict delete | ||||
| bed_method_planting_management_plan_id_foreign |
|
|
Restrict delete | ||||
| scoutinglog_activity_id_foreign |
|
|
Cascade on delete | ||||
| soil_amendment_task_products_purpose_relationship_purpose_id_fo |
|
|
Restrict delete | ||||
| soil_amendment_task_products_purpose_relationship_task_products |
|
|
Restrict delete | ||||
| crop_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| crop_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| crop_farm_id_foreign |
|
|
Restrict delete | ||||
| nomination_crop_crop_id_foreign |
|
|
Restrict delete | ||||
| nomination_crop_nomination_id_foreign |
|
|
Restrict delete | ||||
| area_figure_id_foreign |
|
|
Restrict delete | ||||
| nitrogenbalance_field_id_foreign |
|
|
Cascade on delete | ||||
| management_tasks_planting_management_plan_id_foreign |
|
|
Restrict delete | ||||
| activitycrops_activity_id_foreign |
|
|
Cascade on delete | ||||
| activityfields_field_id_foreign |
|
|
Restrict delete | ||||
| activityfields_activity_id_foreign |
|
|
Cascade on delete | ||||
| product_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| product_farm_id_foreign |
|
|
Restrict delete | ||||
| product_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| waterbalanceschedule_farm_id_foreign |
|
|
Restrict delete | ||||
| irrigation_task_irrigation_type_id_foreign |
|
|
Restrict delete | ||||
| irrigation_task_location_id_foreign |
|
|
Restrict delete | ||||
| irrigationlog_activity_id_foreign |
|
|
Cascade on delete | ||||
| natural_area_location_id_foreign |
|
|
Cascade on delete | ||||
| task_type_foreign |
|
|
Restrict delete | ||||
| activitylog_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| activitylog_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| user_id |
|
|
Restrict delete | ||||
| task_assignee_foreign |
|
|
Restrict delete | ||||
| nitrogenschedule_farm_id_foreign |
|
|
Restrict delete | ||||
| animal_identifier_type_id_foreign |
|
|
Restrict delete | ||||
| animal_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| animal_custom_type_id_foreign |
|
|
Restrict delete | ||||
| animal_farm_id_foreign |
|
|
Restrict delete | ||||
| animal_custom_breed_id_foreign |
|
|
Restrict delete | ||||
| animal_default_breed_id_foreign |
|
|
Restrict delete | ||||
| animal_location_id_foreign |
|
|
Restrict delete | ||||
| animal_animal_removal_reason_id_foreign |
|
|
Restrict delete | ||||
| animal_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| animal_origin_id_foreign |
|
|
Restrict delete | ||||
| animal_sex_id_foreign |
|
|
Restrict delete | ||||
| animal_default_type_id_foreign |
|
|
Restrict delete | ||||
| animal_identifier_color_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_custom_type_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_farm_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_default_type_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_animal_removal_reason_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_location_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_origin_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_default_breed_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_custom_breed_id_foreign |
|
|
Restrict delete | ||||
| animal_batch_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| farmdataschedule_farm_id_foreign |
|
|
Restrict delete | ||||
| user_id |
|
|
Restrict delete | ||||
| field_work_type_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| field_work_type_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| field_work_type_farm_id_foreign |
|
|
Restrict delete | ||||
| price_crop_id_foreign |
|
|
Restrict delete | ||||
| price_farm_id_foreign |
|
|
Restrict delete | ||||
| barn_location_id_foreign |
|
|
Cascade on delete | ||||
| location_defaults_irrigation_type_id_foreign |
|
|
Restrict delete | ||||
| location_defaults_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| location_defaults_location_id_foreign |
|
|
Restrict delete | ||||
| location_defaults_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| sale_task_task_id_foreign |
|
|
Restrict delete | ||||
| notification_user_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| notification_user_user_id_foreign |
|
|
Restrict delete | ||||
| notification_user_notification_id_foreign |
|
|
Restrict delete | ||||
| notification_user_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| password_user_id_foreign |
|
|
Restrict delete | ||||
| seedlog_activity_id_foreign |
|
|
Cascade on delete | ||||
| plant_task_planting_management_plan_id_foreign |
|
|
Restrict delete | ||||
| task_document_task_id_foreign |
|
|
Restrict delete | ||||
| task_document_document_id_foreign |
|
|
Restrict delete | ||||
| greenhouse_location_id_foreign |
|
|
Cascade on delete | ||||
| pestcontrollog_activity_id_foreign |
|
|
Cascade on delete | ||||
| pest_control_task_product_id_foreign |
|
|
Restrict delete | ||||
| creek_location_id_foreign |
|
|
Cascade on delete | ||||
| shift_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| shift_farm_id_user_id_foreign |
|
|
Restrict delete | ||||
| shift_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| farmexpense_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| farmexpense_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| farmexpense_farm_id_foreign |
|
|
Restrict delete | ||||
| farmexpense_expense_type_id_foreign |
|
|
Restrict delete | ||||
| fertilizer_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| fertilizer_farm_id_foreign |
|
|
Restrict delete | ||||
| fertilizer_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| garden_location_id_foreign |
|
|
Cascade on delete | ||||
| garden_station_id_foreign |
|
|
Restrict delete | ||||
| line_figure_id_foreign |
|
|
Restrict delete | ||||
| organiccertifiersurvey_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| organiccertifiersurvey_farm_id_foreign |
|
|
Restrict delete | ||||
| organiccertifiersurvey_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| organiccertifiersurvey_certification_id_foreign |
|
|
Restrict delete | ||||
| organiccertifiersurvey_farm_id_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| organiccertifiersurvey_certifier_id_foreign |
|
|
Restrict delete | ||||
| organiccertifiersurvey_farm_id_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| custom_animal_breed_farm_id_foreign |
|
|
Restrict delete | ||||
| custom_animal_breed_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| custom_animal_breed_custom_type_id_foreign |
|
|
Restrict delete | ||||
| custom_animal_breed_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| custom_animal_breed_default_type_id_foreign |
|
|
Restrict delete | ||||
| showedspotlight_user_id_foreign |
|
|
Restrict delete | ||||
| weatherhourly_station_id_foreign |
|
|
Restrict delete | ||||
| soil_amendment_task_products_product_id_foreign |
|
|
Restrict delete | ||||
| soil_amendment_task_products_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| soil_amendment_task_products_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| soil_amendment_task_products_task_id_foreign |
|
|
Restrict delete | ||||
| field_work_task_field_work_type_id_foreign |
|
|
Restrict delete | ||||
| field_work_task_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| fieldworklog_activity_id_foreign |
|
|
Cascade on delete | ||||
| field_work_task_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| gate_location_id_foreign |
|
|
Cascade on delete | ||||
| ground_water_location_id_foreign |
|
|
Cascade on delete | ||||
| task_animal_relationship_animal_id_foreign |
|
|
Restrict delete | ||||
| task_animal_relationship_task_id_foreign |
|
|
Restrict delete | ||||
| fence_location_id_foreign |
|
|
Cascade on delete | ||||
| pesticide_created_by_user_id_foreign |
|
|
Restrict delete | ||||
| pesticide_updated_by_user_id_foreign |
|
|
Restrict delete | ||||
| pesticide_farm_id_foreign |
|
|
Restrict delete | ||||
| row_method_planting_management_plan_id_foreign |
|
|
Restrict delete | ||||
| task_animal_batch_relationship_animal_batch_id_foreign |
|
|
Restrict delete | ||||
| task_animal_batch_relationship_task_id_foreign |
|
|
Restrict delete | ||||
| certifiers_certification_id_foreign |
|
|
Restrict delete | ||||
| point_figure_id_foreign |
|
|
Restrict delete | ||||
| animal_type_use_relationship_animal_use_id_foreign |
|
|
Restrict delete | ||||
| animal_type_use_relationship_default_type_id_foreign |
|
|
Restrict delete | ||||
| release_badge_user_id_foreign |
|
|
Restrict delete | ||||
| container_method_planting_management_plan_id_foreign |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|