USE [Hemodialysis]
GO

/****** Object:  Table [dbo].[tbHemodialysisPatientInfo]    Script Date: 7/24/2025 1:23:31 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbHemodialysisPatientInfo](
	[HospNum] [varchar](50) NULL,
	[IDNum] [varchar](50) NULL,
	[DateSave] [date] NULL,
	[Acute_kidney_injury] [bit] NULL,
	[CKD_5_esrd] [bit] NULL,
	[Diabetic_nephropathy] [bit] NULL,
	[Hypertensive_nephrosclerosis] [bit] NULL,
	[Chronic_glomerulonephritis] [bit] NULL,
	[Obstructive_nephropathy] [bit] NULL,
	[Gouty_nephropathy] [bit] NULL,
	[Polycystic_kidney_disease] [bit] NULL,
	[Chronic_pyelonephritis] [bit] NULL,
	[Other_renal_diagnosis] [varchar](255) NULL,
	[Hypertension] [bit] NULL,
	[Diabetes] [bit] NULL,
	[Arthritis] [bit] NULL,
	[Stroke] [bit] NULL,
	[Bronchial_asthma] [bit] NULL,
	[Copd] [bit] NULL,
	[Dyslipidemia] [bit] NULL,
	[Other_concomitant] [varchar](500) NULL,
	[Dialysis_start_date] [date] NULL,
	[Dialysis_location] [varchar](500) NULL,
	[Temporary] [bit] NULL,
	[TemporaryNotApplicable] [bit] NULL,
	[InternalJugular] [bit] NULL,
	[Femoral] [bit] NULL,
	[Subclavian] [bit] NULL,
	[Temp_jugular_date] [date] NULL,
	[Temp_jugular_surgeon] [varchar](500) NULL,
	[Temp_femoral_date] [date] NULL,
	[Temp_femoral_surgeon] [varchar](500) NULL,
	[Temp_subclavian_date] [date] NULL,
	[Temp_subclavian_surgeon] [varchar](500) NULL,
	[Permanent] [bit] NULL,
	[PermanentNotApplicable] [bit] NULL,
	[Catheter] [bit] NULL,
	[AVFistula] [bit] NULL,
	[AVGraft] [bit] NULL,
	[Perm_catheter_date] [date] NULL,
	[Perm_catheter_surgeon] [varchar](500) NULL,
	[Perm_av_fistula_date] [date] NULL,
	[Perm_av_fistula_surgeon] [varchar](500) NULL,
	[Perm_av_graft_date] [date] NULL,
	[Perm_av_graft_surgeon] [varchar](500) NULL,
	[Hbsag_date_taken] [date] NULL,
	[Hbsag_result] [varchar](500) NULL,
	[Hbsag_date_due] [date] NULL,
	[Anti_hbs_date_taken] [date] NULL,
	[Anti_hbs_result] [varchar](500) NULL,
	[Anti_hbs_date_due] [date] NULL,
	[Anti_hcv_date_taken] [date] NULL,
	[Anti_hcv_result] [varchar](500) NULL,
	[Anti_hcv_date_due] [date] NULL,
	[Hiv_test_date_taken] [date] NULL,
	[Hiv_test_result] [varchar](500) NULL,
	[Hiv_test_date_due] [date] NULL,
	[Hep_b_1st_date] [date] NULL,
	[Hep_b_1st_remarks] [varchar](500) NULL,
	[Hep_b_2nd_date] [date] NULL,
	[Hep_b_2nd_remarks] [varchar](500) NULL,
	[Hep_b_3rd_date] [date] NULL,
	[Hep_b_3rd_remarks] [varchar](500) NULL,
	[Influenza_vaccine] [varchar](500) NULL,
	[Pneumococcal_vaccine] [varchar](500) NULL,
	[UserID] [varchar](10) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Acute_kidney_injury]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [CKD_5_esrd]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Diabetic_nephropathy]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Hypertensive_nephrosclerosis]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Chronic_glomerulonephritis]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Obstructive_nephropathy]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Gouty_nephropathy]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Polycystic_kidney_disease]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Chronic_pyelonephritis]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Hypertension]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Diabetes]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Arthritis]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Stroke]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Bronchial_asthma]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Copd]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Dyslipidemia]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Temporary]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [TemporaryNotApplicable]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [InternalJugular]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Femoral]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Subclavian]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Permanent]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [PermanentNotApplicable]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [Catheter]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [AVFistula]
GO

ALTER TABLE [dbo].[tbHemodialysisPatientInfo] ADD  DEFAULT ((0)) FOR [AVGraft]
GO