Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||
| Cancer Site | varchar | 50 | √ | null |
|
|
||
| NHS Number | varchar | 10 | √ | null |
|
|
||
| Hospital Number | varchar | 20 | √ | null |
|
|
||
| Full Name | varchar | 111 | √ | null |
|
|
||
| Diagnostic Investigation | varchar | 50 | √ | null |
|
|
||
| Other Investigation | varchar | 50 | √ | null |
|
|
||
| Date Requested | date | 20 | √ | null |
|
|
||
| Requested By | varchar | 50 | √ | null |
|
|
||
| Organisation | nvarchar | 500 | √ | null |
|
|
||
| Anaesthesia Required | varchar | 3 | √ | null |
|
|
||
| Pre-Booked Investigation | varchar | 3 | √ | null |
|
|
||
| Date Performed | date | 20 | √ | null |
|
|
||
| Requested-Performed Time Lapse | int | 4 | √ | null |
|
|
||
| Reported Date | date | 20 | √ | null |
|
|
||
| Performed-Reported Time Lapse | int | 4 | √ | null |
|
|
||
| Biopsy Taken | varchar | 3 | √ | null |
|
|
||
| Outcome | varchar | 30 | √ | null |
|
|
||
| Comments | text | 2147483647 | √ | null |
|
|
||
| Reason Not Performed | varchar | 50 | √ | null |
|
|
||
| Other Reason Not Performed | varchar | 40 | √ | null |
|
|
||
| Imaging Code(NICIP) | varchar | 6 | √ | null |
|
|
||
| Imaging Code (SNOMed CT) | varchar | 18 | √ | null |
|
|
||
| Anatomical Site 1 | varchar | 255 | √ | null |
|
|
||
| Anatomical Site 2 | varchar | 255 | √ | null |
|
|
||
| Anatomical Site 3 | varchar | 255 | √ | null |
|
|
||
| Anatomical Side | varchar | 40 | √ | null |
|
|
||
| Imaging Report Text | text | 2147483647 | √ | null |
|
|
||
| Primary Lesion Size | real | 4 | √ | null |
|
|
||
| Radiologist | varchar | 50 | √ | null |
|
|
||
| Platelet Count | int | 4 | √ | null |
|
|
||
| HB Concentration | real | 4 | √ | null |
|
|
||
| Bone Marrow Blasts (%) | int | 4 | √ | null |
|
|
||
| Neutrophil Count | real | 4 | √ | null |
|
|
||
| Albumin Level | int | 4 | √ | null |
|
|
||
| Beta 2 Microglobulin | real | 4 | √ | null |
|
|
||
| Lymphocyte Count | real | 4 | √ | null |
|
|
||
| Blood Myeloblasts | int | 4 | √ | null |
|
|
||
| Blood Basophils | int | 4 | √ | null |
|
|
||
| Blood Eosinophils | int | 4 | √ | null |
|
|
||
| % Predicted / FEV1 | real | 4 | √ | null |
|
|
||
| Absolute Figure / FEV1 | real | 4 | √ | null |
|
|
||
| Staging Laparoscopy Performed | varchar | 3 | √ | null |
|
|
||
| FBC | varchar | 3 | √ | null |
|
|
||
| U&E | varchar | 3 | √ | null |
|
|
||
| LFT | varchar | 3 | √ | null |
|
|
||
| ECG | varchar | 3 | √ | null |
|
|
||
| Group Save | varchar | 3 | √ | null |
|
|
||
| X Match | varchar | 3 | √ | null |
|
|
||
| Calcium | varchar | 3 | √ | null |
|
|
||
| CA 15-3 | varchar | 3 | √ | null |
|
|
||
| Other | varchar | 3 | √ | null |
|
|
||
| Radiological T Stage | varchar | 6 | √ | null |
|
|
||
| Radiological N Stage | varchar | 6 | √ | null |
|
|
||
| Radiological M Stage | varchar | 6 | √ | null |
|
|