| SchemaSpy Analysis of transmart.i2b2demodata | 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 |
|---|---|---|---|---|---|
| archive_observation_fact | 23 | 0 | |||
| async_job | 12 | 0 | Stores record per an advanced analysis job. | ||
| cd | 3 | 0 | |||
| code_lookup | 11 | 350 | |||
| concept_counts | 3 | 0 | Deprecated. Stores number of patients for which there are observations over the given concept. | ||
| concept_dimension | 10 | 0 | Table contains the concepts that classify observations. | ||
| counter | 2 | 0 | |||
| crc_db_lookup | 12 | 0 | |||
| datamart_report | 4 | 0 | |||
| dimloader | 21 | 0 | |||
| encounter_mapping | 1 | 12 | 0 | ||
| hilosequences | 2 | 0 | |||
| jms_messages | 5 | 0 | |||
| jms_roles | 2 | 0 | |||
| jms_subscriptions | 4 | 0 | |||
| jms_transactions | 1 | 0 | |||
| jms_users | 3 | 0 | |||
| linked_file_collection | 2 | 5 | 0 | Stores universally unique identifier to the collection of files (a folder) on an external file system (e.g. Arvados Keep) | |
| map | 2 | 0 | |||
| modifier_dimension | 11 | 0 | Table holds the modifiers on an observation. Used to link to highdim data and samples as well. | ||
| modifier_dimension_view | 14 | view | |||
| modifier_metadata | 4 | 0 | |||
| news_updates | 7 | 0 | |||
| observation_fact | 1 | 24 | 0 | Table that stores all observations | |
| patient_dimension | 3 | 19 | 0 | Table holds patients. | |
| patient_mapping | 10 | 0 | Table with subject identifiers from different sources. | ||
| patient_trial | 3 | 0 | Table that links patients to trials. Unused. | ||
| provider_dimension | 9 | 0 | Table that holds providers, e.g., physicians. | ||
| qt_analysis_plugin | 15 | 0 | |||
| qt_analysis_plugin_result_type | 2 | 0 | |||
| qt_breakdown_path | 5 | 0 | |||
| qt_patient_enc_collection | 1 | 5 | 0 | ||
| qt_patient_sample_collection | 3 | 0 | |||
| qt_patient_set_collection | 1 | 4 | 0 | ||
| qt_pdo_query_master | 6 | 0 | |||
| qt_privilege | 4 | 6 | |||
| qt_query_instance | 1 | 2 | 10 | 0 | |
| qt_query_master | 1 | 14 | 0 | This master table to the holds the client?s anaysis request information. i.e. the user_id, analysis definition , the i2b2 request_xml, etc.. | |
| qt_query_result_instance | 3 | 3 | 12 | 0 | |
| qt_query_result_type | 1 | 5 | 9 | ||
| qt_query_status_type | 2 | 3 | 10 | ||
| qt_xml_result | 1 | 3 | 0 | ||
| relation | 3 | 5 | 0 | Represents relationships between subjects. e.g. pedigree. | |
| relation_type | 1 | 5 | 0 | Dictionary of relations. e.g. "parent of" relation. | |
| ricerca | 2 | 0 | |||
| sample_categories | 29 | 0 | |||
| sample_dimension | 1 | 0 | Deprecated. Stores sample ids. | ||
| set_type | 1 | 3 | 8 | ||
| set_upload_status | 1 | 13 | 0 | ||
| source_master | 3 | 0 | |||
| storage_system | 1 | 6 | 0 | Registered storage instances. | |
| study | 2 | 1 | 5 | 0 | Table holds studies and their access tokens |
| supported_workflow | 7 | 0 | Registers arvados workflows. | ||
| timers | 6 | 0 | |||
| trial_visit_dimension | 1 | 1 | 5 | 0 | Table holds descriptions of trial visits, which represent relative time points in a study. |
| upload_status | 14 | 0 | |||
| visit_dimension | 1 | 1 | 15 | 0 | Table holds descriptions of actual visits in real time. |
| 56 Tables | 434 | 383 | |||
| 1 View | 14 |