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 |
|
|
||||
instance_fk | int8 | 19 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
instance_req_pkey | Primary key | Asc | pk |
fk_47n586hkafgp9m1etqohgfybl | Performance | Asc | instance_fk |
fk_cqmmps9maltjybl44t4cck404 | Performance | Asc | req_phys_name_fk |
uk_1typgaxhn4d0pt1f0vlp18wvb | Performance | Asc | study_iuid |
uk_43h9ogidkcnex0e14q6u0c3jn | Performance | Asc | sps_id |
uk_7pudwdgrg9wwc73wo65hpg517 | Performance | Asc | req_proc_id |
uk_cqpv94ky100d0eguhrxpyplmv | Performance | Asc | accession_no |
uk_n32ktg5h9xc1ex9x8g69w1s10 | Performance | Asc | req_service |