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

START TRANSACTION;



--
-- Database: `iomt`
--

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

--
-- Table structure for table `live_session_val`
--

CREATE TABLE `live_session_val` (
  `email` varchar(100) NOT NULL,
  `session_id` bigint NOT NULL,
  `reading_data` json NOT NULL,
  `user_current_timestamp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `live_session_val`
--

INSERT INTO `live_session_val` (`email`, `session_id`, `reading_data`, `user_current_timestamp`) VALUES
('abc@email.com', 16875498309, '\"&quot;{\\\\n  \\\\&quot;pulse\\\\&quot;: 123,\\\\n  \\\\&quot;SpO2\\\\&quot;: 98,\\\\n  \\\\&quot;sys\\\\&quot;: 120,\\\\n  \\\\&quot;dia\\\\&quot;: 80,\\\\n  \\\\&quot;body_temp\\\\&quot;: 38.5,\\\\n  \\\\&quot;room_temp\\\\&quot;: 38.5,\\\\n  \\\\&quot;humidity\\\\&quot;: 40,\\\\n  \\\\&quot;gsr\\\\&quot;: 100,\\\\n  \\\\&quot;esp\\\\&quot;: [1, 2, 3]\\\\n}&quot;\"', '06/24/2023 01:20:30'),
('abc@email.com', 16878769090, '\"&quot;{\\\\n  \\\\&quot;pulse\\\\&quot;: 123,\\\\n  \\\\&quot;SpO2\\\\&quot;: 98,\\\\n  \\\\&quot;sys\\\\&quot;: 120,\\\\n  \\\\&quot;dia\\\\&quot;: 80,\\\\n  \\\\&quot;body_temp\\\\&quot;: 38.5,\\\\n  \\\\&quot;room_temp\\\\&quot;: 38.5,\\\\n  \\\\&quot;humidity\\\\&quot;: 40,\\\\n  \\\\&quot;gsr\\\\&quot;: 100,\\\\n  \\\\&quot;esp\\\\&quot;: [1, 2, 3]\\\\n}&quot;\"', '06/27/2023 08:11:49');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `live_session_val`
--
ALTER TABLE `live_session_val`
  ADD PRIMARY KEY (`session_id`);
COMMIT;

