BreastSwitches


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
ReferralId int 4 null
Referrals.Id FK_dbo.BreastSwitches_dbo.Referrals_ReferralIdC
StartDate datetime 16,3 null
EndDate datetime 16,3 √ null
DrugName nvarchar 1073741823 √ null
AuthorisedByConsultantId int 4 √ null
Consultants.Id FK_dbo.BreastSwitches_dbo.Consultants_AuthorisedByConsultantIdR
AuthorisedByGPId int 4 √ null
GPs.Id FK_dbo.BreastSwitches_dbo.GPs_AuthorisedByGPIdR
AuthorisedByCNSId int 4 √ null
CNSs.Id FK_dbo.BreastSwitches_dbo.CNSs_AuthorisedByCNSIdR
OrganisationId int 4 √ null
Organisations.Id FK_dbo.BreastSwitches_dbo.Organisations_OrganisationIdR
ReasonForChangeId int 4 √ null
BreastSwitchChangeReasonTypes.Id FK_dbo.BreastSwitches_dbo.BreastSwitchChangeReasonTypes_ReasonForChangeIdR
ReasonForChangeOther nvarchar 1073741823 √ null
DateDeleted datetime 16,3 √ null
ActivityId int 4 √ null
Activities.Id FK_dbo.BreastSwitches_dbo.Activities_ActivityIdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.BreastSwitches Primary key Asc Id
IX_ActivityId Performance Asc ActivityId
IX_AuthorisedByCNSId Performance Asc AuthorisedByCNSId
IX_AuthorisedByConsultantId Performance Asc AuthorisedByConsultantId
IX_AuthorisedByGPId Performance Asc AuthorisedByGPId
IX_OrganisationId Performance Asc OrganisationId
IX_ReasonForChangeId Performance Asc ReasonForChangeId
IX_ReferralId Performance Asc ReferralId

Relationships

Close relationships within degrees of separation