Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||
| accession_no | varchar | 255 | null |
|
|
|||||
| req_proc_id | varchar | 255 | null |
|
|
|||||
| req_service | varchar | 255 | null |
|
|
|||||
| study_iuid | varchar | 255 | null |
|
|
|||||
| accno_issuer_fk | int8 | 19 | √ | null |
|
|
||||
| req_phys_name_fk | int8 | 19 | √ | null |
|
|
||||
| ups_fk | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ups_req_pkey | Primary key | Asc | pk |
| fk_7vt6m05r0hertks2fcngd5wn1 | Performance | Asc | ups_fk |
| fk_gegm1c1ymem7tj2wcm0o7e0pu | Performance | Asc | accno_issuer_fk |
| fk_kocdb2pxx2fymu1modhneb4xm | Performance | Asc | req_phys_name_fk |
| uk_524vr0q4c0kvyjwov74eru44x | Performance | Asc | req_proc_id |
| uk_emsk27nclko11ph2tcj5vk7hg | Performance | Asc | req_service |
| uk_hf0tly8umknn77civcsi0tdih | Performance | Asc | study_iuid |
| uk_rfium2ybikqm1f4xmi24mnv4u | Performance | Asc | accession_no |
Relationships
Close relationships within degrees of separation
