- Tables
- Relationships
- Utility Tables
- Constraints
- Anomalies
- Columns
- Donate

SchemaSpy Analysis of sahebkhabar - Constraints | Generated by SchemaSpy

91 Foreign Key Constraints: |

Constraint Name | Child Column | Parent Column | Delete Rule
--- | --- | --- | ---
FK143BF46AE3778376 | user_role.user_id | user_profile.id | Restrict delete
FK178B06237393E | ads.topic_id | topic.id | Restrict delete
FK2BF2B3785A42C676 | news_media.news_id | news.id | Cascade on delete
FK2BF2B378652E411E | news_media.media_id | media.id | Cascade on delete
FK2C201C9B5A42C676 | news_place.news_id | news.id | Cascade on delete
FK2C201C9B9D98A3E | news_place.place_id | place.id | Restrict delete
FK36EBCBBE740F4D | user_profile.user_config_id | user_config.id | Restrict delete
FK_7n0m9sdowho7bahiaxnxl7ijx | news_history.locker_id | user_profile.id | Restrict delete
FK_8yd4jgtdnd2x6waxx0w9hospr | entity_audit_log.user_id | user_profile.id | Restrict delete
FK_ads_media_flash | ads.flash_media_id | media.id | Restrict delete
FK_ads_media_image | ads.image_media_id | media.id | Restrict delete
FK_ads_place | ads.place_id | place.id | Restrict delete
FK_archive_news_place_subtopic | news_place_archive.sub_topic_id | topic.id | Restrict delete
FK_archive_news_place_topic | news_place_archive.topic_id | topic.id | Restrict delete
FK_bdgw368dhxfhor560wbmnt19b | media_keyword.keyword_id | keyword.id | Restrict delete
FK_fpqxks3masc7x1x3frflik3f | tag_option.item_id | tag_item.id | Restrict delete
FK_fwjt2wyfe2g7qc8v6oc10kq17 | media_keyword.media_id | media.id | Restrict delete
FK_io1bbopmg4bder9jfwk52ubk9 | news_comment.news_id | news.id | Restrict delete
FK_j8mhh7jtx34ce164ja68wuv5a | news_transition_log.news_id | news.id | Cascade on delete
FK_keyword_keyword | keyword.parent_id | keyword.id | Restrict delete
fk_keyword_preferred | keyword.preferred_id | keyword.id | Restrict delete
fk_link_link_group | link.link_group_id | link_group.id | Restrict delete
FK_media_person | media.photographer_id | person.id | Restrict delete
FK_messaging_log_newsletter | messaging_log.newsletter_id | newsletter.id | Null on delete
FK_messaging_log_subscription | messaging_log.subscription_id | subscription.id | Null on delete
FK_news_comment_news_comment | news_comment.parent_id | news_comment.id | Restrict delete
fk_news_history_image | news_history.image_id | media.id | Restrict delete
fk_news_history_large_entity_1 | news_history.body_html_id | large_entity.id | Cascade on delete
fk_news_history_large_entity_3 | news_history.body_plain_id | large_entity.id | Cascade on delete
fk_news_history_news_id | news_history.news_id | news.id | Cascade on delete
fk_news_history_person | news_history.journalist_id | person.id | Restrict delete
fk_news_history_recipient | news_history.recipient_id | user_profile.id | Restrict delete
FK_news_history_region | news_history.region_id | region.id | Restrict delete
fk_news_history_source | news_history.source_id | source.id | Restrict delete
fk_news_history_topic | news_history.topic_id | topic.id | Restrict delete
fk_news_history_topic_2 | news_history.sub_topic_id | topic.id | Restrict delete
FK_news_id | news_place_archive.news_id | news.id | Cascade on delete
fk_news_image | news.image_id | media.id | Restrict delete
fk_news_keyword_keyword_1 | news_keyword.keyword_id | keyword.id | Cascade on delete
fk_news_keyword_news_1 | news_keyword.news_id | news.id | Cascade on delete
fk_news_large_entity | news.body_html_id | large_entity.id | Cascade on delete
fk_news_large_entity_2 | news.body_plain_id | large_entity.id | Cascade on delete
fk_news_locker | news.locker_id | user_profile.id | Restrict delete
FK_news_log_news | news_log.news_id | news.id | Cascade on delete
fk_news_media2 | news.image2_id | media.id | Restrict delete
FK_news_news_news | news_news.news_id | news.id | Cascade on delete
FK_news_news_news_2 | news_news.related_news_id | news.id | Cascade on delete
fk_news_person | news.journalist_id | person.id | Restrict delete
FK_news_place_subtopic | news_place.sub_topic_id | topic.id | Restrict delete
FK_news_place_topic | news_place.topic_id | topic.id | Restrict delete
fk_news_recipient | news.recipient_id | user_profile.id | Restrict delete
fk_news_region | news.region_id | region.id | Restrict delete
fk_news_site | news.site_id | site.id | Restrict delete
fk_news_source | news.source_id | source.id | Restrict delete
fk_news_sub_topic | news.sub_topic_id | topic.id | Restrict delete
FK_news_subtopic_news | news_subtopic.news_id | news.id | Cascade on delete
FK_news_subtopic_topic | news_subtopic.topic_id | topic.id | Restrict delete
fk_news_topic | news.topic_id | topic.id | Restrict delete
FK_news_transition_log_user | news_transition_log.from_user_id | user_profile.id | Restrict delete
FK_news_transition_log_user_2 | news_transition_log.to_user_id | user_profile.id | Restrict delete
fk_news_type_id | news.type_id | news_type.id | Restrict delete
fk_news_type_id_2 | news_history.type_id | news_type.id | Restrict delete
FK_newsletter_place | newsletter.place_id | place.id | Restrict delete
fk_place | poll.place_id | place.id | Restrict delete
FK_place_news | place.subject_id | news.id | Restrict delete
FK_place_news_type | place.news_type_id | news_type.id | Restrict delete
FK_place_place | place.archive_place_id | place.id | Restrict delete
FK_place_topic | place.topic_id | topic.id | Restrict delete
fk_poll | vote.poll_id | poll.id | Restrict delete
fk_poll_option | vote.choice_id | poll_option.id | Restrict delete
FK_poll_option_poll | poll_option.poll_id | poll.id | Restrict delete
fk_prodcat_icon | product_category.icon_id | media.id | Restrict delete
fk_prodcat_parent | product_category.parent_id | product_category.id | Restrict delete
fk_prodpricelog_product | product_price_log.product_id | product.id | Restrict delete
fk_product_category | product.category_id | product_category.id | Restrict delete
fk_product_icon | product.icon_id | media.id | Restrict delete
fk_product_image | product.image_id | media.id | Restrict delete
FK_region_region | region.parent_id | region.id | Restrict delete
fk_site_domain_site_id | site_domain.site_id | site.id | Restrict delete
fk_site_master | site.master_site_id | site.id | Restrict delete
FK_subscription_newsletter | subscription.newsletter_id | newsletter.id | Restrict delete
fk_topic | poll.topic_id | topic.id | Restrict delete
FK_topic_topic | topic.parent_id | topic.id | Restrict delete
fk_user-site_user_1 | user_site.user_id | user_profile.id | Restrict delete
fk_user_role_role_1 | user_role.role_id | role.id | Restrict delete
FKA7A0293E5A42C676 | entity_tag.news_id | news.id | Restrict delete
FKA7A0293E652E411E | entity_tag.media_id | media.id | Restrict delete
FKA7A0293E98682B53 | entity_tag.tag_option_id | tag_option.id | Restrict delete
FKA7A0293EF8FFE836 | entity_tag.person_id | person.id | Restrict delete
FKADABD91E9D98A3E | news_place_archive.place_id | place.id | Restrict delete
ft_site | poll.site_id | site.id | Restrict delete

Check Constraints:

Table | Constraint Name | Constraint
--- | --- | ---
None detected