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

START TRANSACTION;



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

--
-- Table structure for table `mri_ind`
--

CREATE TABLE `mri_ind` (
  `id` int(11) NOT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `IPAddress` varchar(50) DEFAULT NULL,
  `Progress` int(11) DEFAULT NULL,
  `Duration_in_seconds` int(11) DEFAULT NULL,
  `Finished` varchar(10) DEFAULT NULL,
  `RecordedDate` datetime DEFAULT NULL,
  `ResponseId` varchar(255) DEFAULT NULL,
  `RecipientLastName` varchar(100) DEFAULT NULL,
  `RecipientFirstName` varchar(100) DEFAULT NULL,
  `RecipientEmail` varchar(255) DEFAULT NULL,
  `ExternalReference` varchar(255) DEFAULT NULL,
  `LocationLatitude` decimal(10,7) DEFAULT NULL,
  `LocationLongitude` decimal(10,7) DEFAULT NULL,
  `DistributionChannel` varchar(100) DEFAULT NULL,
  `UserLanguage` varchar(50) DEFAULT NULL,
  `1_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `1_11` tinyint(3) UNSIGNED DEFAULT NULL,
  `2_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `2_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `2_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `2_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `2_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `2_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `3_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `4_11` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `5_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_11` tinyint(3) UNSIGNED DEFAULT NULL,
  `6_12` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `7_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `8_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `8_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `8_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `8_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `8_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `9_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `10_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `10_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `10_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `10_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `10_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `10_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `10_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `11_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `12_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `12_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `12_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `12_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `13_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `13_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `13_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `13_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `13_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `14_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `14_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `14_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `14_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `14_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `15_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `15_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `15_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `15_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `15_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `16` tinyint(3) UNSIGNED DEFAULT NULL,
  `17` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_11` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_12` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_13` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_14` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_15` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_16` tinyint(3) UNSIGNED DEFAULT NULL,
  `17_17` tinyint(3) UNSIGNED DEFAULT NULL,
  `18` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_1` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_2` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_3` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_4` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_5` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_6` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_7` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_8` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_9` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_10` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_11` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_12` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_13` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_14` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_15` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_16` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_17` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_18` tinyint(3) UNSIGNED DEFAULT NULL,
  `18_1_19` tinyint(3) UNSIGNED DEFAULT NULL,
  `19` tinyint(3) UNSIGNED DEFAULT NULL,
  `20` tinyint(3) UNSIGNED DEFAULT NULL,
  `21` tinyint(3) UNSIGNED DEFAULT NULL,
  `22` tinyint(3) UNSIGNED DEFAULT NULL,
  `23` tinyint(3) UNSIGNED DEFAULT NULL,
  `24` tinyint(3) UNSIGNED DEFAULT NULL,
  `25` tinyint(3) UNSIGNED DEFAULT NULL,
  `26` tinyint(3) UNSIGNED DEFAULT NULL,
  `27` tinyint(3) UNSIGNED DEFAULT NULL,
  `28` tinyint(3) UNSIGNED DEFAULT NULL,
  `SurveyID` varchar(255) DEFAULT NULL,
  `Create_New_Field_or_Choose_From_Dropdown` varchar(255) DEFAULT NULL,
  `Q_TotalDuration` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `org_answers`
--

CREATE TABLE `org_answers` (
  `id` bigint(20) NOT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `IPAddress` varchar(50) DEFAULT NULL,
  `Progress` int(11) DEFAULT NULL,
  `Duration_in_seconds` int(11) DEFAULT NULL,
  `Finished` varchar(10) DEFAULT NULL,
  `RecordedDate` datetime DEFAULT NULL,
  `ResponseId` varchar(100) DEFAULT NULL,
  `RecipientLastName` varchar(255) DEFAULT NULL,
  `RecipientFirstName` varchar(255) DEFAULT NULL,
  `RecipientEmail` varchar(255) DEFAULT NULL,
  `ExternalReference` varchar(255) DEFAULT NULL,
  `LocationLatitude` decimal(10,8) DEFAULT NULL,
  `LocationLongitude` decimal(11,8) DEFAULT NULL,
  `DistributionChannel` varchar(100) DEFAULT NULL,
  `UserLanguage` varchar(50) DEFAULT NULL,
  `1_1` tinyint(4) DEFAULT NULL,
  `1_2` tinyint(4) DEFAULT NULL,
  `1_3` tinyint(4) DEFAULT NULL,
  `1_4` tinyint(4) DEFAULT NULL,
  `1_5` tinyint(4) DEFAULT NULL,
  `1_6` tinyint(4) DEFAULT NULL,
  `1_7` tinyint(4) DEFAULT NULL,
  `2_1` tinyint(4) DEFAULT NULL,
  `2_2` tinyint(4) DEFAULT NULL,
  `2_3` tinyint(4) DEFAULT NULL,
  `2_4` tinyint(4) DEFAULT NULL,
  `2_5` tinyint(4) DEFAULT NULL,
  `2_6` tinyint(4) DEFAULT NULL,
  `2_7` tinyint(4) DEFAULT NULL,
  `3_1` tinyint(4) DEFAULT NULL,
  `3_2` tinyint(4) DEFAULT NULL,
  `3_3` tinyint(4) DEFAULT NULL,
  `3_4` tinyint(4) DEFAULT NULL,
  `3_5` tinyint(4) DEFAULT NULL,
  `3_6` tinyint(4) DEFAULT NULL,
  `3_7` tinyint(4) DEFAULT NULL,
  `3_8` tinyint(4) DEFAULT NULL,
  `4_1` tinyint(4) DEFAULT NULL,
  `4_2` tinyint(4) DEFAULT NULL,
  `4_3` tinyint(4) DEFAULT NULL,
  `4_4` tinyint(4) DEFAULT NULL,
  `4_5` tinyint(4) DEFAULT NULL,
  `4_6` tinyint(4) DEFAULT NULL,
  `4_7` tinyint(4) DEFAULT NULL,
  `5_1` tinyint(4) DEFAULT NULL,
  `5_2` tinyint(4) DEFAULT NULL,
  `5_3` tinyint(4) DEFAULT NULL,
  `5_4` tinyint(4) DEFAULT NULL,
  `5_5` tinyint(4) DEFAULT NULL,
  `5_6` tinyint(4) DEFAULT NULL,
  `6_1` tinyint(4) DEFAULT NULL,
  `6_2` tinyint(4) DEFAULT NULL,
  `6_3` tinyint(4) DEFAULT NULL,
  `6_4` tinyint(4) DEFAULT NULL,
  `6_5` tinyint(4) DEFAULT NULL,
  `6_6` tinyint(4) DEFAULT NULL,
  `6_7` tinyint(4) DEFAULT NULL,
  `6_8` tinyint(4) DEFAULT NULL,
  `6_9` tinyint(4) DEFAULT NULL,
  `7_1` tinyint(4) DEFAULT NULL,
  `7_2` tinyint(4) DEFAULT NULL,
  `7_3` tinyint(4) DEFAULT NULL,
  `7_4` tinyint(4) DEFAULT NULL,
  `7_5` tinyint(4) DEFAULT NULL,
  `7_6` tinyint(4) DEFAULT NULL,
  `7_7` tinyint(4) DEFAULT NULL,
  `7_8` tinyint(4) DEFAULT NULL,
  `8_1` tinyint(4) DEFAULT NULL,
  `8_2` tinyint(4) DEFAULT NULL,
  `8_3` tinyint(4) DEFAULT NULL,
  `8_4` tinyint(4) DEFAULT NULL,
  `8_5` tinyint(4) DEFAULT NULL,
  `8_6` tinyint(4) DEFAULT NULL,
  `8_7` tinyint(4) DEFAULT NULL,
  `9_1` tinyint(4) DEFAULT NULL,
  `9_2` tinyint(4) DEFAULT NULL,
  `9_3` tinyint(4) DEFAULT NULL,
  `9_4` tinyint(4) DEFAULT NULL,
  `9_5` tinyint(4) DEFAULT NULL,
  `9_6` tinyint(4) DEFAULT NULL,
  `9_7` tinyint(4) DEFAULT NULL,
  `9_8` tinyint(4) DEFAULT NULL,
  `10_1` tinyint(4) DEFAULT NULL,
  `10_2` tinyint(4) DEFAULT NULL,
  `10_3` tinyint(4) DEFAULT NULL,
  `10_4` tinyint(4) DEFAULT NULL,
  `11_1` tinyint(4) DEFAULT NULL,
  `11_2` tinyint(4) DEFAULT NULL,
  `11_3` tinyint(4) DEFAULT NULL,
  `11_4` tinyint(4) DEFAULT NULL,
  `11_5` tinyint(4) DEFAULT NULL,
  `12_1` tinyint(4) DEFAULT NULL,
  `12_2` tinyint(4) DEFAULT NULL,
  `12_3` tinyint(4) DEFAULT NULL,
  `12_4` tinyint(4) DEFAULT NULL,
  `12_5` tinyint(4) DEFAULT NULL,
  `13_1` tinyint(4) DEFAULT NULL,
  `13_2` tinyint(4) DEFAULT NULL,
  `13_3` tinyint(4) DEFAULT NULL,
  `13_4` tinyint(4) DEFAULT NULL,
  `13_5` tinyint(4) DEFAULT NULL,
  `14` tinyint(4) DEFAULT NULL,
  `15` tinyint(4) DEFAULT NULL,
  `16` tinyint(4) DEFAULT NULL,
  `17` tinyint(4) DEFAULT NULL,
  `18` tinyint(4) DEFAULT NULL,
  `19` tinyint(4) DEFAULT NULL,
  `20` tinyint(4) DEFAULT NULL,
  `21` tinyint(4) DEFAULT NULL,
  `22` tinyint(4) DEFAULT NULL,
  `23` int(10) DEFAULT NULL,
  `24` int(10) DEFAULT NULL,
  `25` int(10) DEFAULT NULL,
  `26` tinyint(4) DEFAULT NULL,
  `27` tinyint(4) DEFAULT NULL,
  `Q_TotalDuration` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `org_answers`
--

INSERT INTO `org_answers` (`id`, `user_id`, `StartDate`, `EndDate`, `Status`, `IPAddress`, `Progress`, `Duration_in_seconds`, `Finished`, `RecordedDate`, `ResponseId`, `RecipientLastName`, `RecipientFirstName`, `RecipientEmail`, `ExternalReference`, `LocationLatitude`, `LocationLongitude`, `DistributionChannel`, `UserLanguage`, `1_1`, `1_2`, `1_3`, `1_4`, `1_5`, `1_6`, `1_7`, `2_1`, `2_2`, `2_3`, `2_4`, `2_5`, `2_6`, `2_7`, `3_1`, `3_2`, `3_3`, `3_4`, `3_5`, `3_6`, `3_7`, `3_8`, `4_1`, `4_2`, `4_3`, `4_4`, `4_5`, `4_6`, `4_7`, `5_1`, `5_2`, `5_3`, `5_4`, `5_5`, `5_6`, `6_1`, `6_2`, `6_3`, `6_4`, `6_5`, `6_6`, `6_7`, `6_8`, `6_9`, `7_1`, `7_2`, `7_3`, `7_4`, `7_5`, `7_6`, `7_7`, `7_8`, `8_1`, `8_2`, `8_3`, `8_4`, `8_5`, `8_6`, `8_7`, `9_1`, `9_2`, `9_3`, `9_4`, `9_5`, `9_6`, `9_7`, `9_8`, `10_1`, `10_2`, `10_3`, `10_4`, `11_1`, `11_2`, `11_3`, `11_4`, `11_5`, `12_1`, `12_2`, `12_3`, `12_4`, `12_5`, `13_1`, `13_2`, `13_3`, `13_4`, `13_5`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `24`, `25`, `26`, `27`, `Q_TotalDuration`, `created_at`, `updated_at`) VALUES
(1, 'RAHU9435', '2026-06-02 17:32:34', '2026-06-03 17:52:27', '1', '127.0.0.1', 100, NULL, '1', '2026-06-03 17:52:27', NULL, 'singh', 'rahul', 'rahul@gmail.com', 'RAHU9435', NULL, NULL, 'Chrome', 'English', 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 1, 1, 2, 2, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 16, 1, 6, 4, 2, 4, 3, 3, 141, 13, 43, 6, 8, NULL, '2026-06-02 12:02:34', '2026-06-03 12:22:27'),
(2, 'SACH3912', '2026-06-03 18:16:00', NULL, '1', '127.0.0.1', 5, NULL, NULL, NULL, NULL, 'deshwal', 'sachin test', 'sachin@gmail.com', 'SACH3912', NULL, NULL, 'Chrome', 'English', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-03 12:46:00', '2026-06-03 12:46:00');

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

--
-- Table structure for table `org_questions`
--

CREATE TABLE `org_questions` (
  `sr_no` int(11) NOT NULL,
  `question_id` varchar(20) NOT NULL,
  `question_text` text NOT NULL,
  `p_code` varchar(20) NOT NULL,
  `flag` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `org_questions`
--

INSERT INTO `org_questions` (`sr_no`, `question_id`, `question_text`, `p_code`, `flag`) VALUES
(41, '1', 'The organisation I am working for is aware of the (i.e has data or tacit knowledge)', '1', 1),
(42, '1.1', 'extent of cultural diversity in Australia', '1', 1),
(43, '1.2', 'trends of immigration in Australia', '1', 1),
(44, '1.3', 'cultural diversity of its stakeholders (e.g. employees, customer, clients)', '1', 1),
(45, '1.4', 'cultural characteristics of its stakeholders', '1', 1),
(46, '1.5', 'influence of culture on people (e.g. values, expectation, behaviour)', '1', 1),
(47, '1.6', 'required resources for effective performance in multicultural environments', '1', 1),
(48, '1.7', 'legislation supporting cultural diversity in Australia (e.g. Racial Discrimination Act)', '1', 1),
(49, '2', 'The organisation I am working for is willing to continously improve cultural knowledge through its approach to :', '2', 1),
(50, '2.1', 'collect data to learn about people from diverse cultural backgrounds', '2', 1),
(51, '2.2', 'engage experts that can bring in cultural knowledge (e.g. cultural consultants)', '2', 1),
(52, '2.3', 'conduct cultural training on an ongoing basis', '2', 1),
(53, '2.4', 'disseminate cultural educational materials (e.g. guidelines, relevant legislation)', '2', 1),
(54, '2.5', 'support the sharing of cultural knowledge', '2', 1),
(55, '2.6', 'encourage participation in cultural training programs (e.g. provide incentives, allocate adequate time)', '2', 1),
(56, '2.7', 'provide mentoring programs to empower employees work effectively in a multicultural workplace', '2', 1),
(57, '3', 'The organisation I am working for is able to understand and process cultural knowledge through its approach to:', '3', 1),
(58, '3.1', 'monitor the feedback of service users from diverse cultural backgrounds', '3', 1),
(59, '3.2', 'evaluates its employees cultural competence', '3', 1),
(60, '3.3', 'integrate cultural information acquired from multiple sources (e.g. the research output, stakeholder feedback, consultation with cultural experts)', '3', 1),
(61, '3.4', 'put cultural information into the organisational context', '3', 1),
(62, '3.5', 'monitor the cultural appropriateness of its practices based on available cultural information', '3', 1),
(63, '3.6', 'monitor the cultural appropriateness of its policies based on available cultural information', '3', 1),
(64, '3.7', 'use integrated cultural information to address organisational decisions', '3', 1),
(65, '3.8', 'Please indicate to what extent do you agree/disagree with the following statements', '3', 1),
(66, '4', 'The organisation I am working for is willing to accept and embrace cultural diversity in terms of its approach to:', '4', 1),
(67, '4.1', 'engage stakeholders (e.g. employees, customers, clients) from diverse cultural backgrounds', '4', 1),
(68, '4.2', 'respect everyone, regardless of their cultural backgrounds', '4', 1),
(69, '4.3', 'respect diverse cultural practices (e.g. celebrate cultural festivals, provide prayer room)', '4', 1),
(70, '4.4', 'respect the opinions of people from diverse cultural backgrounds', '4', 1),
(71, '4.5', 'use culturally inclusive language in organisational written materials', '4', 1),
(72, '4.6', 'provide on site artefacts of cultural diversity (e.g. artwork, images of culturally diverse people)', '4', 1),
(73, '4.7', 'represent cultural diversity in its marketing materials (e.g. brochures, video content, social media posts)', '4', 1),
(74, '5', 'The organisation I am working for acknowledges cultural diversity as a valuable resources for', '5', 1),
(75, '5.1', 'gaining access to a broader pool of potential talents (e.g. future employees)', '5', 1),
(76, '5.2', 'increased creativity and innovation', '5', 1),
(77, '5.3', 'diversity of perspectives', '5', 1),
(78, '5.4', 'improved decision making', '5', 1),
(79, '5.5', 'gaining access to multicultural markets', '5', 1),
(80, '5.6', 'helping connect to business partners overseas', '5', 1),
(81, '6', 'The organisation I am working for adjusts its policies to fit a multicultural context, such as those that reinforce', '6', 1),
(82, '6.1', 'cultural fairness in the workplace (e.g. anti-discrimination policies)', '6', 1),
(83, '6.2', 'its commitment to recruit people from diverse cultural backgrounds at all levels', '6', 1),
(84, '6.3', 'its commitment to improve cultural competence in the workplace', '6', 1),
(85, '6.4', 'its commitment to serve people from different cultural backgrounds', '6', 1),
(86, '6.5', 'the provision of culturally appropriate services to people from diverse cultural backgrounds', '6', 1),
(87, '6.6', 'the importance of involving people from diverse cultural backgrounds in organisational decision making', '6', 1),
(88, '6.7', 'the process of correcting culturallly inappropriate behaviours (e.g. counselling, penalizing)', '6', 1),
(89, '6.8', 'its commitment to build an inclusive environment where everyone feels welcomed', '6', 1),
(90, '6.9', 'monitoring the implementation of policies that support cultural diversity in the organisation', '6', 1),
(91, '7', 'The organisation I am working for adjusts its human resource practices to fit a multicultural context, such as its approach to:', '7', 1),
(92, '7.1', 'hire employees from diverse cultural backgrounds', '7', 1),
(93, '7.2', 'hire leaders from diverse cultural backgrounds', '7', 1),
(94, '7.3', 'consider cultural competence as a key employee selection criteria', '7', 1),
(95, '7.4', 'keep the selection process (hiring) free of any cultural bias', '7', 1),
(96, '7.5', 'provide equal opportunities to everyone regardless of their cultural background', '7', 1),
(97, '7.6', 'keep the employee development process at all organisational levels free of any cultural bias', '7', 1),
(98, '7.7', 'keep the employee performance review process free of any cultural bias', '7', 1),
(99, '7.8', 'select leaders who are committed to promoting cultural competence in the organisation', '7', 1),
(100, '8', 'The organisation I am working for adjusts its services to fit a multicultural context, such as its approach to:', '8', 1),
(101, '8.1', 'design new services based on the expectation of people from diverse cultural backgrounds', '8', 1),
(102, '8.2', 'customize existing services for meeting the needs of people from diverse cultural backgrounds', '8', 1),
(103, '8.3', 'have employees who are competent in providing effective services to people from diverse cultural backgrounds', '8', 1),
(104, '8.4', 'provide language assistance services (e.g. bilingual staff, interpreters)', '8', 1),
(105, '8.5', 'translate information in languages used by its service users (e.g. service description, forms, webpages)', '8', 1),
(106, '8.6', 'customize service recovery tactics based on the preferences of people from diverse cultural backgrounds (e.g. replacement of service, apology)', '8', 1),
(107, '8.7', 'provide extra information about services to ensure people from diverse cultural backgrounds fully understand the service(s) that is being offered to them', '8', 1),
(108, '9', 'The organisation I am working for is able to nurture and encourage communication with its culturally diverse stakeholders through its approach to:', '9', 1),
(109, '9.1', 'organize multicultural events (e.g. cultural festivals, morning tea)', '9', 1),
(110, '9.2', 'bring people from diverse cultural backgrounds together to share their experiences (e.g. multicultural workshops)', '9', 1),
(111, '9.3', 'organize meeting among employees and managers to discuss topics related to cultural diversity', '9', 1),
(112, '9.4', 'involve culturally diverse employees in making important organisational decisions (e.g. service design, policies, etc.)', '9', 1),
(113, '9.5', 'build network with diverse cultural groups among all stakeholders (e.g. networking with existing and target customers/clients, community representatives)', '9', 1),
(114, '9.6', 'involve culturally diverse external stakeholders in making important organisational decisions (e.g. service design, policies, etc)', '9', 1),
(115, '9.7', 'share organisational multicultural policies with all the stakeholders (e.g. employees, customers, clients)', '9', 1),
(116, '9.8', 'provide the opportunity for employees from diverse cultural backgrounds to work together (e.g. create multicultural teams)', '9', 1),
(117, '10', 'To what extent do you interact with the following people whose cultural background is different from your own?', '10', 1),
(118, '10.1', 'Work colleagues in your organisation', '10', 1),
(119, '10.2', 'Work colleagues in other organisation', '10', 1),
(120, '10.3', 'Customers/Clients', '10', 1),
(121, '10.4', 'Others outside the workplace', '10', 1),
(122, '11', 'The members of the organisation I am working for are very different from each other in terms of', '11', 1),
(123, '11.1', 'Race or ethnicity', '11', 1),
(124, '11.2', 'Nationality', '11', 1),
(125, '11.3', 'Customs or culture', '11', 1),
(126, '11.4', 'language', '11', 1),
(127, '11.5', 'religious beliefs', '11', 1),
(128, '12', 'The members of the work unit I am working in are very different from each other in terms of', '12', 1),
(129, '12.1', 'Race or ethnicity', '12', 1),
(130, '12.2', 'Nationality', '12', 1),
(131, '12.3', 'Customs or culture', '12', 1),
(132, '12.4', 'language', '12', 1),
(133, '12.5', 'religious beliefs', '12', 1),
(134, '13', 'The organisation I am working for serves customers or clients who are very different from each other in terms of', '13', 1),
(135, '13.1', 'Race or ethnicity', '13', 1),
(136, '13.2', 'Nationality', '13', 1),
(137, '13.3', 'Customs or culture', '13', 1),
(138, '13.4', 'language', '13', 1),
(139, '13.5', 'religious beliefs', '13', 1),
(140, '14', 'Which of the follwing sectors do you currently work in?', '14', 1),
(141, '15', 'Which industry division best describes where you are employed?', '15', 1),
(142, '16', 'Which industry sub division best describes where you are employes?', '16', 1),
(143, '17', 'Which major group best describes your occupation?', '17', 1),
(144, '18', 'How long you have been in the workforce?', '18', 1),
(145, '19', 'How long you have been working in your current organisation?', '19', 1),
(146, '20', 'What is the highest qualification level you have completed? (Please indicate the approximate equivalent if you have other education/qualifications, such as from overseas)', '20', 1),
(147, '21', 'Please select your gender', '21', 1),
(148, '22', 'Please select your age range (rounded to the nearest year)', '22', 1),
(149, '23', 'Please select your country of birth', '23', 1),
(150, '24', 'Please select your ancestry', '24', 1),
(151, '25', 'Which state or territory do you live in Australia?', '25', 1),
(152, '26', 'How long have you lived in Australia?', '26', 1),
(153, '27', 'How long have you lived outside your country of birth?', '27', 1);

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `sr_no` int(11) NOT NULL,
  `question_id` varchar(20) DEFAULT NULL,
  `question_text` text DEFAULT NULL,
  `p_code` int(10) DEFAULT NULL,
  `flag` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`sr_no`, `question_id`, `question_text`, `p_code`, `flag`) VALUES
(437, '1', 'I am aware that there are differences and similarities among cultures in terms of their', 1, 1),
(438, '1.1', 'language', 1, 1),
(439, '1.2', 'clothing', 1, 1),
(440, '1.3', 'food or dietary preference', 1, 1),
(441, '1.4', 'celebrations', 1, 1),
(442, '1.5', 'artistic expression', 1, 1),
(443, '1.6', 'behavioural rules regarding taboos (undesirable behaviours)', 1, 1),
(444, '1.7', 'rules for expressing non verbal behaviours', 1, 1),
(445, '1.8', 'sense of humour', 1, 1),
(446, '1.9', 'religious beliefs', 1, 1),
(447, '1.10', 'social norms', 1, 1),
(448, '1.11', 'cultural values', 1, 1),
(449, '2', 'I am aware of cultural diversity in Australia in terms of', 2, 1),
(450, '2.1', 'The history of cultural diversity in Australia', 2, 1),
(451, '2.2', 'The extent of cultural diversity in Australia', 2, 1),
(452, '2.3', 'The cultural diversity of people living in Australia', 2, 1),
(453, '2.4', 'The trend of immigration to Australia', 2, 1),
(454, '2.5', 'The experience of people in intercultural interactions in Australia', 2, 1),
(455, '2.6', 'The challenges faced by people in intercultural interactions in Australia', 2, 1),
(456, '3', 'I am willing to continuously learn about diverse culture through my approach to', 3, 1),
(457, '3.1', 'Read cultural material from different sources', 3, 1),
(458, '3.2', 'attend cultural competency training programs', 3, 1),
(459, '3.3', 'watch movies from other cultures', 3, 1),
(460, '3.4', 'observe people from diverse cultural backgrounds on social media', 3, 1),
(461, '3.5', 'interact with people from diverse cultural backgrounds', 3, 1),
(462, '3.6', 'Get involved in activities with people from diverse cultural backgrounds', 3, 1),
(463, '3.7', 'work in a multicultural workspace', 3, 1),
(464, '3.8', 'ask people about their cultures', 3, 1),
(465, '3.9', 'Listen to music from other cultures', 3, 1),
(466, '3.10', 'Attend multicultural events (e.g. festivals)', 3, 1),
(467, '4', 'I am interested in cultural diversity because it allows me to', 4, 1),
(468, '4.1', 'Meet people from diverse cultural backgrounds', 4, 1),
(469, '4.2', 'learn different ways of looking at things', 4, 1),
(470, '4.3', 'acquire new experiences', 4, 1),
(471, '4.4', 'try a wider variety of ethnic foods', 4, 1),
(472, '4.5', 'enjoy a wider variety of music', 4, 1),
(473, '4.6', 'acquire a broader range of skills', 4, 1),
(474, '4.7', 'make my personal network culturally more diverse', 4, 1),
(475, '4.8', 'make my professional network culturally more diverse', 4, 1),
(476, '4.9', 'enrich my own culture with new experiences', 4, 1),
(477, '4.10', 'build a positive attitude towards people from diverse cultural backgrounds', 4, 1),
(478, '4.11', 'grow as a person', 4, 1),
(479, '5', 'I am able to process my knowledge about diverse cultures through my approach to', 5, 1),
(480, '5.1', 'see things from their point of view', 5, 1),
(481, '5.2', 'see the world from their eyes', 5, 1),
(482, '5.3', 'employ different cultural frames of reference', 5, 1),
(483, '5.4', 'see various sides of multicultural issue by an unbiased mindset', 5, 1),
(484, '5.5', 'assess the cultural knowledge I acquire from different sources in an unbiased manner', 5, 1),
(485, '5.6', 'apply my cultural knowledge into the way I think', 5, 1),
(486, '5.7', 'apply my cultural knowledge into the way I behave', 5, 1),
(487, '5.8', 'continuously monitor my thinking based on my cultural knowledge', 5, 1),
(488, '5.9', 'continuously monitor my behaviour based on my cultural knowledge', 5, 1),
(489, '6', 'I am willing to accept cultural diversity in terms of how people in other cultures', 6, 1),
(490, '6.1', 'are different from me', 6, 1),
(491, '6.2', 'do not physically look like me', 6, 1),
(492, '6.3', 'speak with an accent different from me', 6, 1),
(493, '6.4', 'do not dress like me', 6, 1),
(494, '6.5', 'have food habits different from me', 6, 1),
(495, '6.6', 'have hobbies different from me', 6, 1),
(496, '6.7', 'do not behave like me', 6, 1),
(497, '6.8', 'have different cultural perspectives than my own', 6, 1),
(498, '6.9', 'have underlying social norms different from me', 6, 1),
(499, '6.10', 'have underlying cultural values different from me', 6, 1),
(500, '6.11', 'have beliefs different from me', 6, 1),
(501, '6.12', 'work differently compared to me', 6, 1),
(502, '7', 'I am able to adjust my behaviour when interacting with people from diverse cultural backgrounds, such as', 7, 1),
(503, '7.1', 'shift my behaviours in a manner which is appropriate in a multicultural context', 7, 1),
(504, '7.2', 'alter my behavioural habits that may offend them', 7, 1),
(505, '7.3', 'respect diverse cultural practices', 7, 1),
(506, '7.4', 'respect diverse cultural norms', 7, 1),
(507, '7.5', 'not acting rude in situations when I do not understand the other person', 7, 1),
(508, '7.6', 'not acting rude if the other person does not understand me', 7, 1),
(509, '7.7', 'seek help from a person who is aware of the other culture if there is a miscommunication', 7, 1),
(510, '7.8', 'deal effectively with cultural misunderstandings', 7, 1),
(511, '8', 'I am willing to put extra effort to adjust my behaviour when interacting with people from diverse cultural backgrounds, such as', 8, 1),
(512, '8.1', 'alter certain aspects of doing things as per my culture', 8, 1),
(513, '8.2', 'include certain interesting elements from other cultures into my behaviour', 8, 1),
(514, '8.3', 'ask for feedback from others on how I can be corrected if I am wrong', 8, 1),
(515, '8.4', 'make everyone, regardless of their culture, feels included', 8, 1),
(516, '8.5', 'demonstrate my objection to cultural discrimination', 8, 1),
(517, '9', 'I am able to communicate effectively when interacting with people from diverse cultural backgrounds, such as', 9, 1),
(518, '9.1', 'speak very clearly', 9, 1),
(519, '9.2', 'avoid unnecessary words', 9, 1),
(520, '9.3', 'use a clear accent', 9, 1),
(521, '9.4', 'change my speaking speed in order to be understood', 9, 1),
(522, '9.5', 'choose my words carefully as not to hurt others', 9, 1),
(523, '9.6', 'change my language that may be considered offensive', 9, 1),
(524, '9.7', 'adjust my body language', 9, 1),
(525, '9.8', 'make the effort to listen carefully', 9, 1),
(526, '9.9', 'repeat sentences again if the other person does not understand me', 9, 1),
(527, '10', 'When it comes to communication with people from diverse cultural backgrounds, I am confident enough to', 10, 1),
(528, '10.1', 'approach them in a friendly manner', 10, 1),
(529, '10.2', 'initiate conversations with them', 10, 1),
(530, '10.3', 'develop in-depth communications', 10, 1),
(531, '10.4', 'maintain a satisfying level of communication', 10, 1),
(532, '10.5', 'find mutual interest between myself and them', 10, 1),
(533, '10.6', 'work successfully with them', 10, 1),
(534, '10.7', 'easily communicate with them in english', 10, 1),
(535, '11', 'When it comes to communication with people from diverse cultural backgrounds', 11, 1),
(536, '11.1', 'I am comfortable to have close face-to-face communication with them', 11, 1),
(537, '11.2', 'I am comfortable to have close online communication with them', 11, 1),
(538, '11.3', 'I am comfortable to be friend with them', 11, 1),
(539, '11.4', 'I am comfortable to keep them in my network', 11, 1),
(540, '11.5', 'I am comfortable to work in a multicultural organisation', 11, 1),
(541, '11.6', 'I am comfortable to work in multicultural teams', 11, 1),
(542, '11.7', 'I think I am starting from the scratch', 11, 1),
(543, '11.8', 'having less familiar things to refer to makes it uncomfortable to communicate with them', 11, 1),
(544, '11.9', 'having less similar experiences makes it uncomfortable to communicate with them', 11, 1),
(545, '11.10', 'misunderstandings make it uncomfortable to communicate with them', 11, 1),
(546, '12', 'To what extent do you interact with the following people whose cultural background is different from your own?', 12, 1),
(547, '12.1', 'Work colleagues in your organisation', 12, 1),
(548, '12.2', 'Work colleagues in other organisation', 12, 1),
(549, '12.3', 'Customers/Clients', 12, 1),
(550, '12.4', 'Others outside the workplace', 12, 1),
(551, '13', 'The members of the organisation I am working for are very different from each other in terms of', 13, 1),
(552, '13.1', 'Race or ethnicity', 13, 1),
(553, '13.2', 'Nationality', 13, 1),
(554, '13.3', 'Customs or culture', 13, 1),
(555, '13.4', 'language', 13, 1),
(556, '13.5', 'religious beliefs', 13, 1),
(557, '14', 'The members of the work unit I am working in are very different from each other in terms of', 14, 1),
(558, '14.1', 'Race or ethnicity', 14, 1),
(559, '14.2', 'Nationality', 14, 1),
(560, '14.3', 'Customs or culture', 14, 1),
(561, '14.4', 'language', 14, 1),
(562, '14.5', 'religious beliefs', 14, 1),
(563, '15', 'The organisation I am working for serves customers or clients who are very different from each other in terms of', 15, 1),
(564, '15.1', 'Race or ethnicity', 15, 1),
(565, '15.2', 'Nationality', 15, 1),
(566, '15.3', 'Customs or culture', 15, 1),
(567, '15.4', 'language', 15, 1),
(568, '15.5', 'religious beliefs', 15, 1),
(569, '16', 'Which of the following sectors do you currently work in?', 16, 1),
(570, '17', 'Which industry division best describes where you are employed?', 17, 1),
(571, '18', 'Which industry sub division best describes where you are employed?', 18, 1),
(572, '19', 'Which major group best describes your occupation?', 19, 1),
(573, '20', 'Which group best describes your occupation?', 20, 1),
(574, '21', 'How long you have been in the workforce?', 21, 1),
(575, '22', 'How long you have been working in your current organisation?', 22, 1),
(576, '23', 'What is the highest qualification level you have completed?', 23, 1),
(577, '24', 'Please select your gender', 24, 1),
(578, '25', 'Please select your age range', 25, 1),
(579, '26', 'Please select your country of birth', 26, 1),
(580, '27', 'Please select your ancestry', 27, 1),
(581, '28', 'Which state or territory do you live in Australia?', 28, 1),
(582, '29', 'How long have you lived in Australia?', 29, 1),
(583, '30', 'How long have you lived outside your country of birth?', 30, 1);

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

--
-- Table structure for table `user_answers`
--

CREATE TABLE `user_answers` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `IPAddress` varchar(100) DEFAULT NULL,
  `Progress` int(11) DEFAULT NULL,
  `Duration_in_seconds` int(11) DEFAULT NULL,
  `Finished` varchar(10) DEFAULT NULL,
  `RecordedDate` datetime DEFAULT NULL,
  `ResponseId` varchar(255) DEFAULT NULL,
  `RecipientLastName` varchar(255) DEFAULT NULL,
  `RecipientFirstName` varchar(255) DEFAULT NULL,
  `RecipientEmail` varchar(255) DEFAULT NULL,
  `ExternalReference` varchar(255) DEFAULT NULL,
  `LocationLatitude` varchar(100) DEFAULT NULL,
  `LocationLongitude` varchar(100) DEFAULT NULL,
  `DistributionChannel` varchar(100) DEFAULT NULL,
  `UserLanguage` varchar(50) DEFAULT NULL,
  `1_1` tinyint(4) DEFAULT NULL,
  `1_2` tinyint(4) DEFAULT NULL,
  `1_3` tinyint(4) DEFAULT NULL,
  `1_4` tinyint(4) DEFAULT NULL,
  `1_5` tinyint(4) DEFAULT NULL,
  `1_6` tinyint(4) DEFAULT NULL,
  `1_7` tinyint(4) DEFAULT NULL,
  `1_8` tinyint(4) DEFAULT NULL,
  `1_9` tinyint(4) DEFAULT NULL,
  `1_10` tinyint(4) DEFAULT NULL,
  `1_11` tinyint(4) DEFAULT NULL,
  `2_1` tinyint(4) DEFAULT NULL,
  `2_2` tinyint(4) DEFAULT NULL,
  `2_3` tinyint(4) DEFAULT NULL,
  `2_4` tinyint(4) DEFAULT NULL,
  `2_5` tinyint(4) DEFAULT NULL,
  `2_6` tinyint(4) DEFAULT NULL,
  `3_1` tinyint(4) DEFAULT NULL,
  `3_2` tinyint(4) DEFAULT NULL,
  `3_3` tinyint(4) DEFAULT NULL,
  `3_4` tinyint(4) DEFAULT NULL,
  `3_5` tinyint(4) DEFAULT NULL,
  `3_6` tinyint(4) DEFAULT NULL,
  `3_7` tinyint(4) DEFAULT NULL,
  `3_8` tinyint(4) DEFAULT NULL,
  `3_9` tinyint(4) DEFAULT NULL,
  `3_10` tinyint(4) DEFAULT NULL,
  `4_1` tinyint(4) DEFAULT NULL,
  `4_2` tinyint(4) DEFAULT NULL,
  `4_3` tinyint(4) DEFAULT NULL,
  `4_4` tinyint(4) DEFAULT NULL,
  `4_5` tinyint(4) DEFAULT NULL,
  `4_6` tinyint(4) DEFAULT NULL,
  `4_7` tinyint(4) DEFAULT NULL,
  `4_8` tinyint(4) DEFAULT NULL,
  `4_9` tinyint(4) DEFAULT NULL,
  `4_10` tinyint(4) DEFAULT NULL,
  `4_11` tinyint(4) DEFAULT NULL,
  `5_1` tinyint(4) DEFAULT NULL,
  `5_2` tinyint(4) DEFAULT NULL,
  `5_3` tinyint(4) DEFAULT NULL,
  `5_4` tinyint(4) DEFAULT NULL,
  `5_5` tinyint(4) DEFAULT NULL,
  `5_6` tinyint(4) DEFAULT NULL,
  `5_7` tinyint(4) DEFAULT NULL,
  `5_8` tinyint(4) DEFAULT NULL,
  `5_9` tinyint(4) DEFAULT NULL,
  `6_1` tinyint(4) DEFAULT NULL,
  `6_2` tinyint(4) DEFAULT NULL,
  `6_3` tinyint(4) DEFAULT NULL,
  `6_4` tinyint(4) DEFAULT NULL,
  `6_5` tinyint(4) DEFAULT NULL,
  `6_6` tinyint(4) DEFAULT NULL,
  `6_7` tinyint(4) DEFAULT NULL,
  `6_8` tinyint(4) DEFAULT NULL,
  `6_9` tinyint(4) DEFAULT NULL,
  `6_10` tinyint(4) DEFAULT NULL,
  `6_11` tinyint(4) DEFAULT NULL,
  `6_12` tinyint(4) DEFAULT NULL,
  `7_1` tinyint(4) DEFAULT NULL,
  `7_2` tinyint(4) DEFAULT NULL,
  `7_3` tinyint(4) DEFAULT NULL,
  `7_4` tinyint(4) DEFAULT NULL,
  `7_5` tinyint(4) DEFAULT NULL,
  `7_6` tinyint(4) DEFAULT NULL,
  `7_7` tinyint(4) DEFAULT NULL,
  `7_8` tinyint(4) DEFAULT NULL,
  `8_1` tinyint(4) DEFAULT NULL,
  `8_2` tinyint(4) DEFAULT NULL,
  `8_3` tinyint(4) DEFAULT NULL,
  `8_4` tinyint(4) DEFAULT NULL,
  `8_5` tinyint(4) DEFAULT NULL,
  `9_1` tinyint(4) DEFAULT NULL,
  `9_2` tinyint(4) DEFAULT NULL,
  `9_3` tinyint(4) DEFAULT NULL,
  `9_4` tinyint(4) DEFAULT NULL,
  `9_5` tinyint(4) DEFAULT NULL,
  `9_6` tinyint(4) DEFAULT NULL,
  `9_7` tinyint(4) DEFAULT NULL,
  `9_8` tinyint(4) DEFAULT NULL,
  `9_9` tinyint(4) DEFAULT NULL,
  `10_1` tinyint(4) DEFAULT NULL,
  `10_2` tinyint(4) DEFAULT NULL,
  `10_3` tinyint(4) DEFAULT NULL,
  `10_4` tinyint(4) DEFAULT NULL,
  `10_5` tinyint(4) DEFAULT NULL,
  `10_6` tinyint(4) DEFAULT NULL,
  `10_7` tinyint(4) DEFAULT NULL,
  `11_1` tinyint(4) DEFAULT NULL,
  `11_2` tinyint(4) DEFAULT NULL,
  `11_3` tinyint(4) DEFAULT NULL,
  `11_4` tinyint(4) DEFAULT NULL,
  `11_5` tinyint(4) DEFAULT NULL,
  `11_6` tinyint(4) DEFAULT NULL,
  `11_7` tinyint(4) DEFAULT NULL,
  `11_8` tinyint(4) DEFAULT NULL,
  `11_9` tinyint(4) DEFAULT NULL,
  `11_10` tinyint(4) DEFAULT NULL,
  `12_1` tinyint(4) DEFAULT NULL,
  `12_2` tinyint(4) DEFAULT NULL,
  `12_3` tinyint(4) DEFAULT NULL,
  `12_4` tinyint(4) DEFAULT NULL,
  `13_1` tinyint(4) DEFAULT NULL,
  `13_2` tinyint(4) DEFAULT NULL,
  `13_3` tinyint(4) DEFAULT NULL,
  `13_4` tinyint(4) DEFAULT NULL,
  `13_5` tinyint(4) DEFAULT NULL,
  `14_1` tinyint(4) DEFAULT NULL,
  `14_2` tinyint(4) DEFAULT NULL,
  `14_3` tinyint(4) DEFAULT NULL,
  `14_4` tinyint(4) DEFAULT NULL,
  `14_5` tinyint(4) DEFAULT NULL,
  `15_1` tinyint(4) DEFAULT NULL,
  `15_2` tinyint(4) DEFAULT NULL,
  `15_3` tinyint(4) DEFAULT NULL,
  `15_4` tinyint(4) DEFAULT NULL,
  `15_5` tinyint(4) DEFAULT NULL,
  `16` int(10) DEFAULT NULL,
  `17` tinyint(4) DEFAULT NULL,
  `18` tinyint(4) DEFAULT NULL,
  `19` tinyint(4) DEFAULT NULL,
  `20` tinyint(4) DEFAULT NULL,
  `21` tinyint(4) DEFAULT NULL,
  `22` tinyint(4) DEFAULT NULL,
  `23` tinyint(4) DEFAULT NULL,
  `24` tinyint(4) DEFAULT NULL,
  `25` tinyint(4) DEFAULT NULL,
  `26` tinyint(4) DEFAULT NULL,
  `27` tinyint(4) DEFAULT NULL,
  `28` tinyint(4) DEFAULT NULL,
  `29` int(10) DEFAULT NULL,
  `30` int(10) DEFAULT NULL,
  `Q_TotalDuration` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_answers`
--

INSERT INTO `user_answers` (`id`, `user_id`, `StartDate`, `EndDate`, `Status`, `IPAddress`, `Progress`, `Duration_in_seconds`, `Finished`, `RecordedDate`, `ResponseId`, `RecipientLastName`, `RecipientFirstName`, `RecipientEmail`, `ExternalReference`, `LocationLatitude`, `LocationLongitude`, `DistributionChannel`, `UserLanguage`, `1_1`, `1_2`, `1_3`, `1_4`, `1_5`, `1_6`, `1_7`, `1_8`, `1_9`, `1_10`, `1_11`, `2_1`, `2_2`, `2_3`, `2_4`, `2_5`, `2_6`, `3_1`, `3_2`, `3_3`, `3_4`, `3_5`, `3_6`, `3_7`, `3_8`, `3_9`, `3_10`, `4_1`, `4_2`, `4_3`, `4_4`, `4_5`, `4_6`, `4_7`, `4_8`, `4_9`, `4_10`, `4_11`, `5_1`, `5_2`, `5_3`, `5_4`, `5_5`, `5_6`, `5_7`, `5_8`, `5_9`, `6_1`, `6_2`, `6_3`, `6_4`, `6_5`, `6_6`, `6_7`, `6_8`, `6_9`, `6_10`, `6_11`, `6_12`, `7_1`, `7_2`, `7_3`, `7_4`, `7_5`, `7_6`, `7_7`, `7_8`, `8_1`, `8_2`, `8_3`, `8_4`, `8_5`, `9_1`, `9_2`, `9_3`, `9_4`, `9_5`, `9_6`, `9_7`, `9_8`, `9_9`, `10_1`, `10_2`, `10_3`, `10_4`, `10_5`, `10_6`, `10_7`, `11_1`, `11_2`, `11_3`, `11_4`, `11_5`, `11_6`, `11_7`, `11_8`, `11_9`, `11_10`, `12_1`, `12_2`, `12_3`, `12_4`, `13_1`, `13_2`, `13_3`, `13_4`, `13_5`, `14_1`, `14_2`, `14_3`, `14_4`, `14_5`, `15_1`, `15_2`, `15_3`, `15_4`, `15_5`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `24`, `25`, `26`, `27`, `28`, `29`, `30`, `Q_TotalDuration`, `created_at`, `updated_at`) VALUES
(6, 'SACH3912', '2026-05-21 18:10:33', NULL, '1', '127.0.0.1', 100, NULL, NULL, '2026-05-21 18:12:35', NULL, 'deshwal', 'sachin', NULL, 'SACH3912', NULL, NULL, 'Chrome', 'English', 1, 1, 1, 2, 2, 1, 2, 3, 3, 3, 3, 3, 3, 3, 4, 4, 4, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 3, 3, 3, 3, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4, 3, 2, 2, 2, 2, 2, 2, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3, 3, 3, 3, 3, 3, 2, 2, 1, 1, 1, 1, 1, 1, 2, 3, 3, 3, 1, 1, 1, 1, 1, 2, 14, 16, 3, 3, 9, 5, 2, 2, 4, 16, 16, 3, 12, 12, NULL, '2026-05-21 12:40:33', '2026-05-21 12:42:54'),
(7, 'RAHU9435', '2026-05-22 18:18:36', NULL, '1', '127.0.0.1', 50, NULL, NULL, '2026-06-01 17:40:24', NULL, 'singh', 'rahul', NULL, 'RAHU9435', NULL, NULL, 'Chrome', 'English', 1, 1, 2, 2, 3, 3, 4, 4, 4, 4, 5, 1, 1, 1, 2, 2, 2, 1, 2, 2, 2, 2, 1, 1, 1, 2, 2, 1, 1, 1, 2, 2, 2, 1, 1, 1, 1, 2, 1, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 3, 2, 2, 2, 2, 3, 3, 3, 1, 2, 3, 4, 5, 7, 7, 7, 7, 7, 7, 7, 7, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 3, 3, 3, 3, 3, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 2, 3, 3, 3, 3, 2, 2, 2, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 12:48:36', '2026-06-01 12:10:24');

--
-- Indexes for table `mri_ind`
--
ALTER TABLE `mri_ind`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `org_answers`
--
ALTER TABLE `org_answers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `org_questions`
--
ALTER TABLE `org_questions`
  ADD PRIMARY KEY (`sr_no`);

--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
  ADD PRIMARY KEY (`sr_no`);

--
-- Indexes for table `user_answers`
--
ALTER TABLE `user_answers`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `mri_ind`
--
ALTER TABLE `mri_ind`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `org_answers`
--
ALTER TABLE `org_answers`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `org_questions`
--
ALTER TABLE `org_questions`
  MODIFY `sr_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154;

--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
  MODIFY `sr_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=584;

--
-- AUTO_INCREMENT for table `user_answers`
--
ALTER TABLE `user_answers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

