Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CareID | int | 4 | null |
|
|
|||
PatientID | int | 4 | null |
|
|
|||
NHSNumber | varchar | 10 | √ | null |
|
|
||
HospitalNumber | varchar | 50 | √ | null |
|
|
||
DateOfBirth | date | 20 | √ | null |
|
|
||
Surname | varchar | 60 | √ | null |
|
|
||
Forename | varchar | 50 | √ | null |
|
|
||
Postcode | varchar | 10 | √ | null |
|
|
||
Gender | char | 1 | √ | null |
|
|
||
OrgCodeSeen | varchar | 5 | √ | null |
|
|
||
DiagnosisDate | date | 20 | √ | null |
|
|
||
OutpatientReferral | varchar | 2 | √ | null |
|
|
||
IndicatorCode | varchar | 2 | √ | null |
|
|
||
DiagnosisCode | varchar | 5 | √ | null |
|
|
||
PreTStage | varchar | 5 | √ | null |
|
|
||
PreNStage | varchar | 5 | √ | null |
|
|
||
PreMStage | varchar | 5 | √ | null |
|
|
||
TNMUnknown | bit | 1 | null |
|
|
|||
TumourStatus | int | 4 | √ | null |
|
|
||
RecurrenceMetastaticType | int | 4 | √ | null |
|
|
||
CancerSite | varchar | 50 | √ | null |
|
|
||
Username | varchar | 50 | null |
|
|
|||
ClinicalTLetter | varchar | 5 | √ | null |
|
|
||
ClinicalNLetter | varchar | 5 | √ | null |
|
|
||
ClinicalMLetter | varchar | 5 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors