USE [Hemodialysis]
GO

/****** Object:  Table [dbo].[tbHemodialysisHealthEducation]    Script Date: 7/24/2025 1:22:44 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbHemodialysisHealthEducation](
	[HealthEducationID] [int] IDENTITY(1,1) NOT NULL,
	[Hospnum] [varchar](10) NULL,
	[IdNum] [varchar](10) NULL,
	[LearnerPatient] [bit] NOT NULL,
	[LearnerSpouse] [bit] NOT NULL,
	[LearnerChild] [bit] NOT NULL,
	[LearnerCaregiver] [bit] NOT NULL,
	[LearnerOthers] [bit] NOT NULL,
	[LearnerOthersText] [varchar](255) NULL,
	[BarrierNone] [bit] NOT NULL,
	[BarrierImpairedHearing] [bit] NOT NULL,
	[BarrierImpairedVision] [bit] NOT NULL,
	[BarrierEmotional] [bit] NOT NULL,
	[BarrierEducational] [bit] NOT NULL,
	[BarrierLanguage] [bit] NOT NULL,
	[BarrierReligious] [bit] NOT NULL,
	[BarrierFinancial] [bit] NOT NULL,
	[BarrierImpairedThought] [bit] NOT NULL,
	[BarrierOthers] [bit] NOT NULL,
	[BarrierOthersText] [varchar](255) NULL,
	[NeedsDiagnosis] [bit] NOT NULL,
	[NeedsPersonalHygiene] [bit] NOT NULL,
	[NeedsPatientRights] [bit] NOT NULL,
	[NeedsSafeUse] [bit] NOT NULL,
	[NeedsChronicDialysis] [bit] NOT NULL,
	[NeedsCommunityResources] [bit] NOT NULL,
	[NeedsOthers] [bit] NOT NULL,
	[NeedsOthersText] [varchar](255) NULL,
	[Diet] [bit] NOT NULL,
	[DietPersonality] [bit] NOT NULL,
	[DietImmunization] [bit] NOT NULL,
	[DietMedication] [bit] NOT NULL,
	[DietPertinent] [bit] NOT NULL,
	[DietExercises] [bit] NOT NULL,
	[DietBraces] [bit] NOT NULL,
	[ResponseAskedQuestions] [bit] NOT NULL,
	[ResponseRespondedUnderstood] [bit] NOT NULL,
	[ResponseRequiresReinforcement] [bit] NOT NULL,
	[ResponseSeemsUninterested] [bit] NOT NULL,
	[ResponseSeemsDistressed] [bit] NOT NULL,
	[ResponseUnableLearn] [bit] NOT NULL,
	[ResponseAbleDemonstrate] [bit] NOT NULL,
	[ResponseAbleVerbalize] [bit] NOT NULL,
	[ResponseTeachingPostponed] [bit] NOT NULL,
	[AidVerbal] [bit] NOT NULL,
	[AidDemonstration] [bit] NOT NULL,
	[AidAudiovisual] [bit] NOT NULL,
	[AidWritten] [bit] NOT NULL,
	[AidPamphlet] [bit] NOT NULL,
	[AidOthers] [bit] NOT NULL,
	[AidOthersText] [varchar](255) NULL,
	[DateTime] [datetime] NULL,
	[LearnerNameSignature] [varchar](255) NULL,
	[SpecificInfoTaughtBy] [varchar](255) NULL,
	[HealthcareProvider] [varchar](255) NULL,
	[CreatedDate] [datetime] NOT NULL,
	[ModifiedDate] [datetime] NULL,
	[CreatedBy] [varchar](100) NULL,
	[ModifiedBy] [varchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[HealthEducationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [LearnerPatient]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [LearnerSpouse]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [LearnerChild]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [LearnerCaregiver]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [LearnerOthers]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierNone]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierImpairedHearing]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierImpairedVision]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierEmotional]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierEducational]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierLanguage]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierReligious]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierFinancial]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierImpairedThought]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [BarrierOthers]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [NeedsDiagnosis]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [NeedsPersonalHygiene]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [NeedsPatientRights]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [NeedsSafeUse]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [NeedsChronicDialysis]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [NeedsCommunityResources]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [NeedsOthers]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [Diet]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [DietPersonality]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [DietImmunization]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [DietMedication]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [DietPertinent]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [DietExercises]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [DietBraces]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseAskedQuestions]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseRespondedUnderstood]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseRequiresReinforcement]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseSeemsUninterested]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseSeemsDistressed]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseUnableLearn]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseAbleDemonstrate]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseAbleVerbalize]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [ResponseTeachingPostponed]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [AidVerbal]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [AidDemonstration]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [AidAudiovisual]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [AidWritten]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [AidPamphlet]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT ((0)) FOR [AidOthers]
GO

ALTER TABLE [dbo].[tbHemodialysisHealthEducation] ADD  DEFAULT (getdate()) FOR [CreatedDate]
GO