SchemaSpy Analysis of mkt.periodics - Constraints Generated by
SchemaSpy
46 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
cdrom_timeprec_fkey cdrom.dateissuedtimeprecisionid timeprecision.id Restrict delete 
document_by_corporate_role_cname_fkey document_by_corporate_role.corporatenameid corporate_name.id Restrict delete 
document_by_corporate_role_doc_fkey document_by_corporate_role.documentid document.id Restrict delete 
document_by_corporate_role_fromprec_fkey document_by_corporate_role.roledatefromtimeprecisionid timeprecision.id Restrict delete 
document_by_corporate_role_role_fkey document_by_corporate_role.roleid role.id Restrict delete 
document_by_corporate_role_toprec_fkey document_by_corporate_role.roledatetotimeprecisionid timeprecision.id Restrict delete 
document_by_person_role_doc_fkey document_by_person_role.documentid document.id Restrict delete 
document_by_person_role_fromprec_fkey document_by_person_role.roledatefromtimeprecisionid timeprecision.id Restrict delete 
document_by_person_role_persname_fkey document_by_person_role.personnameid person_name.id Restrict delete 
document_by_person_role_role_fkey document_by_person_role.roleid role.id Restrict delete 
document_by_person_role_toprec_fkey document_by_person_role.roledatetotimeprecisionid timeprecision.id Restrict delete 
document_datefreq_fkey document.datefrequencyid datefrequency.id Restrict delete 
document_fromprec_fkey document.dateissuedfromtimeprecisionid timeprecision.id Restrict delete 
document_haspart_image_img_fkey document_haspart_image.imageid document.id Restrict delete 
document_relateddocument_relation_fkey document_relateddocument.relationid relation.id Restrict delete 
document_style_doc_fkey document_style.documentid document.id Restrict delete 
document_style_style_fkey document_style.styleid styleperiodics.id Restrict delete 
document_title_doc_fkey document_title.documentid document.id Restrict delete 
document_title_fromprec_fkey document_title.datefromtimeprecisionid timeprecision.id Restrict delete 
document_title_titletype_fkey document_title.titletypeid titletypefilm.id Restrict delete 
document_title_toprec_fkey document_title.datetotimeprecisionid timeprecision.id Restrict delete 
document_toprec_fkey document.dateissuedtotimeprecisionid timeprecision.id Restrict delete 
documents_about_books_bo_fkey document_about_book.bookid document.id Restrict delete 
documents_about_books_doc_fkey document_about_book.documentid document.id Restrict delete 
documents_about_subjects_doc_fkey document_about_subject.documentid document.id Restrict delete 
documents_formatextentsizes_doc_fkey document_formatextentsize.documentid document.id Restrict delete 
documents_formatextentsizes_fromprec_fkey document_formatextentsize.dateissuedfromtimeprecisionid timeprecision.id Restrict delete 
documents_formatextentsizes_toprec_fkey document_formatextentsize.dateissuedtotimeprecisionid timeprecision.id Restrict delete 
documents_genres_doc_fkey document_genre.documentid document.id Restrict delete 
documents_haspart_images_doc_fkey document_haspart_image.issueid issue.id Restrict delete 
documents_languages_doc_fkey document_language.documentid document.id Restrict delete 
documents_relateddocuments_doc_fkey document_relateddocument.documentid document.id Restrict delete 
documents_relateddocuments_reldoc_fkey document_relateddocument.relateddocumentid document.id Restrict delete 
issue_fkey issue.documentid document.id Restrict delete 
languageusage_lang_fkey languageusageincontext.languageid language.id Restrict delete 
periodics_about_subject_sub_fkey document_about_subject.subjectid subject.id Restrict delete 
periodics_genre_per_fkey document_genre.genreid genreperiodics.id Restrict delete 
periodics_language_per_fkey document_language.languageid language.id Restrict delete 
periodics_maintopic_per_fkey document_maintopic.documentid document.id Restrict delete 
periodics_maintopic_topic_fkey document_maintopic.maintopicid maintopicperiodics.id Restrict delete 
periodics_right_corporate_cname_fkey document_right_corporate.corporatenameid corporate_name.id Restrict delete 
periodics_right_corporate_per_fkey document_right_corporate.documentid document.id Restrict delete 
periodics_right_corporate_right_fkey document_right_corporate.righttypeid righttype.id Restrict delete 
periodics_right_person_per_fkey document_right_person.documentid document.id Restrict delete 
periodics_right_person_pname_fkey document_right_person.personnameid person_name.id Restrict delete 
periodics_right_person_right_fkey document_right_person.righttypeid righttype.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected