Practices


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
Patients.RegisteredPracticeId FK_dbo.Patients_dbo.Practices_RegisteredPracticeIdR
PracticeGPAssociations.PracticeId FK_dbo.PracticeGPAssociations_dbo.Practices_PracticeIdC
Code nvarchar 12 √ null
AddressLine1 nvarchar 500 √ null
AddressLine2 nvarchar 500 √ null
AddressLine3 nvarchar 500 √ null
AddressLine4 nvarchar 500 √ null
Postcode nvarchar 40 √ null
IsDeleted bit 1 null
AddressLine5 nvarchar 500 √ null

Indexes

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

Relationships

Close relationships within degrees of separation