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