Tables [dbo].[Patient_Community]
Patient Community Membership
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Patient_Community_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_Community Table
Indexes NIX_Patient_Community_PatientIDForeign Keys FK_Patient_Community_PatientID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULL((0))Patient Idetifier. Link to Person.ID
Foreign Keys FK_Patient_Community_CommStatusDE: [dbo].[Community_Status_DE].CommStatusDECommStatusDE[dbo].[dict_id]5NOT NULL((0))Community Status. Link to Community_Status_DE.ID
Indexes NIX_Patient_Community_PatientIDOrgIDnumeric(18,0)9NOT NULL((0))Organziation Identifier. link to Organization.ID
Indexes NIX_Patient_Community_PatientIDForeign Keys FK_Patient_Community_CommunityID: [dbo].[CED_Endpoints].CommunityIDCommunityID[dbo].[uniqueid]9NOT NULLCommunity Identifier. Link to CED_Endpoints.ID