Tables [dbo].[Patient_Family_Unit]
Family unit information for the patient (employee)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Patient_Family_Unit_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Surrogate auto-generated unique primary key value
FamilyUnitNamevarchar(70)70NOT NULLName of the family unit, current requirement is to hold the patient last name concatenated with PatientID
Indexes NIX_Patient_Family_Unit_PatientIDForeign Keys FK_Patient_Family_Unit_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatientID of the family unit owner. Link to Patient_Member.ID
CreatedBy[dbo].[uniqueid]9NOT NULLUserID of the user who created the family unit. Link to IDX_User.ID
CreatedDTTMdatetime8NOT NULLFamily unit created date and time