Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
Username | varchar | 50 | null |
|
|
|||
CareID | int | 4 | null |
|
|
|||
CancerSite | varchar | 25 | null |
|
|
|||
NHSNumber | varchar | 10 | √ | null |
|
|
||
HospitalNumber | varchar | 50 | √ | null |
|
|
||
Surname | varchar | 60 | √ | null |
|
|
||
Forename | varchar | 50 | √ | null |
|
|
||
DiscussionDate | smalldatetime | 16 | √ | null |
|
|
||
isoDiscussionDate | varchar | 10 | √ | null |
|
|
||
MeetingType | varchar | 250 | √ | null |
|
|
||
DiscussionType | varchar | 40 | √ | null |
|
|
||
DateOfDiagnosis | smalldatetime | 16 | √ | null |
|
|
||
isoDateOfDiagnosis | varchar | 10 | √ | null |
|
|
||
Diagnosis | varchar | 250 | √ | null |
|
|
||
referralLink | varchar | 100 | √ | null |
|
|
||
Subtype | varchar | 100 | √ | null |
|
|
||
MDTListType | varchar | 50 | √ | null |
|
|
||
Consultant | varchar | 50 | √ | null |
|
|
||
DiscussionTypeCode | varchar | 2 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors