| 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 |