-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 28, 2025 at 06:59 AM
-- Server version: 10.11.13-MariaDB
-- PHP Version: 8.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `unic_db`
--

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `option_id` int(11) NOT NULL COMMENT 'Unique ID',
  `option_name` varchar(150) DEFAULT NULL COMMENT 'Option Name',
  `question_id` int(11) DEFAULT NULL COMMENT 'question->question_id',
  `option_sequence` varchar(45) DEFAULT NULL COMMENT 'Option Sequence No.',
  `status` int(11) DEFAULT 0 COMMENT 'Active/Inactive',
  `is_terminate` int(11) NOT NULL DEFAULT 0,
  `option_type` varchar(50) NOT NULL,
  `serial_no_for_app` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`option_id`, `option_name`, `question_id`, `option_sequence`, `status`, `is_terminate`, `option_type`, `serial_no_for_app`) VALUES
(1, 'Original Address', 22, '1', 0, 0, '', 1),
(2, 'Next Address', 22, '2', 0, 0, '', 2),
(3, 'Previous Address', 22, '3', 0, 0, '', 3),
(4, 'Substitute Address', 22, '4', 0, 0, '', 4),
(5, 'CWE staying at home', 23, '1', 0, 0, '', 1),
(6, 'CWE does not stay at home', 23, '2', 0, 0, '', 2),
(7, 'Yes - with audio recording', 24, '1', 1, 0, '', 1),
(8, 'Yes - without audio recording', 24, '2', 0, 0, '', 2),
(9, 'No - Do not wish to continue the interview (with or without audio recording)', 24, '3', 0, 0, '', 3),
(10, 'Marketing/Market Research', 25, '1', 0, 1, '', 1),
(11, 'Broadcasting Agency', 25, '2', 0, 1, '', 2),
(12, 'Working with DTH/IPTV /Cable Operator', 25, '3', 0, 1, '', 3),
(13, 'Advertising/Public Relations /Media Planning Agency', 25, '4', 0, 1, '', 4),
(14, 'Media (Print & TV)', 25, '5', 0, 1, '', 5),
(15, 'TV Channel Network', 25, '6', 0, 1, '', 6),
(16, 'Journalist/Anchor (Full time or Part time', 25, '7', 0, 1, '', 7),
(17, 'None of the above', 25, '9', 0, 0, '', 9),
(18, 'Yes', 26, '1', 0, 0, '', 1),
(19, 'No', 26, '2', 0, 1, '', 2),
(20, 'Yes', 27, '1', 0, 0, '', 1),
(21, 'No', 27, '2', 0, 1, '', 2),
(22, 'Illiterate', 28, '1', 0, 0, '', 1),
(23, 'Literate, But No Formal Schooling', 28, '2', 0, 0, '', 2),
(24, 'School - Upto 4th Standard', 28, '3', 0, 0, '', 3),
(25, 'School - 5th Standard', 28, '11', 0, 0, '', 3),
(26, 'School - 6th - 9th Standard', 28, '4', 0, 0, '', 4),
(27, 'SSC/HSC (10th-12th)', 28, '5', 0, 0, '', 5),
(28, 'Some College (Incl. Diploma) But Not Graduate', 28, '6', 0, 0, '', 6),
(29, 'Graduate - General (B.A., B.S.C., B. Com.)', 28, '7', 0, 0, '', 7),
(30, 'Graduate - Professional (B.E., M.B.B.S., B.Tech.)', 28, '8', 0, 0, '', 8),
(31, 'Post-Graduate - General (M.A., M.S.C., M. Com., M.Phil)', 28, '9', 0, 0, '', 9),
(32, 'Post-Graduate - Professional (M.E., M.Tech., M.B.A.)', 28, '10', 0, 0, '', 10),
(33, 'Air-Conditioner ', 29, '1', 0, 0, '', 1),
(34, 'Fridge-Refrigerator ', 29, '2', 0, 0, '', 2),
(35, 'Washing Machine ', 29, '3', 0, 0, '', 3),
(36, 'Color TV/LCD/LED/PLASMA TV', 29, '4', 0, 0, '', 4),
(37, 'Personal Computer / Laptop', 29, '5', 0, 0, '', 5),
(38, 'Electricity Connection (availability of electricity) ', 29, '6', 0, 0, '', 6),
(39, 'Ceiling Fan ', 29, '7', 0, 0, '', 7),
(40, 'Gas Stove Stove/PNG stove', 29, '8', 0, 0, '', 8),
(41, 'Two-Wheeler ', 29, '9', 0, 0, '', 9),
(42, 'Car/Jeep/Van ', 29, '10', 0, 0, '', 10),
(43, 'Agricultural Land', 29, '11', 0, 0, '', 11),
(44, 'Male', 34, '1', 0, 0, '', 1),
(45, 'Female', 34, '2', 0, 0, '', 2),
(46, 'Illiterate', 36, '1', 0, 0, '', 1),
(47, 'Literate, But No Formal Schooling', 36, '2', 0, 0, '', 2),
(48, 'School - Upto 4th Standard', 36, '3', 0, 0, '', 3),
(49, 'School - 5th Standard', 36, '11', 0, 0, '', 4),
(50, 'School - 6th - 9th Standard', 36, '4', 0, 0, '', 5),
(51, 'SSC/HSC (10th-12th)', 36, '5', 0, 0, '', 6),
(52, 'Some College (Incl. Diploma) But Not Graduate', 36, '6', 0, 0, '', 7),
(53, 'Graduate - General (B.A., B.S.C., B. Com.)', 36, '7', 0, 0, '', 8),
(54, 'Graduate - Professional (B.E., M.B.B.S., B.Tech.)', 36, '8', 0, 0, '', 9),
(55, 'Post-Graduate - General (M.A., M.S.C., M. Com., M.Phil)', 36, '9', 0, 0, '', 10),
(56, 'Post-Graduate - Professional (M.E., M.Tech., M.B.A.)', 36, '10', 0, 0, '', 11),
(57, 'Not Working', 37, '1', 0, 0, '', 1),
(58, 'Student Not Working', 37, '2', 0, 0, '', 2),
(59, 'Student Working Part Time', 37, '6', 0, 0, '', 6),
(60, 'Student Working Full Time', 37, '7', 0, 0, '', 7),
(61, 'Retired', 37, '3', 0, 0, '', 3),
(62, 'Working Part Time', 37, '4', 0, 0, '', 4),
(63, 'Working Full Time', 37, '5', 0, 0, '', 5),
(64, 'Unskilled Worker', 38, '1', 0, 0, 'Urban', 1),
(65, 'Skilled Worker', 38, '2', 0, 0, 'Urban', 2),
(66, 'Petty Traders', 38, '3', 0, 0, 'Urban', 3),
(67, 'Shop Owners', 38, '4', 0, 0, 'Urban', 4),
(68, 'Businessman/Industrialist (No Employees)', 38, '5', 0, 0, 'Urban', 5),
(69, 'Businessman/Industrialist (1-9 Employees)', 38, '6', 0, 0, 'Urban', 6),
(70, 'Businessman/Industrialist (10+ Employees)', 38, '7', 0, 0, 'Urban', 7),
(71, 'Self Employed Professional', 38, '8', 0, 0, 'Urban', 8),
(72, 'Clerk / Salesman', 38, '9', 0, 0, 'Urban', 9),
(73, 'Supervisory Level', 38, '10', 0, 0, 'Urban', 10),
(74, 'Officer / Executive', 38, '11', 0, 0, 'Urban', 11),
(75, 'Officer / Executive - Middle/Senior', 38, '12', 0, 0, 'Urban', 12),
(76, 'Not Applicable', 38, '99', 0, 0, 'Urban', 13),
(77, 'Owner Farmer', 38, '13', 0, 0, 'Urban', 14),
(78, 'Leased Farmer', 38, '14', 0, 0, 'Urban', 15),
(79, 'Yes', 39, '1', 0, 0, '', 1),
(80, 'No', 39, '2', 0, 0, '', 2),
(81, 'Yes', 40, '1', 0, 0, '', 1),
(82, 'No', 40, '2', 0, 0, '', 2),
(83, 'Father/Mother', 42, '1', 0, 0, '', 1),
(84, 'Husband/Wife', 42, '2', 0, 0, '', 2),
(85, 'Son/Daughter', 42, '3', 0, 0, '', 3),
(86, 'Brother/sister', 42, '4', 0, 0, '', 4),
(87, 'Grandparent', 42, '5', 0, 0, '', 5),
(88, 'Grandchild', 42, '6', 0, 0, '', 6),
(89, 'Uncle/aunt', 42, '7', 0, 0, '', 7),
(90, 'Nephew/niece', 42, '8', 0, 0, '', 8),
(91, 'Cousin', 42, '9', 0, 0, '', 9),
(92, 'Father-in-law/Mother-in-law', 42, '10', 0, 0, '', 10),
(93, 'Son-in-law/Daughter-in-law', 42, '11', 0, 0, '', 11),
(94, 'Brother-in-law/ Sister-in-law', 42, '12', 0, 0, '', 12),
(95, 'Friends staying together/ Family friend', 42, '13', 0, 0, '', 13),
(96, 'Paying Guests', 42, '14', 0, 0, '', 14),
(97, 'Full time domestic help/ Nurse', 42, '15', 0, 0, '', 15),
(98, 'Babysitter who stays in the house', 42, '16', 0, 0, '', 16),
(99, 'Self', 42, '17', 0, 0, '', 17),
(100, 'Yes', 43, '1', 0, 0, '', 1),
(101, 'No', 43, '2', 0, 0, '', 2),
(102, 'Mobile phone', 44, '1', 0, 0, '', 1),
(103, 'Tablet', 44, '2', 0, 0, '', 2),
(104, 'Desktop', 44, '3', 0, 0, '', 3),
(105, 'Laptop', 44, '4', 0, 0, '', 4),
(106, 'Smart TV', 44, '5', 0, 0, '', 5),
(107, 'We do not use internet in our household', 44, '6', 0, 0, '', 6),
(108, 'Lives in another house in the same city', 45, '1', 0, 0, '', 1),
(109, 'Lives in another city', 45, '2', 0, 0, '', 2),
(110, 'Lives outside the country', 45, '3', 0, 0, '', 3),
(111, 'Deceased / Is no more', 45, '4', 0, 0, '', 4),
(112, 'No working members. Money received as grant, allowance or help', 45, '5', 0, 0, '', 5),
(113, 'Male', 48, '1', 0, 0, '', 1),
(114, 'Female', 48, '2', 0, 0, '', 2),
(115, 'Illiterate', 49, '1', 0, 0, '', 1),
(116, 'Literate, But No Formal Schooling', 49, '2', 0, 0, '', 2),
(117, 'School - Upto 4th Standard', 49, '3', 0, 0, '', 3),
(118, 'School - 5th Standard', 49, '11', 0, 0, '', 4),
(119, 'School - 6th - 9th Standard', 49, '4', 0, 0, '', 5),
(120, 'SSC/HSC (10th-12th)', 49, '5', 0, 0, '', 6),
(121, 'Some College (Incl. Diploma) But Not Graduate', 49, '6', 0, 0, '', 7),
(122, 'Graduate - General (B.A., B.S.C., B. Com.)', 49, '7', 0, 0, '', 8),
(123, 'Graduate - Professional (B.E., M.B.B.S., B.Tech.)', 49, '8', 0, 0, '', 9),
(124, 'Post-Graduate - General (M.A., M.S.C., M. Com., M.Phil)', 49, '9', 0, 0, '', 10),
(125, 'Post-Graduate - Professional (M.E., M.Tech., M.B.A.)', 49, '10', 0, 0, '', 11),
(126, 'Not Working', 50, '1', 0, 0, '', 1),
(127, 'Student Not Working', 50, '2', 0, 0, '', 2),
(128, 'Student Working Part Time', 50, '6', 0, 0, '', 3),
(129, 'Student Working Full Time', 50, '7', 0, 0, '', 4),
(130, 'Retired', 50, '3', 0, 0, '', 5),
(131, 'Working Part Time', 50, '4', 0, 0, '', 6),
(132, 'Working Full Time', 50, '5', 0, 0, '', 7),
(133, 'Unskilled Worker', 51, '1', 0, 0, 'Urban', 1),
(134, 'Skilled Worker', 51, '2', 0, 0, 'Urban', 2),
(135, 'Petty Traders', 51, '3', 0, 0, 'Urban', 3),
(136, 'Shop Owners', 51, '4', 0, 0, 'Urban', 4),
(137, 'Businessman/Industrialist (No Employees)', 51, '5', 0, 0, 'Urban', 5),
(138, 'Businessman/Industrialist (1-9 Employees)', 51, '6', 0, 0, 'Urban', 6),
(139, 'Businessman/Industrialist (10+ Employees)', 51, '7', 0, 0, 'Urban', 7),
(140, 'Self Employed Professional', 51, '8', 0, 0, 'Urban', 8),
(141, 'Clerk / Salesman', 51, '9', 0, 0, 'Urban', 9),
(142, 'Supervisory Level', 51, '10', 0, 0, 'Urban', 10),
(143, 'Officer / Executive', 51, '11', 0, 0, 'Urban', 11),
(144, 'Officer / Executive - Middle/Senior', 51, '12', 0, 0, 'Urban', 12),
(145, 'Not Applicable', 51, '99', 0, 0, 'Urban', 13),
(146, 'Owner Farmer', 51, '13', 0, 0, 'Urban', 14),
(147, 'Leased Farmer', 51, '14', 0, 0, 'Urban', 15),
(148, 'Married', 52, '1', 0, 0, '', 1),
(149, 'Unmarried', 52, '2', 0, 0, '', 2),
(150, 'Divorced', 52, '3', 0, 0, '', 3),
(151, 'Widowed', 52, '4', 0, 0, '', 4),
(152, 'Alive', 53, '1', 1, 0, '', 1),
(153, 'Not living at home', 53, '2', 0, 0, '', 2),
(154, 'Dead/Deceased', 53, '3', 0, 0, '', 3),
(155, 'Air-Conditioner ', 54, '1', 0, 0, '', 1),
(156, 'Fridge-Refrigerator ', 54, '2', 0, 0, '', 2),
(157, 'Washing Machine ', 54, '3', 0, 0, '', 3),
(158, 'Color TV/LCD/LED/PLASMA TV', 54, '4', 0, 0, '', 4),
(159, 'Personal Computer / Laptop', 54, '5', 0, 0, '', 5),
(160, 'Electricity Connection (availability of electricity) ', 54, '6', 0, 0, '', 6),
(161, 'Ceiling Fan ', 54, '7', 0, 0, '', 7),
(162, 'Gas Stove Stove/PNG stove', 54, '8', 0, 0, '', 8),
(163, 'Two-Wheeler ', 54, '9', 0, 0, '', 9),
(164, 'Car/Jeep/Van ', 54, '10', 0, 0, '', 10),
(165, 'Agricultural Land', 54, '11', 0, 0, '', 11),
(166, 'Electric Induction plate', 55, '1', 0, 0, '', 1),
(167, 'Kerosene stove', 55, '2', 0, 0, '', 2),
(168, 'Chulha', 55, '3', 0, 0, '', 3),
(169, 'Solar cooking', 55, '4', 0, 0, '', 4),
(170, 'Sigree (Coal cooking)', 55, '5', 0, 0, '', 5),
(171, 'Living room', 58, '1', 0, 0, '', 1),
(172, 'Bed room', 58, '2', 0, 0, '', 2),
(173, 'Any other room', 58, '3', 0, 0, '', 3),
(174, 'Black & White', 59, '2', 0, 0, '', 2),
(175, 'Color', 59, '1', 0, 0, '', 1),
(176, 'Conventional TV', 60, '1', 0, 0, '', 1),
(177, 'LCD/LED/Plasma TV', 60, '2', 0, 0, '', 2),
(178, 'Aiwa', 61, '1', 0, 0, '', 1),
(179, 'Akai', 61, '2', 0, 0, '', 2),
(180, 'BenQ', 61, '3', 0, 0, '', 3),
(181, 'Bose', 61, '4', 0, 0, '', 4),
(182, 'BPL', 61, '5', 0, 0, '', 5),
(183, 'BPL Sanyo', 61, '6', 0, 0, '', 6),
(184, 'Bush', 61, '7', 0, 0, '', 7),
(185, 'Crown', 61, '8', 0, 0, '', 8),
(186, 'Haier', 61, '9', 0, 0, '', 9),
(187, 'Hitachi', 61, '10', 0, 0, '', 10),
(188, 'Hyundai', 61, '11', 0, 0, '', 11),
(189, 'LG', 61, '12', 0, 0, '', 12),
(190, 'Lloyd', 61, '13', 0, 0, '', 13),
(191, 'Micromax', 61, '14', 0, 0, '', 14),
(192, 'National', 61, '15', 0, 0, '', 15),
(193, 'National Panasonic', 61, '16', 0, 0, '', 16),
(194, 'Onida', 61, '17', 0, 0, '', 17),
(195, 'Panasonic', 61, '18', 0, 0, '', 18),
(196, 'Philips', 61, '19', 0, 0, '', 19),
(197, 'Salora', 61, '20', 0, 0, '', 20),
(198, 'Samsung', 61, '21', 0, 0, '', 21),
(199, 'Sansui', 61, '22', 0, 0, '', 22),
(200, 'Sharp', 61, '23', 0, 0, '', 23),
(201, 'Sony', 61, '24', 0, 0, '', 24),
(202, 'TCL', 61, '25', 0, 0, '', 25),
(203, 'Toshiba', 61, '26', 0, 0, '', 26),
(204, 'Uptron', 61, '27', 0, 0, '', 27),
(205, 'Videocon', 61, '28', 0, 0, '', 28),
(206, 'VU', 61, '29', 0, 0, '', 29),
(207, 'Weston', 61, '30', 0, 0, '', 30),
(208, 'Other Branded', 61, '31', 0, 0, '', 31),
(209, 'Unbranded', 61, '32', 0, 0, '', 32),
(210, 'Do not Know / Can not Say', 61, '33', 0, 0, '', 33),
(211, 'Yes', 62, '1', 0, 0, '', 1),
(212, 'No', 62, '2', 0, 0, '', 2),
(213, '14 Inches or less', 63, '1', 0, 0, '', 1),
(214, '15-19 inches', 63, '2', 0, 0, '', 2),
(215, '20 inches', 63, '3', 0, 0, '', 3),
(216, '21 inches', 63, '4', 0, 0, '', 4),
(217, '22-24 inches', 63, '5', 0, 0, '', 5),
(218, '25 inches', 63, '6', 0, 0, '', 6),
(219, '26-28 inches', 63, '7', 0, 0, '', 7),
(220, '29 inches', 63, '8', 0, 0, '', 8),
(221, '30 - 31 inches', 63, '9', 0, 0, '', 9),
(222, '32 inches', 63, '10', 0, 0, '', 10),
(223, '33-37 inches', 63, '11', 0, 0, '', 11),
(224, '38-42 inches', 63, '12', 0, 0, '', 12),
(225, '43-46 inches', 63, '13', 0, 0, '', 13),
(226, 'More than 46 inches', 63, '14', 0, 0, '', 14),
(227, 'Dont know/ Cant say', 63, '99', 0, 0, '', 15),
(228, 'DTH ', 64, '1', 0, 0, '', 1),
(229, 'Normal Antenna', 64, '2', 0, 0, '', 2),
(230, 'Local cable operator (with set top box)', 64, '3', 0, 0, '', 3),
(231, 'Local cable operator (without set top box)', 64, '4', 1, 0, '', 4),
(232, 'IPTV', 64, '5', 1, 0, '', 5),
(233, 'OTT (i.e. Via internet - fire stick, screen mirror, Smartphone etc)', 64, '6', 1, 0, '', 6),
(234, 'DK/CS', 64, '7', 1, 0, '', 7),
(235, 'None', 64, '8', 1, 0, '', 8),
(236, 'Dish TV', 65, '1', 0, 0, '', 1),
(237, 'Airtel TV', 65, '2', 0, 0, '', 2),
(238, 'Doordarshan-DD Direct/ DD Freedish', 65, '3', 0, 0, '', 3),
(239, 'Tata Sky', 65, '4', 0, 0, '', 4),
(240, 'Videocon D2H', 65, '5', 0, 0, '', 5),
(241, 'Sun direct', 65, '6', 0, 0, '', 6),
(242, 'Reliance Big TV/Independent TV', 65, '7', 0, 0, '', 7),
(243, 'Zing Digital', 65, '8', 0, 0, '', 8),
(244, 'Hathway', 66, '11', 0, 0, '', 1),
(245, 'DEN', 66, '12', 0, 0, '', 2),
(246, 'Siti Cable', 66, '13', 0, 0, '', 3),
(247, 'IN Cable', 66, '14', 0, 0, '', 4),
(248, 'GTPL', 66, '15', 0, 0, '', 5),
(249, 'Fastway', 66, '16', 0, 0, '', 6),
(250, 'Kable First', 66, '17', 0, 0, '', 7),
(251, 'Digicable', 66, '18', 0, 0, '', 8),
(252, 'Media Vision', 66, '19', 0, 0, '', 9),
(253, 'E Infrastructure', 66, '20', 0, 0, '', 10),
(254, 'KCV', 66, '21', 0, 0, '', 11),
(255, 'Darsh', 66, '22', 0, 0, '', 12),
(256, 'Arasu', 66, '23', 0, 0, '', 13),
(257, 'SCV', 66, '24', 0, 0, '', 14),
(258, 'Manthan', 66, '25', 0, 0, '', 15),
(259, 'Asianet', 66, '26', 0, 0, '', 16),
(260, 'Ortel', 66, '27', 0, 0, '', 17),
(261, 'RED / SR Digital', 66, '28', 0, 0, '', 18),
(262, 'UCN', 66, '29', 0, 0, '', 19),
(263, 'Signet', 66, '30', 0, 0, '', 20),
(264, 'Take One Media', 66, '32', 0, 0, '', 21),
(265, 'Sky Net', 66, '33', 0, 0, '', 22),
(266, 'Net Vision', 66, '34', 0, 0, '', 23),
(267, 'Shekhawati Cable', 66, '35', 0, 0, '', 24),
(268, 'A.C.N', 66, '36', 0, 0, '', 25),
(269, 'Rajasthan Infotech', 66, '37', 0, 0, '', 26),
(270, 'Neo', 66, '38', 0, 0, '', 27),
(271, 'Bhima Riddhi', 66, '39', 0, 0, '', 28),
(272, 'Nxt Hits', 66, '40', 0, 0, '', 29),
(273, 'ABPL', 66, '41', 0, 0, '', 30),
(274, 'BSN', 66, '42', 0, 0, '', 31),
(275, 'ACT DIGITAL', 66, '43', 0, 0, '', 32),
(276, 'You Scod', 66, '44', 0, 0, '', 33),
(277, 'KCBP', 66, '45', 0, 0, '', 34),
(278, 'ABC Digital', 66, '46', 0, 0, '', 35),
(279, 'ABS DIGITAL', 66, '47', 0, 0, '', 36),
(280, 'ACDC Digital', 66, '48', 0, 0, '', 37),
(281, 'AJK Network/MV Digital Network', 66, '49', 0, 0, '', 38),
(282, 'ALL DIGITAL', 66, '50', 0, 0, '', 39),
(283, 'ALTIMETRIC DIGITAL', 66, '51', 0, 0, '', 40),
(284, 'AMN Digital', 66, '52', 0, 0, '', 41),
(285, 'AP Fiber/APSFL', 66, '53', 0, 0, '', 42),
(286, 'ASCSC', 66, '54', 0, 0, '', 43),
(287, 'Bajarangi Digital', 66, '55', 0, 0, '', 44),
(288, 'BDS CABLE', 66, '56', 0, 0, '', 45),
(289, 'Bharati Digital', 66, '57', 0, 0, '', 46),
(290, 'Bhaskar TV Digital', 66, '58', 0, 0, '', 47),
(291, 'Bhimavaram Community Network (BCN Digital)', 66, '59', 0, 0, '', 48),
(292, 'BHOOMIKA', 66, '60', 0, 0, '', 49),
(293, 'Brightway Digital', 66, '61', 0, 0, '', 50),
(294, 'Cable Cast Digital Network', 66, '62', 0, 0, '', 51),
(295, 'Canara Star Digital', 66, '63', 0, 0, '', 52),
(296, 'CATVISION', 66, '64', 0, 0, '', 53),
(297, 'CCN Digital', 66, '65', 0, 0, '', 54),
(298, 'CCON', 66, '66', 0, 0, '', 55),
(299, 'CEL Digital', 66, '67', 0, 0, '', 56),
(300, 'Channel 9 Net Digital', 66, '68', 0, 0, '', 57),
(301, 'Citi cable', 66, '69', 0, 0, '', 58),
(302, 'COWMALAYA', 66, '70', 0, 0, '', 59),
(303, 'CTN CABLE', 66, '71', 0, 0, '', 60),
(304, 'DCN', 66, '72', 0, 0, '', 61),
(305, 'DDC CABLE', 66, '73', 0, 0, '', 62),
(306, 'DEWSHREE NETWORK', 66, '74', 0, 0, '', 63),
(307, 'DIAMOND DIGITAL', 66, '75', 0, 0, '', 64),
(308, 'EM Digital', 66, '76', 0, 0, '', 65),
(309, 'Enhance Multi Trade Digital', 66, '77', 0, 0, '', 66),
(310, 'FIBTRON', 66, '78', 0, 0, '', 67),
(311, 'Garuda Digital', 66, '79', 0, 0, '', 68),
(312, 'GDN CABLE', 66, '80', 0, 0, '', 69),
(313, 'GLOBAL CHAPTER', 66, '81', 0, 0, '', 70),
(314, 'Gospell', 66, '82', 0, 0, '', 71),
(315, 'GRAND GANTLE', 66, '83', 0, 0, '', 72),
(316, 'HDS Digital', 66, '84', 0, 0, '', 73),
(317, 'HOME DIGITAL', 66, '85', 0, 0, '', 74),
(318, 'ICC DIGITAL', 66, '86', 0, 0, '', 75),
(319, 'ICE CABLE', 66, '87', 0, 0, '', 76),
(320, 'IMPACT TV', 66, '88', 0, 0, '', 77),
(321, 'INSPIRE CABLE', 66, '89', 0, 0, '', 78),
(322, 'ISTV NETWORK', 66, '90', 0, 0, '', 79),
(323, 'Jak Communications', 66, '91', 0, 0, '', 80),
(324, 'JAY NETWORK', 66, '92', 0, 0, '', 81),
(325, 'JBM Digital', 66, '93', 0, 0, '', 82),
(326, 'JPR SPACE DIGITAL', 66, '94', 0, 0, '', 83),
(327, 'KDN CABLE', 66, '95', 0, 0, '', 84),
(328, 'KHMD', 66, '96', 0, 0, '', 85),
(329, 'LMO  DIGITAL', 66, '97', 0, 0, '', 86),
(330, 'LPS', 66, '98', 0, 0, '', 87),
(331, 'Lucky Digital', 66, '101', 0, 0, '', 88),
(332, 'Machilipatnam Communication Pvt. Ltd. (MCPL Digital)', 66, '102', 0, 0, '', 89),
(333, 'MCN CABLE', 66, '103', 0, 0, '', 90),
(334, 'MEGHBELA Digital', 66, '104', 0, 0, '', 91),
(335, 'MLC CABLE', 66, '105', 0, 0, '', 92),
(336, 'MRMPL', 66, '106', 0, 0, '', 93),
(337, 'Multi Star Digital', 66, '107', 0, 0, '', 94),
(338, 'Multicity Digital/Digicon', 66, '108', 0, 0, '', 95),
(339, 'MV NETWORK', 66, '109', 0, 0, '', 96),
(340, 'Navrang Digital Cable', 66, '110', 0, 0, '', 97),
(341, 'Navya Digital', 66, '111', 0, 0, '', 98),
(342, 'NEXT GENERATION', 66, '112', 0, 0, '', 99),
(343, 'Palamoor Digital', 66, '114', 0, 0, '', 100),
(344, 'Pavani Digital', 66, '115', 0, 0, '', 101),
(345, 'Prachi Vision/Prachi Digital', 66, '116', 0, 0, '', 102),
(346, 'PRISM', 66, '117', 0, 0, '', 103),
(347, 'RADIANT DIGITAL', 66, '118', 0, 0, '', 104),
(348, 'Rajmoti cable', 66, '119', 0, 0, '', 105),
(349, 'RCBS CABLE', 66, '120', 0, 0, '', 106),
(350, 'RM CABLE', 66, '121', 0, 0, '', 107),
(351, 'RRC CABLE', 66, '122', 0, 0, '', 108),
(352, 'RSSS', 66, '123', 0, 0, '', 109),
(353, 'SAHYA', 66, '124', 0, 0, '', 110),
(354, 'Sampark Digital (Space Vision)', 66, '125', 0, 0, '', 111),
(355, 'SANKALP', 66, '126', 0, 0, '', 112),
(356, 'SAPTAK DIGITAL', 66, '127', 0, 0, '', 113),
(357, 'SBCN', 66, '128', 0, 0, '', 114),
(358, 'SCC CABLE', 66, '129', 0, 0, '', 115),
(359, 'SCN Cable', 66, '130', 0, 0, '', 116),
(360, 'SEVEN STAR', 66, '131', 0, 0, '', 117),
(361, 'SIRI CABLE', 66, '132', 0, 0, '', 118),
(362, 'SKY VISION', 66, '133', 0, 0, '', 119),
(363, 'SMART BOX', 66, '134', 0, 0, '', 120),
(364, 'SMARTWAY CABLE', 66, '135', 0, 0, '', 121),
(365, 'Sri Devi Digital', 66, '136', 0, 0, '', 122),
(366, 'Sri Sai Communications Digital', 66, '137', 0, 0, '', 123),
(367, 'SRISTI DIGITAL', 66, '138', 0, 0, '', 124),
(368, 'SSB', 66, '139', 0, 0, '', 125),
(369, 'STAR CLUB DIGITAL', 66, '140', 0, 0, '', 126),
(370, 'Surya Digital', 66, '141', 0, 0, '', 127),
(371, 'TCCL Digital', 66, '142', 0, 0, '', 128),
(372, 'TCN Digital', 66, '143', 0, 0, '', 129),
(373, 'TIGER CABLE', 66, '144', 0, 0, '', 130),
(374, 'TRIVENI', 66, '145', 0, 0, '', 131),
(375, 'UMBRELLA', 66, '146', 0, 0, '', 132),
(376, 'V DIGITAL', 66, '147', 0, 0, '', 133),
(377, 'V4 Media Digital', 66, '148', 0, 0, '', 134),
(378, 'Victory Digital', 66, '149', 0, 0, '', 135),
(379, 'VK Digital', 66, '150', 0, 0, '', 136),
(380, 'Willet', 66, '151', 0, 0, '', 137),
(381, 'Yes Digital', 66, '152', 0, 0, '', 138),
(382, 'ZONET', 66, '155', 0, 0, '', 139),
(383, 'Other Independent Operator', 66, '99', 0, 0, '', 140),
(384, 'Yes', 67, '1', 0, 0, '', 1),
(385, 'No', 67, '2', 0, 0, '', 2),
(386, 'Hotstar/Hotstar Premium (Paid Subscription)', 68, '1', 0, 0, '', 1),
(387, 'Netflix', 68, '2', 0, 0, '', 2),
(388, 'Amazon prime', 68, '3', 0, 0, '', 3),
(389, 'Zee5', 68, '4', 0, 0, '', 4),
(390, 'SonyLiv', 68, '5', 0, 0, '', 5),
(391, 'Voot', 68, '6', 0, 0, '', 6),
(392, 'Yupp TV', 68, '7', 0, 0, '', 7),
(393, 'ALT Balaji', 68, '8', 0, 0, '', 8),
(394, 'Jio Cinema / Jio TV', 68, '9', 0, 0, '', 9),
(395, 'Airtel TV', 68, '10', 0, 0, '', 10),
(396, 'Viu TV', 68, '11', 0, 0, '', 11),
(397, 'Eros Now', 68, '13', 0, 0, '', 13),
(398, 'HooQ', 68, '14', 0, 0, '', 14),
(399, 'YouTube', 68, '15', 0, 0, '', 15),
(400, 'YouTube premium (Paid Subscription)', 68, '16', 0, 0, '', 16),
(401, 'Vodafone Play', 68, '17', 0, 0, '', 17),
(402, 'Hungama TV', 68, '18', 0, 0, '', 18),
(403, 'Epic TV', 68, '19', 0, 0, '', 19),
(404, 'Sun Nxt', 68, '20', 0, 0, '', 20),
(405, 'Ullu', 68, '21', 0, 0, '', 21),
(406, 'MX Player', 68, '22', 0, 0, '', 22),
(407, 'Tata Sky', 68, '23', 0, 0, '', 23),
(408, 'Apple TV', 68, '24', 0, 0, '', 24),
(409, 'Aha ', 68, '25', 0, 0, '', 25),
(410, 'Shemaro ', 68, '26', 0, 0, '', 26),
(411, 'Hoichoi', 68, '27', 0, 0, '', 27),
(412, 'Discovery Plus', 68, '28', 0, 0, '', 28),
(413, 'Mubi', 68, '29', 0, 0, '', 29),
(414, 'Bigflix ', 68, '30', 0, 0, '', 30),
(415, 'Hulu', 68, '31', 0, 0, '', 31),
(416, 'Others', 68, '12', 0, 0, '', 12),
(417, 'Microwave Oven  ', 69, '1', 0, 0, '', 1),
(418, 'Internet broadband connection/Data card/ Wi-Fi  ', 69, '2', 0, 0, '', 2),
(419, 'Mobile phone (with anyone in the HH) ', 69, '3', 0, 0, '', 3),
(420, 'Tablet (with anyone in the HH)', 69, '4', 0, 0, '', 4),
(421, 'Vacuum cleaner   ', 69, '5', 0, 0, '', 5),
(422, 'Inverter  ', 69, '6', 0, 0, '', 6),
(423, 'Mixer Grinder  ', 69, '7', 0, 0, '', 7),
(424, 'Electric Iron  ', 69, '8', 0, 0, '', 8),
(425, 'DVD Player     / CD Player ', 69, '9', 0, 0, '', 9),
(426, 'Landline telephone connection ', 69, '10', 0, 0, '', 10),
(427, 'Cooler', 69, '11', 0, 0, '', 11),
(428, 'Tractor ', 70, '1', 0, 0, '', 1),
(429, 'Pump Set (Electricity, Diesel, etc.)', 70, '2', 0, 0, '', 2),
(430, 'Yes', 71, '1', 0, 0, '', 1),
(431, 'No', 71, '2', 0, 0, '', 2),
(432, 'Joint family', 72, '1', 0, 0, '', 1),
(433, 'Nuclear family without elders', 72, '2', 0, 0, '', 2),
(434, 'Nuclear family with elders', 72, '3', 0, 0, '', 3),
(435, 'Living Alone', 73, '1', 0, 0, '', 1),
(436, 'Siblings Living Together', 73, '2', 0, 0, '', 2),
(437, 'Singles/Friends Living Together', 73, '3', 0, 0, '', 3),
(438, 'Owned', 74, '1', 0, 0, '', 1),
(439, 'Rented', 74, '2', 0, 0, '', 2),
(440, 'Provided by employer', 74, '3', 0, 0, '', 3),
(441, 'Other', 74, '4', 0, 0, '', 4),
(442, 'Flat / Apartment', 75, '1', 0, 0, '', 1),
(443, 'Independent house / makaan bungalow / kothi', 75, '2', 0, 0, '', 2),
(444, 'Chawl', 75, '3', 0, 0, '', 3),
(445, 'Slum (Juggi Jhopdi)', 75, '4', 0, 0, '', 4),
(446, 'Yes', 76, '1', 0, 0, '', 1),
(447, 'No', 76, '2', 0, 0, '', 2),
(448, '1', 77, '1', 0, 0, '', 1),
(449, '2', 77, '2', 0, 0, '', 2),
(450, '3', 77, '3', 0, 0, '', 3),
(451, '4', 77, '4', 0, 0, '', 4),
(452, '5 or more', 77, '5', 0, 0, '', 5),
(453, 'Assamese', 78, '1', 0, 0, '', 1),
(454, 'Avadhi', 78, '2', 0, 0, '', 2),
(455, 'Bengali', 78, '3', 0, 0, '', 3),
(456, 'Bhojpuri', 78, '4', 0, 0, '', 4),
(457, 'English', 78, '5', 0, 0, '', 5),
(458, 'Garhwali', 78, '6', 0, 0, '', 6),
(459, 'Gujarati', 78, '7', 0, 0, '', 7),
(460, 'Hindi', 78, '8', 0, 0, '', 8),
(461, 'Kannada', 78, '9', 0, 0, '', 9),
(462, 'Konkani', 78, '10', 0, 0, '', 10),
(463, 'Kutchi', 78, '11', 0, 0, '', 11),
(464, 'Maithili', 78, '15', 0, 0, '', 15),
(465, 'Malayalam', 78, '12', 0, 0, '', 12),
(466, 'Marathi', 78, '14', 0, 0, '', 14),
(467, 'Marwari', 78, '13', 0, 0, '', 13),
(468, 'Oriya', 78, '16', 0, 0, '', 16),
(469, 'Other Foreign', 78, '25', 0, 0, '', 25),
(470, 'Other Indian', 78, '24', 0, 0, '', 24),
(471, 'Punjabi', 78, '17', 0, 0, '', 17),
(472, 'Santhali', 78, '18', 0, 0, '', 18),
(473, 'Sindhi', 78, '19', 0, 0, '', 19),
(474, 'Tamil', 78, '20', 0, 0, '', 20),
(475, 'Telugu', 78, '21', 0, 0, '', 21),
(476, 'Tulu', 78, '22', 0, 0, '', 22),
(477, 'Urdu', 78, '23', 0, 0, '', 23),
(478, 'Bodo', 78, '26', 0, 0, '', 26),
(479, 'Dogri', 78, '27', 0, 0, '', 27),
(480, 'Kashmiri', 78, '28', 0, 0, '', 28),
(481, 'Khasi', 78, '29', 0, 0, '', 29),
(482, 'Manipuri', 78, '30', 0, 0, '', 30),
(483, 'Nepali', 78, '31', 0, 0, '', 31),
(484, 'Sanskrit', 78, '32', 0, 0, '', 32),
(485, 'Assamese', 79, '1', 0, 0, '', 1),
(486, 'Avadhi', 79, '2', 0, 0, '', 2),
(487, 'Bengali', 79, '3', 0, 0, '', 3),
(488, 'Bhojpuri', 79, '4', 0, 0, '', 4),
(489, 'English', 79, '5', 0, 0, '', 5),
(490, 'Garhwali', 79, '6', 0, 0, '', 6),
(491, 'Gujarati', 79, '7', 0, 0, '', 7),
(492, 'Hindi', 79, '8', 0, 0, '', 8),
(493, 'Kannada', 79, '9', 0, 0, '', 9),
(494, 'Konkani', 79, '10', 0, 0, '', 10),
(495, 'Kutchi', 79, '11', 0, 0, '', 11),
(496, 'Maithili', 79, '15', 0, 0, '', 12),
(497, 'Malayalam', 79, '12', 0, 0, '', 13),
(498, 'Marathi', 79, '14', 0, 0, '', 14),
(499, 'Marwari', 79, '13', 0, 0, '', 15),
(500, 'Oriya', 79, '16', 0, 0, '', 16),
(501, 'Other Foreign', 79, '25', 0, 0, '', 17),
(502, 'Other Indian', 79, '24', 0, 0, '', 18),
(503, 'Punjabi', 79, '17', 0, 0, '', 19),
(504, 'Santhali', 79, '18', 0, 0, '', 20),
(505, 'Sindhi', 79, '19', 0, 0, '', 21),
(506, 'Tamil', 79, '20', 0, 0, '', 22),
(507, 'Telugu', 79, '21', 0, 0, '', 23),
(508, 'Tulu', 79, '22', 0, 0, '', 24),
(509, 'Urdu', 79, '23', 0, 0, '', 25),
(510, 'Bodo', 79, '26', 0, 0, '', 26),
(511, 'Dogri', 79, '27', 0, 0, '', 27),
(512, 'Kashmiri', 79, '28', 0, 0, '', 28),
(513, 'Khasi', 79, '29', 0, 0, '', 29),
(514, 'Manipuri', 79, '30', 0, 0, '', 30),
(515, 'Nepali', 79, '31', 0, 0, '', 31),
(516, 'Sanskrit', 79, '32', 0, 0, '', 32),
(517, 'Assamese', 80, '1', 0, 0, '', 1),
(518, 'Avadhi', 80, '2', 0, 0, '', 2),
(519, 'Bengali', 80, '3', 0, 0, '', 3),
(520, 'Bhojpuri', 80, '4', 0, 0, '', 4),
(521, 'English', 80, '5', 0, 0, '', 5),
(522, 'Garhwali', 80, '6', 0, 0, '', 6),
(523, 'Gujarati', 80, '7', 0, 0, '', 7),
(524, 'Hindi', 80, '8', 0, 0, '', 8),
(525, 'Kannada', 80, '9', 0, 0, '', 9),
(526, 'Konkani', 80, '10', 0, 0, '', 10),
(527, 'Kutchi', 80, '11', 0, 0, '', 11),
(528, 'Maithili', 80, '15', 0, 0, '', 12),
(529, 'Malayalam', 80, '12', 0, 0, '', 13),
(530, 'Marathi', 80, '14', 0, 0, '', 14),
(531, 'Marwari', 80, '13', 0, 0, '', 15),
(532, 'Oriya', 80, '16', 0, 0, '', 16),
(533, 'Other Foreign', 80, '25', 0, 0, '', 17),
(534, 'Other Indian', 80, '24', 0, 0, '', 18),
(535, 'Punjabi', 80, '17', 0, 0, '', 19),
(536, 'Santhali', 80, '18', 0, 0, '', 20),
(537, 'Sindhi', 80, '19', 0, 0, '', 21),
(538, 'Tamil', 80, '20', 0, 0, '', 22),
(539, 'Telugu', 80, '21', 0, 0, '', 23),
(540, 'Tulu', 80, '22', 0, 0, '', 24),
(541, 'Urdu', 80, '23', 0, 0, '', 25),
(542, 'Bodo', 80, '26', 0, 0, '', 26),
(543, 'Dogri', 80, '27', 0, 0, '', 27),
(544, 'Kashmiri', 80, '28', 0, 0, '', 28),
(545, 'Khasi', 80, '29', 0, 0, '', 29),
(546, 'Manipuri', 80, '30', 0, 0, '', 30),
(547, 'Nepali', 80, '31', 0, 0, '', 31),
(548, 'Sanskrit', 80, '32', 0, 0, '', 32),
(549, 'Regular keypad', 81, '1', 0, 0, '', 1),
(550, 'QWERTY', 81, '2', 0, 0, '', 2),
(551, 'Touch screen', 81, '3', 0, 0, '', 3),
(552, 'Do not have a mobile phone', 81, '4', 0, 0, '', 4),
(553, 'Do not know/Can not say ', 81, '99', 0, 0, '', 99),
(554, 'Yes', 82, '1', 0, 0, '', 1),
(555, 'No', 82, '2', 0, 0, '', 2),
(556, 'Yes', 83, '1', 0, 0, '', 1),
(557, 'No', 83, '2', 0, 0, '', 2),
(558, 'DK/CS', 83, '9', 0, 0, '', 9),
(559, 'I am always online ', 84, '9', 0, 0, '', 1),
(560, 'Last 24 hours but had turned off data for some time', 84, '1', 0, 0, '', 2),
(561, 'In the last 3 days', 84, '2', 0, 0, '', 3),
(562, 'In the last one week', 84, '3', 0, 0, '', 4),
(563, 'In the last two weeks', 84, '4', 0, 0, '', 5),
(564, 'In the last month', 84, '5', 0, 0, '', 6),
(565, 'In the last 3 months or more', 84, '6', 0, 0, '', 7),
(566, 'Did not access internet in the last 1 year', 84, '7', 0, 0, '', 8),
(567, 'I had never accessed the internet', 84, '8', 0, 0, '', 9),
(568, 'Daily', 85, '1', 0, 0, '', 1),
(569, 'Several times a week, but not every day', 85, '2', 0, 0, '', 2),
(570, 'Once in a week', 85, '3', 0, 0, '', 3),
(571, 'Several times a month, but not every week', 85, '4', 0, 0, '', 4),
(572, 'Once a month', 85, '5', 0, 0, '', 5),
(573, 'Less than once a month', 85, '6', 0, 0, '', 6),
(574, 'Mobile phone available but currently not with respondent', 87, '1', 0, 0, '', 1),
(575, 'Mobile phone available but mobile not working', 87, '2', 0, 0, '', 2),
(576, 'Respondent does not want to give a miss call', 87, '3', 0, 0, '', 3),
(577, 'Respondent does not have a mobile', 87, '4', 0, 0, '', 4),
(578, 'Missed call given but code not received', 87, '5', 0, 0, '', 5),
(579, 'Yes', 89, '1', 0, 0, '', 1),
(580, 'No', 89, '2', 0, 0, '', 2),
(581, 'At the door', 103, '1', 0, 0, '', 1),
(582, 'In the house', 103, '2', 0, 0, '', 2),
(583, 'Yes', 104, '1', 0, 0, '', 1),
(584, 'No', 104, '2', 0, 0, '', 2),
(585, 'Family Member/ Family Friend/ Relative', 106, '1', 0, 0, '', 1),
(586, 'Friends staying together', 106, '2', 0, 0, '', 2),
(587, 'Paying guests', 106, '3', 0, 0, '', 3),
(588, 'Full time domestic help/ Nurse', 106, '4', 0, 0, '', 4),
(589, 'Owner Farmer', 38, '1', 0, 0, 'Rural', 1),
(590, 'Leased Farmer', 38, '2', 0, 0, 'Rural', 2),
(591, 'Agricultural Worker', 38, '3', 0, 0, 'Rural', 3),
(592, 'Owner Of Livestock', 38, '4', 0, 0, 'Rural', 4),
(593, 'Owner Of Fisheries', 38, '5', 0, 0, 'Rural', 5),
(594, 'Owner Of Poultry', 38, '6', 0, 0, 'Rural', 6),
(595, 'Unskilled Labourer (Other Than Agriculture)', 38, '7', 0, 0, 'Rural', 7),
(596, 'Artisan / Skilled Labourer', 38, '8', 0, 0, 'Rural', 8),
(597, 'Shopkeeper / Trader', 38, '9', 0, 0, 'Rural', 9),
(598, 'Postman', 38, '10', 0, 0, 'Rural', 10),
(599, 'Teacher', 38, '11', 0, 0, 'Rural', 11),
(600, 'Doctor', 38, '12', 0, 0, 'Rural', 12),
(601, 'Service (Rural In any village)', 38, '13', 0, 0, 'Rural', 13),
(602, 'Service (Urban)', 38, '14', 0, 0, 'Rural', 14),
(603, 'Petty Traders', 38, '15', 0, 0, 'Rural', 15),
(604, 'Shop Owners', 38, '16', 0, 0, 'Rural', 16),
(605, 'Businessman/Industrialist (No Employees)', 38, '17', 0, 0, 'Rural', 17),
(606, 'Businessman/Industrialist (1 - 9 Employees)', 38, '18', 0, 0, 'Rural', 18),
(607, 'Businessman/Industrialist (10+ Employees)', 38, '19', 0, 0, 'Rural', 19),
(608, 'Self Employed Professional', 38, '20', 0, 0, 'Rural', 20),
(609, 'Clerk / Salesman', 38, '21', 0, 0, 'Rural', 21),
(610, 'Supervisory Level', 38, '22', 0, 0, 'Rural', 22),
(611, 'Officer / Executive Junior', 38, '23', 0, 0, 'Rural', 23),
(612, 'Officer / Executive Middle / Senior', 38, '24', 0, 0, 'Rural', 24),
(613, 'Not Applicable', 38, '99', 0, 0, 'Rural', 25),
(614, 'Owner Farmer', 51, '1', 0, 0, 'Rural', 1),
(615, 'Leased Farmer', 51, '2', 0, 0, 'Rural', 2),
(616, 'Agricultural Worker', 51, '3', 0, 0, 'Rural', 3),
(617, 'Owner Of Livestock', 51, '4', 0, 0, 'Rural', 4),
(618, 'Owner Of Fisheries', 51, '5', 0, 0, 'Rural', 5),
(619, 'Owner Of Poultry', 51, '6', 0, 0, 'Rural', 6),
(620, 'Unskilled Labourer (Other Than Agriculture)', 51, '7', 0, 0, 'Rural', 7),
(621, 'Artisan / Skilled Labourer', 51, '8', 0, 0, 'Rural', 8),
(622, 'Shopkeeper / Trader', 51, '9', 0, 0, 'Rural', 9),
(623, 'Postman', 51, '10', 0, 0, 'Rural', 10),
(624, 'Teacher', 51, '11', 0, 0, 'Rural', 11),
(625, 'Doctor', 51, '12', 0, 0, 'Rural', 12),
(626, 'Service (Rural In any village)', 51, '13', 0, 0, 'Rural', 13),
(627, 'Service (Urban)', 51, '14', 0, 0, 'Rural', 14),
(628, 'Petty Traders', 51, '15', 0, 0, 'Rural', 15),
(629, 'Shop Owners', 51, '16', 0, 0, 'Rural', 16),
(630, 'Businessman/Industrialist (No Employees)', 51, '17', 0, 0, 'Rural', 17),
(631, 'Businessman/Industrialist (1 - 9 Employees)', 51, '18', 0, 0, 'Rural', 18),
(632, 'Businessman/Industrialist (10+ Employees)', 51, '19', 0, 0, 'Rural', 19),
(633, 'Self Employed Professional', 51, '20', 0, 0, 'Rural', 20),
(634, 'Clerk / Salesman', 51, '21', 0, 0, 'Rural', 21),
(635, 'Supervisory Level', 51, '22', 0, 0, 'Rural', 22),
(636, 'Officer / Executive Junior', 51, '23', 0, 0, 'Rural', 23),
(637, 'Officer / Executive Middle / Senior', 51, '24', 0, 0, 'Rural', 24),
(638, 'Not Applicable', 51, '99', 0, 0, 'Rural', 25),
(639, 'Yes', 111, '1', 0, 0, '', 1),
(640, 'No', 111, '2', 0, 0, '', 2),
(641, 'None', 69, '99', 0, 0, '', 99),
(642, 'None', 70, '3', 0, 0, '', 2),
(643, 'DTH', 113, '1', 0, 0, '', 1),
(644, 'Normal Antenna', 113, '2', 0, 0, '', 2),
(645, 'Local cable operator (with set top box)', 113, '3', 0, 0, '', 3),
(646, 'None', 113, '4', 0, 0, '', 4),
(647, 'Free', 114, '1', 0, 0, '', 1),
(648, 'Paid', 114, '2', 0, 0, '', 2),
(649, 'Less than INR 100', 115, '1', 0, 0, '', 1),
(650, 'INR 101 to 200', 115, '2', 0, 0, '', 2),
(651, 'INR 201 to 300', 115, '3', 0, 0, '', 3),
(652, 'INR 301 to 400', 115, '4', 0, 0, '', 4),
(653, 'INR 401 to 500', 115, '5', 0, 0, '', 5),
(654, 'Greater than INR 500', 115, '6', 0, 0, '', 6),
(655, 'DK/CS', 115, '7', 0, 0, '', 7),
(656, 'Upto 9th Standard', 116, '1', 0, 0, '', 1),
(657, 'SSC/HSC (10th-12th)/ Some College (Incl. Diploma) But Not Graduate', 116, '2', 0, 0, '', 2),
(658, 'Graduate and above', 116, '3', 0, 0, '', 3),
(659, 'Yes', 105, '1', 0, 0, '', 1),
(660, 'No', 105, '2', 0, 0, '', 2),
(661, 'Yes', 133, '1', 0, 0, '', 1),
(662, 'No', 133, '2', 0, 0, '', 2),
(663, 'Yes, in working Condition', 134, '1', 0, 0, '', 1),
(664, 'No, But will recharge in 15 Days', 134, '2', 0, 0, '', 2),
(666, 'Yes', 136, '1', 0, 0, '', 1),
(667, 'No', 136, '2', 0, 0, '', 2),
(668, 'Yes', 138, '1', 0, 0, '', 1),
(669, 'No', 138, '2', 0, 0, '', 2),
(670, 'Are you part of any TV/Media panel in last two years (Including BARCINDIA Panel)', 25, '8', 0, 1, '', 8),
(671, 'CWE Deceased', 23, '4', 0, 0, '', 3),
(672, 'No CWE', 23, '5', 1, 0, '', 4),
(673, 'IPTV / Internet-based streaming devices/ WIFI', 113, '5', 0, 0, '', 5),
(674, 'JIO FIBER', 113, '6', 0, 0, '', 6),
(675, 'Airtel Xstream', 113, '7', 0, 0, '', 7),
(676, 'Chhattisgariya', 78, '33', 0, 0, '', 33),
(677, 'Magahi/Maghadhi', 78, '34', 0, 0, '', 34),
(678, 'LUSHAI/MIZO', 78, '35', 0, 0, '', 35),
(679, 'Malwani', 78, '36', 0, 0, '', 36),
(680, 'Bundelkhandi', 78, '37', 0, 0, '', 37),
(681, 'Pahari', 78, '38', 0, 0, '', 38),
(682, 'Chhattisgariya', 79, '33', 0, 0, '', 33),
(683, 'Magahi/Maghadhi', 79, '34', 0, 0, '', 34),
(684, 'LUSHAI/MIZO', 79, '35', 0, 0, '', 35),
(685, 'Malwani', 79, '36', 0, 0, '', 36),
(686, 'Bundelkhandi', 79, '37', 0, 0, '', 37),
(687, 'Pahari', 79, '38', 0, 0, '', 38),
(688, 'Chhattisgariya', 80, '33', 0, 0, '', 33),
(689, 'Magahi/Maghadhi', 80, '34', 0, 0, '', 34),
(690, 'LUSHAI/MIZO', 80, '35', 0, 0, '', 35),
(691, 'Malwani', 80, '36', 0, 0, '', 36),
(692, 'Bundelkhandi', 80, '37', 0, 0, '', 37),
(693, 'Pahari', 80, '38', 0, 0, '', 38),
(694, 'Smart TV', 60, '3', 0, 0, '', 3),
(695, 'Yes', 129, '1', 0, 0, '', 1),
(696, 'No', 129, '2', 0, 0, '', 2),
(697, 'Not working or not retired but receiving some grants', 37, '8', 0, 0, '', 8),
(698, 'Not working or not retired but receiving some grants', 50, '8', 0, 0, '', 8),
(699, 'DTH', 140, '1', 0, 0, '', 1),
(700, 'Normal Antenna', 140, '2', 0, 0, '', 2),
(701, 'Local cable operator (with set top box)', 140, '3', 0, 0, '', 3),
(702, 'None', 140, '4', 0, 0, '', 4),
(703, 'IPTV / Internet-based streaming devices/ WIFI', 140, '5', 0, 0, '', 5),
(704, 'JIO FIBER', 140, '6', 0, 0, '', 6),
(705, 'Airtel Xstream', 140, '7', 0, 0, '', 7);

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

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

CREATE TABLE `questions` (
  `question_id` int(11) NOT NULL COMMENT 'Unique ID',
  `question_name` text DEFAULT NULL COMMENT 'Question Name',
  `questions_type_id` int(11) DEFAULT NULL COMMENT 'question_type->question_type_id',
  `question_input_type_id` int(11) DEFAULT NULL COMMENT 'question_input_type->input_type_id',
  `status` int(11) DEFAULT 0 COMMENT 'Active/Inactive',
  `max_input` int(11) DEFAULT 0,
  `screen_no` int(11) DEFAULT 0,
  `group_id` int(11) DEFAULT 0,
  `group_relation_id` int(11) NOT NULL DEFAULT 0,
  `sequence_no` int(11) DEFAULT 0,
  `field_name` varchar(50) NOT NULL,
  `ref_table` varchar(50) NOT NULL,
  `validation_id` int(11) DEFAULT 1,
  `title` varchar(100) NOT NULL,
  `question_no` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `question_input_type`
--

CREATE TABLE `question_input_type` (
  `question_input_type_id` int(11) NOT NULL COMMENT 'Unique ID',
  `question_input_type_name` varchar(45) DEFAULT NULL COMMENT 'Input Type Name (Text/Integer)',
  `status` int(11) DEFAULT 0 COMMENT 'Active/Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `question_input_type`
--

INSERT INTO `question_input_type` (`question_input_type_id`, `question_input_type_name`, `status`) VALUES
(1, 'Text', 0),
(2, 'Integer', 0),
(3, 'None', 0);

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

--
-- Table structure for table `question_type`
--

CREATE TABLE `question_type` (
  `questions_type_id` int(11) NOT NULL COMMENT 'Unique ID',
  `questions_type_name` varchar(45) DEFAULT NULL COMMENT 'Type Name (Radio/Dropdown/Text)',
  `status` int(11) DEFAULT 0 COMMENT 'Active/Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `question_type`
--

INSERT INTO `question_type` (`questions_type_id`, `questions_type_name`, `status`) VALUES
(1, 'Text Field', 0),
(2, 'Radio', 0),
(3, 'Checkbox', 0),
(4, 'Spinner', 0),
(5, 'Button', 0),
(6, 'HTML', 0);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`role_id`, `role_name`) VALUES
(1, 'Admin'),
(2, 'Asha workers');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(20) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `username`, `password`, `email`, `contact`, `role_id`, `created_at`) VALUES
(1, 'admin', '0192023a7bbd73250516f069df18b500', 'admin@example.com', '9097513232', 1, '2025-08-26 06:04:31'),
(2, 'Asha', 'e23dc43d634373099bb9fdb6049c68d2', 'asha@gmail.com', '9097513232', 2, '2025-08-27 05:30:01');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`option_id`);

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

--
-- Indexes for table `question_input_type`
--
ALTER TABLE `question_input_type`
  ADD PRIMARY KEY (`question_input_type_id`);

--
-- Indexes for table `question_type`
--
ALTER TABLE `question_type`
  ADD PRIMARY KEY (`questions_type_id`),
  ADD UNIQUE KEY `questions_type_id_UNIQUE` (`questions_type_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`role_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `options`
--
ALTER TABLE `options`
  MODIFY `option_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID', AUTO_INCREMENT=706;

--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
  MODIFY `question_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID';

--
-- AUTO_INCREMENT for table `question_input_type`
--
ALTER TABLE `question_input_type`
  MODIFY `question_input_type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID', AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `question_type`
--
ALTER TABLE `question_type`
  MODIFY `questions_type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID', AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;