Tables [dbo].[Patient_Family_Unit_Member]
Family unit member information
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Patient_Family_Unit_Member_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Surrogate auto-generated unique primary key value
Cluster Key CIX_Patient_Family_Unit_Member_FamilyUnitID: FamilyUnitIDForeign Keys FK_Patient_Family_Unit_Member_FamilyUnitID_Patient_Family_Unit_ID: [dbo].[Patient_Family_Unit].FamilyUnitIDFamilyUnitID[dbo].[uniqueid]9NOT NULLReference to the family unit
Indexes NIX_Patient_Family_Unit_Member_LinkPatientIDForeign Keys FK_Patient_Family_Unit_Member_LinkPatientID_Patient_Member_ID: [dbo].[Patient_Member].LinkPatientIDLinkPatientID[dbo].[uniqueid]9NOT NULLPatientID identifier of the family unit member. Link to Patient_Member.ID
Foreign Keys FK_Patient_Family_Unit_Member_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDERelationshipDE[dbo].[dict_id]5NOT NULLRelationship detail of the family member to the patient. Link to Relationship_DE.ID
CreatedBy[dbo].[uniqueid]9NOT NULLUserID of the user who associated the patient to the family unit. Link to IDX_User.ID
CreatedDTTMdatetime8NOT NULLFamily unit member created date and time