Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ReferralID | int | 4 | null |
|
|
|||||
| CancerComplicationsMsccSuspected | int | 4 | √ | null |
|
|
||||
| CancerComplicationsImagingRequested | int | 4 | √ | null |
|
|
||||
| CancerComplicationsImagingNotRequestedReason | varchar | 250 | √ | null |
|
|
||||
| CancerComplicationsSvco | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsAscites | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsPluralEffusion | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsTamponade | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsPeDvt | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsPain | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsOtherMetabolic | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsHypercalcaemia | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsVte | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsBrainMets | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsOtherCns | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsOtherTypeProgression | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsOther | bit | 1 | ((0)) |
|
|
|||||
| CancerComplicationsOtherDesc | varchar | 250 | √ | null |
|
|
||||
| CancerComplicationsAdditionalComplications | varchar | 2147483647 | √ | null |
|
|
||||
| TreatmentComplicationsNeutropenicSepsisSuspected | int | 4 | √ | null |
|
|
||||
| TreatmentComplicationsAnitibioticAdministered | int | 4 | √ | null |
|
|
||||
| TreatmentComplicationsAnitibioticNotAdministeredReason | varchar | 250 | √ | null |
|
|
||||
| TreatmentComplicationsOtherSepsis | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsMyelosuppression | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsBiochemicalMetabolic | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsDermatological | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsDiarrhoeaChemo | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsDiarrhoeaRt | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsOtherRtEffects | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsPeDvt | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsEmesis | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsExtravasation | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsVte | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsOther | bit | 1 | ((0)) |
|
|
|||||
| TreatmentComplicationsOtherDesc | varchar | 250 | √ | null |
|
|
||||
| TreatmentComplicationsAdditionalComplications | varchar | 2147483647 | √ | null |
|
|
||||
| CurrentTreatmentID | varchar | 2 | √ | null |
|
|
||||
| CurrentTreatmentOther | varchar | 250 | √ | null |
|
|
||||
| CurrentTreatmentIntentID | int | 4 | √ | null |
|
|
||||
| ClinicalTrial | int | 4 | √ | null |
|
|
||||
| TreatmentLastReceivedDate | datetime | 16,3 | √ | null |
|
|
||||
| TreatmentRegimenID | int | 4 | √ | null |
|
|
||||
| CurrentRegimenCycle | int | 4 | √ | null |
|
|
||||
| OncologistHaematologistID | int | 4 | √ | null |
|
|
||||
| PrimaryTreatmentCentreID | int | 4 | √ | null |
|
|
||||
| CancerComplicationsCancerProgression | bit | 1 | ((0)) |
|
|
|||||
| AuditID | int | 4 | √ | null |
|
|
||||
| TreatmentRegimenOther | varchar | 250 | √ | null |
|
|
||||
| CancerComplicationsShortnessOfBreath | bit | 1 | ((0)) |
|
|
|||||
| OtherConsultantHaematologist | varchar | 250 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblAO_COMPLICATIONS_TREATMENT | Primary key | Asc | ReferralID |