Patients


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
_Deprecated_20_03_PatientPreferredContact.PatientId FK_dbo._Deprecated_20_03_PatientPreferredContact_dbo.Patients_PatientIdR
PortalRegistrationAuditRecords.PatientId FK_dbo.PortalRegistrationAuditRecords_dbo.Patients_PatientIdC
Referrals.PatientId FK_dbo.Referrals_dbo.Patients_PatientIdC
NhsNumber nvarchar 20 √ null
HospitalNumber nvarchar 40 null
TitleId int 4 √ null
Titles.Id FK_dbo.Patients_dbo.Titles_TitleIdR
FamilyName nvarchar 120 null
GivenName nvarchar 100 null
DateOfBirth datetime 16,3 √ null
GenderId int 4 √ null
Genders.Id FK_dbo.Patients_dbo.Genders_GenderIdR
EthnicityId int 4 √ null
Ethnicities.Id FK_dbo.Patients_dbo.Ethnicities_EthnicityIdR
DayPhone nvarchar 100 √ null
EvePhone nvarchar 100 √ null
EmailAddress nvarchar 100 √ null
AddressLine1 nvarchar 300 √ null
AddressLine2 nvarchar 300 √ null
AddressLine3 nvarchar 300 √ null
AddressLine4 nvarchar 300 √ null
AddressLine5 nvarchar 300 √ null
Postcode nvarchar 20 √ null
Deceased bit 1 null
ContactName nvarchar 500 √ null
ContactRelationship nvarchar 200 √ null
ContactEmail nvarchar 200 √ null
RegisteredGPId int 4 √ null
GPs.Id FK_dbo.Patients_dbo.GPs_RegisteredGPIdR
RegisteredPracticeId int 4 √ null
Practices.Id FK_dbo.Patients_dbo.Practices_RegisteredPracticeIdR
DateDeleted datetime 16,3 √ null
DateOfDeath datetime 16,3 √ null
OptedInSMS bit 1 √ null
OptedInEmail bit 1 √ null
ContactNumber nvarchar 100 √ null
NhsNumberStatusId int 4 ((3))
NhsNumberStatus.Id FK_dbo.Patients_dbo.NhsNumberStatus_NhsNumberStatusIdC
OptedInPatientPortal bit 1 √ null
NotificationSMSId int 4 √ null
PatientNotificationSMS.Id FK_dbo.Patients_dbo.PatientNotificationSMS_NotificationSMSIdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Patients Primary key Asc Id
IX_EthnicityId Performance Asc EthnicityId
IX_GenderId Performance Asc GenderId
IX_NhsNumberStatusId Performance Asc NhsNumberStatusId
IX_NotificationSMSId Performance Asc NotificationSMSId
IX_RegisteredGPId Performance Asc RegisteredGPId
IX_RegisteredPracticeId Performance Asc RegisteredPracticeId
IX_TitleId Performance Asc TitleId

Relationships

Close relationships within degrees of separation