| SchemaSpy Analysis of transmart.biomart_user | 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) |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| bio_data_values_view | 3 | view | |||
| browse_analyses_view | 7 | view | |||
| browse_assays_view | 10 | view | |||
| browse_folders_view | 4 | view | |||
| browse_programs_view | 10 | view | |||
| browse_studies_view | 14 | view | |||
| concept_patient_set_bitset | 3 | view | |||
| folder_study_mapping | 4 | view | |||
| gene_ontology | 2 | 0 | |||
| gene_ontology_data | 4 | 0 | |||
| ioe_temp_obj_reg2 | 6 | 0 | |||
| kde_temp_obj_reg3 | 6 | 0 | |||
| patient_num_boundaries | 3 | view | |||
| patient_set_bitset | 2 | view | |||
| query | 1 | 13 | 0 | Storage for patients and observations queries to support front end functionality. DEPRECATED! This table has been moved to a gb-backend application database. | |
| query_set | 2 | 1 | 5 | 0 | Table stores information about data sets for user queries. DEPRECATED! This table has been moved to a gb-backend application database. |
| query_set_diff | 1 | 4 | 0 | Table stores information about specific objects, deleted or added to the subscribed user query related set. DEPRECATED! This table has been moved to a gb-backend application database. | |
| query_set_instance | 1 | 3 | 0 | Table stores information about specific instances of the query set. DEPRECATED! This table has been moved to a gb-backend application. | |
| study_concept_patient_set_bitset | 4 | view | |||
| study_patient_set_bitset | 3 | view | |||
| 8 Tables | 43 | 0 | |||
| 12 Views | 67 |