| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||||||||||
| created_time | timestamp | 29,6 | null |
|
|
|||||||||||||
| failed_verifications | int4 | 10 | null |
|
|
|||||||||||||
| num_studies | int4 | 10 | null |
|
|
|||||||||||||
| pat_birthdate | varchar | 255 | null |
|
|
|||||||||||||
| pat_custom1 | varchar | 255 | null |
|
|
|||||||||||||
| pat_custom2 | varchar | 255 | null |
|
|
|||||||||||||
| pat_custom3 | varchar | 255 | null |
|
|
|||||||||||||
| pat_sex | varchar | 255 | null |
|
|
|||||||||||||
| updated_time | timestamp | 29,6 | null |
|
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| patient_pkey | Primary key | Asc | pk |
| fk_39gahcxyursxfxe2ucextr65s | Performance | Asc | patient_id_fk |
| fk_56r2g5ggptqgcvb3hl11adke2 | Performance | Asc | resp_person_fk |
| fk_rj42ffdtimnrcwmqqlvj24gi2 | Performance | Asc | pat_name_fk |
| fk_sk77bwjgaoetvy1pbcgqf08g | Performance | Asc | merge_fk |
| uk_1ho1jyofty54ip8aqpuhi4mu1 | Performance | Asc | pat_birthdate |
| uk_296rccryifu6d8byisl2f4dvq | Performance | Asc | num_studies |
| uk_39gahcxyursxfxe2ucextr65s | Must be unique | Asc | patient_id_fk |
| uk_3ioui3yamjf01yny98bliqfgs | Performance | Asc | pat_custom3 |
| uk_545wp9un24fhgcy2lcfu1o04y | Performance | Asc | pat_sex |
