tblRDCPresentation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblRDCPresentation_tblMAIN_REFERRALSC
SymptomsAbnormalLabFinding bit 1 ((0))
SymptomsAbnormalRadSugCan bit 1 ((0))
SymptomsAnaemia bit 1 ((0))
SymptomsBloating bit 1 ((0))
SymptomsFatigue bit 1 ((0))
SymptomsGPGutFeeling bit 1 ((0))
SymptomsJaundice bit 1 ((0))
SymptomsLossOfAppetite bit 1 ((0))
SymptomsMalaise bit 1 ((0))
SymptomsNauseaVomiting bit 1 ((0))
SymptomsOther bit 1 ((0))
SymptomsProgPain bit 1 ((0))
SymptomsUnexpBreathlessness bit 1 ((0))
SymptomsUnexpThrombo bit 1 ((0))
SymptomsUnexpWeightLoss bit 1 ((0))
SymptomsUnknown bit 1 ((0))
SymptomsVagueAbdoPain bit 1 ((0))
SymptomsOtherNotes varchar 500 √ null
NbrConsBefReferral int 4 √ null
TestsFBC bit 1 ((0))
TestsESR_CRP bit 1 ((0))
TestsClotting bit 1 ((0))
TestsLDH bit 1 ((0))
TestsLFTSInclGlobs bit 1 ((0))
TestsGGT bit 1 ((0))
TestsCA_125 bit 1 ((0))
TestsPSA bit 1 ((0))
TestsProtEP bit 1 ((0))
TestsHBA1c bit 1 ((0))
TestsTFTS bit 1 ((0))
TestsHIV bit 1 ((0))
TestsCXR bit 1 ((0))
TestsFIT bit 1 ((0))
TestsURINE bit 1 ((0))
TestsUltrasound bit 1 ((0))
TestsBone bit 1 ((0))
TestsFerritinFolate bit 1 ((0))
TestsTTG_AB bit 1 ((0))
TestsGlucose bit 1 ((0))
TestsOther bit 1 ((0))
TestsNo bit 1 ((0))
TestsOtherNotes varchar 500 √ null
ACTION_ID int 4 √ null
NbrConsBefReferralUnknown bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_tblRDCPresentation Primary key Asc CareID

Relationships

Close relationships within degrees of separation