Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| na_accessionnumber | varchar | 25 | √ | null |
|
|
||
| co_patientid | int | 4 | null |
|
|
|||
| na_patientname | varchar | 70 | √ | null |
|
|
||
| co_performingid | int | 4 | √ | null |
|
|
||
| na_performingname | int | 4 | √ | null |
|
|
||
| na_performingcrm | int | 4 | √ | null |
|
|
||
| na_performinguf | int | 4 | √ | null |
|
|
||
| na_performingemail | int | 4 | √ | null |
|
|
||
| na_bodypart | int | 4 | √ | null |
|
|
||
| na_patientsex | varchar | 1 | √ | null |
|
|
||
| na_patientbirthday | varchar | 10 | √ | null |
|
|
||
| na_patientweight | RMDVALOR2 | 17,2 | √ | null |
|
|
||
| na_patientheight | RMDVALOR2 | 17,2 | √ | null |
|
|
||
| co_requesterid | int | 4 | √ | null |
|
|
||
| na_requestername | varchar | 50 | √ | null |
|
|
||
| na_requestercrm | varchar | 15 | √ | null |
|
|
||
| na_requesteremail | varchar | 50 | √ | null |
|
|
||
| na_requesteruf | varchar | 2 | √ | null |
|
|
||
| na_description | varchar | 100 | √ | null |
|
|
||
| na_studydate | varchar | 10 | √ | null |
|
|
||
| na_studytime | varchar | 8000 | √ | null |
|
|
||
| na_modalityris | varchar | 10 | √ | null |
|
|
||
| na_requestingservice | varchar | 100 | √ | null |
|
|
||
| na_requireunit | varchar | 100 | √ | null |
|
|
||
| na_studyid | varchar | 90 | √ | null |
|
|
||
| na_password | varchar | 10 | √ | null |
|
|
||
| na_insuranceplan | varchar | 40 | √ | null |
|
|
||
| na_stepstatus | varchar | 12 | √ | null |
|
|