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
OrganisationId int 4 √ null
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))
_Deprecated_CareProfessionalId int 4 √ null
_Shared_CareProfessionalId int 4 √ null
_Deprecated_OrganisationId int 4 √ null
_Shared_OrganisationId int 4 √ null

Indexes

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

Relationships

Close relationships within degrees of separation