SchemaSpy Analysis of mkt.film - Constraints Generated by
SchemaSpy
217 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
document_haspart_sound_sound_fkey document_haspart_sound.soundid document.id Restrict delete 
documentpart_extent_filmformat_fkey documentpart_extent.formatfilmformatid formatfilmformat.id Restrict delete 
documentpart_extent_segm_fkey documentpart_extent.segmentid segment.id Restrict delete 
event_document_production_doc_fkey event_document_production.documentid document.id Restrict delete 
event_document_production_eventtype_fkey event_document_production.eventtypeid filmeventtype.id Restrict delete 
event_document_production_sourceprec_fkey event_document_production.sourceprecisionid sourceprecision.id Restrict delete 
event_document_production_timeprec_fkey event_document_production.eventdatetimeprecisionid timeprecision.id Restrict delete 
event_document_production_tprecmod_fkey event_document_production.eventdatetimeprecisionmodifierid timeprecisionmodifier.id Restrict delete 
event_filmfestival_festivalname_fkey event_filmfestival.eventcollection_filmfestivalnameid eventcollection_filmfestival_name.id Restrict delete 
event_filmfestival_fromprec_fkey event_filmfestival.datefromtimeprecisionid timeprecision.id Restrict delete 
event_filmfestival_locname_fkey event_filmfestival.locationnameid location_name.id Restrict delete 
event_filmfestival_toprec_fkey event_filmfestival.datetotimeprecisionid timeprecision.id Restrict delete 
eventcollection_filmfestival_awars_festival_fkey eventcollection_filmfestival_award.eventcollection_filmfestivalid eventcollection_filmfestival.id Restrict delete 
eventcollection_filmfestival_name_festival_fkey eventcollection_filmfestival_name.eventcollection_filmfestivalid eventcollection_filmfestival.id Restrict delete 
eventcollection_filmfestival_name_nametype_fkey eventcollection_filmfestival_name.filmfestivalnametypeid filmfestivalnametype.id Restrict delete 
film_about_corporate_cname_fkey document_about_corporate.corporatenameid corporate_name.id Restrict delete 
film_about_corporate_segm_fkey document_about_corporate.segmentid segment.id Restrict delete 
film_about_corporate_topic_fkey document_about_corporate.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_event_event_fkey document_about_event.eventid event.id Restrict delete 
film_about_event_segm_fkey document_about_event.segmentid segment.id Restrict delete 
film_about_event_topic_fkey document_about_event.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_film_left_fkey document_about_film.segmentid segment.id Restrict delete 
film_about_film_topic_fkey document_about_film.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_image_film_fkey document_about_image.segmentid segment.id Restrict delete 
film_about_image_image_fkey document_about_image.imageid document.id Restrict delete 
film_about_image_topic_fkey document_about_image.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_keyword_docid_fkey document_about_keyword.documentid document.id Restrict delete 
film_about_keyword_keywordid_fkey document_about_keyword.keywordid keyword.id Restrict delete 
film_about_keyword_segmid_fkey document_about_keyword.segmentid segment.id Restrict delete 
film_about_keyword_synchron_fkey document_about_keyword.formatsynchronsoundid formatsynchronsound.id Restrict delete 
film_about_keyword_topic_fkey document_about_keyword.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_location_lname_fkey document_about_location.locationnameid location_name.id Restrict delete 
film_about_location_segment_fkey document_about_location.segmentid segment.id Restrict delete 
film_about_location_topic_fkey document_about_location.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_nation_nation_fkey document_about_nation.nationid nation.id Restrict delete 
film_about_nation_topic_fkey document_about_nation.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_period_film_fkey document_about_period.documentid document.id Restrict delete 
film_about_period_peri_fkey document_about_period.periodid period.id Restrict delete 
film_about_periodics_film_fkey document_about_periodics.segmentid segment.id Restrict delete 
film_about_periodics_per_fkey document_about_periodics.periodicsid document.id Restrict delete 
film_about_periodics_topic_fkey document_about_periodics.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_person_persname_fkey document_about_person.personnameid person_name.id Restrict delete 
film_about_person_segment_fkey document_about_person.segmentid segment.id Restrict delete 
film_about_person_synchron_fkey document_about_person.formatsynchronsoundid formatsynchronsound.id Restrict delete 
film_about_person_topic_fkey document_about_person.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_sound_film_fkey document_about_sound.segmentid segment.id Restrict delete 
film_about_sound_sound_fkey document_about_sound.soundid document.id Restrict delete 
film_about_sound_topic_fkey document_about_sound.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_about_subject_doc_fkey document_about_subject.documentid document.id Restrict delete 
film_about_subject_segment_fkey document_about_subject.segmentid segment.id Restrict delete 
film_about_subject_subj_fkey document_about_subject.subjectid subject.id Restrict delete 
film_about_subject_synchron_fkey document_about_subject.formatsynchronsoundid formatsynchronsound.id Restrict delete 
film_about_subject_topic_fkey document_about_subject.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_aboutfilm_right_fkey document_about_film.filmid document.id Restrict delete 
film_article_art_fkey document_about_article.articleid document.id Restrict delete 
film_article_film_fkey document_about_article.segmentid segment.id Restrict delete 
film_article_topic_fkey document_about_article.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_award_corporate_award_fkey document_award_corporate.awardnameid eventcollection_filmfestival_award.id Restrict delete 
film_award_corporate_cname_fkey document_award_corporate.corporatenameid corporate_name.id Restrict delete 
film_award_corporate_event_fkey document_award_corporate.eventid event.id Restrict delete 
film_award_corporate_film_fkey document_award_corporate.filmid document.id Restrict delete 
film_award_corporate_jury_fkey document_award_corporate.jurytypeid jurytype.id Restrict delete 
film_award_film_award_fkey document_award_document.awardnameid eventcollection_filmfestival_award.id Restrict delete 
film_award_film_event_fkey document_award_document.eventid event.id Restrict delete 
film_award_film_film_fkey document_award_document.filmid document.id Restrict delete 
film_award_film_filmtype_fkey document_award_document.filmtypeid filmtype.id Restrict delete 
film_award_film_jury_fkey document_award_document.jurytypeid jurytype.id Restrict delete 
film_award_person_event_fkey document_award_person.eventid event.id Restrict delete 
film_award_person_film_fkey document_award_person.filmid document.id Restrict delete 
film_award_person_jury_fkey document_award_person.jurytypeid jurytype.id Restrict delete 
film_award_person_pname_fkey document_award_person.personnameid person_name.id Restrict delete 
film_book_book_fkey document_about_book.bookid document.id Restrict delete 
film_book_film_fkey document_about_book.segmentid segment.id Restrict delete 
film_book_topic_fkey document_about_book.topicplaceindocumentid topicplaceindocument.id Restrict delete 
film_by_animal_role_aniname_fkey document_by_animal_role.animalnameid animalname.id Restrict delete 
film_by_animal_role_film_fkey document_by_animal_role.documentid document.id Restrict delete 
film_by_animal_role_role_fkey document_by_animal_role.roleid role.id Restrict delete 
film_by_corporate_role_cname_fkey document_by_corporate_role.corporatenameid corporate_name.id Restrict delete 
film_by_corporate_role_film_fkey document_by_corporate_role.documentid document.id Restrict delete 
film_by_corporate_role_role_fkey document_by_corporate_role.roleid role.id Restrict delete 
film_by_corporate_role_sourcepr_fkey document_by_corporate_role.sourceprecisionid sourceprecision.id Restrict delete 
film_by_corporate_roleprem_corpname_fkey document_by_corporate_role_premiering.corporatenameid corporate_name.id Restrict delete 
film_by_corporate_roleprem_event_fkey document_by_corporate_role_premiering.event_productionid event_document_production.id Restrict delete 
film_by_corporate_roleprem_film_fkey document_by_corporate_role_premiering.documentid document.id Restrict delete 
film_by_corporate_roleprem_tprec_fkey document_by_corporate_role_premiering.datepublishedtimeprecisionid timeprecision.id Restrict delete 
film_by_person_role_film_fkey document_by_person_role.documentid document.id Restrict delete 
film_by_person_role_givenrole_fkey document_by_person_role.givenroleid role.id Restrict delete 
film_by_person_role_pname_fkey document_by_person_role.personnameid person_name.id Restrict delete 
film_by_person_role_role_fkey document_by_person_role.roleid role.id Restrict delete 
film_by_person_role_sourcepr_fkey document_by_person_role.sourceprecisionid sourceprecision.id Restrict delete 
film_colortechnics_fkey document.formatcolortechnicsid formatcolortechnics.id Restrict delete 
film_concext_doc_fkey documentusageincontext.documentid document.id Restrict delete 
film_context_con_fkey documentusageincontext.contextid context.id Restrict delete 
film_filmcolor_fkey document.formatfilmcolorid formatfilmcolor.id Restrict delete 
film_filmcopy_in_filmarchive_completeness_fkey document_documentcopyinfilmarchive.formatdocumentcompletenessid formatdocumentcompleteness.id Restrict delete 
film_filmcopy_in_filmarchive_dialogue_fkey document_documentcopyinfilmarchive.languagedialogueid language.id Restrict delete 
film_filmcopy_in_filmarchive_film_fkey document_documentcopyinfilmarchive.documentid document.id Restrict delete 
film_filmcopy_in_filmarchive_filmcolor_fkey document_documentcopyinfilmarchive.formatfilmcolorid formatfilmcolor.id Restrict delete 
film_filmcopy_in_filmarchive_filmcopyquality_fkey document_documentcopyinfilmarchive.formatdocumentcopyqualityid formatdocumentcopyquality.id Restrict delete 
film_filmcopy_in_filmarchive_filmformat_fkey document_documentcopyinfilmarchive.formatfilmformatid formatfilmformat.id Restrict delete 
film_filmcopy_in_filmarchive_filmscreenformat_fkey document_documentcopyinfilmarchive.formatfilmscreenformatid formatfilmscreenformat.id Restrict delete 
film_filmcopy_in_filmarchive_filmsound_fkey document_documentcopyinfilmarchive.formatfilmsoundid formatfilmsound.id Restrict delete 
film_filmcopy_in_filmarchive_insert_fkey document_documentcopyinfilmarchive.languageimageinsertid language.id Restrict delete 
film_filmcopy_in_filmarchive_song_fkey document_documentcopyinfilmarchive.languagesonginsertid language.id Restrict delete 
film_filmcopy_in_filmarchive_synchrontext_fkey document_documentcopyinfilmarchive.languagesynchrontextid language.id Restrict delete 
film_filmformat_film_fkey document_formatfilmformat.documentid document.id Restrict delete 
film_filmformat_filmformat_fkey document_formatfilmformat.formatfilmformatid formatfilmformat.id Restrict delete 
film_filmscreenformat_fkey document.formatfilmscreenformatid formatfilmscreenformat.id Restrict delete 
film_filmsound_fkey document.formatfilmsoundid formatfilmsound.id Restrict delete 
film_filmtype_film_fkey document_filmtype.documentid document.id Restrict delete 
film_filmtype_filmtype_fkey document_filmtype.filmtypeid filmtype.id Restrict delete 
film_genre_film_fkey document_genre.documentid document.id Restrict delete 
film_genre_genre_fkey document_genre.genreid genrefilm.id Restrict delete 
film_haspart_sound_film_fkey document_haspart_sound.documentid document.id Restrict delete 
film_historicalpreiod_film_fkey document_historicalperiod.documentid document.id Restrict delete 
film_historicalpreiod_period_fkey document_historicalperiod.historicalperiodid historicalperiod.id Restrict delete 
film_in_bgperson_bgrole_fprid_fkey document_in_person_role_bgperson_bgrole.documentinpersonroleid document_in_person_role.id Restrict delete 
film_in_bgperson_bgrole_pname_fkey document_in_person_role_bgperson_bgrole.bg_personnameid person_name.id Restrict delete 
film_in_bgperson_bgrole_role_fkey document_in_person_role_bgperson_bgrole.bg_roleid role.id Restrict delete 
film_in_corporate_role_cname_fkey document_in_corporate_role.corporatenameid corporate_name.id Restrict delete 
film_in_corporate_role_film_fkey document_in_corporate_role.documentid document.id Restrict delete 
film_in_corporate_role_infilm_fkey document_in_document.indocumentid document.id Restrict delete 
film_in_corporate_role_role_fkey document_in_corporate_role.roleid role.id Restrict delete 
film_in_film_film_fkey document_in_document.documentd document.id Restrict delete 
film_in_language_film_fkey document_in_language.documentid document.id Restrict delete 
film_in_language_lang_fkey document_in_language.languageid language.id Restrict delete 
film_in_language_languse_fkey document_in_language.languageusagetypeid languageusagetype.id Restrict delete 
film_in_person_role_film_fkey document_in_person_role.documentid document.id Restrict delete 
film_in_person_role_pname_fkey document_in_person_role.personnameid person_name.id Restrict delete 
film_in_person_role_role_fkey document_in_person_role.roleid role.id Restrict delete 
film_in_person_role_sourceprec_fkey document_in_person_role.sourceprecisionid sourceprecision.id Restrict delete 
film_maintopic_filmsegment_fkey document_maintopic.segmentid segment.id Restrict delete 
film_maintopic_topic_fkey document_maintopic.maintopicid maintopicfilm.id Restrict delete 
film_permission_film_fkey document_permission.documentid document.id Restrict delete 
film_productionplace_eventtype_fkey document_productionplace.filmeventtypeid filmeventtype.id Restrict delete 
film_productionplace_film_fkey document_productionplace.documentid document.id Restrict delete 
film_productionplace_locname_fkey document_productionplace.locationnameid location_name.id Restrict delete 
film_resource document_resource.documentid document.id Restrict delete 
film_right_corporate_cname_fkey document_right_corporate.corporatenameid corporate_name.id Restrict delete 
film_right_corporate_film_fkey document_right_corporate.documentid document.id Restrict delete 
film_right_corporate_righttype_fkey document_right_corporate.righttypeid righttype.id Restrict delete 
film_right_person_film_fkey document_right_person.documentid document.id Restrict delete 
film_right_person_pname_fkey document_right_person.personnameid person_name.id Restrict delete 
film_right_person_ritghttype_fkey document_right_person.righttypeid righttype.id Restrict delete 
film_series_film_fkey document_series.documentid document.id Restrict delete 
film_series_series_fkey document_series.seriesid series.id Restrict delete 
film_soundtechnics_fkey document.formatsoundtechnicsid formatsoundtechnics.id Restrict delete 
film_style_film_fkey document_style.documentid document.id Restrict delete 
film_style_style_fkey document_style.styleid stylefilm.id Restrict delete 
film_title_film_fkey document_title.documentid document.id Restrict delete 
film_title_lang_fkey document_title.languageid language.id Restrict delete 
film_title_titletype_fkey document_title.titletypeid titletypefilm.id Restrict delete 
film_titleusageincontext_context_fkey document_titleusageincontext.contextid context.id Restrict delete 
film_web_film_fkey document_web.documentid document.id Restrict delete 
filmcopies_formatfilmfaults_fault_fkey documentcopy_formatfilmfault.formatfilmfaultid formatfilmfault.id Restrict delete 
filmcopies_formatfilmfaults_film_fkey documentcopy_formatfilmfault.documentid document.id Restrict delete 
filmcopies_formatfilmfaults_filmarchivecopy_fkey documentcopy_formatfilmfault.documentcopyid document_documentcopyinfilmarchive.id Restrict delete 
genreusageincontext_context_fkey genreusageincontext.contextid context.id Restrict delete 
genreusageincontext_genre_fkey genreusageincontext.genreid genrefilm.id Restrict delete 
hungarianfilmaward_person_award_fkey hungarianfilmaward_person.hungarianfilmawardid hungarianfilmaward.id Restrict delete 
hungarianfilmaward_person_pname_fkey hungarianfilmaward_person.personnameid person_name.id Restrict delete 
ilm_award_person_award_fkey document_award_person.awardnameid eventcollection_filmfestival_award.id Restrict delete 
languageusageincontext_context_fkey languageusageincontext.contextid context.id Restrict delete 
languageusageincontext_lang_fkey languageusageincontext.languageid language.id Restrict delete 
location_nameusageincontextfilm_locname_fkey location_nameusageincontextfilm.locationnameid location_name.id Restrict delete 
periodusageincontextfilm_preiod_fkey periodusageincontextfilm.periodid period.id Restrict delete 
permission_source_article_fkey permissions_sources.articleid document.id Restrict delete 
permission_source_perm_fkey permissions_sources.documentpermissionid document_permission.id Restrict delete 
segment_by_corporate_role_cname_fkey segment_by_corporate_role.corporatenameid corporate_name.id Restrict delete 
segment_by_corporate_role_role_fkey segment_by_corporate_role.roleid role.id Restrict delete 
segment_by_corporate_role_segm_fkey segment_by_corporate_role.segmentid segment.id Restrict delete 
segment_by_person_role_role_fkey segment_by_person_role.roleid role.id Restrict delete 
segment_by_person_role_segm_fkey segment_by_person_role.segmentid segment.id Restrict delete 
segment_description_segs_fkey segment_description.segmentid segment.id Restrict delete 
segment_doc_fkey segment.documentid document.id Restrict delete 
segment_filename_segm_fkey segment_filename.segmentid segment.id Restrict delete 
segment_haspart_sound_segm_fkey segment_haspart_sound.segmentid segment.id Restrict delete 
segment_haspart_sound_sound_fkey segment_haspart_sound.soundid document.id Restrict delete 
segment_in_corporate_role_cname_fkey segment_in_corporate_role.corporatenameid corporate_name.id Restrict delete 
segment_in_corporate_role_role_fkey segment_in_corporate_role.roleid role.id Restrict delete 
segment_in_corporate_role_segm_fkey segment_in_corporate_role.segmentid segment.id Restrict delete 
segment_in_dialoguelist_segm_fkey segment_in_dialoguelist.segmentid segment.id Restrict delete 
segment_in_dialoguelist_transcript_fkey segment_in_dialoguelist.transcripttypeid transcripttype.id Restrict delete 
segment_in_document_segm_fkey segment_in_document.segmentid segment.id Restrict delete 
segment_in_person_role_bgpname_fkey segment_in_person_role.backgroundpersonnameid person_name.id Restrict delete 
segment_in_person_role_pname_fkey segment_in_person_role.personnameid person_name.id Restrict delete 
segment_in_person_role_role_fkey segment_in_person_role.roleid role.id Restrict delete 
segment_in_person_role_segm_fkey segment_in_person_role.segmentid segment.id Restrict delete 
segment_in_person_role_synchron_fkey segment_in_person_role.formatsynchronsoundid formatsynchronsound.id Restrict delete 
segment_in_person_role_topic_fkey segment_in_person_role.topicplaceindocumentid topicplaceindocument.id Restrict delete 
segment_in_selectedperson_feature_filmsegment_fkey segment_in_selectedperson_feature.segmentid segment.id Restrict delete 
segment_in_selectedperson_feature_keyword_fkey segment_in_selectedperson_feature.keywordid keyword.id Restrict delete 
segment_in_selectedperson_feature_pname_fkey segment_in_selectedperson_feature.personnameid person_name.id Restrict delete 
segment_in_selectedperson_filmsegment_fkey segment_in_selectedperson.segmentid segment.id Restrict delete 
segment_in_selectedperson_pname_fkey segment_in_selectedperson.personnameid person_name.id Restrict delete 
segment_nore_film_fkey segment_note.documentid document.id Restrict delete 
segment_nore_filmsegment_fkey segment_note.segmentid segment.id Restrict delete 
segment_segmenttype_fkey segment.segmenttypeid segmenttypefilm.id Restrict delete 
series_by_corporate_role_cname_fkey series_by_corporate_role.corporatenameid corporate_name.id Restrict delete 
series_by_corporate_role_role_fkey series_by_corporate_role.roleid role.id Restrict delete 
series_by_corporate_role_series_fkey series_by_corporate_role.seriesid series.id Restrict delete 
series_by_person_role_pname_fkey series_by_person_role.personnameid person_name.id Restrict delete 
series_by_person_role_role_fkey series_by_person_role.roleid role.id Restrict delete 
series_by_person_role_series_fkey series_by_person_role.seriesid series.id Restrict delete 
series_fromprec_fkey series.datefromtimeprecisionid timeprecision.id Restrict delete 
series_right_corporate_cname_fkey series_right_corporate.corporatenameid corporate_name.id Restrict delete 
series_right_corporate_fromprec_fkey series_right_corporate.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
series_right_corporate_righttype_fkey series_right_corporate.righttypeid righttype.id Restrict delete 
series_right_corporate_series_fkey series_right_corporate.seriesid series.id Restrict delete 
series_right_corporate_toprec_fkey series_right_corporate.rightdatetotimeprecisionid timeprecision.id Restrict delete 
series_right_person_fromprec_fkey series_right_person.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
series_right_person_pname_fkey series_right_person.personnameid person_name.id Restrict delete 
series_right_person_righttype_fkey series_right_person.righttypeid righttype.id Restrict delete 
series_right_person_series_fkey series_right_person.seriesid series.id Restrict delete 
series_right_person_toprec_fkey series_right_person.rightdatetotimeprecisionid timeprecision.id Restrict delete 
series_seriestype_fkey series.seriestypeid seriestype.id Restrict delete 
series_toprec_fkey series.datetotimeprecisionid timeprecision.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected