Reviews


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
ReviewContacts.ReviewId FK_dbo.ReviewContacts_dbo.Reviews_ReviewIdC
ReviewInvestigationTypes.ReviewId FK_dbo.ReviewInvesitgationTypes_dbo.Reviews_ReviewIdC
ReviewOutcomeRecipients.ReviewId FK_dbo.ReviewOutcomeRecipients_dbo.Reviews_ReviewIdC
ReviewDate datetime 16,3 √ null
ActivityId int 4 √ null
Activities.Id FK_dbo.Reviews_dbo.Activities_ActivityIdR
CareProfessionalId int 4 √ null
CNSs.Id FK_dbo.Reviews_dbo.CNSs_CareProfessionalIdR
OrganisationId int 4 √ null
Organisations.Id FK_dbo.Reviews_dbo.Organisations_OrganisationIdR
Comments nvarchar 1073741823 √ null
ReferralID int 4 ((0))
Referrals.Id FK_dbo.Reviews_dbo.Referrals_ReferralIDC
DateDeleted datetime 16,3 √ null
OutcomeId int 4 √ null
ReviewOutcomes.Id FK_dbo.Reviews_dbo.ReviewOutcomes_OutcomeIdR
OtherOutcomeRecipientDetails nvarchar 1073741823 √ null
IsBreastSwitchReview bit 1 ((0))

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Reviews Primary key Asc Id
IX_CareProfessionalId Performance Asc CareProfessionalId
IX_OrganisationId Performance Asc OrganisationId
IX_OutcomeId Performance Asc OutcomeId
IX_ReferralID Performance Asc ReferralID

Relationships

Close relationships within degrees of separation