PracticeGPAssociations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PracticeId int 4 null
Practices.Id FK_dbo.PracticeGPAssociations_dbo.Practices_PracticeIdC
GPId int 4 null
GPs.Id FK_dbo.PracticeGPAssociations_dbo.GPs_GPIdC

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.PracticeGPAssociations Primary key Asc/Asc PracticeId + GPId
IX_GPId Performance Asc GPId
IX_PracticeId Performance Asc PracticeId

Relationships

Close relationships within degrees of separation