SchemaSpy Analysis of mkt.book - Constraints Generated by
SchemaSpy
66 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
book_formatextentpagenumbermeasureunit_fkey document.formatextentpagenumbermeasureunitid formatextentpagenumbermeasureunit.id Restrict delete 
book_formatextentsizemeasureunit_fkey document.formatextentsizemeasureunitid formatextentsizemeasureunit.id Restrict delete 
book_formatpageorientation_fkey document.formatpageorientationid formatpageorientation.id Restrict delete 
book_fromprec_fkey document.dateissuedfromtimeprecisionid timeprecision.id Restrict delete 
book_publishingtpye_fkey document.publishingtypeid publishingtype.id Restrict delete 
book_right_corporate_fromprec_fkey document_right_corporate.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
book_right_corporate_toprec_fkey document_right_corporate.rightdatetotimeprecisionid timeprecision.id Restrict delete 
book_right_person_fromprec_fkey document_right_person.rightdatefromtimeprecisionid timeprecision.id Restrict delete 
book_right_person_toprec_fkey document_right_person.rightdatetotimeprecisionid timeprecision.id Restrict delete 
book_series_fkey document.seriesid_redund series.id Restrict delete 
book_toprec_fkey document.dateissuedtotimeprecisionid timeprecision.id Restrict delete 
books_about_articles_art_fkey document_about_article.articleid document.id Restrict delete 
books_about_articles_book_fkey document_about_article.documentid document.id Restrict delete 
books_about_books_book_fkey document_about_book.documentid document.id Restrict delete 
books_about_books_bookright_fkey document_about_book.bookid document.id Restrict delete 
books_about_corporates_book_fkey document_about_corporate.documentid document.id Restrict delete 
books_about_corporates_corp_fkey document_about_corporate.corporatenameid corporate_name.id Restrict delete 
books_about_events_book_fkey document_about_event.documentid document.id Restrict delete 
books_about_events_event_fkey document_about_event.eventid event.id Restrict delete 
books_about_films_book_fkey document_about_film.documentid document.id Restrict delete 
books_about_films_film_fkey document_about_film.filmid document.id Restrict delete 
books_about_images_book_fkey document_about_image.documentid document.id Restrict delete 
books_about_locations_book_fkey document_about_location.documentid document.id Restrict delete 
books_about_locations_locname_fkey document_about_location.locationnameid location_name.id Restrict delete 
books_about_periodics_book_fkey document_about_periodics.documentid document.id Restrict delete 
books_about_periodics_peri_fkey document_about_periodics.periodicsid document.id Restrict delete 
books_about_persons_book_fkey document_about_person.documentid document.id Restrict delete 
books_about_persons_persname_fkey document_about_person.personnameid person_name.id Restrict delete 
books_about_sounds_book_fkey document_about_sound.documentid document.id Restrict delete 
books_about_sounds_sound_fkey document_about_sound.soundid document.id Restrict delete 
books_by_corporates_book_fkey document_by_corporate_role.documentid document.id Restrict delete 
books_by_corporates_corpname_fkey document_by_corporate_role.corporatenameid corporate_name.id Restrict delete 
books_by_corporates_role_fkey document_by_corporate_role.roleid role.id Restrict delete 
books_by_genres_book_fkey document_genre.documentid document.id Restrict delete 
books_by_genres_genre_fkey document_genre.genreid genrebook.id Restrict delete 
books_by_persons_book_fkey document_by_person_role.documentid document.id Restrict delete 
books_by_persons_persname_fkey document_by_person_role.personnameid person_name.id Restrict delete 
books_by_persons_role_fkey document_by_person_role.roleid role.id Restrict delete 
books_haspart_images_book_fkey document_haspart_image.documentid document.id Restrict delete 
books_languages_book_fkey document_language.documentid document.id Restrict delete 
books_languages_lang_fkey document_language.languageid language.id Restrict delete 
books_locationissueds_book_fkey document_locationissued.documentid document.id Restrict delete 
books_maintopics_book_fkey document_maintopic.documentid document.id Restrict delete 
books_maintopics_topic_fkey document_maintopic.maintopicid maintopicbook.id Restrict delete 
books_rights_corporates_book_fkey document_right_corporate.documentid document.id Restrict delete 
books_rights_corporates_corpname_fkey document_right_corporate.corporatenameid corporate_name.id Restrict delete 
books_rights_corporates_right_fkey document_right_corporate.rightid righttype.id Restrict delete 
books_rights_persons_book_fkey document_right_person.documentid document.id Restrict delete 
books_rights_persons_persname_fkey document_right_person.personnameid person_name.id Restrict delete 
books_rights_persons_right_fkey document_right_person.rightid righttype.id Restrict delete 
books_series_book_fkey document_series.documentid document.id Restrict delete 
books_series_series_fkey document_series.seriesid series.id Restrict delete 
books_styles_book_fkey document_style.documentid document.id Restrict delete 
books_styles_lang_fkey document_title.languageid language.id Restrict delete 
books_styles_style_fkey document_style.styleid stylebook.id Restrict delete 
books_styles_titletype_fkey document_title.titletypeid titletypebook.id Restrict delete 
books_titles_book_fkey document_title.documentid document.id Restrict delete 
document_about_article_topic_fkey document_about_article.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_about_image_img_fkey document_about_image.imageid 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_topic_fkey document_about_subject.topicplaceindocumentid topicplaceindocument.id Restrict delete 
document_haspart_image_img_fkey document_haspart_image.imageid document.id Restrict delete 
languageusageincontext_fkey languageusageincontext.languageid language.id Restrict delete 
locations_namesusageincontextfilm_locname_fkey locationnameusageincontextfilm.locationnameid location_name.id Restrict delete 
locations_namesusageincontextfilm_locprec_fkey locationnameusageincontextfilm.locationprecisionid locationprecision.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected