tmpNOGCA_HGD


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NOGCAHGDID int identity 4 √ null
CareID int 4 √ null
NHSNumber varchar 50 √ null
DateOfBirth datetime2 54 √ null
HospitalNumber varchar 50 √ null
RouteOfReferral varchar 2 √ null
DateOfBiopsy smalldatetime 16 √ null
HospitalBiopsy varchar 5 √ null
AppearanceOfHGD int 4 √ null
BarrettsSegment int 4 √ null
LengthCircColumnarLining varchar 5 √ null
MaxLengthColumnarLining varchar 5 √ null
DiagnosisConfirmed varchar 2 √ null
HospitalPlan varchar 5 √ null
DatePlanAgreed smalldatetime 16 √ null
TreatmentAgreedAtMDT varchar 1 √ null
InitialTreatmentModality varchar 2 √ null
ReferredToSpecialistHosp varchar 2 √ null
UseOfEMR int 4 √ null
EMRDate smalldatetime 16 √ null
EMRResults int 4 √ null
EMRPathology int 4 √ null
Username varchar 50 √ null
Comorbidities varchar 30 √ null
HospitalInitialTreatment char 5 √ null
DateInitialTreatment datetime 16,3 √ null
TreatmentPlanReason int 4 √ null
NextSurveillanceEndoscopy int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tmpNOGCA_HGD Primary key Asc NOGCAHGDID

Diagram producer might be missing

No diagrams were produced please see application output for any errors