| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||||||
| body_part | varchar | 255 | null |
|
|
|||||||||
| completeness | int4 | 10 | null |
|
|
|||||||||
| compress_failures | int4 | 10 | null |
|
|
|||||||||
| compress_params | varchar | 255 | √ | null |
|
|
||||||||
| compress_time | timestamp | 29,6 | √ | null |
|
|
||||||||
| compress_tsuid | varchar | 255 | √ | null |
|
|
||||||||
| created_time | timestamp | 29,6 | null |
|
|
|||||||||
| expiration_date | varchar | 255 | √ | null |
|
|
||||||||
| expiration_exporter_id | varchar | 255 | √ | null |
|
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| series_pkey | Primary key | Asc | pk |
| fk_1og1krtgxfh207rtqjg0r7pbd | Performance | Asc | study_fk |
| fk_5n4bxxb2xa7bvvq26ao7wihky | Performance | Asc | perf_phys_name_fk |
| fk_avp2oeuufo8axv5j184cchrop | Performance | Asc | dept_code_fk |
| fk_oiq81nulcmtg6p85iu31igtf5 | Performance | Asc | inst_code_fk |
| fk_pu4p7k1o9hleuk9rmxvw2ybj6 | Performance | Asc | metadata_fk |
| series_desc_upper_idx | Performance | ||
| uk_1e4aqxc5w1557hr3fb3lqm2qb | Performance | Asc | sending_hl7_facility |
| uk_38mfgfnjhan2yhnwqtcrawe4 | Performance | Asc | compress_time |
| uk_4lnegvfs65fbkjn7nmg9s8usy | Performance | Asc | completeness |
