SchemaSpy Analysis of mkt.sound - Constraints Generated by
SchemaSpy
65 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
article_pkey document_about_article.articleid document.id Restrict delete 
document_about_book_book_fkey document_about_book.bookid document.id Restrict delete 
document_about_book_doc_fkey document_about_book.documentid document.id Restrict delete 
document_about_corporate_cname_fkey document_about_corporate.corporatenameid corporate_name.id Restrict delete 
document_about_corporate_doc_fkey document_about_corporate.documentid document.id Restrict delete 
document_about_event_doc_fkey document_about_event.documentid document.id Restrict delete 
document_about_event_event_fkey document_about_event.eventid event.id Restrict delete 
document_about_film_doc_fkey document_about_film.documentid document.id Restrict delete 
document_about_film_film_fkey document_about_film.filmid document.id Restrict delete 
document_about_image_doc_fkey document_about_image.documentid document.id Restrict delete 
document_about_image_img_fkey document_about_image.imageid document.id Restrict delete 
document_about_location_doc_fkey document_about_location.documentid document.id Restrict delete 
document_about_location_lname_fkey document_about_location.locationnameid location_name.id Restrict delete 
document_about_periodics_doc_fkey document_about_periodic.documentid document.id Restrict delete 
document_about_periodics_peri_fkey document_about_periodic.periodicsid document.id Restrict delete 
document_about_person_doc_fkey document_about_person.documentid document.id Restrict delete 
document_about_person_pname_fkey document_about_person.personnameid person_name.id Restrict delete 
document_about_sound_doc_fkey document_about_sound.documentid document.id Restrict delete 
document_about_sound_sound_fkey document_about_sound.soundid document.id Restrict delete 
document_about_subject_doc_fkey document_about_subject.documentid document.id Restrict delete 
document_about_subject_subj_fkey document_about_subject.subjectid subject.id Restrict delete 
document_about_subject_synchron_fkey document_about_subject.formatsynchronsoundid formatsynchronsound.id Restrict delete 
document_about_subject_topic_fkey document_about_subject.topicplaceindocumentid topicplaceindocument.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_role_fkey document_by_corporate_role.roleid role.id Restrict delete 
document_by_person_role_doc_fkey document_by_person_role.documentid document.id Restrict delete 
document_by_person_role_pname_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_digformat_fkey document.formatsounddigitalversionid formatsounddigitalversion.id Restrict delete 
document_fkey document_about_article.documentid document.id Restrict delete 
document_genre_doc_fkey document_genre.documentid document.id Restrict delete 
document_genre_genre_fkey document_genre.genreid genresound.id Restrict delete 
document_in_corporate_role_cname_fkey document_in_corporate_role.corporatenameid corporate_name.id Restrict delete 
document_in_corporate_role_doc_fkey document_in_corporate_role.documentid document.id Restrict delete 
document_in_corporate_role_role_fkey document_in_corporate_role.roleid role.id Restrict delete 
document_in_person_role_doc_fkey document_in_person_role.documentid document.id Restrict delete 
document_in_person_role_pname_fkey document_in_person_role.personnameid person_name.id Restrict delete 
document_in_person_role_role_fkey document_in_person_role.roleid role.id Restrict delete 
document_ispartof_sound_doc_fkey documents_ispartof_sound.documentid document.id Restrict delete 
document_ispartof_sound_sound_fkey documents_ispartof_sound.soundid document.id Restrict delete 
document_maintopic_doc_fkey document_maintopic.documentid document.id Restrict delete 
document_maintopic_topic_fkey document_maintopic.maintopicid maintopicsound.id Restrict delete 
document_right_corporate_doc_fkey document_right_corporate.documentid document.id Restrict delete 
document_right_corporate_fromprec_fkey document_right_corporate.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
document_right_corporate_pname_fkey document_right_corporate.corporatenameid corporate_name.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_doc_fkey document_right_person.documentid document.id Restrict delete 
document_right_person_fromprec_fkey document_right_person.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
document_right_person_pname_fkey document_right_person.personnameid person_name.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_soundtype_fkey document.soundtypeid soundtype.id Restrict delete 
document_style_doc_fkey document_style.documentid document.id Restrict delete 
document_style_style_fkey document_style.styleid stylesound.id Restrict delete 
document_timeprec_fkey document.datecreatedtimeprecisionid timeprecision.id Restrict delete 
documentusageincontext_cont_fkey documentusageincontext.contextid context.id Restrict delete 
documentusageincontext_doc_fkey documentusageincontext.documentid document.id Restrict delete 
languageusageincontext_lang_fkey languageusageincontext.languageid language.id Restrict delete 
locationnameusageincontext_lname_fkey locationnameusageincontext.locationnameid location_name.id Restrict delete 
periodusageincontext_preiod_fkey periodusageincontext.periodid period.id Restrict delete 
segment_createprec_fkey segment.datecreatedtimeprecisionid timeprecision.id Restrict delete 
segment_doc_fkey segment.documentid document.id Restrict delete 
segment_segmtype_fkey segment.segmenttypeid segmenttypesound.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected