-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `development_ctm`
--

-- --------------------------------------------------------

--
-- Table structure for table `contact_form`
--

CREATE TABLE `contact_form` (
  `contact_id` bigint(20) NOT NULL,
  `first_name` varchar(300) NOT NULL,
  `middle_name` varchar(250) DEFAULT NULL,
  `last_name` varchar(300) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `dob` date DEFAULT NULL,
  `day_time_phone` varchar(150) NOT NULL,
  `evening_time_phone` varchar(150) NOT NULL,
  `email_address` varchar(300) NOT NULL,
  `country` varchar(200) NOT NULL,
  `state` varchar(150) NOT NULL,
  `zip` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_form`
--

INSERT INTO `contact_form` (`contact_id`, `first_name`, `middle_name`, `last_name`, `gender`, `dob`, `day_time_phone`, `evening_time_phone`, `email_address`, `country`, `state`, `zip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Test', NULL, 'Test', 'Male', '1998-12-30', '1111111111', '1111111111', 'hargovind@gmail.com', 'India', 'Noida', '201023', '2023-02-14 10:04:30', '2023-02-14 10:04:30', NULL),
(2, 'Test', NULL, 'Test', 'Male', '1998-12-30', '1111111111', '1111111111', 'hargovind@gmail.com', 'India', 'Noida', '201023', '2023-02-14 10:04:30', '2023-02-14 10:04:30', NULL),
(3, 'Test', NULL, 'Test', 'Male', '1998-12-30', '1111111111', '1111111111', 'hargovind@gmail.com', 'India', 'Noida', '201023', '2023-02-14 10:04:30', '2023-02-14 10:04:30', NULL),
(4, 'Test', NULL, 'Test', 'Male', '1998-12-30', '1111111111', '1111111111', 'hargovind@gmail.com', 'India', 'Noida', '201023', '2023-02-14 10:04:30', '2023-02-14 10:04:30', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `studies`
--

CREATE TABLE `studies` (
  `study_id` bigint(20) NOT NULL,
  `study_name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `patient_portal_layout` varchar(200) DEFAULT NULL,
  `geographical_radius` varchar(200) DEFAULT NULL,
  `language` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Inactive',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `studies`
--

INSERT INTO `studies` (`study_id`, `study_name`, `description`, `patient_portal_layout`, `geographical_radius`, `language`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Hargovind singh kanyal', 'Test Description', 'PatientMasterPage1', '12', 'English', '1', '2023-02-13 15:25:33', '2023-02-13 15:25:33', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `contact_form`
--
ALTER TABLE `contact_form`
  ADD PRIMARY KEY (`contact_id`);

--
-- Indexes for table `studies`
--
ALTER TABLE `studies`
  ADD PRIMARY KEY (`study_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `contact_form`
--
ALTER TABLE `contact_form`
  MODIFY `contact_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `studies`
--
ALTER TABLE `studies`
  MODIFY `study_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

