TABLES
37
VIEWS
0
COLUMNS
395
Constraints
60
Anomalies
15
Routines
0
Database Properties
Database Type: PostgreSQL - 14.2 (Debian 14.2-1.pgdg110+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| person_name | 9 | 3 | 4 | 0 | Table | |
| location | 0 | 2 | 12 | 0 | Table | |
| global_subscription | 0 | 1 | 4 | 0 | Table | |
| mpps | 2 | 3 | 16 | 0 | Table | |
| content_item | 0 | 3 | 6 | 0 | Table | |
| ian_task | 0 | 2 | 7 | 0 | Table | |
| study | 3 | 3 | 35 | 0 | Table | |
| id_sequence | 10 | 0 | 3 | 0 | Table | |
| sps_station_aet | 0 | 1 | 2 | 0 | Table | |
| mwl_item | 1 | 5 | 27 | 0 | Table | |
| ups | 6 | 3 | 23 | 0 | Table | |
| verify_observer | 0 | 2 | 4 | 0 | Table | |
| soundex_code | 0 | 1 | 5 | 0 | Table | |
| hl7psu_task | 0 | 2 | 9 | 0 | Table | |
| series_query_attrs | 0 | 1 | 7 | 0 | Table | |
| rel_ups_perf_code | 0 | 2 | 2 | 0 | Table | |
| task | 1 | 2 | 44 | 0 | Table | |
| series | 3 | 7 | 54 | 0 | Table | |
| ups_req | 0 | 2 | 10 | 0 | Table | |
| dicomattrs | 9 | 0 | 2 | 0 | Table | |
| subscription | 0 | 1 | 4 | 0 | Table | |
| instance | 3 | 3 | 21 | 0 | Table | |
| stgcmt_result | 0 | 1 | 14 | 0 | Table | |
| patient_demographics | 1 | 1 | 4 | 0 | Table | |
| rel_ups_station_name_code | 0 | 2 | 2 | 0 | Table | |
| rel_ups_station_location_code | 0 | 2 | 2 | 0 | Table | |
| code | 15 | 0 | 5 | 0 | Table | |
| series_req | 0 | 2 | 11 | 0 | Table | |
| rel_task_dicomattrs | 0 | 2 | 2 | 0 | Table | |
| study_query_attrs | 0 | 1 | 9 | 0 | Table | |
| rel_study_pcode | 0 | 2 | 2 | 0 | Table | |
| rel_ups_station_class_code | 0 | 2 | 2 | 0 | Table | |
| patient | 5 | 5 | 18 | 0 | Table | |
| patient_id | 1 | 1 | 7 | 0 | Table | |
| metadata | 1 | 0 | 7 | 0 | Table | |
| rejected_instance | 0 | 1 | 7 | 0 | Table | |
| uidmap | 1 | 0 | 2 | 0 | Table |