USE [LAB_DB_GTR]
GO
/****** Object:  Table [dbo].[lab_item]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[lab_item](
	[lab_items_code] [nvarchar](50) NULL,
	[lab_items_name] [nvarchar](255) NULL,
	[lab_items_group] [float] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[tbl_lab_setup_log_Test]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_log_Test](
	[Test_Trx_Id] [int] IDENTITY(1,1) NOT NULL,
	[Test_Trx_Dt] [datetime] NULL CONSTRAINT [DF_tbl_lab_setup_log_Test_Test_Trx_Dt]  DEFAULT (getdate()),
	[Test_Code] [varchar](6) NOT NULL,
	[Test_Group_Code] [varchar](6) NULL,
	[Test_Seq] [nvarchar](4) NULL,
	[Test_Name] [nvarchar](255) NULL,
	[Test_Display_Name] [nvarchar](10) NULL,
	[Test_Display_Name_Hide_Print_Flag] [varchar](1) NULL,
	[Test_Type_Code] [varchar](1) NULL,
	[Test_Order_Status_Flag] [varchar](1) NULL,
	[Test_Data_Type_Code] [varchar](2) NULL,
	[Specimen_Type_Code] [varchar](2) NULL,
	[Test_His_Code] [varchar](20) NULL,
	[Test_Checkup_Code] [varchar](15) NULL,
	[Test_Send_Out_Flag] [varchar](1) NULL,
	[Test_Preliminary_Enable_Flag] [varchar](1) NULL,
	[Test_Inactive] [varchar](1) NULL,
	[Test_Method_Code] [varchar](6) NULL,
	[Test_Profile_Option_Flag] [varchar](1) NULL,
	[Test_Trx_By] [varchar](255) NULL,
	[Test_Checkup_Flag] [varchar](1) NULL,
	[Test_Profile_Option_Share_Code_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_log_Test] PRIMARY KEY CLUSTERED 
(
	[Test_Trx_Id] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test](
	[Test_Code] [varchar](6) NOT NULL DEFAULT (''),
	[Test_Group_Code] [varchar](6) NULL,
	[Test_Seq] [nvarchar](4) NULL,
	[Test_Name] [nvarchar](255) NULL,
	[Test_Display_Name] [nvarchar](10) NULL,
	[Test_Display_Name_Hide_Print_Flag] [varchar](1) NULL,
	[Test_Type_Code] [varchar](1) NULL,
	[Test_Order_Status_Flag] [varchar](1) NULL,
	[Test_Data_Type_Code] [varchar](2) NULL,
	[Specimen_Type_Code] [varchar](2) NULL,
	[Test_His_Code] [varchar](20) NULL,
	[Test_Checkup_Code] [varchar](15) NULL,
	[Test_Send_Out_Flag] [varchar](1) NULL,
	[Test_Preliminary_Enable_Flag] [varchar](1) NULL,
	[Test_Inactive] [varchar](1) NULL,
	[Test_Method_Code] [varchar](6) NULL,
	[Test_Profile_Option_Flag] [varchar](1) NULL,
	[Test_Checkup_Flag] [varchar](1) NULL,
	[Test_Profile_Option_Share_Code_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test] PRIMARY KEY CLUSTERED 
(
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Age]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Age](
	[Age_Code] [varchar](3) NOT NULL,
	[Age_Text] [nvarchar](50) NULL,
	[Age_Operator_Code] [varchar](2) NULL,
	[Age_Unit] [varchar](1) NULL,
	[Age_Value1] [bigint] NULL,
	[Age_value2] [bigint] NULL,
	[Age_Inactive] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_age] PRIMARY KEY CLUSTERED 
(
	[Age_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Condition]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Condition](
	[Condition_Code] [varchar](3) NOT NULL,
	[Condition_Text] [nvarchar](300) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_condition] PRIMARY KEY CLUSTERED 
(
	[Condition_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Control]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Control](
	[Test_Code] [varchar](6) NOT NULL,
	[Test_Auto_Test_Comment] [nvarchar](100) NULL,
	[Test_Auto_Result_Text] [nvarchar](25) NULL,
	[Test_Send_HIS_Text] [nvarchar](200) NULL,
	[Test_Default_Value_Text] [nvarchar](50) NULL,
	[Test_TAT_R_Days] [int] NULL,
	[Test_TAT_R_Hours] [int] NULL,
	[Test_TAT_R_Minutes] [int] NULL,
	[Test_TAT_S_Days] [int] NULL,
	[Test_TAT_S_Hours] [int] NULL,
	[Test_TAT_S_Minutes] [int] NULL,
	[Comment_Type_Code] [varchar](3) NULL,
	[Test_Share_Code_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Share_Code_Flag]  DEFAULT ('0'),
	[Test_Default_Value_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Default_Value_Flag]  DEFAULT ('0'),
	[Test_Comment_Type_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Comment_Type_Flag]  DEFAULT ('0'),
	[Test_Send_HIS_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Send_HIS_Flag]  DEFAULT ('0'),
	[Test_Limit_Result_Access_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Limit_Result_Access_Flag]  DEFAULT ('0'),
	[Test_Blind_Result_Display_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Blind_Result_Display_Flag]  DEFAULT ('0'),
	[Test_Auto_Result_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Auto_Result_Flag]  DEFAULT ('0'),
	[Test_Scan_File_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Scan_File_Flag]  DEFAULT ('0'),
	[Test_Text_Keyin_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Text_Keyin_Flag]  DEFAULT ('0'),
	[Test_Text_Column_Print_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Text_Column_Print_Flag]  DEFAULT ('0'),
	[Test_Blank_Result_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Blank_Result_Flag]  DEFAULT ('0'),
	[Test_Sp_Barcode_Flag] [varchar](1) NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Sp_Barcode_Flag]  DEFAULT ('0'),
	[Test_Critical_Flag] [varchar](1) NOT NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Critical_Flag]  DEFAULT ('0'),
	[Test_Routine_Flag] [varchar](1) NOT NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Routine_Flag]  DEFAULT ('0'),
	[Test_Countable] [varchar](1) NOT NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Countable]  DEFAULT ('1'),
	[Test_Ref_Text_Value] [nvarchar](100) NOT NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Ref_Text_Value]  DEFAULT (''),
	[Test_Ref_Text_Flag] [varchar](1) NOT NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Ref_Text_Flag]  DEFAULT ('0'),
	[Test_Package_Flag] [varchar](1) NOT NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Package_Flag]  DEFAULT ('0'),
	[Test_Package_Price] [money] NOT NULL CONSTRAINT [DF_tbl_lab_setup_test_control_Test_Package_Price]  DEFAULT ('0.00'),
	[Test_Blind_Result_Display_Authen_Flag] [varchar](1) NULL,
	[Test_Pending_Time_Flag] [varchar](1) NULL,
	[Test_Pending_Time_Day] [nvarchar](100) NULL,
	[Test_Pending_Time_Hours] [nvarchar](100) NULL,
	[Test_Pending_Time_Miniutes] [nvarchar](100) NULL,
	[Test_Report_Flag] [varchar](1) NULL,
	[Test_Report] [varchar](255) NULL,
	[Test_Block_Result] [nvarchar](100) NULL,
	[Test_Block_Result_Flag] [varchar](1) NULL,
	[Test_Barcode_Copy_Flag] [varchar](1) NULL,
	[Test_Barcode_Copy] [int] NULL,
	[Test_Cost] [float] NULL,
	[Test_OutLab_Flag] [nvarchar](1) NULL,
	[Test_OutLab_Code] [nvarchar](50) NULL,
	[Test_Result_Equal_Pre1_Flag] [varchar](1) NULL,
	[Test_Click_Formula_Flag] [varchar](1) NULL,
	[Test_Blood_Group_Color] [varchar](1) NULL,
	[Test_OutLab_Specimen_Code] [nvarchar](3) NULL,
	[Test_Report_Show_Dialog_Print_On_App] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_control] PRIMARY KEY CLUSTERED 
(
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Data_Type]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Data_Type](
	[Test_Data_Type_Code] [varchar](2) NOT NULL,
	[Test_Data_Type_Name] [nvarchar](30) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_data_type] PRIMARY KEY CLUSTERED 
(
	[Test_Data_Type_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Group]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Group](
	[Test_Group_Code] [varchar](6) NOT NULL,
	[Test_Group_Name] [nvarchar](30) NULL,
	[Test_Group_Name_Hide_Print_Flag] [varchar](1) NULL,
	[Test_Group_Report_Form_Path] [nvarchar](200) NULL,
	[Test_Group_Seq] [nvarchar](3) NULL,
	[Test_Group_Inactive] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_group] PRIMARY KEY CLUSTERED 
(
	[Test_Group_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Interpretation]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Interpretation](
	[Test_Code] [nvarchar](6) NOT NULL,
	[Test_Interpreted_Start_DateTime] [datetime] NOT NULL,
	[Test_Lower_Values] [nvarchar](10) NULL,
	[Test_Upper_Values] [nvarchar](10) NULL,
	[Test_Interpreted_Result] [nvarchar](30) NULL,
	[Test_Interpreted_Abnormal_Flag] [nvarchar](1) NULL,
	[Test_Interpreted_Value_Display_Flag] [nvarchar](1) NULL,
	[Test_Interpreted_Value_Print_Flag] [nvarchar](1) NULL,
	[Test_Interpreted_Interpret_Display_Flag] [nvarchar](1) NULL,
	[Test_Interpreted_Interpret_Print_Flag] [nvarchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_Test_Interpretation] PRIMARY KEY CLUSTERED 
(
	[Test_Code] ASC,
	[Test_Interpreted_Start_DateTime] 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
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Method]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Method](
	[Test_Method_Code] [varchar](6) NOT NULL,
	[Test_Method_Name] [nvarchar](30) NULL,
	[Test_Method_Inactive] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_method] PRIMARY KEY CLUSTERED 
(
	[Test_Method_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Numeric_Operator]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Numeric_Operator](
	[Test_Numeric_Operator_Code] [varchar](2) NOT NULL,
	[Test_Numeric_Operator_Symbol] [nvarchar](30) NULL,
	[Test_Numeric_Operator_Description] [nvarchar](10) NULL,
	[Test_Numeric_Operator_Type] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_numeric_operator] PRIMARY KEY CLUSTERED 
(
	[Test_Numeric_Operator_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Out_Lab]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Out_Lab](
	[Out_Lab_Code] [nvarchar](50) NULL,
	[Test_Out_Lab_Code] [nvarchar](50) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Profile]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Profile](
	[Test_Profile_Code] [varchar](6) NOT NULL,
	[Test_Item_Code] [varchar](6) NOT NULL,
	[Test_Item_Seq] [nvarchar](3) NULL,
	[Test_Profile_Hide_Print_Flag] [varchar](1) NULL,
	[Test_Profile_Shift_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_profile] PRIMARY KEY CLUSTERED 
(
	[Test_Profile_Code] ASC,
	[Test_Item_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Profile_Option]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Profile_Option](
	[Test_Profile_Code] [varchar](6) NOT NULL,
	[Test_Item_Code] [varchar](6) NOT NULL,
	[Test_Item_Seq] [nvarchar](3) NULL,
	[Test_Profile_Hide_Print_Flag] [varchar](1) NULL,
	[Test_Profile_Shift_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_Test_Profile_Option] PRIMARY KEY CLUSTERED 
(
	[Test_Profile_Code] ASC,
	[Test_Item_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Result_MB_Relation]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Result_MB_Relation](
	[Test_Code] [varchar](6) NOT NULL,
	[Test_Organism_Code] [varchar](10) NOT NULL,
	[Test_Organism_Result_Type] [varchar](1) NOT NULL,
	[Test_Organism_Name] [nvarchar](50) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_result_mb_relation] PRIMARY KEY CLUSTERED 
(
	[Test_Organism_Code] ASC,
	[Test_Organism_Result_Type] ASC,
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Result_Numeric]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Result_Numeric](
	[Test_Code] [varchar](6) NOT NULL,
	[Unit_Code] [varchar](3) NULL,
	[Test_Delta_Check_Value] [int] NULL,
	[Test_Delta_Check_Percentage] [int] NULL,
	[Formula_Code] [varchar](6) NULL,
	[Test_MMR_Detail_Text] [nvarchar](300) NULL,
	[Test_Multi_Method_Enable_Flag] [varchar](1) NULL,
	[Test_Formula_Enable_Flag] [varchar](1) NULL,
	[Test_Interpreted_Enable_Flag] [varchar](1) NULL,
	[Test_MMR_Detail_Enable_Flag] [varchar](1) NULL,
	[Test_Output_Digit] [nvarchar](12) NULL,
	[Impossible_Range_Enable_Flag] [varchar](1) NULL,
	[Impossible_Range_Operator] [varchar](6) NULL,
	[Impossible_Range_Value1] [varchar](6) NULL,
	[Impossible_Range_Value2] [varchar](6) NULL,
	[Test_Delta_Check_Limit_Days] [int] NULL,
	[Test_Delta_Check_Limit_Hours] [int] NULL,
	[Test_Delta_Check_Limit_minutes] [int] NULL,
	[Test_Delta_Check_Limit_Flag] [varchar](1) NULL,
	[Test_Delta_Check_Alert_Critical_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_result_numeric] PRIMARY KEY CLUSTERED 
(
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Result_Numeric_Reference]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Result_Numeric_Reference](
	[Test_Code] [varchar](6) NOT NULL,
	[Test_Method_Code] [varchar](6) NOT NULL,
	[Test_Reference_Id] [varchar](2) NOT NULL,
	[Sex_Code] [varchar](2) NULL,
	[Age_Code] [varchar](3) NULL,
	[Test_Numeric_Operator_Code] [varchar](2) NULL,
	[Test_Reference_Value1] [varchar](10) NULL,
	[Test_Reference_Value2] [varchar](10) NULL,
	[Test_Reference_Text] [varchar](50) NULL,
	[Test_Reference_Cri1] [varchar](10) NULL,
	[Test_Reference_Cri2] [varchar](10) NULL,
	[Test_Method_Priority] [varchar](1) NULL,
	[Test_Reference_Cri_Comment] [varchar](max) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_result_numeric_reference] PRIMARY KEY CLUSTERED 
(
	[Test_Method_Code] ASC,
	[Test_Reference_Id] ASC,
	[Test_Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Result_Short_Text]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Result_Short_Text](
	[Test_Code] [varchar](6) NOT NULL,
	[Short_Text_Result_Code] [varchar](6) NOT NULL,
	[Test_Abnormal_Flag] [varchar](1) NULL,
	[Short_Text_Seq] [nvarchar](3) NULL,
	[Test_Alert_Flag] [varchar](1) NULL,
	[Not_Show_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_result_short_text] PRIMARY KEY CLUSTERED 
(
	[Short_Text_Result_Code] ASC,
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Result_Short_Text_Control]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Result_Short_Text_Control](
	[Test_Code] [varchar](6) NOT NULL,
	[Unit_Code] [varchar](3) NULL,
	[Formula_Code] [varchar](6) NULL,
	[Test_Formula_Enable_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_Test_Result_Short_Text_Control] PRIMARY KEY CLUSTERED 
(
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Result_Special_Text]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Result_Special_Text](
	[Test_Code] [varchar](50) NOT NULL,
	[Test_Column_Index] [int] NOT NULL,
	[Test_Column_Name] [nvarchar](30) NULL,
	[Test_Default_Value] [nvarchar](80) NULL,
	[Test_Column_Inactive] [varchar](1) NULL,
	[Test_Hide_Print_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_result_special_text] PRIMARY KEY CLUSTERED 
(
	[Test_Column_Index] ASC,
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[tbl_lab_setup_Test_Result_Special_Text_Matching]    Script Date: 22/10/2567 4:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_lab_setup_Test_Result_Special_Text_Matching](
	[Test_Code] [varchar](6) NOT NULL,
	[Test_Column_Index] [int] NOT NULL,
	[Special_Text_Result_Code] [varchar](50) NOT NULL,
	[Test_Special_Text_Seq] [nvarchar](3) NULL,
	[Test_Special_Result_Abnormal_Flag] [varchar](1) NULL,
 CONSTRAINT [PK_tbl_lab_setup_test_result_special_text_matching] PRIMARY KEY CLUSTERED 
(
	[Special_Text_Result_Code] ASC,
	[Test_Column_Index] ASC,
	[Test_Code] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[tbl_lab_setup_Test_Condition] ADD  CONSTRAINT [DF_tbl_lab_setup_Test_Condition_Condition_Text]  DEFAULT ('') FOR [Condition_Text]
GO