83 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| otp_static_statictok_device_id_74b7c7d1_fk_otp_stati |
|
|
Restrict delete | ||
| frontend_contextlaye_layer_id_2358dd38_fk_frontend_ |
|
|
Restrict delete | ||
| organisation_representative_user_id_570902e8_fk_auth_user_id |
|
|
Restrict delete | ||
| organisation_represe_organisation_id_193faa53_fk_organisat |
|
|
Restrict delete | ||
| socialaccount_social_socialapp_id_97fb6e7d_fk_socialacc |
|
|
Restrict delete | ||
| socialaccount_social_site_id_2579dee5_fk_django_si |
|
|
Restrict delete | ||
| annual_population_survey_method_id_6c817095_fk_survey_method_id |
|
|
Restrict delete | ||
| annual_population_certainty_id_18dc75ae_fk_certainty_id |
|
|
Restrict delete | ||
| annual_population_count_method_id_5dd67fc8_fk_count_method_id |
|
|
Restrict delete | ||
| annual_population_population_status_id_f6d7284c_fk_populatio |
|
|
Restrict delete | ||
| annual_population_owned_species_id_78e80c72_fk_owned_species_id |
|
|
Restrict delete | ||
| annual_population_population_estimate__104aa225_fk_populatio |
|
|
Restrict delete | ||
| annual_population_sampling_effort_cove_3c7949d4_fk_sampling_ |
|
|
Restrict delete | ||
| annual_population_sampling_size_unit_i_51ec19f6_fk_sampling_ |
|
|
Restrict delete | ||
| annual_population_open_close_system_id_7f7d2cdb_fk_open_clos |
|
|
Restrict delete | ||
| taxon_taxon_rank_id_5c9c4c40_fk_taxon_rank_id |
|
|
Restrict delete | ||
| taxon_parent_id_4645e052_fk_taxon_id |
|
|
Restrict delete | ||
| frontend_uploadspeciescsv_property_id_73bb6ef4_fk_property_id |
|
|
Restrict delete | ||
| frontend_uploadspeciescsv_uploader_id_d318b0f0_fk_auth_user_id |
|
|
Restrict delete | ||
| frontend_draftspeciesupload_taxon_id_1a354749_fk_taxon_id |
|
|
Restrict delete | ||
| frontend_draftspeciesupload_property_id_0076ca92_fk_property_id |
|
|
Restrict delete | ||
| frontend_draftspecie_upload_by_id_1570b9a9_fk_auth_user |
|
|
Restrict delete | ||
| socialaccount_socialaccount_user_id_8146e70c_fk_auth_user_id |
|
|
Restrict delete | ||
| otp_totp_totpdevice_user_id_0fb18292_fk_auth_user_id |
|
|
Restrict delete | ||
| frontend_statisticalmodel_taxon_id_6b219d54_fk_taxon_id |
|
|
Restrict delete | ||
| property_province_id_70166351_fk_province_id |
|
|
Restrict delete | ||
| property_created_by_id_b7197b07_fk_auth_user_id |
|
|
Restrict delete | ||
| property_organisation_id_80655533_fk_organisation_id |
|
|
Restrict delete | ||
| property_property_type_id_137d71ff_fk_property_type_id |
|
|
Restrict delete | ||
| user_login_user_id_3438589a_fk_auth_user_id |
|
|
Restrict delete | ||
| user_login_login_status_id_fb64d3b5_fk_login_status_id |
|
|
Restrict delete | ||
| OrganisationInvites_organisation_id_b73b3468_fk_organisation_id |
|
|
Restrict delete | ||
| OrganisationInvites_user_role_id_21fb9ef3_fk_user_role_id |
|
|
Restrict delete | ||
| frontend_boundarysea_request_by_id_c26d7773_fk_auth_user |
|
|
Restrict delete | ||
| organisation_data_use_permission__df588176_fk_data_use_ |
|
|
Restrict delete | ||
| organisation_province_id_58368a67_fk_province_id |
|
|
Restrict delete | ||
| account_emailconfirm_email_address_id_5b7f8c58_fk_account_e |
|
|
Restrict delete | ||
| auth_user_groups_group_id_97559544_fk_auth_group_id |
|
|
Restrict delete | ||
| auth_user_groups_user_id_6a12ed8b_fk_auth_user_id |
|
|
Restrict delete | ||
| parcel_property_id_1ea05422_fk_property_id |
|
|
Restrict delete | ||
| parcel_parcel_type_id_f809fabb_fk_parcel_type_id |
|
|
Restrict delete | ||
| django_celery_beat_p_crontab_id_d3cba168_fk_django_ce |
|
|
Restrict delete | ||
| django_celery_beat_p_clocked_id_47a69f82_fk_django_ce |
|
|
Restrict delete | ||
| django_celery_beat_p_interval_id_a8ca27da_fk_django_ce |
|
|
Restrict delete | ||
| django_celery_beat_p_solar_id_a87ce72c_fk_django_ce |
|
|
Restrict delete | ||
| account_emailaddress_user_id_2c513194_fk_auth_user_id |
|
|
Restrict delete | ||
| frontend_boundaryfile_uploader_id_40d0d212_fk_auth_user_id |
|
|
Restrict delete | ||
| django_admin_log_content_type_id_c4bce8eb_fk_django_co |
|
|
Restrict delete | ||
| django_admin_log_user_id_c564eba6_fk_auth_user_id |
|
|
Restrict delete | ||
| species_taxonsurveymethod_taxon_id_11dc866f_fk_taxon_id |
|
|
Restrict delete | ||
| species_taxonsurveym_survey_method_id_68ea9597_fk_survey_me |
|
|
Restrict delete | ||
| otp_static_staticdevice_user_id_7f9cff2b_fk_auth_user_id |
|
|
Restrict delete | ||
| user_profile_user_role_type_id_f16426fe_fk_user_role_id |
|
|
Restrict delete | ||
| user_profile_title_id_f72c3222_fk_user_title_id |
|
|
Restrict delete | ||
| user_profile_user_id_8fdce8e2_fk_auth_user_id |
|
|
Restrict delete | ||
| user_profile_current_organisation_46e2d249_fk_organisat |
|
|
Restrict delete | ||
| frontend_statistical_model_id_ac2d094c_fk_frontend_ |
|
|
Restrict delete | ||
| frontend_spatialdata_context_layer_id_a0319e19_fk_frontend_ |
|
|
Restrict delete | ||
| frontend_spatialdatamodel_property_id_e7876a3a_fk_property_id |
|
|
Restrict delete | ||
| auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm |
|
|
Restrict delete | ||
| auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id |
|
|
Restrict delete | ||
| django_redirect_site_id_c3e37341_fk_django_site_id |
|
|
Restrict delete | ||
| socialaccount_social_app_id_636a42d7_fk_socialacc |
|
|
Restrict delete | ||
| socialaccount_social_account_id_951f210e_fk_socialacc |
|
|
Restrict delete | ||
| annual_population_pe_activity_type_id_aeeef484_fk_activity_ |
|
|
Restrict delete | ||
| annual_population_pe_owned_species_id_b65dcda8_fk_owned_spe |
|
|
Restrict delete | ||
| guardian_groupobject_permission_id_36572738_fk_auth_perm |
|
|
Restrict delete | ||
| guardian_groupobject_group_id_4bbbfb62_fk_auth_grou |
|
|
Restrict delete | ||
| guardian_groupobject_content_type_id_7ade36b8_fk_django_co |
|
|
Restrict delete | ||
| organisation_user_user_id_ff649da2_fk_auth_user_id |
|
|
Restrict delete | ||
| organisation_user_organisation_id_fc223d75_fk_organisation_id |
|
|
Restrict delete | ||
| guardian_userobjectp_permission_id_71807bfc_fk_auth_perm |
|
|
Restrict delete | ||
| guardian_userobjectpermission_user_id_d5c1e964_fk_auth_user_id |
|
|
Restrict delete | ||
| guardian_userobjectp_content_type_id_2e892405_fk_django_co |
|
|
Restrict delete | ||
| auth_group_permissions_group_id_b120cbf9_fk_auth_group_id |
|
|
Restrict delete | ||
| auth_group_permissio_permission_id_84c5c92e_fk_auth_perm |
|
|
Restrict delete | ||
| Reminders_user_id_c6839c25_fk_auth_user_id |
|
|
Restrict delete | ||
| Reminders_organisation_id_89663faf_fk_organisation_id |
|
|
Restrict delete | ||
| owned_species_taxon_id_7f71855b_fk_taxon_id |
|
|
Restrict delete | ||
| owned_species_user_id_48befe77_fk_auth_user_id |
|
|
Restrict delete | ||
| owned_species_property_id_0a341d83_fk_property_id |
|
|
Restrict delete | ||
| auth_permission_content_type_id_2f476e4b_fk_django_co |
|
|
Restrict delete | ||
| frontend_spatialdata_spatial_data_id_624c01c7_fk_frontend_ |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| annual_population | Adult male and adult female must not be greater than total | ((total >= (adult_male + adult_female))) |
| annual_population | annual_population_year_check | ((year >= 0)) |
| taxon | taxon_front_page_order_check | ((front_page_order >= 0)) |
| frontend_draftspeciesupload | frontend_draftspeciesupload_last_step_check | ((last_step >= 0)) |
| frontend_draftspeciesupload | frontend_draftspeciesupload_year_check | ((year >= 0)) |
| otp_totp_totpdevice | otp_totp_totpdevice_digits_check | ((digits >= 0)) |
| otp_totp_totpdevice | otp_totp_totpdevice_step_check | ((step >= 0)) |
| otp_totp_totpdevice | otp_totp_totpdevice_throttling_failure_count_check | ((throttling_failure_count >= 0)) |
| otp_totp_totpdevice | otp_totp_totpdevice_tolerance_check | ((tolerance >= 0)) |
| django_celery_beat_periodictask | django_celery_beat_periodictask_expire_seconds_check | ((expire_seconds >= 0)) |
| django_celery_beat_periodictask | django_celery_beat_periodictask_priority_check | ((priority >= 0)) |
| django_celery_beat_periodictask | django_celery_beat_periodictask_total_run_count_check | ((total_run_count >= 0)) |
| spatial_ref_sys | spatial_ref_sys_srid_check | (((srid > 0) AND (srid <= 998999))) |
| django_admin_log | django_admin_log_action_flag_check | ((action_flag >= 0)) |
| otp_static_staticdevice | otp_static_staticdevice_throttling_failure_count_check | ((throttling_failure_count >= 0)) |
| django_celery_results_chordcounter | django_celery_results_chordcounter_count_check | ((count >= 0)) |
| annual_population_per_activity | annual_population_per_activity_year_check | ((year >= 0)) |