SchemaSpy Analysis of mkt.article - Constraints Generated by
SchemaSpy
71 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
artice_context_con_fkey documentusageincontext.contextid context.id Restrict delete 
article_about_article_left_fkey document_about_article.documentid document.id Restrict delete 
article_about_article_right_fkey document_about_article.articleid document.id Restrict delete 
article_about_bokk_art_fkey document_about_book.documentid document.id Restrict delete 
article_about_book_book_fkey document_about_book.bookid document.id Restrict delete 
article_about_corporate_art_fkey document_about_corporate.documentid document.id Restrict delete 
article_about_corporate_corp_fkey document_about_corporate.corporatenameid corporate_name.id Restrict delete 
article_context_art_fkey documentusageincontext.documentid document.id Restrict delete 
articles_about_events_art_fkey document_about_event.documentid document.id Restrict delete 
articles_about_events_event_fkey document_about_event.eventid event.id Restrict delete 
articles_about_films_art_fkey document_about_film.documentid document.id Restrict delete 
articles_about_films_film_fkey document_about_film.filmid document.id Restrict delete 
articles_about_images_art_fkey document_about_image.documentid document.id Restrict delete 
articles_about_locations_art_fkey document_about_location.documentid document.id Restrict delete 
articles_about_locations_loc_fkey document_about_location.locationnameid location_name.id Restrict delete 
articles_about_periodics_art_fkey document_about_periodics.documentid document.id Restrict delete 
articles_about_periodics_per_fkey document_about_periodics.periodicsid document.id Restrict delete 
articles_about_persons_art_fkey document_about_person.documentid document.id Restrict delete 
articles_about_persons_per_fkey document_about_person.personnameid person_name.id Restrict delete 
articles_about_sounds_art_fkey document_about_sound.documentid document.id Restrict delete 
articles_about_sounds_sound_fkey document_about_sound.soundid document.id Restrict delete 
articles_about_subjects_art_fkey document_about_subject.documentid document.id Restrict delete 
articles_about_subjects_sub_fkey document_about_subject.subjectid subject.id Restrict delete 
articles_by_corporates_art_fkey document_by_corporate_role.documentid document.id Restrict delete 
articles_by_corporates_corp_fkey document_by_corporate_role.corporatenameid corporate_name.id Restrict delete 
articles_by_corporates_role_fkey document_by_corporate_role.roleid role.id Restrict delete 
articles_by_persons_art_fkey document_by_person_role.documentid document.id Restrict delete 
articles_by_persons_pers_fkey document_by_person_role.personnameid person_name.id Restrict delete 
articles_by_persons_role_fkey document_by_person_role.roleid role.id Restrict delete 
articles_genres_art_fkey document_genre.documentid document.id Restrict delete 
articles_genres_genre_fkey document_genre.genreid genrearticle.id Restrict delete 
articles_haspart_images_art_fkey document_haspart_image.documentid document.id Restrict delete 
articles_in_persons_art_fkey document_in_person_role.documentid document.id Restrict delete 
articles_in_persons_pname_fkey document_in_person_role.personnameid person_name.id Restrict delete 
articles_in_persons_role_fkey document_in_person_role.roleid role.id Restrict delete 
articles_maintopics_art_fkey document_maintopic.documentid document.id Restrict delete 
articles_maintopics_mtop_fkey document_maintopic.maintopicid maintopicarticle.id Restrict delete 
articles_rights_corporates_art_fkey document_right_corporate.documentid document.id Restrict delete 
articles_rights_corporates_cname_fkey document_right_corporate.corporatenameid corporate_name.id Restrict delete 
articles_rights_persons_art_fkey document_right_person.documentid document.id Restrict delete 
articles_rights_persons_pname_fkey document_right_person.personnameid person_name.id Restrict delete 
articles_styles_art_fkey document_style.documentid document.id Restrict delete 
articles_styles_sty_fkey document_style.styleid stylearticle.id Restrict delete 
document_about_article_topic_fkey document_about_article.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_book_topic_fkey document_about_book.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_corporate_topic_fkey document_about_corporate.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_film_topic_fkey document_about_film.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_image_img_fkey document_about_image.imageid document.id Restrict delete 
document_about_image_topic_fkey document_about_image.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_location_topic_fkey document_about_location.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_periodics_topic_fkey document_about_periodics.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_person_topic_fkey document_about_person.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_subject_topic_fkey document_about_subject.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_haspart_image_img_fkey document_haspart_image.imageid document.id Restrict delete 
document_in_book_book_fkey document_in_book.bookid document.id Restrict delete 
document_in_book_doc_fkey document_in_book.documentid document.id Restrict delete 
document_in_cdrom_cdrom_fkey document_in_cdrom.cdromid cdrom.id Restrict delete 
document_in_cdrom_doc_fkey document_in_cdrom.documentid document.id Restrict delete 
document_in_periodics_doc_fkey document_in_periodics.documentid document.id Restrict delete 
document_in_periodics_peri_fkey document_in_periodics.periodicsid document.id Restrict delete 
document_in_web_doc_fkey document_in_web.documentid document.id Restrict delete 
document_in_web_web_fkey document_in_web.webid web.id Restrict delete 
document_issue_fkey document.issueid_redund issue.id Restrict delete 
document_right_corporate_fromprec_fkey document_right_corporate.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
document_right_corporate_right_fkey document_right_corporate.rightid righttype.id Restrict delete 
document_right_corporate_toprec_fkey document_right_corporate.rightdatetotimeprecisionid timeprecision.id Restrict delete 
document_right_person_fromprec_fkey document_right_person.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
document_right_person_right_fkey document_right_person.rightid righttype.id Restrict delete 
document_right_person_toprec_fkey document_right_person.rightdatetotimeprecisionid timeprecision.id Restrict delete 
document_textintype_fkey document.textintypeid_redund textintype.id Restrict delete 
document_timeprec_fkey document.dateissuedtimeprecisionid_redund timeprecision.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected