Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ASSESSMENT_ID | int | 4 | null |
|
|
|||||||||
SuspectedRecurrence | int | 4 | √ | null |
|
|
||||||||
SuspectedNewTumour | int | 4 | √ | null |
|
|
||||||||
PlannedWeeksNextAppt | int | 4 | √ | null |
|
|
||||||||
ClinicianLetterDate | date | 20 | √ | null |
|
|
||||||||
ClinicianLetterCopied | int | 4 | √ | null |
|
|
||||||||
RadiologyReportDate | date | 20 | √ | null |
|
|
||||||||
RadiologyReportCopied | int | 4 | √ | null |
|
|
||||||||
PathologyReportDate | date | 20 | √ | null |
|
|
||||||||
PathologyReportCopied | int | 4 | √ | null |
|
|
||||||||
MDTDiscussionSuspResultsDate | date | 20 | √ | null |
|
|
||||||||
MouthOpeningPreTreat | int | 4 | √ | null |
|
|
||||||||
MouthOpeningPostTreat | int | 4 | √ | null |
|
|
||||||||
SuspectedRecurrenceSite | varchar | 5 | √ | null |
|
|
||||||||
SuspectedRecurrenceSide | varchar | 1 | √ | null |
|
|
||||||||
SuspectedNewTumourSite | int | 4 | √ | null |
|
|
||||||||
SuspectedNewTumourSide | varchar | 1 | √ | null |
|
|
||||||||
ConfirmedRecurrenceSite | int | 4 | √ | null |
|
|
||||||||
MouthMeasurementSite | int | 4 | √ | null |
|
|
||||||||
PostTreatRadioDiscussed | int | 4 | √ | null |
|
|
||||||||
SuspectedNewTumourSiteHeadNeck | varchar | 5 | √ | null |
|
|
||||||||
OtherComplications | varchar | 1024 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_tblHANA_Follow_Up | Primary key | Asc | ASSESSMENT_ID |