Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||
| accession_no | varchar | 255 | null |
|
|
|||||
| accno_entity_id | varchar | 255 | √ | null |
|
|
||||
| accno_entity_uid | varchar | 255 | √ | null |
|
|
||||
| accno_entity_uid_type | varchar | 255 | √ | null |
|
|
||||
| req_proc_id | varchar | 255 | null |
|
|
|||||
| req_service | varchar | 255 | null |
|
|
|||||
| sps_id | varchar | 255 | null |
|
|
|||||
| study_iuid | varchar | 255 | null |
|
|
|||||
| req_phys_name_fk | int8 | 19 | √ | null |
|
|
||||
| series_fk | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| series_req_pkey | Primary key | Asc | pk |
| fk15lid2bqbrsmjatxiq0vug4wq | Performance | Asc | req_phys_name_fk |
| fk1gs2u7w7uefvi7dcjg9vlp23x | Performance | Asc | series_fk |
| idx4uq79j30ind90jjs68gb24j6e | Performance | Asc | sps_id |
| idxcrnpneoalwq25p795xtrhbx2 | Performance | Asc | study_iuid |
| idxl1fg3crmk6pjeu1x36e25h6p4 | Performance | Asc | req_service |
| idxm4wanupyq3yldxgh3pbo7t68h | Performance | Asc | accession_no |
| idxp9w1wg4031w6y66w4xhx1ffay | Performance | Asc | req_proc_id |
| series_req_req_phys_name_fk_key | Must be unique | Asc | req_phys_name_fk |
Relationships
Close relationships within degrees of separation
