Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CareID | int | 4 | null |
|
|
|||||
| CancerSite | varchar | 30 | √ | null |
|
|
||||
| Subtype | varchar | 30 | √ | null |
|
|
||||
| NHSNumber | varchar | 10 | √ | null |
|
|
||||
| HospitalNumber | varchar | 25 | √ | null |
|
|
||||
| PatientName | varchar | 120 | √ | null |
|
|
||||
| DateReceiptReferral | date | 20 | √ | null |
|
|
||||
| DateConsultantUpgrade | date | 20 | √ | null |
|
|
||||
| ReferralPriority | varchar | 20 | √ | null |
|
|
||||
| PatientStatus | varchar | 75 | √ | null |
|
|
||||
| FDSClockStopDate | date | 20 | √ | null |
|
|
||||
| PathwayEndDate | date | 20 | √ | null |
|
|
||||
| TimedPathwayVersionID | int | 4 | null |
|
|
|||||
| TimedPathwayName | varchar | 100 | null |
|
|
|||||
| DateFirstAppointment | date | 20 | √ | null |
|
|
||||
| DateDiagnosis | date | 20 | √ | null |
|
|
||||
| Diagnosis | varchar | 150 | √ | null |
|
|
||||
| FasterDiagnosisEndReason | varchar | 30 | √ | null |
|
|
||||
| PPI | varchar | 20 | √ | null |
|
|
||||
| Username | varchar | 100 | null |
|
|
Relationships
Close relationships within degrees of separation
