Investigations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
_Deprecated_21_01_LabTestResults.InvestigationId FK_dbo.LabTestResults_dbo.Investigations_InvestigationIdC
_Deprecated_21_01_TumourMarkerResults.InvestigationId FK_dbo.TumourMarkerResults_dbo.Investigations_InvestigationIdC
BloodTestResults.InvestigationId FK_dbo.BloodTestResults_dbo.Investigations_InvestigationIdC
BreastInvestigationResults.InvestigationId FK_dbo.BreastInvestigationResults_dbo.Investigations_InvestigationIdC
InvestigationReviewStatuses.InvestigationId FK_dbo.InvestigationReviewStatuses_dbo.Investigations_InvestigationIdC
ReferralId int 4 null
Referrals.Id FK_dbo.Investigations_dbo.Referrals_ReferralIdC
InvestigationTypeId int 4 null
InvestigationTypes.Id FK_dbo.Investigations_dbo.InvestigationTypes_InvestigationTypeIdC
DateRequested datetime 16,3 √ null
DatePerformed datetime 16,3 √ null
DateReported datetime 16,3 √ null
OrganisationId int 4 √ null
Organisations.Id FK_dbo.Investigations_dbo.Organisations_OrganisationIdR
AnatomicalSite1Id int 4 √ null
AnatomicalSites.Id FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite1IdR
AnatomicalSite2Id int 4 √ null
AnatomicalSites.Id FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite2IdR
AnatomicalSite3Id int 4 √ null
AnatomicalSites.Id FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite3IdR
AnatomicalSideId int 4 √ null
AnatomicalSides.Id FK_dbo.Investigations_dbo.AnatomicalSides_AnatomicalSideIdR
InvestigationOutcomeId int 4 √ null
InvestigationOutcomes.Id FK_dbo.Investigations_dbo.InvestigationOutcomes_InvestigationOutcomeIdR
BiopsyTakenId int 4 √ null
RequestedById int 4 √ null
ReportText nvarchar 1073741823 √ null
TNMStage nvarchar 1073741823 √ null
TNMVersion nvarchar 1073741823 √ null
TNM_Rad_TValueId int 4 √ null
TNM_T_Value.Id FK_dbo.Investigations_dbo.TNM_T_Value_TNM_Rad_TValueIdR
TNM_Rad_TLetterId int 4 √ null
TNM_T_Letter.Id FK_dbo.Investigations_dbo.TNM_T_Letter_TNM_Rad_TLetterIdR
TNM_Rad_NValueId int 4 √ null
TNM_N_Value.Id FK_dbo.Investigations_dbo.TNM_N_Value_TNM_Rad_NValueIdR
TNM_Rad_NLetterId int 4 √ null
TNM_N_Letter.Id FK_dbo.Investigations_dbo.TNM_N_Letter_TNM_Rad_NLetterIdR
TNM_Rad_MValueId int 4 √ null
TNM_M_Value.Id FK_dbo.Investigations_dbo.TNM_M_Value_TNM_Rad_MValueIdR
TNM_Rad_MLetterId int 4 √ null
TNM_M_Letter.Id FK_dbo.Investigations_dbo.TNM_M_Letter_TNM_Rad_MLetterIdR
TNM_Rad_VersionId int 4 √ null
TNMRadVersion_Id int 4 √ null
TNMVersions.Id FK_dbo.Investigations_dbo.TNMVersions_TNMRadVersion_IdR
ActivityId int 4 √ null
Activities.Id FK_dbo.Investigations_dbo.Activities_ActivityIdR
DateDeleted datetime 16,3 √ null
InformationForPatient nvarchar 1073741823 √ null
TNM_Rad_EditionId int 4 √ null
TNMRadEdition_Id int 4 √ null
TNMEditions.Id FK_dbo.Investigations_dbo.TNMEditions_TNMRadEdition_IdR
PortalId uniqueidentifier 16 (newid())

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Investigations Primary key Asc Id
IX_ActivityId Performance Asc ActivityId
IX_AnatomicalSideId Performance Asc AnatomicalSideId
IX_AnatomicalSite1Id Performance Asc AnatomicalSite1Id
IX_AnatomicalSite2Id Performance Asc AnatomicalSite2Id
IX_AnatomicalSite3Id Performance Asc AnatomicalSite3Id
IX_InvestigationOutcomeId Performance Asc InvestigationOutcomeId
IX_InvestigationPerformedSort Performance Asc/Asc/Desc Id + ReferralId + DatePerformed
IX_InvestigationTypeId Performance Asc InvestigationTypeId
IX_OrganisationId Performance Asc OrganisationId
IX_ReferralId Performance Asc ReferralId
IX_TNM_Rad_MLetterId Performance Asc TNM_Rad_MLetterId
IX_TNM_Rad_MValueId Performance Asc TNM_Rad_MValueId
IX_TNM_Rad_NLetterId Performance Asc TNM_Rad_NLetterId
IX_TNM_Rad_NValueId Performance Asc TNM_Rad_NValueId
IX_TNM_Rad_TLetterId Performance Asc TNM_Rad_TLetterId
IX_TNM_Rad_TValueId Performance Asc TNM_Rad_TValueId
IX_TNMRadEdition_Id Performance Asc TNMRadEdition_Id
IX_TNMRadVersion_Id Performance Asc TNMRadVersion_Id

Relationships

Close relationships within degrees of separation