| SchemaSpy Analysis of pacsdb.public | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue Jan 28 14:54 CET 2020 | |
| Database Type: PostgreSQL - 9.6.8 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| code | 12 | 5 | 0 | ||
| content_item | 3 | 6 | 0 | ||
| dicomattrs | 9 | 2 | 0 | ||
| diff_task | 1 | 1 | 14 | 0 | |
| diff_task_attrs | 2 | 2 | 0 | ||
| export_task | 1 | 14 | 0 | ||
| global_subscription | 1 | 4 | 0 | ||
| hl7psu_task | 1 | 7 | 0 | ||
| ian_task | 1 | 7 | 0 | ||
| id_sequence | 3 | 0 | |||
| instance | 3 | 3 | 21 | 0 | |
| issuer | 7 | 4 | 0 | ||
| location | 2 | 12 | 0 | ||
| metadata | 1 | 7 | 0 | ||
| mpps | 2 | 4 | 14 | 0 | |
| mwl_item | 1 | 4 | 16 | 0 | |
| patient | 5 | 5 | 18 | 0 | |
| patient_id | 1 | 1 | 5 | 0 | |
| person_name | 9 | 16 | 0 | ||
| queue_msg | 4 | 18 | 0 | ||
| rejected_instance | 1 | 7 | 0 | ||
| rel_study_pcode | 2 | 2 | 0 | ||
| rel_ups_perf_code | 2 | 2 | 0 | ||
| retrieve_task | 1 | 20 | 0 | ||
| series | 3 | 5 | 46 | 0 | |
| series_query_attrs | 1 | 7 | 0 | ||
| series_req | 3 | 9 | 0 | ||
| soundex_code | 1 | 5 | 0 | ||
| sps_station_aet | 1 | 2 | 0 | ||
| stgcmt_result | 14 | 0 | |||
| stgver_task | 1 | 13 | 0 | ||
| study | 3 | 4 | 29 | 0 | |
| study_query_attrs | 1 | 9 | 0 | ||
| subscription | 1 | 4 | 0 | ||
| uidmap | 1 | 2 | 0 | ||
| ups | 3 | 7 | 24 | 0 | |
| ups_req | 3 | 8 | 0 | ||
| verify_observer | 2 | 4 | 0 | ||
| 38 Tables | 402 | 0 | |||
| 0 Views | 0 |