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
AuthorisedByGPId int 4 √ null
AuthorisedByCNSId int 4 √ null
OrganisationId int 4 √ null
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
_Deprecated_AuthorisedByCNSId int 4 √ null
_Shared_AuthorisedByCNSId int 4 √ null
_Deprecated_AuthorisedByConsultantId int 4 √ null
_Shared_AuthorisedByConsultantId int 4 √ null
_Deprecated_AuthorisedByGPId int 4 √ null
_Shared_AuthorisedByGPId int 4 √ null
_Deprecated_OrganisationId int 4 √ null
_Shared_OrganisationId int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.BreastSwitches Primary key Asc Id
IX_ActivityId Performance Asc ActivityId
IX_ReasonForChangeId Performance Asc ReasonForChangeId
IX_ReferralId Performance Asc ReferralId

Relationships

Close relationships within degrees of separation