SchemaSpy Analysis of transmart.searchapp - Constraints Generated by
SchemaSpy
22 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
fk_search_tax_rels_child search_taxonomy_rels.child_id search_taxonomy.term_id Restrict delete 
fk_search_tax_rels_parent search_taxonomy_rels.parent_id search_taxonomy.term_id Restrict delete 
fk_search_tax_search_keyword search_taxonomy.search_keyword_id search_keyword.search_keyword_id Restrict delete 
fkfb14ef79287e0cac search_role_auth_user.authorities_id search_auth_user.id Restrict delete 
fkfb14ef798f01f561 search_role_auth_user.people_id search_role.id Restrict delete 
gene_sig_create_auth_user_fk1 search_gene_signature.created_by_auth_user_id search_auth_user.id Restrict delete 
gene_sig_file_schema_fk1 search_gene_signature.search_gene_sig_file_schema_id search_gene_sig_file_schema.search_gene_sig_file_schema_id Restrict delete 
gene_sig_mod_auth_user_fk1 search_gene_signature.modified_by_auth_user_id search_auth_user.id Restrict delete 
gene_sig_parent_fk1 search_gene_signature.parent_gene_signature_id search_gene_signature.search_gene_signature_id Restrict delete 
plugin_module_plugin_fk1 plugin_module.plugin_seq plugin.plugin_seq Restrict delete 
saved_faceted_search_user_id saved_faceted_search.user_id search_auth_user.id Restrict delete 
sch_sec_a_u_fk search_auth_sec_object_access.auth_principal_id search_auth_principal.id Restrict delete 
sch_sec_s_a_l_fk search_auth_sec_object_access.secure_access_level_id search_sec_access_level.search_sec_access_level_id Restrict delete 
sch_sec_s_o_fk search_auth_sec_object_access.secure_object_id search_secure_object.search_secure_object_id Restrict delete 
sch_user_gp_m_grp_fk search_auth_group_member.auth_group_id search_auth_group.id Restrict delete 
sch_user_gp_m_usr_fk search_auth_group_member.auth_user_id search_auth_principal.id Restrict delete 
search_kw_fk search_keyword_term.search_keyword_id search_keyword.search_keyword_id Restrict delete 
search_sec_a_u_fk search_auth_user_sec_access.search_auth_user_id search_auth_user.id Restrict delete 
search_sec_s_a_l_fk search_auth_user_sec_access.search_sec_access_level_id search_sec_access_level.search_sec_access_level_id Restrict delete 
search_sec_s_o_fk search_auth_user_sec_access.search_secure_object_id search_secure_object.search_secure_object_id Restrict delete 
sh_auth_gp_id_fk search_auth_group.id search_auth_principal.id Restrict delete 
sh_auth_user_id_fk search_auth_user.id search_auth_principal.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected