SchemaSpy Analysis of transmart.searchapp Generated by
SchemaSpy
Generated by SchemaSpy on Wed Jun 26 00:11 CEST 2019
Database Type: PostgreSQL - 10.9 (Ubuntu 10.9-0ubuntu0.18.10.1) SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
listsig_genes 2 view
pathway_genes 3 view
plugin 1 9 1
plugin_module 1 11 20
plugin_module_backup 11 0
report 7 0
report_item 3 0
saved_faceted_search 1 8 0
search_app_access_log 6 0
search_auth_group 1 1 2 1
search_auth_group_member 2 2 0
search_auth_principal 4 8 6
search_auth_sec_object_access 3 4 0
search_auth_user 5 1 8 5
search_auth_user_sec_access 3 4 0
search_auth_user_sec_access_v 4 view
search_bio_mkr_correl_fast_mv 5 0
search_bio_mkr_correl_fast_view 5 view
search_bio_mkr_correl_view 5 view
search_categories 2 view
search_custom_filter 5 0
search_custom_filter_item 4 0
search_form_layout 7 6
search_gene_sig_file_schema 1 5 3
search_gene_signature 1 4 58 0
search_gene_signature_item 7 0
search_keyword 3 8 105,716
search_keyword_term 1 6 220,305
search_request_map 4 17
search_required_upload_field 3 0
search_role 1 4 5
search_role_auth_user 2 2 8
search_sec_access_level 2 3 3
search_secure_object 2 5 0 Holds the secure tokens that control access.
search_secure_object_path 3 0
search_taxonomy 2 1 5 38
search_taxonomy_level1 3 view
search_taxonomy_level2 3 view
search_taxonomy_level3 3 view
search_taxonomy_level4 3 view
search_taxonomy_level5 3 view
search_taxonomy_lineage 5 view
search_taxonomy_rels 2 3 38
search_taxonomy_terms_cats 3 view
search_user_feedback 5 0
search_user_settings 4 0
solr_keywords_lineage 3 view
subset 9 0
           
34 Tables     238 326,172  
14 Views     47