Tables [dbo].[Patient_Education]
Patient Education details.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Patient_Education: IDIndexes NIX_patient_education_createdttm_name_id_encounteridID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_Education table
Cluster Key IX_Patient_Education: EncounterIDIndexes NIX_patient_education_createdttm_name_id_encounteridForeign Keys FK_Patient_Education_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Indexes NIX_patient_education_createdttm_name_id_encounteridNamevarchar(255)255NOT NULLPatient Education Type. Ex Medication Profile.
Indexes NIX_patient_education_createdttm_name_id_encounteridCreateDTTMdatetime8NOT NULLRecord Created Date Time
Foreign Keys FK_Patient_Education_User_ID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser ID who created record. Link to IDX_User.ID
TextChunkvarchar(max)maxNOT NULLFormated data containing Patient Education details.