SchemaSpy Analysis of transmart.i2b2metadata | 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 |
---|---|---|---|---|---|
custom_meta | 25 | 0 | |||
dimension_description | 1 | 9 | 0 | All supported dimensions and their properties. | |
i2b2 | 26 | 0 | DEPRECATED. Holds all nodes in the i2b2 tree. Redundant, as the same data is in i2b2_secure. | ||
i2b2_secure | 27 | 1 | The same as i2b2, but with an added security token. | ||
i2b2_tag_options | 1 | 1 | 3 | 0 | |
i2b2_tag_types | 1 | 7 | 0 | ||
i2b2_tags | 1 | 6 | 0 | ||
i2b2_trial_nodes | 2 | view | |||
ont_db_lookup | 12 | 0 | |||
ont_process_status | 12 | 0 | |||
schemes | 3 | 15 | |||
study_dimension_descriptions | 1 | 2 | 0 | ||
table_access | 23 | 0 | |||
tmp_secure_token | 2 | 0 | |||
13 Tables | 157 | 16 | |||
1 View | 2 |