GPs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 null
BreastSwitches.AuthorisedByGPId FK_dbo.BreastSwitches_dbo.GPs_AuthorisedByGPIdR
Patients.RegisteredGPId FK_dbo.Patients_dbo.GPs_RegisteredGPIdR
PracticeGPAssociations.GPId FK_dbo.PracticeGPAssociations_dbo.GPs_GPIdC
Code nvarchar 16 null
Name nvarchar 200 null
IsDeleted bit 1 null
Unknown bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.GPs Primary key Asc Id

Relationships