ALTER  TABLE  [Hemodialysis].[dbo].[tbHemodialysisResultEntry] DROP COLUMN [HdStartTime] 
GO

ALTER  TABLE [Hemodialysis].[dbo].[tbHemodialysisResultEntry] ADD   [HdStartTime] DATETIME
GO

ALTER  TABLE  [Hemodialysis].[dbo].[tbHemodialysisResultEntry] DROP COLUMN [HdEndTime] 
GO

ALTER  TABLE [Hemodialysis].[dbo].[tbHemodialysisResultEntry] ADD   [HdEndTime] DATETIME
GO



ALTER  TABLE  [Hemodialysis].[dbo].[tbHemodialysisResultEntry] DROP COLUMN [HdStarted] 
GO

ALTER  TABLE [Hemodialysis].[dbo].[tbHemodialysisResultEntry] ADD   [HdStarted] DATETIME
GO

ALTER  TABLE  [Hemodialysis].[dbo].[tbHemodialysisResultEntry] DROP COLUMN [HdEnded] 
GO

ALTER  TABLE [Hemodialysis].[dbo].[tbHemodialysisResultEntry] ADD   [HdEnded] DATETIME
GO


USE [Hemodialysis]
GO

/****** Object:  Table [dbo].[tbHemoLabResults]    Script Date: 9/4/2025 2:25:40 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbHemoLabResults](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[TransDate] [datetime] NULL,
	[HospNum] [varchar](50) NULL,
	[IDNum] [varchar](50) NULL,
	[HemoNum] [varchar](50) NULL,
	[Hematology] [varchar](50) NULL,
	[Hemoglobin] [varchar](50) NULL,
	[Hematocrit] [varchar](50) NULL,
	[RBC] [varchar](50) NULL,
	[WBC] [varchar](50) NULL,
	[Neutrophils] [varchar](50) NULL,
	[Eosinophils] [varchar](50) NULL,
	[Basophils] [varchar](50) NULL,
	[Lymphocytes] [varchar](50) NULL,
	[Monocytes] [varchar](50) NULL,
	[Plateletcount] [varchar](50) NULL,
	[Chemistry] [varchar](50) NULL,
	[Creatinine] [varchar](50) NULL,
	[Pre_HDBUN] [varchar](50) NULL,
	[Post_HDBUN] [varchar](50) NULL,
	[URR] [varchar](50) NULL,
	[KT_V] [varchar](50) NULL,
	[Sodium] [varchar](50) NULL,
	[Potassium] [varchar](50) NULL,
	[IonizedCalcium] [varchar](50) NULL,
	[Albumin] [varchar](50) NULL,
	[Phosphorus] [varchar](50) NULL,
	[UricAcid] [varchar](50) NULL,
	[SGPT] [varchar](50) NULL,
	[SGOT] [varchar](50) NULL,
	[Alkphosphatase] [varchar](50) NULL,
	[FBS] [varchar](50) NULL,
	[HBA1C] [varchar](50) NULL,
	[SerumIron] [varchar](50) NULL,
	[Ferritin] [varchar](50) NULL,
	[Transferrin] [varchar](50) NULL,
	[Others] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [Hemodialysis]
GO

/****** Object:  Index [by_HemoNum]    Script Date: 9/4/2025 2:25:52 AM ******/
CREATE NONCLUSTERED INDEX [by_HemoNum] ON [dbo].[tbHemoLabResults]
(
	[HemoNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

USE [Hemodialysis]
GO

/****** Object:  Index [by_HospNum]    Script Date: 9/4/2025 2:25:59 AM ******/
CREATE NONCLUSTERED INDEX [by_HospNum] ON [dbo].[tbHemoLabResults]
(
	[HospNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

USE [Hemodialysis]
GO

/****** Object:  Index [by_ID]    Script Date: 9/4/2025 2:26:05 AM ******/
CREATE NONCLUSTERED INDEX [by_ID] ON [dbo].[tbHemoLabResults]
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
USE [Hemodialysis]
GO

/****** Object:  Index [by_IDNum]    Script Date: 9/4/2025 2:26:13 AM ******/
CREATE NONCLUSTERED INDEX [by_IDNum] ON [dbo].[tbHemoLabResults]
(
	[IDNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
USE [Hemodialysis]
GO

/****** Object:  Index [by_TransDate]    Script Date: 9/4/2025 2:26:19 AM ******/
CREATE CLUSTERED INDEX [by_TransDate] ON [dbo].[tbHemoLabResults]
(
	[TransDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO





ALTER  TABLE  [Hemodialysis].[dbo].[tbHemodialysisResultEntry] DROP COLUMN [HdStartTime] 
GO

ALTER  TABLE [Hemodialysis].[dbo].[tbHemodialysisResultEntry] ADD   [HdStartTime] DATETIME
GO

ALTER  TABLE  [Hemodialysis].[dbo].[tbHemodialysisResultEntry] DROP COLUMN [HdEndTime] 
GO

ALTER  TABLE [Hemodialysis].[dbo].[tbHemodialysisResultEntry] ADD   [HdEndTime] DATETIME
GO