Constraints

35 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
SeoQueryTextualContents_seo_free_query_id_fkey
SeoQueryTextualContents.seo_free_query_id
SeoFreeQueries.id
Restrict delete
SeoQueryTextualContents_textual_content_id_fkey
SeoQueryTextualContents.textual_content_id
SeoTextualContents.id
Restrict delete
SeoCustomSlugPageJobSubCategories_seo_custom_slug_page_id_fkey
SeoCustomSlugPageJobSubCategories.seo_custom_slug_page_id
SeoCustomSlugPages.id
Cascade on delete
SeoCustomSlugPageJobSubCategories_job_sub_category_id_fkey
SeoCustomSlugPageJobSubCategories.job_sub_category_id
HierarchicalJobCategories.id
Restrict delete
LanguageToCountryMaps_country_code_fkey
LanguageToCountryMaps.country_code
Countries.code
Restrict delete
SeoTextualContentFAQs_textual_content_id_fkey
SeoTextualContentFAQs.textual_content_id
SeoTextualContents.id
Restrict delete
SeoPageMetadatas_language_to_country_map_id_fkey
SeoPageMetadatas.language_to_country_map_id
LanguageToCountryMaps.id
Restrict delete
SeoCustomSlugPages_country_id_fkey
SeoCustomSlugPages.country_code
Countries.code
Restrict delete
SeoCustomSlugPageCities_city_id_fkey
SeoCustomSlugPageCities.city_id
Cities.id
Restrict delete
SeoCustomSlugPageCities_location_id_fkey
SeoCustomSlugPageCities.location_id
Locations.id
Null on delete
SeoCustomSlugPageCities_seo_custom_slug_page_id_fkey
SeoCustomSlugPageCities.seo_custom_slug_page_id
SeoCustomSlugPages.id
Cascade on delete
SeoCustomSlugPageJobCategorie_hierarchical_job_category_id_fkey
SeoCustomSlugPageJobCategories.hierarchical_job_category_id
HierarchicalJobCategories.id
Null on delete
SeoCustomSlugPageJobCategories_job_category_id_fkey
SeoCustomSlugPageJobCategories.job_category_id
JobCategories.id
Restrict delete
SeoCustomSlugPageJobCategories_seo_custom_slug_page_id_fkey
SeoCustomSlugPageJobCategories.seo_custom_slug_page_id
SeoCustomSlugPages.id
Cascade on delete
SeoJobCategoryTextualContents_job_category_id_fkey
SeoJobCategoryTextualContents.job_category_id
JobCategories.id
Restrict delete
SeoJobCategoryTextualContents_hierarchical_job_category_id_fkey
SeoJobCategoryTextualContents.hierarchical_job_category_id
HierarchicalJobCategories.id
Null on delete
SeoJobCategoryTextualContents_textual_content_id_fkey
SeoJobCategoryTextualContents.textual_content_id
SeoTextualContents.id
Restrict delete
SeoLocationTextualContents_city_id_fkey
SeoLocationTextualContents.city_id
Cities.id
Restrict delete
SeoLocationTextualContents_textual_content_id_fkey
SeoLocationTextualContents.textual_content_id
SeoTextualContents.id
Restrict delete
SeoLocationTextualContents_location_id_fkey
SeoLocationTextualContents.location_id
Locations.id
Null on delete
SeoCustomSlugPageTagMaps_tag_id_fkey
SeoCustomSlugPageTagMaps.tag_id
SeoCustomSlugPageTags.id
Cascade on delete
SeoCustomSlugPageTagMaps_seo_custom_slug_page_id_fkey
SeoCustomSlugPageTagMaps.seo_custom_slug_page_id
SeoCustomSlugPages.id
Cascade on delete
SeoQueryMetadatas_seo_free_query_id_fkey
SeoQueryMetadatas.seo_free_query_id
SeoFreeQueries.id
Restrict delete
SeoQueryMetadatas_seo_page_metadata_id_fkey
SeoQueryMetadatas.seo_page_metadata_id
SeoPageMetadatas.id
Restrict delete
SeoCustomSlugPageJobTitles_seo_custom_slug_page_id_fkey
SeoCustomSlugPageJobTitles.seo_custom_slug_page_id
SeoCustomSlugPages.id
Cascade on delete
SeoCustomSlugPageJobTitles_job_title_id_fkey
SeoCustomSlugPageJobTitles.job_title_id
JobTitles.id
Restrict delete
SeoCustomSlugPageJobTitles_hierarchical_job_category_id_fkey
SeoCustomSlugPageJobTitles.hierarchical_job_category_id
HierarchicalJobCategories.id
Null on delete
SeoNegativeKeywords_createdByUserId_fkey
SeoNegativeKeywords.createdByUserId
Users.id
Null on delete
SeoLocationMetadatas_seo_page_metadata_id_fkey
SeoLocationMetadatas.seo_page_metadata_id
SeoPageMetadatas.id
Restrict delete
SeoLocationMetadatas_location_id_fkey
SeoLocationMetadatas.location_id
Locations.id
Null on delete
SeoLocationMetadatas_city_id_fkey
SeoLocationMetadatas.city_id
Cities.id
Restrict delete
SeoJobCategoryMetadatas_hierarchical_job_category_id_fkey
SeoJobCategoryMetadatas.hierarchical_job_category_id
HierarchicalJobCategories.id
Null on delete
SeoJobCategoryMetadatas_job_category_id_fkey
SeoJobCategoryMetadatas.job_category_id
JobCategories.id
Restrict delete
SeoJobCategoryMetadatas_seo_page_metadata_id_fkey
SeoJobCategoryMetadatas.seo_page_metadata_id
SeoPageMetadatas.id
Restrict delete
SeoTextualContents_country_code_to_language_code_id_fkey
SeoTextualContents.country_code_to_language_code_id
LanguageToCountryMaps.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
SeoCustomSlugPageJobCategories SeoCustomSlugPageJobCategories_jobCategoryId_hierarchicalJobCat (((job_category_id IS NOT NULL) OR (hierarchical_job_category_id IS NOT NULL)))