Consultants


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
BreastSwitches.AuthorisedByConsultantId FK_dbo.BreastSwitches_dbo.Consultants_AuthorisedByConsultantIdR
Diagnosis.ConsultantAtDiagnosisId FK_dbo.Diagnosis_dbo.Consultants_ConsultantAtDiagnosisIdR
Referrals.ConsultantId FK_dbo.Referrals_dbo.Consultants_ConsultantIdR
Code nvarchar 16 √ null
LocalCode nvarchar 1073741823 √ null
TitleId int 4 √ null
ConsultantTitles.Id FK_dbo.Consultants_dbo.ConsultantTitles_TitleIdR
Name nvarchar 1073741823 √ null
Specialty nvarchar 1073741823 √ null
IsDeleted bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Consultants Primary key Asc Id
IX_TitleId Performance Asc TitleId

Relationships

Close relationships within degrees of separation