-- SQL script to create tbl_ipd_investigation_master table
-- Run this script in your MySQL database

CREATE TABLE IF NOT EXISTS `tbl_ipd_investigation_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TestId` int(11) DEFAULT NULL,
  `TestName` varchar(255) DEFAULT NULL,
  `Unit` varchar(50) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT 1,
  `CreatedBy` int(11) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int(11) DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_TestId` (`TestId`),
  KEY `idx_Status` (`Status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;