INSERT INTO `inventory_building_rooms` (`id`, `inventory_location_id`, `inventory_location_building_id`, `wing_name`, `floor_no`, `room_no`, `room_types`, `remark`, `deleted_at`, `created_at`, `updated_at`) VALUES
(4307, 117, 133, '', '4', '406', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4308, 117, 133, '', '4', '407', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4309, 117, 133, '', '4', '408', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4310, 117, 133, '', '5', '501', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4311, 117, 133, '', '5', '502', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4312, 117, 133, '', '5', '503', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4313, 117, 133, '', '5', '504', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4314, 117, 133, '', '5', '505', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4315, 117, 133, '', '5', '506', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4316, 117, 133, '', '5', '507', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4317, 117, 133, '', '5', '508', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4318, 117, 133, '', '6', '601', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4319, 117, 133, '', '6', '602', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4320, 117, 133, '', '6', '603', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4321, 117, 133, '', '6', '604', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4322, 117, 133, '', '6', '605', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4323, 117, 133, '', '6', '606', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4324, 117, 133, '', '6', '607', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4325, 117, 133, '', '6', '608', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4326, 117, 133, '', '7', '701', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4327, 117, 133, '', '7', '702', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4328, 117, 133, '', '7', '703', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4329, 117, 133, '', '7', '704', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4330, 117, 133, '', '7', '705', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4331, 117, 133, '', '7', '706', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4332, 117, 133, '', '7', '707', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4333, 117, 133, '', '7', '708', 1, NULL, NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(4334, 116, 135, '', '1', '101', 4, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4335, 116, 135, '', '1', '102', 4, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4336, 116, 135, '', '1', '103', 4, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4337, 116, 135, '', '1', '104', 25, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4338, 116, 135, '', '1', '105', 2, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4339, 116, 135, '', '1', '106', 27, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4340, 116, 135, '', '1', '107', 26, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4341, 116, 135, '', '1', '108', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4342, 116, 135, '', '1', '109', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4343, 116, 135, '', '1', '110', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4344, 116, 135, '', '1', '111', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4345, 116, 135, '', '1', '112', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4346, 116, 135, '', '1', '113', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4347, 116, 135, '', '2', '201', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4348, 116, 135, '', '2', '202', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4349, 116, 135, '', '2', '203', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4350, 116, 135, '', '2', '204', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4351, 116, 135, '', '2', '205', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4352, 116, 135, '', '2', '206', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4353, 116, 135, '', '2', '207', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4354, 116, 135, '', '2', '208', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4355, 116, 135, '', '2', '209', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4356, 116, 135, '', '2', '210', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4357, 116, 135, '', '2', '211', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4358, 116, 135, '', '2', '212', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4359, 116, 135, '', '2', '213', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4360, 116, 135, '', '3', '301', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4361, 116, 135, '', '3', '302', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4362, 116, 135, '', '3', '303', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4363, 116, 135, '', '3', '304', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4364, 116, 135, '', '3', '305', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4365, 116, 135, '', '3', '306', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4366, 116, 135, '', '3', '307', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4367, 116, 135, '', '3', '308', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4368, 116, 135, '', '3', '309', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4369, 116, 135, '', '3', '310', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4370, 116, 135, '', '3', '311', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4371, 116, 135, '', '3', '312', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4372, 116, 135, '', '3', '313', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4373, 116, 135, '', '4', '401', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4374, 116, 135, '', '4', '402', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4375, 116, 135, '', '4', '403', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4376, 116, 135, '', '4', '404', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4377, 116, 135, '', '4', '405', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4378, 116, 135, '', '4', '406', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4379, 116, 135, '', '4', '407', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4380, 116, 135, '', '4', '408', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4381, 116, 135, '', '4', '409', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4382, 116, 135, '', '4', '410', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4383, 116, 135, '', '4', '411', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4384, 116, 135, '', '4', '412', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4385, 116, 135, '', '4', '413', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4386, 116, 135, '', '5', '501', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4387, 116, 135, '', '5', '502', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4388, 116, 135, '', '5', '503', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4389, 116, 135, '', '5', '504', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4390, 116, 135, '', '5', '505', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4391, 116, 135, '', '5', '506', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4392, 116, 135, '', '5', '507', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4393, 116, 135, '', '5', '508', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4394, 116, 135, '', '5', '509', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4395, 116, 135, '', '5', '510', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4396, 116, 135, '', '5', '511', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4397, 116, 135, '', '5', '512', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4398, 116, 135, '', '5', '513', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4399, 116, 135, '', '6', '601', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4400, 116, 135, '', '6', '602', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4401, 116, 135, '', '6', '603', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4402, 116, 135, '', '6', '604', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4403, 116, 135, '', '6', '605', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4404, 116, 135, '', '6', '606', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4405, 116, 135, '', '6', '607', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4406, 116, 135, '', '6', '608', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4407, 116, 135, '', '6', '609', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4408, 116, 135, '', '6', '610', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4409, 116, 135, '', '6', '611', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4410, 116, 135, '', '6', '612', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4411, 116, 135, '', '6', '613', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4412, 116, 135, '', '7', '701', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4413, 116, 135, '', '7', '702', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4414, 116, 135, '', '7', '703', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4415, 116, 135, '', '7', '704', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4416, 116, 135, '', '7', '705', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4417, 116, 135, '', '7', '706', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4418, 116, 135, '', '7', '707', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4419, 116, 135, '', '7', '708', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4420, 116, 135, '', '7', '709', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4421, 116, 135, '', '7', '710', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4422, 116, 135, '', '7', '711', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4423, 116, 135, '', '7', '712', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4424, 116, 135, '', '7', '713', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4425, 116, 135, '', '8', '801', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4426, 116, 135, '', '8', '802', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4427, 116, 135, '', '8', '803', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4428, 116, 135, '', '8', '804', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4429, 116, 135, '', '8', '805', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4430, 116, 135, '', '8', '806', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4431, 116, 135, '', '8', '807', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4432, 116, 135, '', '8', '808', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4433, 116, 135, '', '8', '809', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4434, 116, 135, '', '8', '810', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4435, 116, 135, '', '8', '811', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4436, 116, 135, '', '8', '812', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4437, 116, 135, '', '8', '813', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4438, 116, 135, '', '9', '901', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4439, 116, 135, '', '9', '902', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4440, 116, 135, '', '9', '903', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4441, 116, 135, '', '9', '904', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4442, 116, 135, '', '9', '905', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4443, 116, 135, '', '9', '906', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4444, 116, 135, '', '9', '907', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4445, 116, 135, '', '9', '908', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4446, 116, 135, '', '9', '909', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4447, 116, 135, '', '9', '910', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4448, 116, 135, '', '9', '911', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4449, 116, 135, '', '9', '912', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4450, 116, 135, '', '9', '913', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4451, 116, 135, '', '10', '1001', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4452, 116, 135, '', '10', '1002', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4453, 116, 135, '', '10', '1003', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4454, 116, 135, '', '10', '1004', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4455, 116, 135, '', '10', '1005', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4456, 116, 135, '', '10', '1006', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4457, 116, 135, '', '10', '1007', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4458, 116, 135, '', '10', '1008', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4459, 116, 135, '', '10', '1009', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4460, 116, 135, '', '10', '1010', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4461, 116, 135, '', '10', '1011', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4462, 116, 135, '', '10', '1012', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4463, 116, 135, '', '10', '1013', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4464, 116, 135, '', '11', '1101', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4465, 116, 135, '', '11', '1102', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4466, 116, 135, '', '11', '1103', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4467, 116, 135, '', '11', '1104', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4468, 116, 135, '', '11', '1105', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4469, 116, 135, '', '11', '1106', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4470, 116, 135, '', '11', '1107', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4471, 116, 135, '', '11', '1108', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4472, 116, 135, '', '11', '1109', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4473, 116, 135, '', '11', '1110', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4474, 116, 135, '', '11', '1111', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4475, 116, 135, '', '11', '1112', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4476, 116, 135, '', '11', '1113', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4477, 116, 135, '', '12', '1201', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4478, 116, 135, '', '12', '1202', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4479, 116, 135, '', '12', '1203', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4480, 116, 135, '', '12', '1204', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4481, 116, 135, '', '12', '1205', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4482, 116, 135, '', '12', '1206', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4483, 116, 135, '', '12', '1207', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4484, 116, 135, '', '12', '1208', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4485, 116, 135, '', '12', '1209', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4486, 116, 135, '', '12', '1210', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4487, 116, 135, '', '12', '1211', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4488, 116, 135, '', '12', '1212', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4489, 116, 135, '', '12', '1213', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4490, 116, 135, '', '13', '1301', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4491, 116, 135, '', '13', '1302', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4492, 116, 135, '', '13', '1303', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4493, 116, 135, '', '13', '1304', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4494, 116, 135, '', '13', '1305', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4495, 116, 135, '', '13', '1306', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4496, 116, 135, '', '13', '1307', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4497, 116, 135, '', '13', '1308', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4498, 116, 135, '', '13', '1309', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4499, 116, 135, '', '13', '1310', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4500, 116, 135, '', '13', '1311', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4501, 116, 135, '', '13', '1312', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4502, 116, 135, '', '13', '1313', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4503, 116, 135, '', '14', '1401', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4504, 116, 135, '', '14', '1402', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4505, 116, 135, '', '14', '1403', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4506, 116, 135, '', '14', '1404', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4507, 116, 135, '', '14', '1405', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4508, 116, 135, '', '14', '1406', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4509, 116, 135, '', '14', '1407', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4510, 116, 135, '', '14', '1408', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4511, 116, 135, '', '14', '1409', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4512, 116, 135, '', '14', '1410', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4513, 116, 135, '', '14', '1411', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4514, 116, 135, '', '14', '1412', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4515, 116, 135, '', '14', '1413', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4516, 116, 135, '', '15', '1501', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4517, 116, 135, '', '15', '1502', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4518, 116, 135, '', '15', '1503', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4519, 116, 135, '', '15', '1504', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4520, 116, 135, '', '15', '1505', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4521, 116, 135, '', '15', '1506', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4522, 116, 135, '', '15', '1507', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4523, 116, 135, '', '15', '1508', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4524, 116, 135, '', '15', '1509', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4525, 116, 135, '', '15', '1510', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4526, 116, 135, '', '15', '1511', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4527, 116, 135, '', '15', '1512', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4528, 116, 135, '', '15', '1513', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4529, 116, 135, '', '16', '1601', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4530, 116, 135, '', '16', '1602', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4531, 116, 135, '', '16', '1603', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4532, 116, 135, '', '16', '1604', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4533, 116, 135, '', '16', '1605', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4534, 116, 135, '', '16', '1606', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4535, 116, 135, '', '16', '1607', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4536, 116, 135, '', '16', '1608', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4537, 116, 135, '', '16', '1609', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4538, 116, 135, '', '16', '1610', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4539, 116, 135, '', '16', '1611', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4540, 116, 135, '', '16', '1612', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4541, 116, 135, '', '16', '1613', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4542, 116, 135, '', '17', '1701', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4543, 116, 135, '', '17', '1702', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4544, 116, 135, '', '17', '1703', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4545, 116, 135, '', '17', '1704', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4546, 116, 135, '', '17', '1705', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4547, 116, 135, '', '17', '1706', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4548, 116, 135, '', '17', '1707', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4549, 116, 135, '', '17', '1708', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4550, 116, 135, '', '17', '1709', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4551, 116, 135, '', '17', '1710', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4552, 116, 135, '', '17', '1711', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4553, 116, 135, '', '17', '1712', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4554, 116, 135, '', '17', '1713', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4555, 116, 135, '', '18', '1801', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4556, 116, 135, '', '18', '1802', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4557, 116, 135, '', '18', '1803', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4558, 116, 135, '', '18', '1804', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4559, 116, 135, '', '18', '1805', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4560, 116, 135, '', '18', '1806', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4561, 116, 135, '', '18', '1807', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4562, 116, 135, '', '18', '1808', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4563, 116, 135, '', '18', '1809', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4564, 116, 135, '', '18', '1810', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4565, 116, 135, '', '18', '1811', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4566, 116, 135, '', '18', '1812', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4567, 116, 135, '', '18', '1813', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4568, 116, 135, '', '19', '1901', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4569, 116, 135, '', '19', '1902', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4570, 116, 135, '', '20', '2001', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4571, 116, 135, '', '20', '2002', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4572, 116, 135, '', '20', '2003', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4573, 116, 135, '', '20', '2004', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4574, 116, 135, '', '20', '2005', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4575, 116, 135, '', '20', '2006', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4576, 116, 135, '', '20', '2007', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4577, 116, 135, '', '20', '2008', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4578, 116, 135, '', '20', '2009', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4579, 116, 135, '', '20', '2010', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4580, 116, 135, '', '20', '2011', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4581, 116, 135, '', '20', '2012', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4582, 116, 135, '', '20', '2013', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4583, 116, 135, '', '21', '2101', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4584, 116, 135, '', '21', '2102', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4585, 116, 135, '', '21', '2103', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4586, 116, 135, '', '21', '2104', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4587, 116, 135, '', '21', '2105', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4588, 116, 135, '', '21', '2106', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4589, 116, 135, '', '21', '2107', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4590, 116, 135, '', '21', '2108', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4591, 116, 135, '', '21', '2109', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4592, 116, 135, '', '21', '2110', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4593, 116, 135, '', '21', '2111', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4594, 116, 135, '', '21', '2112', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4595, 116, 135, '', '21', '2113', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4596, 116, 135, '', '22', '2201', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4597, 116, 135, '', '22', '2202', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4598, 116, 135, '', '22', '2203', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4599, 116, 135, '', '22', '2204', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4600, 116, 135, '', '22', '2205', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4601, 116, 135, '', '22', '2206', 7, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4602, 116, 135, '', '22', '2207', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4603, 116, 135, '', '22', '2208', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4604, 116, 135, '', '22', '2209', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4605, 116, 135, '', '22', '2210', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4606, 116, 135, '', '22', '2211', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4607, 116, 135, '', '23', '2301', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4608, 116, 135, '', '23', '2302', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4609, 116, 135, '', '23', '2303', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4610, 116, 135, '', '23', '2304', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4611, 116, 135, '', '23', '2305', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4612, 116, 135, '', '23', '2306', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4613, 116, 135, '', '23', '2307', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4614, 116, 135, '', '23', '2308', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4615, 116, 135, '', '23', '2309', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4616, 116, 135, '', '23', '2310', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4617, 116, 135, '', '23', '2311', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4618, 116, 135, '', '23', '2312', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4619, 116, 135, '', '23', '2313', 1, NULL, NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(4620, 115, 136, 'B', '5', '502', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4621, 115, 136, 'B', '5', '503', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4622, 115, 136, 'B', '5', '504', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4623, 115, 136, 'B', '5', '505', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4624, 115, 136, 'B', '6', '601', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4625, 115, 136, 'B', '6', '602', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4626, 115, 136, 'B', '6', '603', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4627, 115, 136, 'B', '6', '604', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4628, 115, 136, 'B', '6', '605', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4629, 115, 136, 'B', '7', '701', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4630, 115, 136, 'B', '7', '702', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4631, 115, 136, 'B', '7', '703', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4632, 115, 136, 'B', '7', '704', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4633, 115, 136, 'B', '7', '705', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4634, 115, 136, 'B', '8', '801', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4635, 115, 136, 'B', '8', '802', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4636, 115, 136, 'B', '8', '803', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4637, 115, 136, 'B', '8', '804', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4638, 115, 136, 'B', '8', '805', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4639, 115, 136, 'B', '9', '901', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4640, 115, 136, 'B', '9', '902', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4641, 115, 136, 'B', '9', '903', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4642, 115, 136, 'B', '9', '904', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4643, 115, 136, 'B', '9', '905', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4644, 115, 136, 'B', '10', '1001', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4645, 115, 136, 'B', '10', '1002', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4646, 115, 136, 'B', '10', '1003', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4647, 115, 136, 'B', '10', '1004', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4648, 115, 136, 'B', '10', '1005', 1, NULL, NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(4649, 118, 137, 'A', '2', '201', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4650, 118, 137, 'A', '2', '202', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4651, 118, 137, 'A', '2', '203', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4652, 118, 137, 'A', '2', '204', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4653, 118, 137, 'A', '3', '301', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4654, 118, 137, 'A', '3', '302', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4655, 118, 137, 'A', '3', '303', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4656, 118, 137, 'A', '3', '304', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4657, 118, 137, 'A', '4', '401', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4658, 118, 137, 'A', '4', '402', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4659, 118, 137, 'A', '4', '403', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4660, 118, 137, 'A', '4', '404', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4661, 118, 137, 'A', '5', '501', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4662, 118, 137, 'A', '5', '502', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4663, 118, 137, 'A', '5', '503', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4664, 118, 137, 'A', '5', '504', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4665, 118, 137, 'A', '6', '601', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4666, 118, 137, 'A', '6', '602', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4667, 118, 137, 'A', '6', '603', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4668, 118, 137, 'A', '6', '604', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4669, 118, 137, 'A', '7', '701', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4670, 118, 137, 'A', '7', '702', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4671, 118, 137, 'A', '7', '703', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53'),
(4672, 118, 137, 'A', '7', '704', 1, NULL, NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53');

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

--
-- Table structure for table `inventory_building_wings`
--

CREATE TABLE `inventory_building_wings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `inventory_location_id` bigint(20) UNSIGNED NOT NULL,
  `inventory_location_building_id` bigint(20) UNSIGNED NOT NULL,
  `wing` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `inventory_locations`
--

CREATE TABLE `inventory_locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `location` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_locations`
--

INSERT INTO `inventory_locations` (`id`, `location`, `deleted_at`, `created_at`, `updated_at`) VALUES
(106, 'Kolkhepeth, Panvel', NULL, '2025-03-17 07:44:13', '2025-03-17 07:44:13'),
(107, 'Kurla', NULL, '2025-04-08 06:49:34', '2025-04-08 06:49:34'),
(113, 'Mira Bhainder', NULL, '2025-05-23 14:38:42', '2025-05-23 14:38:42'),
(114, 'Malad East', NULL, '2025-05-23 18:07:38', '2025-05-23 18:07:38'),
(115, 'Malad West', NULL, '2025-05-23 18:13:33', '2025-05-23 18:13:33'),
(116, 'Kandivali West', NULL, '2025-05-23 18:15:10', '2025-05-23 18:15:10'),
(117, 'Borivali West', NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(118, 'Dahisar West', NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53');

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

--
-- Table structure for table `inventory_location_buildings`
--

CREATE TABLE `inventory_location_buildings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `inventory_location_id` bigint(20) UNSIGNED NOT NULL,
  `building_no` varchar(255) NOT NULL,
  `building_name` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_location_buildings`
--

INSERT INTO `inventory_location_buildings` (`id`, `inventory_location_id`, `building_no`, `building_name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(106, 106, '1', 'M/s. Sanvo Resorts (M/s. Marathon)', NULL, '2025-03-17 07:44:13', '2025-03-17 07:44:13'),
(107, 107, '13', '13/1', NULL, '2025-04-08 06:49:34', '2025-04-08 06:49:34'),
(113, 113, 'R-1', 'M/S THE JANATA DAIRY CHS', NULL, '2025-05-23 14:38:42', '2025-05-23 14:38:42'),
(114, 113, 'R-2', 'M/S THE JANATA DAIRY CHS', NULL, '2025-05-23 17:12:01', '2025-05-23 17:13:33'),
(117, 113, 'M/S SPAN REALTERS AND DEVELOPERS', 'M/S SPAN REALTERS AND DEVELOPERS', NULL, '2025-05-23 17:22:54', '2025-05-23 17:23:17'),
(119, 113, 'R-1', 'M/S SONAM BUILDERS', NULL, '2025-05-23 17:36:09', '2025-05-23 17:36:09'),
(121, 113, 'R-2', 'M/S SONAM BUILDERS', NULL, '2025-05-23 17:38:34', '2025-05-23 17:38:34'),
(122, 113, 'M/S SK HEIGHTS  PVT LTD', 'M/S SK HEIGHTS  PVT LTD', NULL, '2025-05-23 17:42:16', '2025-05-23 17:42:16'),
(123, 113, 'M/S DARVESH PROPERTY PVT LTD', 'M/S DARVESH PROPERTY PVT LTD', NULL, '2025-05-23 17:48:15', '2025-05-23 17:48:15'),
(124, 113, 'R-1', 'M/S MAN GLOBAL LTD', NULL, '2025-05-23 17:51:07', '2025-05-23 17:51:07'),
(125, 113, 'R-2', 'M/S MAN GLOBAL LTD', NULL, '2025-05-23 17:52:38', '2025-05-23 17:52:38'),
(126, 113, 'M/S GUJRAT BUILDERS AND DEVELOPERS', 'M/S GUJRAT BUILDERS AND DEVELOPERS', NULL, '2025-05-23 17:57:40', '2025-05-23 17:57:40'),
(127, 113, 'SKD REALTY', 'SKD REALTY', NULL, '2025-05-23 17:59:30', '2025-05-23 17:59:30'),
(128, 114, 'R-1', 'M/S PANDEY GHANWAT LLP SRA', NULL, '2025-05-23 18:07:38', '2025-05-23 18:07:38'),
(130, 114, 'R-2', 'M/S PANDEY GHANWAT LLP SRA', NULL, '2025-05-23 18:11:28', '2025-05-23 18:11:28'),
(131, 115, 'MALVANI MAHAKALI SRA CHS', 'MALVANI MAHAKALI SRA CHS', NULL, '2025-05-23 18:13:33', '2025-05-23 18:13:33'),
(132, 116, 'CHAWLA CHAWL SRA CHS', 'CHAWLA CHAWL SRA CHS', NULL, '2025-05-23 18:15:10', '2025-05-23 18:15:10'),
(133, 117, 'BORBHATPADA SRA CHS', 'BORBHATPADA SRA CHS', NULL, '2025-05-23 18:16:51', '2025-05-23 18:16:51'),
(135, 116, '2', 'SHIVSHAHI SRA GANESH NAGAR', NULL, '2025-05-23 18:22:45', '2025-05-23 18:22:45'),
(136, 115, 'JAI AMBE CHS', 'SHIVSHAHI SRA , JAI AMBE CHS', NULL, '2025-05-23 18:28:07', '2025-05-23 18:28:07'),
(137, 118, 'SWAYAM NIKETAN', 'SHIVSHAHI SRA , SWAYAM NIKETAN', NULL, '2025-05-23 18:29:53', '2025-05-23 18:29:53');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `joint_verification_docs`
--

CREATE TABLE `joint_verification_docs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `joint_verification_docs`
--

INSERT INTO `joint_verification_docs` (`id`, `file_name`, `created_at`, `updated_at`, `project_id`) VALUES
(3, '6810780a7d4ee3.01600615.pdf', '2025-04-29 06:56:10', '2025-04-29 06:56:10', 9);

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

--
-- Table structure for table `lotteries`
--

CREATE TABLE `lotteries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(255) NOT NULL,
  `remark` text DEFAULT NULL COMMENT 'Additional remarks or notes',
  `date_time` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteries`
--

INSERT INTO `lotteries` (`id`, `project_id`, `description`, `remark`, `date_time`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 9, 'lottery 1', 'test', '2025-05-24 10:54:11', '2025-05-24 05:24:31', '2025-05-24 05:30:04', NULL);

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

--
-- Table structure for table `marital_statuses`
--

CREATE TABLE `marital_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n            1. Married,\n            2. Unmarried,\n            3. Separated,\n            4. Widow,\n            5. Destitute',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marital_statuses`
--

INSERT INTO `marital_statuses` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Married', NULL, NULL, NULL),
(2, 'Unmarried', NULL, NULL, NULL),
(3, 'Separated', NULL, NULL, NULL),
(4, 'Widow', NULL, NULL, NULL),
(5, 'Destitute', NULL, NULL, NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(2, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(3, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(4, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(5, '2016_06_01_000004_create_oauth_clients_table', 1),
(6, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(7, '2019_08_19_000000_create_failed_jobs_table', 1),
(8, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(9, '2024_10_19_185824_create_user_roles_table', 1),
(10, '2024_10_20_185825_create_agencies_table', 1),
(11, '2024_10_20_185826_create_users_table', 1),
(12, '2024_10_20_185827_add_created_by_foreign_key_to_agencies_table', 1),
(13, '2024_11_29_200525_add_columns_to_agencies_table', 1),
(14, '2024_11_30_140557_add_mobile_number_to_users_table', 1),
(15, '2024_12_04_111404_create_roles_table', 1),
(16, '2024_12_04_114110_create_permissions_table', 1),
(17, '2024_12_04_115140_create_role_permission_table', 1),
(18, '2024_12_04_171514_create_permission_tables', 1),
(19, '2024_12_10_104431_create_products_table', 1),
(20, '2024_12_10_104441_create_product_related_documents_table', 1),
(21, '2024_12_11_134713_create_designations_table', 1),
(22, '2024_12_11_135948_add_designation_id_to_users_table', 1),
(23, '2024_12_11_173505_add_site_location_and_sdc_officer_user_id_to_projects_table', 1),
(24, '2024_12_19_114727_create_surveys_table', 1),
(25, '2024_12_23_151219_create_societies_table', 1),
(26, '2024_12_24_114937_add_agency_email_to_agencies_table', 1),
(27, '2025_01_03_160118_create_inventory_locations_table', 1),
(28, '2025_01_03_160248_create_inventory_location_buildings_table', 1),
(29, '2025_01_03_160345_create_inventory_building_wings_table', 1),
(30, '2025_01_03_160549_create_inventory_building_floors_table', 1),
(31, '2025_01_03_160751_create_inventory_building_rooms_table', 1),
(32, '2025_01_08_175828_add_area_columns_to_projects_table', 1),
(33, '2025_01_13_134656_create_receiveds_table', 1),
(34, '2025_01_15_161319_add_indexes_to_tables', 2),
(36, '2025_01_22_160158_create_structure_holders_table', 3),
(37, '2025_01_22_165411_create_mother_tongues_table', 4),
(38, '2025_01_22_170403_create_caste_groups_table', 5),
(39, '2025_01_22_171237_create_religions_table', 6),
(40, '2025_01_22_172019_create_document_types_table', 7),
(41, '2025_01_22_173133_create_relations_table', 8),
(42, '2025_01_22_173538_create_genders_table', 9),
(43, '2025_01_22_174033_create_marital_statuses_table', 10),
(45, '2025_01_22_175431_create_education_table', 11),
(46, '2025_01_22_180353_create_occupations_table', 12),
(47, '2025_01_22_181021_create_trainings_table', 13),
(48, '2025_01_22_183006_create_types_of_structures_table', 14),
(49, '2025_01_22_183652_create_floors_table', 15),
(50, '2025_01_22_184207_create_rooms_table', 16),
(51, '2025_01_22_184946_create_structure_roofs_table', 17),
(52, '2025_01_23_113401_create_toilet_types_table', 18),
(53, '2025_01_23_114337_create_water_types_table', 19),
(54, '2025_01_23_115015_create_estimate_annual_expenditures_table', 20),
(55, '2025_01_23_115727_create_cooking_fuels_table', 21),
(57, '2025_01_23_120614_create_shop_types_table', 22),
(58, '2025_01_23_121253_create_workers_types_table', 23),
(60, '2025_01_23_122121_create_use_of_structures_table', 24),
(61, '2025_01_23_124648_create_structure_types_table', 25),
(67, '2025_01_23_165455_create_survey_user_others_table', 26),
(69, '2025_01_24_105518_create_survey_documents_table', 27),
(72, '2025_01_24_161556_create_survey_user_commercials_table', 28),
(77, '2025_01_24_173927_create_survey_user_residential_vulnerabilities_table', 29),
(79, '2025_01_27_110404_create_survey_user_residential_socio_economic_indicators_table', 30),
(83, '2025_01_27_115804_create_survey_user_residentials_table', 31),
(84, '2025_01_27_160134_create_survey_user_residential_household_members_table', 31),
(86, '2025_02_26_111636_add_map_fields_to_surveys_table', 32),
(87, '2025_02_26_114846_add_gender_and_establishment_fields_to_survey_user_residentials', 33),
(88, '2025_02_26_120725_add_year_of_establishment_to_survey_agencyuser_others', 34),
(90, '2025_02_26_153301_add_fields_to_survey_agencyuser_commercial_table', 35),
(92, '2025_02_26_170206_add_structure_and_occupant_fields_to_survey_agencyuser_others', 36),
(93, '2025_02_27_133923_create_statuses_table', 36),
(94, '2025_02_27_134132_add_status_id_to_projects_table', 36),
(95, '2025_02_27_164839_create_project_statuses_table', 37),
(96, '2025_03_03_141542_create_remarks_table', 38),
(97, '2025_03_03_141859_add_remark_id_to_survey_user_residentials_table', 39),
(98, '2025_03_03_165830_add_remark_id_to_survey_models', 40),
(99, '2025_03_06_144750_create_allotment_letters_table', 41),
(100, '2025_03_05_113742_create_demolitions_table', 42),
(102, '2025_03_07_202923_update_survey_residential_household_table', 42),
(103, '2025_03_08_002319_add_updated_status_to_survey_user_residentials', 42),
(104, '2025_03_08_120409_add_columns_to_survey_commercial_table', 42),
(105, '2025_03_07_194328_create_monthly_income_ranges_table', 43),
(106, '2025_03_12_182711_create_lotteries_table', 44),
(107, '2025_03_12_182832_create_allotments_table', 44),
(108, '2025_03_18_185346_add_commercial_user_photo_to_surveyusercommercial_table', 45),
(109, '2025_03_19_101108_add_aadhaar_number_to_survey_residential_household_table', 46),
(110, '2025_03_17_124406_add_project_id_to_lotteries_table', 47),
(111, '2025_03_17_163257_create_blocked_lottery_inventories_table', 47),
(112, '2025_03_24_102720_add_remark_to_lotteries_table', 47),
(113, '2025_03_27_170239_add_bank_details_to_sur_residen_socio_economic', 48),
(114, '2025_03_27_173633_add_balanced_area_and_shop_name', 49),
(115, '2025_03_27_175227_add_structure_photo_to_survey_agencyuser_others', 50),
(116, '2025_04_02_184423_add_allotment_status_to_surveyagencyuserresidential_table', 51),
(117, '2025_04_03_143130_add_consumer_no_to_sur_residen_socio_economic', 52),
(119, '2025_04_07_104057_add_remark_other_to_survey_agencyuser_others_table', 54),
(120, '2025_04_07_104511_add_remark_other_to_survey_agencyuser_commercial_table', 54),
(121, '2025_04_07_104747_add_remark_other_to_survey_user_residentials_table', 54),
(122, '2025_04_07_105204_add_allotment_comment_to_survey_user_residentials_table', 54),
(123, '2025_04_07_105313_add_allotment_comment_to_survey_agencyuser_commercial_table', 54),
(124, '2025_04_07_105415_add_allotment_comment_to_survey_agencyuser_others_table', 54),
(125, '2025_04_07_105517_add_draft_annexure_remark_to_projects_table', 55),
(126, '2025_04_05_154302_create_joint_verification_docs_table', 56),
(127, '2025_04_08_094042_add_junior_project_officer_id_to_projects_table', 57),
(129, '2025_04_09_135205_add_api_response_and_remarks_to_survey_documents_table', 58),
(130, '2025_04_11_164925_add_occupation_other_to_survey_residential_household_table', 59),
(131, '2025_04_16_130903_add_survey_completion_flag_to_survey_residential_household_table', 60),
(132, '2025_04_18_182659_create_reasons_table', 61),
(133, '2025_04_18_184420_create_flgrcs_table', 61),
(134, '2025_04_28_203221_create_temporary_allotments_table', 61),
(135, '2025_04_29_104303_create_association_registrations_table', 61),
(143, '2025_04_29_155352_create_amenity_assignments_table', 62),
(144, '2025_04_29_155441_create_amenity_assignment_rooms_table', 62),
(145, '2025_04_30_095925_add_temp_assign_status_to_survey_user_residentials_table', 63),
(146, '2025_04_30_101254_fix_id_column_in_temporary_allotments_table', 64),
(147, '2025_04_30_130428_create_fund_categories_table', 65),
(148, '2025_04_30_162906_add_columns_to_receiveds_table', 65),
(149, '2025_05_06_101535_add_remark_to_inventory_building_rooms_table', 65),
(150, '2025_05_06_171217_add_project_belongs_to_and_project_formate_to_projects_table', 65),
(151, '2025_05_12_132019_add_allotment_columns_to_survey_user_residentials_table', 66),
(152, '2025_05_14_110541_add_indemnity_bond_field_to_survey_user_residentials', 67),
(153, '2025_05_16_182952_create_jobs_table', 68),
(154, '2025_05_21_155637_add_is_document_processed_column_to_survey_documents_table', 69),
(155, '2025_05_24_113740_add_signed_taba_column_to_survey_user_residentials', 70);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 4),
(2, 'App\\Models\\User', 16),
(3, 'App\\Models\\User', 15),
(4, 'App\\Models\\User', 19),
(5, 'App\\Models\\User', 20),
(6, 'App\\Models\\User', 21),
(7, 'App\\Models\\User', 22);

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

--
-- Table structure for table `monthly_income_ranges`
--

CREATE TABLE `monthly_income_ranges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `range` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `monthly_income_ranges`
--

INSERT INTO `monthly_income_ranges` (`id`, `range`, `created_at`, `updated_at`) VALUES
(1, '0-50,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(2, '50,000-1,00,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(3, '1,00,000-1,50,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(4, '1,50,000-2,00,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(5, '2,00,000-2,50,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(6, '2,50,000-3,00,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(7, '3,00,000-3,50,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(8, '3,50,000-4,00,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29'),
(9, '4,00,000-4,50,000', '2025-03-10 11:21:29', '2025-03-10 11:21:29');

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

--
-- Table structure for table `mother_tongues`
--

CREATE TABLE `mother_tongues` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n                1. Marathi,\n                2. Hindi,\n                3. Gujarati,\n                4. Tamil,\n                5. Kannada,\n                6. Oriya,\n                7. Telugu,\n                8. Urdu,\n                9. Bhojpuri,\n                10. Punjabi,\n                11. Banjari,\n                12. Other',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mother_tongues`
--

INSERT INTO `mother_tongues` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Marathi', NULL, NULL, NULL),
(2, 'Hindi', NULL, NULL, NULL),
(3, 'Gujarati', NULL, NULL, NULL),
(4, 'Tamil', NULL, NULL, NULL),
(5, 'Kannada', NULL, NULL, NULL),
(6, 'Oriya', NULL, NULL, NULL),
(7, 'Telugu', NULL, NULL, NULL),
(8, 'Urdu', NULL, NULL, NULL),
(9, 'Bhojpuri', NULL, NULL, NULL),
(10, 'Punjabi', NULL, NULL, NULL),
(11, 'Banjari', NULL, NULL, NULL),
(12, 'Other', NULL, NULL, NULL);

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2025-01-22 10:43:53', '2025-01-22 10:43:53');

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

--
-- Table structure for table `occupations`
--

CREATE TABLE `occupations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n            1. Fisher,\n            2. Labourer,\n            3. Dairy,\n            4. Trader,\n            5. Craftsman,\n            6. Private Company,\n            7. Govt Job,\n            8. Shop Owner,\n            9. Housewife,\n            10. Student,\n            11. Laundry Services,\n            12. School going age but not going,\n            13. Unemployed,\n            14. Business,\n            15. Autorickshaw driver,\n            16. Cook',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `occupations`
--

INSERT INTO `occupations` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Fisher', NULL, NULL, NULL),
(2, 'Labourer', NULL, NULL, NULL),
(3, 'Dairy', NULL, NULL, NULL),
(4, 'Trader', NULL, NULL, NULL),
(5, 'Craftsman', NULL, NULL, NULL),
(6, 'Private Company', NULL, NULL, NULL),
(7, 'Govt Job', NULL, NULL, NULL),
(8, 'Shop Owner', NULL, NULL, NULL),
(9, 'Housewife', NULL, NULL, NULL),
(10, 'Student', NULL, NULL, NULL),
(11, 'Laundry Services', NULL, NULL, NULL),
(12, 'School going age but not going', NULL, NULL, NULL),
(13, 'Unemployed', NULL, NULL, NULL),
(14, 'Business', NULL, NULL, NULL),
(15, 'Autorickshaw driver', NULL, NULL, NULL),
(16, 'Cook', NULL, NULL, NULL),
(17, 'Other', NULL, NULL, NULL);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `display_name` varchar(250) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `display_name`, `parent_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'manage_agency', 'web', 'Manage Agency', NULL, 1, '2025-03-10 06:23:55', '2025-03-10 06:23:55'),
(2, 'agency_list', 'web', 'Agency List', 1, 1, '2025-03-10 06:24:11', '2025-03-10 06:24:11'),
(3, 'add_agency', 'web', 'Add Agency', 1, 1, '2025-03-10 06:39:16', '2025-03-10 06:39:16'),
(4, 'edit_agency', 'web', 'Edit Agency', 1, 1, '2025-03-10 06:39:47', '2025-03-10 06:39:47'),
(5, 'update_agency', 'web', 'Update Agency', 1, 1, '2025-03-10 06:40:02', '2025-03-10 06:40:02'),
(6, 'delete_agency', 'web', 'Delete Agency', 1, 1, '2025-03-10 06:40:13', '2025-03-10 06:40:13'),
(7, 'view_agency', 'web', 'View Agency', 1, 1, '2025-03-10 06:40:34', '2025-03-10 06:40:34'),
(8, 'agency_status_update', 'web', 'Agency Status Update', 1, 1, '2025-03-10 06:42:28', '2025-03-10 06:42:28'),
(9, 'add_agency_user', 'web', 'Add Agency User', 1, 1, '2025-03-10 06:47:07', '2025-03-10 06:47:07'),
(10, 'agency_user_list', 'web', 'Agency User List', 1, 1, '2025-03-10 06:47:29', '2025-03-10 06:47:29'),
(11, 'agency_user_edit', 'web', 'Agency User Edit', 1, 1, '2025-03-10 06:47:41', '2025-03-10 06:47:41'),
(12, 'agency_user_update', 'web', 'Agency User Update', 1, 1, '2025-03-10 06:47:56', '2025-03-10 06:47:56'),
(13, 'agency_user_view', 'web', 'Agency User View', 1, 1, '2025-03-10 06:48:07', '2025-03-10 06:48:07'),
(14, 'agency_user_delete', 'web', 'Agency User Delete', 1, 1, '2025-03-10 06:48:21', '2025-03-10 06:48:21'),
(15, 'agency_user_status_update', 'web', 'Agency User Status Update', 1, 1, '2025-03-10 06:48:42', '2025-03-10 06:48:42'),
(16, 'user_&_roles', 'web', 'User & Roles', NULL, 1, '2025-03-10 06:58:44', '2025-03-10 06:58:44'),
(17, 'system_user_list', 'web', 'System User List', 16, 1, '2025-03-10 06:59:05', '2025-03-10 06:59:38'),
(18, 'system_user_add', 'web', 'System User Add', 16, 1, '2025-03-10 07:00:02', '2025-03-10 07:00:02'),
(19, 'system_user_edit', 'web', 'System User Edit', 16, 1, '2025-03-10 07:00:15', '2025-03-10 07:00:15'),
(20, 'system_user_delete', 'web', 'System User Delete', 16, 1, '2025-03-10 07:00:29', '2025-03-10 07:00:29'),
(21, 'system_user_update', 'web', 'System User Update', 16, 1, '2025-03-10 07:00:47', '2025-03-10 07:00:47'),
(22, 'system_user_view', 'web', 'System User View', 16, 1, '2025-03-10 07:01:07', '2025-03-10 07:01:07'),
(23, 'system_user_update_status', 'web', 'System User Update Status', 16, 1, '2025-03-10 07:05:44', '2025-03-10 07:05:44'),
(24, 'role_list', 'web', 'Role List', 16, 1, '2025-03-10 07:10:45', '2025-03-10 07:10:45'),
(25, 'role_add', 'web', 'Role Add', 16, 1, '2025-03-10 07:10:59', '2025-03-10 07:10:59'),
(26, 'role_edit', 'web', 'Role Edit', 16, 1, '2025-03-10 07:11:11', '2025-03-10 07:11:11'),
(27, 'role_update', 'web', 'Role Update', 16, 1, '2025-03-10 07:11:25', '2025-03-10 07:11:25'),
(28, 'role_delete', 'web', 'Role Delete', 16, 1, '2025-03-10 07:11:47', '2025-03-10 07:11:47'),
(29, 'role_view', 'web', 'Role View', 16, 1, '2025-03-10 07:12:38', '2025-03-10 07:12:38'),
(30, 'permission_add', 'web', 'Permission Add', 16, 1, '2025-03-10 07:52:16', '2025-03-10 07:52:16'),
(31, 'permission_view', 'web', 'Permission View', 16, 1, '2025-03-10 07:52:33', '2025-03-10 07:52:33'),
(32, 'permission_edit', 'web', 'Permission Edit', 16, 1, '2025-03-10 07:52:47', '2025-03-10 07:52:47'),
(33, 'permission_delete', 'web', 'Permission Delete', 16, 1, '2025-03-10 07:53:04', '2025-03-10 07:53:04'),
(34, 'permission_update', 'web', 'Permission Update', 16, 1, '2025-03-10 07:53:22', '2025-03-10 07:53:22'),
(35, 'permission_list', 'web', 'Permission List', 16, 1, '2025-03-10 07:54:18', '2025-03-10 07:54:18'),
(36, 'role_permission_view', 'web', 'Role Permission View', 16, 1, '2025-03-10 07:57:20', '2025-03-10 07:57:20'),
(37, 'role_permission_add', 'web', 'Role Permission Add', 16, 1, '2025-03-10 07:58:33', '2025-03-10 07:58:33'),
(38, 'role_permission_list', 'web', 'Role Permission List', 16, 1, '2025-03-10 07:59:59', '2025-03-10 07:59:59'),
(39, 'user_role_list', 'web', 'User Role List', 16, 1, '2025-03-10 08:03:58', '2025-03-10 08:03:58'),
(40, 'user_role_assign', 'web', 'User Role Assign', 16, 1, '2025-03-10 08:04:11', '2025-03-10 08:04:11'),
(41, 'user_role_add', 'web', 'User Role Add', 16, 1, '2025-03-10 08:04:30', '2025-03-10 08:04:30'),
(42, 'user_role_edit', 'web', 'User Role Edit', 16, 1, '2025-03-10 08:04:45', '2025-03-10 08:04:45'),
(43, 'user_role_update', 'web', 'User Role Update', 16, 1, '2025-03-10 08:05:00', '2025-03-10 08:05:00'),
(44, 'designation_add', 'web', 'Designation Add', 16, 1, '2025-03-10 08:11:54', '2025-03-10 08:11:54'),
(45, 'designation_edit', 'web', 'Designation Edit', 16, 1, '2025-03-10 08:12:12', '2025-03-10 08:12:12'),
(46, 'designation_update', 'web', 'Designation Update', 16, 1, '2025-03-10 08:12:28', '2025-03-10 08:12:28'),
(47, 'designation_delete', 'web', 'Designation Delete', 16, 1, '2025-03-10 08:12:47', '2025-03-10 08:12:47'),
(48, 'designation_view', 'web', 'Designation View', 16, 1, '2025-03-10 08:13:03', '2025-03-10 08:13:03'),
(49, 'designation_update_status', 'web', 'Designation Update Status', 16, 1, '2025-03-10 08:13:23', '2025-03-10 08:13:23'),
(50, 'designation_list', 'web', 'Designation List', 16, 1, '2025-03-10 08:17:45', '2025-03-10 08:17:45'),
(51, 'manage_project', 'web', 'Manage Project', NULL, 1, '2025-03-10 08:20:16', '2025-03-10 08:20:16'),
(52, 'project_add', 'web', 'Project Add', 51, 1, '2025-03-10 08:21:37', '2025-03-10 08:21:37'),
(53, 'project_list', 'web', 'Project List', 51, 1, '2025-03-10 08:21:51', '2025-03-10 08:21:51'),
(54, 'project_edit', 'web', 'Project Edit', 51, 1, '2025-03-10 08:22:07', '2025-03-10 08:22:07'),
(55, 'project_update', 'web', 'Project Update', 51, 1, '2025-03-10 08:22:26', '2025-03-10 08:22:26'),
(56, 'project_view', 'web', 'Project View', 51, 1, '2025-03-10 08:22:52', '2025-03-10 08:22:52'),
(57, 'project_delete', 'web', 'Project Delete', 51, 1, '2025-03-10 08:23:08', '2025-03-10 08:23:08'),
(58, 'project_update_assign', 'web', 'Project Update Assign', 51, 1, '2025-03-10 08:24:37', '2025-03-10 08:24:37'),
(59, 'project_create_view', 'web', 'Project Create View', 51, 1, '2025-03-10 08:25:12', '2025-03-10 08:25:12'),
(60, 'post_r&r', 'web', 'Post R&R', NULL, 1, '2025-03-10 08:36:23', '2025-03-10 08:36:23'),
(61, 'society_add', 'web', 'Society Add', 60, 1, '2025-03-10 08:36:56', '2025-03-10 08:36:56'),
(62, 'society_list', 'web', 'Society List', 60, 1, '2025-03-10 08:37:10', '2025-03-10 08:37:10'),
(63, 'society_edit', 'web', 'Society Edit', 60, 1, '2025-03-10 08:37:31', '2025-03-10 08:37:31'),
(64, 'society_view', 'web', 'Society View', 60, 1, '2025-03-10 08:37:46', '2025-03-10 08:37:46'),
(65, 'society_update', 'web', 'Society Update', 60, 1, '2025-03-10 08:38:04', '2025-03-10 08:38:04'),
(66, 'society_delete', 'web', 'Society Delete', 60, 1, '2025-03-10 08:38:17', '2025-03-10 08:38:17'),
(67, 'received_add', 'web', 'Received Add', 60, 1, '2025-03-10 08:39:22', '2025-03-10 08:39:22'),
(68, 'received_view', 'web', 'Received View', 60, 1, '2025-03-10 08:39:35', '2025-03-10 08:39:35'),
(69, 'received_list', 'web', 'Received List', 60, 1, '2025-03-10 08:39:48', '2025-03-10 08:39:48'),
(70, 'received_edit', 'web', 'Received Edit', 60, 1, '2025-03-10 09:02:13', '2025-03-10 09:02:13'),
(71, 'received_update', 'web', 'Received Update', 60, 1, '2025-03-10 09:02:37', '2025-03-10 09:02:37'),
(72, 'received_delete', 'web', 'Received Delete', 60, 1, '2025-03-10 09:02:53', '2025-03-10 09:02:53'),
(73, 'r&r', 'web', 'R&R', NULL, 1, '2025-03-10 09:09:29', '2025-03-10 09:09:29'),
(74, 'inventory_add', 'web', 'Inventory Add', 73, 1, '2025-03-10 09:09:44', '2025-03-10 09:10:19'),
(75, 'inventory_list', 'web', 'Inventory List', 73, 1, '2025-03-10 09:10:33', '2025-03-10 09:10:33'),
(76, 'inventory_view', 'web', 'Inventory View', 73, 1, '2025-03-10 09:10:46', '2025-03-10 09:10:46'),
(77, 'inventory_edit', 'web', 'Inventory Edit', 73, 1, '2025-03-10 09:11:02', '2025-03-10 09:11:02'),
(78, 'inventory_update', 'web', 'Inventory Update', 73, 1, '2025-03-10 09:11:23', '2025-03-10 09:11:23'),
(79, 'inventory_delete', 'web', 'Inventory Delete', 73, 1, '2025-03-10 09:11:38', '2025-03-10 09:11:38'),
(80, 'inventory_record_view', 'web', 'Inventory Record View', 73, 1, '2025-03-10 09:12:34', '2025-03-10 09:12:34'),
(81, 'inventory_bulk_upload', 'web', 'Inventory Bulk Upload', 73, 1, '2025-03-10 09:12:53', '2025-03-10 09:12:53'),
(82, 'inventory_upload', 'web', 'Inventory Upload', 73, 1, '2025-03-10 09:13:15', '2025-03-10 09:13:15'),
(83, 'r&r_projects_listing', 'web', 'R&R Projects Listing', 73, 1, '2025-04-07 13:31:12', '2025-04-07 13:31:12'),
(84, 'all_projects', 'web', 'All Projects', 73, 1, '2025-04-07 13:44:04', '2025-04-07 13:44:04'),
(85, 'submit_joint_verification', 'web', 'Submit Joint verification', 73, 1, '2025-04-07 14:30:26', '2025-04-07 14:30:26'),
(86, 'update_draft_status', 'web', 'Update Draft Status', 73, 1, '2025-04-07 14:40:25', '2025-04-07 14:40:25'),
(87, 'update_annexure_status', 'web', 'Update Annexure Status', 73, 1, '2025-04-07 14:46:47', '2025-04-07 14:46:47'),
(88, 'lottery_view', 'web', 'Lottery View', 73, 1, '2025-04-07 14:52:01', '2025-04-07 14:52:01'),
(89, 'elottery_view', 'web', 'Elottery view', 73, 1, '2025-04-07 14:52:27', '2025-04-07 14:52:27'),
(90, 'allotment_view', 'web', 'Allotment View', 73, 1, '2025-04-07 14:52:49', '2025-04-07 14:52:49'),
(91, 'association_view', 'web', 'Association View', 60, 1, '2025-05-22 05:38:18', '2025-05-22 05:38:18'),
(92, 'association_add', 'web', 'Association Add', 60, 1, '2025-05-22 05:39:02', '2025-05-22 05:39:02'),
(93, 'association_edit', 'web', 'Association Edit', 60, 1, '2025-05-22 05:39:39', '2025-05-22 05:39:39'),
(94, 'association_update', 'web', 'Association Update', 60, 1, '2025-05-22 05:39:59', '2025-05-22 05:39:59'),
(95, 'association_delete', 'web', 'Association Delete', 60, 1, '2025-05-22 05:40:23', '2025-05-22 05:40:23'),
(96, 'association_list', 'web', 'Association List', 60, 1, '2025-05-22 05:42:08', '2025-05-22 05:42:08'),
(97, 'amenity_list', 'web', 'Amenity List', 60, 1, '2025-05-22 06:13:05', '2025-05-22 06:13:05'),
(98, 'amenity_view', 'web', 'Amenity View', 60, 1, '2025-05-22 06:13:36', '2025-05-22 06:13:36'),
(99, 'amenity_add', 'web', 'Amenity Add', 60, 1, '2025-05-22 06:14:07', '2025-05-22 06:14:07'),
(100, 'temporary_assign', 'web', 'Temporary Assign', 73, 1, '2025-05-22 09:53:38', '2025-05-22 09:53:38');

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

--
-- Table structure for table `permissions_old`
--

CREATE TABLE `permissions_old` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `permission_name` varchar(255) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `note` text DEFAULT NULL,
  `joint_verification_report_file` varchar(255) DEFAULT NULL,
  `type_1` enum('1','2') NOT NULL COMMENT '1: MMRDA, 2: Other',
  `type_2` enum('1','2','3') NOT NULL COMMENT '1: MUTP, 2: MUIP, 3: Other',
  `project_belongs_to` varchar(255) DEFAULT NULL,
  `project_formate` varchar(255) DEFAULT NULL,
  `site_location` varchar(255) DEFAULT NULL,
  `sdc_officer_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `agency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `area_human_readable` text DEFAULT NULL,
  `area` polygon DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `junior_project_officer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status_id` bigint(20) UNSIGNED DEFAULT NULL,
  `draft_annexure_remark` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `name`, `note`, `joint_verification_report_file`, `type_1`, `type_2`, `project_belongs_to`, `project_formate`, `site_location`, `sdc_officer_user_id`, `agency_id`, `area_human_readable`, `area`, `created_by`, `junior_project_officer_id`, `deleted_at`, `created_at`, `updated_at`, `status_id`, `draft_annexure_remark`) VALUES
(9, 'Kalyan Badlapur Railway Line 3 & 4 of Central Railway under MUTP-3A', 'Ok', '67f1033c2ee2a3.05419940.jpg', '1', '2', 'SDC', 'MMRDA/MUIP/SDC/3718/2025', 'Gaya', 20, 10, NULL, NULL, 1, 19, NULL, '2025-03-11 09:40:24', '2025-05-24 05:31:47', 13, 'all ok'),
(12, 'Project3', 'Testing project3', NULL, '1', '1', NULL, NULL, 'Noida', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2025-04-05 09:22:58', '2025-04-06 03:23:41', NULL, NULL),
(13, 'Metro 12', NULL, NULL, '1', '1', NULL, NULL, 'Andheri', 16, 10, NULL, NULL, 1, NULL, NULL, '2025-04-07 06:36:55', '2025-04-07 08:15:37', NULL, NULL),
(14, 'Md Project', NULL, NULL, '1', '1', NULL, NULL, 'Noida', 20, 11, NULL, NULL, 1, 19, NULL, '2025-04-21 07:00:12', '2025-04-21 07:00:51', NULL, NULL);

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

--
-- Table structure for table `project_related_documents`
--

CREATE TABLE `project_related_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `demand_note` varchar(255) DEFAULT NULL,
  `project_coordinates` varchar(255) DEFAULT NULL,
  `next_stage_type` enum('BSES','Annexure') DEFAULT NULL,
  `next_stage_file` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_related_documents`
--

INSERT INTO `project_related_documents` (`id`, `project_id`, `demand_note`, `project_coordinates`, `next_stage_type`, `next_stage_file`, `created_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(9, 9, '67d0050899ac57.65179556.jpg', NULL, NULL, NULL, 1, '2025-03-11 09:40:25', '2025-05-12 07:03:53', NULL),
(11, 12, '67f0f672a882a8.17989583.jpg', NULL, NULL, NULL, 1, '2025-04-05 09:22:58', '2025-04-05 09:22:58', NULL),
(12, 13, '67f37287940694.34907417.jpg', NULL, NULL, NULL, 1, '2025-04-07 06:36:55', '2025-04-07 06:36:55', NULL),
(13, 14, '6805ecfc0dd435.40270414.jpg', NULL, NULL, NULL, 1, '2025-04-21 07:00:12', '2025-04-21 07:00:12', NULL);

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

--
-- Table structure for table `project_statuses`
--

CREATE TABLE `project_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_statuses`
--

INSERT INTO `project_statuses` (`id`, `project_id`, `status`, `created_at`, `updated_at`) VALUES
(14, 9, 1, '2025-03-11 10:15:47', '2025-03-11 10:15:47'),
(64, 9, 2, NULL, NULL),
(65, 9, 3, NULL, NULL),
(124, 9, 4, '2025-04-29 06:58:18', '2025-04-29 06:58:18'),
(132, 9, 5, '2025-04-29 06:58:18', '2025-04-29 06:58:18'),
(133, 9, 6, '2025-04-29 06:58:18', '2025-04-29 06:58:18'),
(134, 9, 7, '2025-04-29 07:19:18', '2025-04-29 07:19:18'),
(135, 9, 8, '2025-04-29 07:20:28', '2025-04-29 07:20:28'),
(141, 9, 9, '2025-05-13 05:02:34', '2025-05-13 05:02:34'),
(142, 9, 9, '2025-05-13 05:04:34', '2025-05-13 05:04:34'),
(143, 9, 10, '2025-05-13 05:05:01', '2025-05-13 05:05:01'),
(144, 9, 11, '2025-05-13 05:05:34', '2025-05-13 05:05:34'),
(145, 9, 13, '2025-05-13 05:08:50', '2025-05-13 05:08:50'),
(146, 9, 9, '2025-05-24 05:24:31', '2025-05-24 05:24:31'),
(147, 9, 9, '2025-05-24 05:26:58', '2025-05-24 05:26:58'),
(148, 9, 10, '2025-05-24 05:28:22', '2025-05-24 05:28:22'),
(149, 9, 11, '2025-05-24 05:30:04', '2025-05-24 05:30:04'),
(150, 9, 13, '2025-05-24 05:31:47', '2025-05-24 05:31:47');

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

--
-- Table structure for table `reasons`
--

CREATE TABLE `reasons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `receiveds`
--

CREATE TABLE `receiveds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `receipt_no` varchar(255) NOT NULL,
  `received_from` varchar(255) NOT NULL,
  `receipt_date` datetime DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_mode` enum('DD','Cheque','Cash') NOT NULL,
  `dated` datetime DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `drawn_on` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `on_account_of` text DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `receipt` varchar(255) DEFAULT NULL,
  `project_name` varchar(255) DEFAULT NULL,
  `fund_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_cleared_on` date DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `receiveds`
--

INSERT INTO `receiveds` (`id`, `receipt_no`, `received_from`, `receipt_date`, `amount`, `payment_mode`, `dated`, `number`, `drawn_on`, `branch`, `on_account_of`, `photo`, `receipt`, `project_name`, `fund_category_id`, `payment_cleared_on`, `deleted_at`, `created_at`, `updated_at`) VALUES
(2, '1425424', 'Sinha Ji', '2025-03-12 11:54:09', 1001.00, 'Cheque', '2025-03-12 11:54:09', '254252', 'Monday', 'Gaya', 'Lala Ji', '67d128898ad6b0.10874029.jpg', NULL, NULL, NULL, NULL, NULL, '2025-03-12 06:24:09', '2025-03-12 06:24:09'),
(3, '14254246', 'Sinha Ji', '2025-03-25 15:40:54', 1001.00, 'Cheque', '2025-03-12 15:40:54', '254252', 'Monday', 'Gaya', 'Lala Ji', '67e2812eb80ec2.45697919.jpg', NULL, NULL, NULL, NULL, NULL, '2025-03-25 10:10:56', '2025-03-25 10:10:56'),
(4, '12', 'Sinha Ji', '2025-03-25 16:06:56', 1001.00, 'Cheque', '2025-03-26 16:06:56', '254252', 'Monday', 'Gaya', 'Lala Ji', '67e28442b86684.54902837.jpg', NULL, NULL, NULL, NULL, NULL, '2025-03-25 10:24:02', '2025-03-25 10:36:56'),
(5, '14254241211', 'Sinha Ji', '2025-03-25 16:07:25', 1001.00, 'DD', '2025-03-12 16:07:25', '2542521', 'Monday', 'Gaya', 'Lala Ji', '67e28765ee5140.69107521.jpg', NULL, NULL, NULL, NULL, NULL, '2025-03-25 10:37:26', '2025-03-25 10:37:26'),
(6, '123', 'Sinha Ji', '2025-03-25 16:07:51', 1001.00, 'Cash', NULL, NULL, 'Monday', 'Gaya', 'Lala Ji', '67e2877f458509.21021309.jpg', NULL, NULL, NULL, NULL, NULL, '2025-03-25 10:37:51', '2025-03-25 10:37:51'),
(7, '1234', 'Sinha Ji', '2025-03-25 16:08:27', 1001.00, 'Cheque', '2025-03-26 16:08:27', '1', 'Monday', 'Gaya', 'Lala Ji', '67e287a3d45cf4.06896412.jpg', NULL, NULL, NULL, NULL, NULL, '2025-03-25 10:38:27', '2025-03-25 10:38:27');

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

--
-- Table structure for table `relations`
--

CREATE TABLE `relations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n                1. Self,\n                2. Spouse,\n                3. Daughter,\n                4. Son,\n                5. Daughter-in-law,\n                6. Son-in-law,\n                7. Father,\n                8. Mother,\n                9. Grandson,\n                10. Granddaughter,\n                11. Sister,\n                12. Brother,\n                13. Sister-in-law,\n                14. Brother-in-law,\n                15. Nephew,\n                16. Niece,\n                17. Other Male Relative,\n                18. Other Female Relative',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `relations`
--

INSERT INTO `relations` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Self', NULL, NULL, NULL),
(2, 'Spouse', NULL, NULL, NULL),
(3, 'Daughter', NULL, NULL, NULL),
(4, 'Son', NULL, NULL, NULL),
(5, 'Daughter-in-law', NULL, NULL, NULL),
(6, 'Son-in-law', NULL, NULL, NULL),
(7, 'Father', NULL, NULL, NULL),
(8, 'Mother', NULL, NULL, NULL),
(9, 'Grandson', NULL, NULL, NULL),
(10, 'Granddaughter', NULL, NULL, NULL),
(11, 'Sister', NULL, NULL, NULL),
(12, 'Brother', NULL, NULL, NULL),
(13, 'Sister-in-law', NULL, NULL, NULL),
(14, 'Brother-in-law', NULL, NULL, NULL),
(15, 'Nephew', NULL, NULL, NULL),
(16, 'Niece', NULL, NULL, NULL),
(17, 'Other Male Relative', NULL, NULL, NULL),
(18, 'Other Female Relative', NULL, NULL, NULL);

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

--
-- Table structure for table `religions`
--

CREATE TABLE `religions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n                1. Hindu,\n                2. Muslim,\n                3. Buddhist,\n                4. Christian,\n                5. Parsi,\n                6. Jain,\n                7. Other',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `religions`
--

INSERT INTO `religions` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Hindu', NULL, NULL, NULL),
(2, 'Muslim', NULL, NULL, NULL),
(3, 'Buddhist', NULL, NULL, NULL),
(4, 'Christian', NULL, NULL, NULL),
(5, 'Parsi', NULL, NULL, NULL),
(6, 'Jain', NULL, NULL, NULL),
(7, 'Other', NULL, NULL, NULL);

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

--
-- Table structure for table `remarks`
--

CREATE TABLE `remarks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `remarks`
--

INSERT INTO `remarks` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'PAP present', NULL, NULL),
(2, 'PAP absent', NULL, NULL),
(3, 'Structure Lock', NULL, NULL),
(5, 'Rented', NULL, NULL),
(6, 'PAP Dead', NULL, NULL),
(7, 'Structure not found', NULL, NULL),
(8, 'Demolished', NULL, NULL),
(9, 'Dispute', NULL, NULL),
(10, 'Out of alignment', NULL, NULL),
(11, 'Partly affected', NULL, NULL),
(12, 'Multiple hutments of PAP & Family for residential structures', NULL, NULL),
(14, 'Other', NULL, NULL);

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'system_admin', 'web', 'System Admin', '2025-03-10 06:22:32', '2025-03-10 06:22:32'),
(2, 'test_user', 'web', 'Test User', '2025-03-24 11:36:26', '2025-03-24 11:36:26'),
(3, 'engineer', 'web', 'Engineer', '2025-04-03 09:39:10', '2025-04-07 13:01:27'),
(4, 'deputy_cdo', 'web', 'Deputy CDO', '2025-04-07 13:02:01', '2025-04-07 13:02:01'),
(5, 'sdc_officer', 'web', 'SDC Officer', '2025-04-07 13:02:15', '2025-04-07 13:02:15'),
(6, 'chief', 'web', 'Chief', '2025-04-07 13:02:42', '2025-04-07 13:02:42'),
(7, 'land_cell', 'web', 'Land Cell', '2025-04-07 15:01:14', '2025-04-07 15:01:14');

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

--
-- Table structure for table `roles_old`
--

CREATE TABLE `roles_old` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_name` varchar(255) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 6),
(2, 1),
(2, 2),
(2, 3),
(2, 6),
(3, 1),
(3, 2),
(3, 3),
(3, 6),
(4, 1),
(4, 2),
(4, 3),
(4, 6),
(5, 1),
(5, 2),
(5, 3),
(5, 6),
(6, 1),
(6, 2),
(6, 3),
(6, 6),
(7, 1),
(7, 2),
(7, 3),
(7, 6),
(8, 1),
(8, 2),
(8, 3),
(8, 6),
(9, 1),
(9, 2),
(9, 6),
(10, 1),
(10, 2),
(10, 6),
(11, 1),
(11, 2),
(11, 6),
(12, 1),
(12, 2),
(12, 6),
(13, 1),
(13, 2),
(13, 6),
(14, 1),
(14, 2),
(14, 6),
(15, 1),
(15, 2),
(15, 6),
(16, 1),
(16, 6),
(17, 1),
(17, 6),
(18, 1),
(18, 6),
(19, 1),
(19, 6),
(20, 1),
(20, 6),
(21, 1),
(21, 6),
(22, 1),
(22, 6),
(23, 1),
(23, 6),
(24, 1),
(24, 6),
(25, 1),
(25, 6),
(26, 1),
(26, 6),
(27, 1),
(27, 6),
(28, 1),
(28, 6),
(29, 1),
(29, 6),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(36, 6),
(37, 1),
(37, 6),
(38, 1),
(38, 6),
(39, 1),
(39, 6),
(40, 1),
(40, 6),
(41, 1),
(41, 6),
(42, 1),
(42, 6),
(43, 1),
(43, 6),
(44, 1),
(44, 6),
(45, 1),
(45, 6),
(46, 1),
(46, 6),
(47, 1),
(47, 6),
(48, 1),
(48, 6),
(49, 1),
(49, 6),
(50, 1),
(50, 6),
(51, 1),
(51, 2),
(51, 3),
(51, 6),
(52, 1),
(52, 2),
(52, 3),
(52, 6),
(53, 1),
(53, 2),
(53, 3),
(53, 6),
(54, 1),
(54, 2),
(54, 3),
(54, 6),
(55, 1),
(55, 2),
(55, 3),
(55, 6),
(56, 1),
(56, 2),
(56, 6),
(57, 1),
(57, 2),
(57, 3),
(57, 6),
(58, 1),
(58, 2),
(58, 3),
(58, 6),
(59, 1),
(59, 2),
(59, 3),
(59, 6),
(60, 1),
(60, 2),
(61, 1),
(61, 2),
(62, 1),
(62, 2),
(63, 1),
(63, 2),
(64, 1),
(64, 2),
(65, 1),
(65, 2),
(66, 1),
(66, 2),
(67, 1),
(67, 2),
(68, 1),
(68, 2),
(69, 1),
(69, 2),
(70, 1),
(70, 2),
(71, 1),
(71, 2),
(72, 1),
(72, 2),
(73, 1),
(73, 2),
(73, 4),
(73, 5),
(73, 6),
(73, 7),
(74, 1),
(74, 2),
(74, 7),
(75, 1),
(75, 2),
(75, 7),
(76, 1),
(76, 2),
(76, 7),
(77, 1),
(77, 2),
(77, 7),
(78, 1),
(78, 2),
(78, 7),
(79, 1),
(79, 2),
(79, 7),
(80, 1),
(80, 2),
(80, 7),
(81, 1),
(81, 2),
(81, 7),
(82, 1),
(82, 2),
(82, 7),
(83, 1),
(83, 4),
(83, 5),
(83, 6),
(84, 1),
(84, 6),
(85, 1),
(85, 5),
(85, 6),
(86, 1),
(86, 5),
(86, 6),
(87, 1),
(87, 5),
(87, 6),
(88, 1),
(88, 5),
(88, 6),
(89, 1),
(89, 5),
(89, 6),
(90, 1),
(90, 5),
(90, 6),
(91, 1),
(92, 1),
(93, 1),
(94, 1),
(95, 1),
(96, 1),
(97, 1),
(98, 1),
(99, 1),
(100, 1),
(100, 5);

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

--
-- Table structure for table `role_permission_old`
--

CREATE TABLE `role_permission_old` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` int(11) NOT NULL COMMENT 'Possible values: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`id`, `number`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, NULL),
(2, 2, NULL, NULL, NULL),
(3, 3, NULL, NULL, NULL),
(4, 4, NULL, NULL, NULL),
(5, 5, NULL, NULL, NULL),
(6, 6, NULL, NULL, NULL),
(7, 7, NULL, NULL, NULL),
(8, 8, NULL, NULL, NULL),
(9, 9, NULL, NULL, NULL),
(10, 10, NULL, NULL, NULL);

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

--
-- Table structure for table `shop_types`
--

CREATE TABLE `shop_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values: Vegetables/Fruits, Provisions, Confectionary, Snacks, Tea, Restaurant, Diary, Flour Mill, Electrician, Carpenter, Mechanic, Other',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shop_types`
--

INSERT INTO `shop_types` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Vegetables/Fruits', NULL, NULL, NULL),
(2, 'Provisions', NULL, NULL, NULL),
(3, 'Confectionary', NULL, NULL, NULL),
(4, 'Snacks', NULL, NULL, NULL),
(5, 'Tea', NULL, NULL, NULL),
(6, 'Restaurant', NULL, NULL, NULL),
(7, 'Diary', NULL, NULL, NULL),
(8, 'Flour Mill', NULL, NULL, NULL),
(9, 'Electrician', NULL, NULL, NULL),
(10, 'Carpenter', NULL, NULL, NULL),
(11, 'Mechanic', NULL, NULL, NULL),
(12, 'Other', NULL, NULL, NULL);

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

--
-- Table structure for table `societies`
--

CREATE TABLE `societies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `registration_number` varchar(255) NOT NULL,
  `society_name` varchar(255) NOT NULL,
  `society_address` text NOT NULL,
  `society_registration_date` datetime DEFAULT NULL,
  `classification_type` enum('Type1','Type2','Type3') NOT NULL,
  `sub_classification_type` enum('Subtype1','Subtype2') NOT NULL,
  `approval_note` varchar(255) DEFAULT NULL,
  `registration_certificate` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `societies`
--

INSERT INTO `societies` (`id`, `registration_number`, `society_name`, `society_address`, `society_registration_date`, `classification_type`, `sub_classification_type`, `approval_note`, `registration_certificate`, `deleted_at`, `created_at`, `updated_at`) VALUES
(6, '12455', 'Gokuldham', 'Powder Gully', '2025-03-12 11:52:50', 'Type1', 'Subtype1', '67d1283a8443c3.31352019.jpg', '67d1283aadb8c7.81130181.jpg', NULL, '2025-03-12 06:22:50', '2025-03-12 06:22:50');

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

--
-- Table structure for table `statuses`
--

CREATE TABLE `statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'BSES - In Progress', NULL, NULL),
(2, 'BSES Completed', NULL, NULL),
(3, 'Joint Verification Started', NULL, NULL),
(4, 'Joint Verification In-progress', NULL, NULL),
(5, 'Joint Verification Completed', NULL, NULL),
(6, 'Joint Verification Submitted', NULL, NULL),
(7, 'Draft Annexure Submitted', NULL, NULL),
(8, 'Annexure 2 Submitted', NULL, NULL),
(9, 'Lottery Draft', NULL, NULL),
(10, 'Lottery Review', NULL, NULL),
(11, 'Lottery Approved', NULL, NULL),
(12, 'Survey Completed', NULL, NULL),
(13, 'Allotment Completed', NULL, NULL);

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

--
-- Table structure for table `structure_holder`
--

CREATE TABLE `structure_holder` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n            1. Occupant,\n            2. Tenant (Renter),\n            3. Purchased,\n            4. Relatives,\n            5. Other (Specify)',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `structure_holder`
--

INSERT INTO `structure_holder` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Occupant', NULL, NULL, NULL),
(2, 'Tenant (Renter)', NULL, NULL, NULL),
(3, 'Purchased', NULL, NULL, NULL),
(4, 'Relatives', NULL, NULL, NULL),
(5, 'Other (Specify)', NULL, NULL, NULL);

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

--
-- Table structure for table `structure_roofs`
--

CREATE TABLE `structure_roofs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values: Cement Concrete, Tin/Bricks, Tiles, Plastic, Wood, Bamboo',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `structure_roofs`
--

INSERT INTO `structure_roofs` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Cement Concrete', NULL, NULL, NULL),
(2, 'Tin/Bricks', NULL, NULL, NULL),
(3, 'Tiles', NULL, NULL, NULL),
(4, 'Plastic', NULL, NULL, NULL),
(5, 'Wood', NULL, NULL, NULL),
(6, 'Bamboo', NULL, NULL, NULL);

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

--
-- Table structure for table `structure_types`
--

CREATE TABLE `structure_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values: Religious Structure - Temple, Religious Structure - Buddhvihar, Religious Structure - Masjid/Madarsa, Religious Structure - Church, Public Toilet, Samaj Mandir, Balwadi/Anganwadi, CBO’s Office, Political Party Office, Any other (Specify)',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `structure_types`
--

INSERT INTO `structure_types` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Religious Structure - Temple', NULL, NULL, NULL),
(2, 'Religious Structure - Buddhvihar', NULL, NULL, NULL),
(3, 'Religious Structure - Masjid/Madarsa', NULL, NULL, NULL),
(4, 'Religious Structure - Church', NULL, NULL, NULL),
(5, 'Public Toilet', NULL, NULL, NULL),
(6, 'Samaj Mandir', NULL, NULL, NULL),
(7, 'Balwadi/Anganwadi', NULL, NULL, NULL),
(8, 'CBO’s Office', NULL, NULL, NULL),
(9, 'Political Party Office', NULL, NULL, NULL),
(10, 'Any other (Specify)', NULL, NULL, NULL);

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

--
-- Table structure for table `surveys`
--

CREATE TABLE `surveys` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pap_name` varchar(255) DEFAULT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `survey_date` datetime DEFAULT NULL,
  `locality` varchar(255) NOT NULL,
  `map_id` varchar(255) DEFAULT NULL,
  `map_location` varchar(255) DEFAULT NULL,
  `structure_id` varchar(255) DEFAULT NULL,
  `gps_latitude` decimal(10,8) DEFAULT NULL,
  `gps_longitude` decimal(11,8) DEFAULT NULL,
  `structure_use` enum('1','2','3','4') NOT NULL COMMENT '1=Residential, 2=Commercial, 3=Residential+Commercial, 4=Others',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `surveys`
--

INSERT INTO `surveys` (`id`, `pap_name`, `project_id`, `agency_user_id`, `survey_date`, `locality`, `map_id`, `map_location`, `structure_id`, `gps_latitude`, `gps_longitude`, `structure_use`, `deleted_at`, `created_at`, `updated_at`) VALUES
(17, 'Survey Resi', 9, 4, '2024-12-20 00:00:00', 'New Sairaj Colony F Cabin Fatak', '1', 'New Sairaj Colony F Cabin Fatak', '3', 19.12899500, 73.00900000, '1', NULL, '2025-03-11 10:13:04', '2025-03-19 05:02:29'),
(18, 'Survey Resi-comm', 9, 4, '2025-03-11 00:00:00', 'New York Resi-cumm-comm', '1', 'New Sairaj Colony F Cabin Fatak', '30', 19.12850000, 73.00900000, '2', NULL, '2025-03-12 06:12:03', '2025-03-19 04:56:58'),
(19, 'Survey Other', 9, 4, '2025-03-11 00:00:00', 'New York Other', '1', 'New Sairaj Colony F Cabin Fatak', '30', 19.12850000, 73.00900000, '4', NULL, '2025-03-12 06:14:10', '2025-03-12 06:14:10'),
(20, 'Survey Resi-cumm-comm', 9, 4, '2025-03-11 00:00:00', 'New York Resi-cumm-comm', '1', 'New Sairaj Colony F Cabin Fatak', '30', 19.12850000, 73.00900000, '3', NULL, '2025-03-12 06:15:32', '2025-03-12 06:15:32'),
(22, 'Vinay Bhaskar Patil', 9, 17, '2025-04-08 00:00:00', 'kurla', '13', 'Kurla', '12', 19.12850000, 73.00900000, '1', NULL, '2025-04-08 04:58:07', '2025-04-08 04:58:07'),
(23, 'RAMESH BAHSKAR KADAM', 9, 17, '2025-04-09 00:00:00', 'kurla', '12', 'Kurla', '13', 19.05480000, 72.85170000, '1', NULL, '2025-04-08 05:26:06', '2025-04-09 04:47:44');

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

--
-- Table structure for table `survey_agencyuser_commercial`
--

CREATE TABLE `survey_agencyuser_commercial` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `shop_types_id` bigint(20) UNSIGNED NOT NULL,
  `shop_type_other` varchar(255) DEFAULT NULL,
  `shop_area` decimal(8,2) NOT NULL,
  `updated_status` text DEFAULT NULL,
  `updated_status_comment` text DEFAULT NULL,
  `workers_type_id` bigint(20) UNSIGNED NOT NULL,
  `daily_sales` decimal(8,2) NOT NULL,
  `ownership` varchar(255) NOT NULL,
  `nature_of_activity` varchar(255) DEFAULT NULL,
  `monthly_turnover` decimal(10,2) DEFAULT NULL,
  `year_of_establishment` int(11) DEFAULT NULL,
  `no_of_employees` int(11) DEFAULT NULL,
  `name_establishment_owner` varchar(255) DEFAULT NULL,
  `end_product_sale_market` varchar(255) NOT NULL,
  `raw_material_place` varchar(255) NOT NULL,
  `total_area` decimal(8,2) NOT NULL,
  `commercial_user_photo` varchar(255) DEFAULT NULL,
  `affected_area` decimal(8,2) NOT NULL,
  `percentage_area` decimal(5,2) NOT NULL,
  `balanced_area` decimal(15,2) DEFAULT NULL,
  `shop_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `remark_id` bigint(20) UNSIGNED DEFAULT NULL,
  `remark_other` text DEFAULT NULL,
  `structure_holder_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_holder_other` varchar(255) DEFAULT NULL,
  `allotment_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = on hold, 0 = active',
  `allotment_comment` text DEFAULT NULL,
  `survey_completion_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = Submitted, 0 = Not Submitted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `survey_agencyuser_commercial`
--

INSERT INTO `survey_agencyuser_commercial` (`id`, `survey_id`, `project_id`, `agency_user_id`, `shop_types_id`, `shop_type_other`, `shop_area`, `updated_status`, `updated_status_comment`, `workers_type_id`, `daily_sales`, `ownership`, `nature_of_activity`, `monthly_turnover`, `year_of_establishment`, `no_of_employees`, `name_establishment_owner`, `end_product_sale_market`, `raw_material_place`, `total_area`, `commercial_user_photo`, `affected_area`, `percentage_area`, `balanced_area`, `shop_name`, `created_at`, `updated_at`, `deleted_at`, `remark_id`, `remark_other`, `structure_holder_id`, `structure_holder_other`, `allotment_status`, `allotment_comment`, `survey_completion_status`) VALUES
(5, 18, 9, 4, 1, NULL, 1000.00, 'Eligible', 'ok', 20, 500.00, 'Dnyaneshwar Sadashiv Gaikwad', 'Saloon', 20000.00, 1950, 2, 'Dnyaneshwar Sadashiv Gaikwad', '200', '100abc', 150.00, '1743498739_file1.jpg', 100.00, 65.00, 32.00, 'XYZ', '2025-03-12 06:12:54', '2025-04-08 06:41:29', NULL, 3, NULL, NULL, NULL, 0, NULL, 0),
(6, 20, 9, 20, 1, NULL, 1000.00, 'Eligible', 'ok', 2, 500.00, 'Dnyaneshwar Sadashiv Gaikwad', 'Saloon', 20000.00, 2001, 2, 'Dnyaneshwar Sadashiv Gaikwad', '200', '100', 150.00, '1742312364_file1.jpg', 100.00, 65.00, NULL, NULL, '2025-03-12 06:18:50', '2025-04-08 06:42:23', NULL, 3, NULL, 4, NULL, 0, NULL, 0);

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

--
-- Table structure for table `survey_agencyuser_others`
--

CREATE TABLE `survey_agencyuser_others` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `owner_name` varchar(255) NOT NULL,
  `ownership_proof` varchar(255) NOT NULL,
  `carpet_area_no` varchar(255) NOT NULL,
  `structure_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_type_other` varchar(255) DEFAULT NULL,
  `other` varchar(255) DEFAULT NULL,
  `updated_status` text DEFAULT NULL,
  `updated_status_comment` text DEFAULT NULL,
  `year_of_establishment` year(4) DEFAULT NULL,
  `total_area` decimal(10,2) NOT NULL,
  `affected_area` decimal(10,2) NOT NULL,
  `percentage_area` decimal(5,2) NOT NULL,
  `balanced_area` decimal(15,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `structure_holder_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_holder_other` varchar(255) DEFAULT NULL,
  `structure_roof_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_wall_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_floor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_photo` varchar(255) DEFAULT NULL,
  `name_of_occupant` varchar(255) DEFAULT NULL,
  `remark_id` bigint(20) UNSIGNED DEFAULT NULL,
  `remark_other` text DEFAULT NULL,
  `allotment_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = on hold, 0 = active',
  `allotment_comment` text DEFAULT NULL,
  `survey_completion_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = Submitted, 0 = Not Submitted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `survey_agencyuser_others`
--

INSERT INTO `survey_agencyuser_others` (`id`, `survey_id`, `project_id`, `agency_user_id`, `owner_name`, `ownership_proof`, `carpet_area_no`, `structure_type_id`, `structure_type_other`, `other`, `updated_status`, `updated_status_comment`, `year_of_establishment`, `total_area`, `affected_area`, `percentage_area`, `balanced_area`, `created_at`, `updated_at`, `deleted_at`, `structure_holder_id`, `structure_holder_other`, `structure_roof_id`, `structure_wall_id`, `structure_floor_id`, `structure_photo`, `name_of_occupant`, `remark_id`, `remark_other`, `allotment_status`, `allotment_comment`, `survey_completion_status`) VALUES
(4, 19, 9, 4, 'Gaurishankar Mandir', 'Document111', '131', 5, NULL, NULL, 'Non-Eligible', 'ok', '2001', 600.00, 150.00, 25.00, 11.00, '2025-03-12 06:14:44', '2025-04-08 06:46:17', NULL, 4, NULL, 1, 2, 1, '1743079833_samm.jpg', 'Gauri Babu', 3, NULL, 0, NULL, 0);

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

--
-- Table structure for table `survey_agencyuser_residen_vulner`
--

CREATE TABLE `survey_agencyuser_residen_vulner` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `senior_citizen_no` int(11) NOT NULL DEFAULT 0,
  `disabled` tinyint(1) NOT NULL DEFAULT 0,
  `children_0_6` int(11) NOT NULL DEFAULT 0,
  `whh` enum('Yes','No') NOT NULL DEFAULT 'No',
  `aged_household` enum('Yes','No') NOT NULL DEFAULT 'No',
  `bpl_household` enum('Yes','No') NOT NULL DEFAULT 'No',
  `sc_st_household` enum('Yes','No') NOT NULL DEFAULT 'No',
  `other` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `survey_agencyuser_residen_vulner`
--

INSERT INTO `survey_agencyuser_residen_vulner` (`id`, `survey_id`, `project_id`, `agency_user_id`, `senior_citizen_no`, `disabled`, `children_0_6`, `whh`, `aged_household`, `bpl_household`, `sc_st_household`, `other`, `created_at`, `updated_at`, `deleted_at`) VALUES
(3, 17, 9, 4, 2, 1, 2, 'No', 'No', 'Yes', 'No', NULL, '2025-03-12 06:10:28', '2025-03-22 18:50:16', NULL),
(4, 20, 9, 4, 2, 1, 2, 'No', 'No', 'Yes', 'No', 'Additional comments', '2025-03-12 06:19:15', '2025-03-12 06:19:15', NULL),
(5, 22, 9, 17, 0, 0, 0, 'No', 'No', 'No', 'No', NULL, '2025-04-08 05:02:26', '2025-04-08 05:02:26', NULL),
(6, 23, 9, 17, 0, 0, 0, 'No', 'No', 'No', 'No', NULL, '2025-04-08 05:29:08', '2025-04-09 04:47:59', NULL);

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

--
-- Table structure for table `survey_documents`
--

CREATE TABLE `survey_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `survey_structure_type` tinyint(4) NOT NULL COMMENT '1: Residential, 2: Commercial, 3: Residential+Commercial, 4: Other',
  `document_types_id` bigint(20) UNSIGNED NOT NULL,
  `document_type_other` varchar(255) DEFAULT NULL,
  `document_file_name` varchar(255) NOT NULL,
  `api_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `consumer_no` varchar(255) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `verification_status` enum('accepted','rejected','pending') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_document_processed` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `survey_documents`
--

INSERT INTO `survey_documents` (`id`, `survey_id`, `project_id`, `agency_user_id`, `survey_structure_type`, `document_types_id`, `document_type_other`, `document_file_name`, `api_response`, `provider`, `consumer_no`, `remarks`, `verification_status`, `created_at`, `updated_at`, `deleted_at`, `is_document_processed`) VALUES
(13, 17, 9, 4, 4, 1, NULL, '1742672739_test.png', NULL, NULL, NULL, 'Zopdi Tests', 'accepted', '2025-03-12 06:09:39', '2025-05-12 10:46:24', NULL, 0),
(14, 17, 9, 4, 4, 10, 'Other Doc', '1742672739_Screenshot__1_.png', NULL, NULL, NULL, 'Other notified tests', 'rejected', '2025-03-12 06:09:39', '2025-05-12 10:46:43', NULL, 0),
(15, 18, 9, 4, 4, 1, NULL, '1742496762_file1.jpg', NULL, NULL, NULL, NULL, 'pending', '2025-03-12 06:13:10', '2025-03-20 18:52:42', NULL, 0),
(16, 18, 9, 4, 4, 9, 'Other Doc', '1742496762_test.png', NULL, NULL, NULL, NULL, 'pending', '2025-03-12 06:13:10', '2025-03-20 18:52:42', NULL, 0),
(17, 19, 9, 4, 4, 1, NULL, '1741760095_SamplePNGImage_200kbmb.png', NULL, NULL, NULL, NULL, 'pending', '2025-03-12 06:14:55', '2025-03-12 06:14:55', NULL, 0),
(18, 19, 9, 4, 4, 9, 'Other Doc', '1741760095_test.png', NULL, NULL, NULL, NULL, 'pending', '2025-03-12 06:14:55', '2025-03-12 06:14:55', NULL, 0),
(19, 20, 9, 4, 4, 1, NULL, '1742312343_file1.jpg', NULL, NULL, NULL, NULL, 'pending', '2025-03-12 06:19:54', '2025-03-18 15:39:03', NULL, 0),
(20, 20, 9, 4, 4, 9, 'Other Doc', '1742312343_samm.jpg', NULL, NULL, NULL, NULL, 'pending', '2025-03-12 06:19:54', '2025-03-18 15:39:03', NULL, 0),
(23, 17, 9, 4, 4, 2, NULL, '1742672887_test.png', NULL, NULL, NULL, 'Electric Test', 'accepted', '2025-03-22 19:48:07', '2025-05-22 10:59:07', NULL, 0),
(24, 17, 9, 4, 4, 9, NULL, '1742672887_Screenshot__1_.png', '[{\"PropertyNo\":\"A010001943028\",\"Flat_No\":308,\"Receipt_No\":\"MBMC2324O4000010\",\"Receipt_Date\":\"20\\/JUN\\/2023\",\"Received_From\":\"Sachin Gosavi\",\"Narration\":null,\"Receipt_Mode\":\"Cash\",\"Receipt_Amount\":1700,\"Receipt_From\":\"SUBODH H. SHAH \\/ANUPAMA S. SHAH\",\"Collectioncenter\":\"HQ\",\"Owner_Name\":\"SUBODH H. SHAH \\/ANUPAMA S. SHAH\",\"Usage_Type\":\"\\u0928\\u093f\\u0935\\u093e\\u0938\\u0940\",\"Construction_Type\":\"\\u0905 - \\u0906\\u0930.\\u0938\\u0940.\\u0938\\u0940\",\"Status\":\"Legal\",\"Address\":\"TIRUPATI  DARSHAN  NO.2 STATION ROAD , BHAYNDAR (W) DIST THANE (OLD SR. NO. A6829)\",\"Property_Type\":\"Active\",\"Ward\":\"1\",\"Zone\":\"A2\",\"Assessment_Date\":\"04\\/JAN\\/2004\",\"Area\":302},{\"PropertyNo\":\"A010001943028\",\"Flat_No\":308,\"Receipt_No\":\"MBMC2324O4000011\",\"Receipt_Date\":\"20\\/JUN\\/2023\",\"Received_From\":\"Sachin Gosavi\",\"Narration\":null,\"Receipt_Mode\":\"Cash\",\"Receipt_Amount\":2004,\"Receipt_From\":\"SUBODH H. SHAH \\/ANUPAMA S. SHAH\",\"Collectioncenter\":\"HQ\",\"Owner_Name\":\"SUBODH H. SHAH \\/ANUPAMA S. SHAH\",\"Usage_Type\":\"\\u0928\\u093f\\u0935\\u093e\\u0938\\u0940\",\"Construction_Type\":\"\\u0905 - \\u0906\\u0930.\\u0938\\u0940.\\u0938\\u0940\",\"Status\":\"Legal\",\"Address\":\"TIRUPATI  DARSHAN  NO.2 STATION ROAD , BHAYNDAR (W) DIST THANE (OLD SR. NO. A6829)\",\"Property_Type\":\"Active\",\"Ward\":\"1\",\"Zone\":\"A2\",\"Assessment_Date\":\"04\\/JAN\\/2004\",\"Area\":302}]', 'Property', 'A010001943028', 'test', 'accepted', '2025-03-22 19:48:07', '2025-05-22 11:00:45', NULL, 0),
(25, 22, 9, 17, 1, 1, NULL, '1744088417_ganana-pavti.jpeg', NULL, NULL, NULL, NULL, 'pending', '2025-04-08 05:00:17', '2025-04-08 05:00:17', NULL, 0),
(26, 22, 9, 17, 1, 6, NULL, '1744088417_aadhar.jpeg', NULL, NULL, NULL, NULL, 'pending', '2025-04-08 05:00:17', '2025-04-08 05:00:17', NULL, 0),
(27, 23, 9, 17, 1, 6, NULL, '1744174072_1744090058_aadhar.jpeg', NULL, NULL, NULL, NULL, 'pending', '2025-04-08 05:27:38', '2025-04-09 04:47:52', NULL, 0),
(28, 23, 9, 17, 1, 1, NULL, '1744174072_1744090058_ganana-pavti.jpeg', NULL, NULL, NULL, NULL, 'pending', '2025-04-08 05:27:38', '2025-04-09 04:47:52', NULL, 0);

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

--
-- Table structure for table `survey_residential_household`
--

CREATE TABLE `survey_residential_household` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `relation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `gender_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gender_other` varchar(255) DEFAULT NULL,
  `marital_status_id` bigint(20) UNSIGNED DEFAULT NULL,
  `education_id` bigint(20) UNSIGNED DEFAULT NULL,
  `education_other` varchar(255) DEFAULT NULL,
  `occupation_id` bigint(20) UNSIGNED DEFAULT NULL,
  `occupation_other` varchar(255) DEFAULT NULL,
  `monthly_income_range` varchar(255) DEFAULT NULL,
  `monthly_range_id` bigint(20) UNSIGNED DEFAULT NULL,
  `secondary_part_time_income` varchar(255) DEFAULT NULL,
  `Hand_llln` varchar(255) DEFAULT NULL,
  `training_id` bigint(20) UNSIGNED DEFAULT NULL,
  `training_other` varchar(255) DEFAULT NULL,
  `distance_place_employment` varchar(255) DEFAULT NULL,
  `work_location` varchar(255) DEFAULT NULL,
  `aadhaar_number` varchar(12) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `survey_residential_household`
--

INSERT INTO `survey_residential_household` (`id`, `survey_id`, `project_id`, `agency_user_id`, `name`, `relation_id`, `age`, `gender_id`, `gender_other`, `marital_status_id`, `education_id`, `education_other`, `occupation_id`, `occupation_other`, `monthly_income_range`, `monthly_range_id`, `secondary_part_time_income`, `Hand_llln`, `training_id`, `training_other`, `distance_place_employment`, `work_location`, `aadhaar_number`, `created_at`, `updated_at`, `deleted_at`) VALUES
(11, 20, 9, 4, 'Animesh', 1, 25, 1, NULL, 2, 3, NULL, 7, NULL, NULL, 1, '10000', 'LLL', 5, NULL, '10 km', 'NY', '252514143636', '2025-03-12 06:18:32', '2025-03-19 19:34:11', NULL),
(12, 20, 9, 4, 'Sagar', 2, 28, 3, 'Trans', 1, 9, 'BHU', 3, NULL, NULL, 2, '5000', 'LLN', 11, 'BHUTRAINS', '5 km', 'LA', NULL, '2025-03-12 06:18:32', '2025-03-19 19:34:11', NULL),
(16, 17, 9, 4, 'SagarBA', 1, 255, 1, NULL, 2, 3, NULL, NULL, NULL, NULL, 1, '00000', 'LLL', 1, NULL, '10 km', 'NAYA', '111111111111', '2025-03-20 14:06:53', '2025-05-09 06:02:11', NULL),
(17, 17, 9, 4, 'Animesh', 2, 281, 3, 'Trans', 1, 9, 'BHU', 3, NULL, NULL, 2, '5000', 'LLN', 11, 'BHUTRAINS', '5 km', 'LA', NULL, '2025-03-20 14:06:53', '2025-03-22 19:50:50', NULL),
(19, 17, 9, 4, 'Sagars', 1, 251, 1, NULL, 2, 3, NULL, NULL, NULL, NULL, 1, NULL, 'LLL', 5, NULL, '10 km', 'NY', '252514143636', '2025-03-22 19:51:24', '2025-05-06 05:38:00', NULL),
(20, 17, 9, 4, 'Animeshs', 2, 281, 3, 'Trans', 1, 9, 'BHU', NULL, NULL, NULL, 2, NULL, 'LLN', 11, 'BHUTRAINS', '5 km', 'LA', NULL, '2025-03-22 19:51:24', '2025-05-06 05:38:00', NULL),
(21, 22, 9, 17, 'Reena Ramesh Patil', 2, 32, 2, NULL, 1, 1, NULL, 9, NULL, NULL, 1, 'NA', '5000', 11, 'na', '5', 'na', '333344445555', '2025-04-08 05:02:07', '2025-04-08 05:02:07', NULL),
(22, 23, 9, 17, 'SEEMA RAMESH KADAM', 2, 43, 1, NULL, 1, 1, NULL, 9, NULL, NULL, 1, 'NA', '5000', 11, 'NA', '6', 'NA', '333344445555', '2025-04-08 05:28:48', '2025-04-08 05:28:48', NULL);

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

--
-- Table structure for table `survey_user_residentials`
--

CREATE TABLE `survey_user_residentials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `name_occupant_structure` varchar(255) NOT NULL,
  `structure_holder_id` bigint(20) UNSIGNED NOT NULL,
  `structure_holder_other` varchar(255) DEFAULT NULL,
  `structure_owner_name` varchar(255) DEFAULT NULL,
  `place_of_residence` varchar(255) DEFAULT NULL,
  `mother_tongue_id` bigint(20) UNSIGNED NOT NULL,
  `mother_tongue_other` varchar(255) DEFAULT NULL,
  `place_of_origin` varchar(255) DEFAULT NULL,
  `caste_group_id` bigint(20) UNSIGNED NOT NULL,
  `religion_id` bigint(20) UNSIGNED NOT NULL,
  `religion_other` varchar(255) DEFAULT NULL,
  `bpl_card` enum('Yes','No') NOT NULL,
  `no_of_household_members` int(11) NOT NULL,
  `total_area` decimal(10,2) NOT NULL,
  `affected_area` decimal(10,2) NOT NULL,
  `percentage_area` decimal(5,2) NOT NULL,
  `balanced_area` decimal(15,2) DEFAULT NULL,
  `residential_user_photo_file_name` varchar(255) DEFAULT NULL,
  `family_photo` varchar(255) DEFAULT NULL,
  `updated_status` text DEFAULT NULL,
  `updated_status_comment` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `gender_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gender_other` varchar(255) DEFAULT NULL,
  `year_of_establishment` year(4) DEFAULT NULL,
  `remark_id` bigint(20) UNSIGNED DEFAULT NULL,
  `remark_other` text DEFAULT NULL,
  `allotment_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = on hold, 0 = active',
  `allotment_comment` text DEFAULT NULL,
  `allotment_random_no` varchar(255) DEFAULT NULL,
  `allotment_no` varchar(255) DEFAULT NULL,
  `temp_assign_status` tinyint(1) NOT NULL DEFAULT 0,
  `indemnity_bond` varchar(255) DEFAULT NULL,
  `signed_taba` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `survey_user_residentials`
--

INSERT INTO `survey_user_residentials` (`id`, `survey_id`, `project_id`, `agency_user_id`, `name_occupant_structure`, `structure_holder_id`, `structure_holder_other`, `structure_owner_name`, `place_of_residence`, `mother_tongue_id`, `mother_tongue_other`, `place_of_origin`, `caste_group_id`, `religion_id`, `religion_other`, `bpl_card`, `no_of_household_members`, `total_area`, `affected_area`, `percentage_area`, `balanced_area`, `residential_user_photo_file_name`, `family_photo`, `updated_status`, `updated_status_comment`, `created_at`, `updated_at`, `deleted_at`, `gender_id`, `gender_other`, `year_of_establishment`, `remark_id`, `remark_other`, `allotment_status`, `allotment_comment`, `allotment_random_no`, `allotment_no`, `temp_assign_status`, `indemnity_bond`, `signed_taba`) VALUES
(7, 17, 9, 4, 'Shoba Ashok Bharade', 1, NULL, 'Shoba Ashok Bharade', 'Gaya', 1, NULL, 'Bihar', 1, 7, 'Atheist', 'Yes', 4, 150.00, 100.00, 65.00, 45.00, '1746708614_file1.jpg', '1746708879_SamplePNGImage_1mbmb.png', NULL, NULL, '2025-03-11 10:15:48', '2025-05-24 05:39:10', NULL, 2, NULL, '2002', 1, NULL, 2, 'him', '8650', 'MMRDA/MUIP/SDC/8650/2025', 1, '68315b7df1a639.97904144.png', NULL),
(8, 20, 9, 4, 'Shoba Ashok Bharade', 1, NULL, 'Shoba Ashok Bharade', 'Gaya', 1, NULL, 'Bihar', 1, 7, 'Atheist', 'Yes', 4, 150.00, 100.00, 65.00, NULL, '1742312293_file1.jpg', '1742359517_file1.jpg', 'Eligible', 'ok', '2025-03-12 06:18:09', '2025-05-24 06:24:07', NULL, 2, NULL, '2011', 3, NULL, 0, NULL, '3653', 'MMRDA/MUIP/SDC/3653/2025', 0, '683165fc0ea185.96630250.png', '6831660714a442.70566581.jpg'),
(9, 22, 9, 17, 'Vinay Bhaskar Patil', 1, NULL, 'Vinay Bhaskar Patil', 'NA', 1, NULL, 'Kurla', 1, 1, NULL, 'No', 2, 1000.00, 750.00, 75.00, NULL, '1744088382_1000036009.png', '1744088527_1000036009.png', 'Eligible', 'ok', '2025-04-08 04:59:42', '2025-05-24 05:31:47', NULL, 1, NULL, '2001', 3, NULL, 0, NULL, '8087', 'MMRDA/MUIP/SDC/8087/2025', 0, NULL, NULL),
(10, 23, 9, 17, 'RAMESH BHASKAR KADAM', 1, NULL, 'RAMESH BHASKAR KADAM', 'Kurla', 1, NULL, 'Kurla', 1, 1, NULL, 'No', 2, 1000.00, 750.00, 75.00, 250.00, '1744090029_1000036009.png', '1744090128_1000036009.png', 'Eligible', 'ok', '2025-04-08 05:27:09', '2025-05-24 05:31:47', NULL, 1, NULL, '2001', 2, NULL, 0, NULL, '5384', 'MMRDA/MUIP/SDC/5384/2025', 0, NULL, NULL);

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

--
-- Table structure for table `sur_residen_socio_economic`
--

CREATE TABLE `sur_residen_socio_economic` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `agency_user_id` bigint(20) UNSIGNED NOT NULL,
  `types_of_structure_id` bigint(20) UNSIGNED DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `floors_id` bigint(20) UNSIGNED DEFAULT NULL,
  `rooms_id` bigint(20) UNSIGNED DEFAULT NULL,
  `kitchen` enum('Yes','No') DEFAULT NULL,
  `structure_roof_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_wall_id` bigint(20) UNSIGNED DEFAULT NULL,
  `structure_floor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `construction_year` year(4) DEFAULT NULL,
  `production_establishment_year` year(4) DEFAULT NULL,
  `yearly_turnover` decimal(15,2) DEFAULT NULL,
  `toilet_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `nearest_hospital` varchar(255) DEFAULT NULL,
  `electricity` enum('Yes','No') DEFAULT NULL,
  `water_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `distance_local_train` decimal(8,2) DEFAULT NULL,
  `distance_school` decimal(8,2) DEFAULT NULL,
  `total_monthly_income` decimal(15,2) DEFAULT NULL,
  `secondary_income_source` varchar(255) DEFAULT NULL,
  `annual_expenditure_id` bigint(20) UNSIGNED DEFAULT NULL,
  `bank_account_number` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_ifsc` varchar(255) DEFAULT NULL,
  `pan_card` enum('Yes','No') DEFAULT NULL,
  `aadhaar_status` enum('Yes','No') DEFAULT NULL,
  `loan_status` enum('Yes','No') DEFAULT NULL,
  `loan_source` varchar(255) DEFAULT NULL,
  `loan_prupose` varchar(255) DEFAULT NULL,
  `loan_amount` decimal(15,2) DEFAULT NULL,
  `loan_repayment` varchar(255) DEFAULT NULL,
  `tv` enum('Yes','No') DEFAULT NULL,
  `fridge` enum('Yes','No') DEFAULT NULL,
  `vehicle` enum('Yes','No') DEFAULT NULL,
  `land_city_village` enum('Yes','No') DEFAULT NULL,
  `computer_laptop` enum('Yes','No') DEFAULT NULL,
  `cooking_fuel_id` bigint(20) UNSIGNED DEFAULT NULL,
  `cooking_fuel_other` varchar(255) DEFAULT NULL,
  `mobile_phone` enum('Yes','No') DEFAULT NULL,
  `ac` enum('Yes','No') DEFAULT NULL,
  `fan` enum('Yes','No') DEFAULT NULL,
  `digital_payment` enum('Yes','No') DEFAULT NULL,
  `washing_machine` enum('Yes','No') DEFAULT NULL,
  `consumer_no` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `survey_completion_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 = Submitted, 0 = Not Submitted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sur_residen_socio_economic`
--

INSERT INTO `sur_residen_socio_economic` (`id`, `survey_id`, `project_id`, `agency_user_id`, `types_of_structure_id`, `area`, `floors_id`, `rooms_id`, `kitchen`, `structure_roof_id`, `structure_wall_id`, `structure_floor_id`, `construction_year`, `production_establishment_year`, `yearly_turnover`, `toilet_type_id`, `nearest_hospital`, `electricity`, `water_type_id`, `distance_local_train`, `distance_school`, `total_monthly_income`, `secondary_income_source`, `annual_expenditure_id`, `bank_account_number`, `bank_name`, `bank_ifsc`, `pan_card`, `aadhaar_status`, `loan_status`, `loan_source`, `loan_prupose`, `loan_amount`, `loan_repayment`, `tv`, `fridge`, `vehicle`, `land_city_village`, `computer_laptop`, `cooking_fuel_id`, `cooking_fuel_other`, `mobile_phone`, `ac`, `fan`, `digital_payment`, `washing_machine`, `consumer_no`, `created_at`, `updated_at`, `deleted_at`, `survey_completion_status`) VALUES
(5, 17, 9, 4, 2, '1100', 3, 2, 'Yes', 1, 2, 1, '2005', NULL, 500000.00, 1, 'Apollo Hospital', 'Yes', 2, 2.50, 1.20, NULL, 'Freelancing', 3, NULL, NULL, NULL, 'Yes', 'Yes', NULL, NULL, NULL, NULL, NULL, 'Yes', 'Yes', 'No', 'Yes', 'No', 3, 'Diesel', 'Yes', 'No', 'Yes', 'Yes', 'No', '3', '2025-03-12 06:10:02', '2025-04-03 09:08:09', NULL, 0),
(6, 20, 9, 4, 2, '1100', 3, 2, 'Yes', 1, 2, 1, '2005', '2010', 500000.00, 1, 'Apollo Hospital', 'Yes', 2, 2.50, 1.20, 45000.00, 'Freelancing', 3, '1234567890', NULL, NULL, 'Yes', 'Yes', 'No', 'bb', 'xyz', 10.00, 'yes', 'Yes', 'Yes', 'No', 'Yes', 'No', 3, 'Diesel', 'Yes', 'No', 'Yes', 'Yes', 'No', NULL, '2025-03-12 06:19:37', '2025-03-19 04:36:50', NULL, 0),
(7, 22, 9, 17, 1, '1000', 1, 1, 'Yes', 4, 2, 1, '2001', '2001', 5000.00, 1, '2', 'Yes', 1, 2.00, 3.00, 20000.00, '0', 3, 'na', NULL, NULL, 'No', 'Yes', 'No', 'na', 'na', 0.00, 'na', 'Yes', 'No', 'Yes', 'No', 'No', 2, NULL, 'Yes', 'No', 'Yes', 'No', 'No', NULL, '2025-04-08 05:04:18', '2025-04-08 05:04:18', NULL, 0),
(8, 23, 9, 17, 1, '1000', 1, 1, 'Yes', 4, 2, 1, '2001', NULL, NULL, 1, '5', 'Yes', 1, 5.00, 3.00, 5000.00, '0', 3, NULL, NULL, NULL, 'No', 'Yes', 'No', NULL, NULL, 0.00, 'No', 'Yes', 'No', 'Yes', 'No', 'No', 2, NULL, 'Yes', 'No', 'Yes', 'No', 'No', '233586688', '2025-04-08 05:31:17', '2025-04-08 05:31:17', NULL, 0);

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

--
-- Table structure for table `temporary_allotments`
--

CREATE TABLE `temporary_allotments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `survey_id` bigint(20) UNSIGNED NOT NULL,
  `inventory_building_rooms_id` bigint(20) UNSIGNED NOT NULL,
  `alloted_from_date` date NOT NULL,
  `alloted_to_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `temporary_allotments`
--

INSERT INTO `temporary_allotments` (`id`, `project_id`, `survey_id`, `inventory_building_rooms_id`, `alloted_from_date`, `alloted_to_date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(3, 9, 17, 166, '2025-04-30', '2025-05-30', '2025-04-30 10:08:01', '2025-04-30 10:08:01', NULL);

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

--
-- Table structure for table `toilet_types`
--

CREATE TABLE `toilet_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values: Public, Private',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toilet_types`
--

INSERT INTO `toilet_types` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Public', NULL, NULL, NULL),
(2, 'Private', NULL, NULL, NULL);

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

--
-- Table structure for table `trainings`
--

CREATE TABLE `trainings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n            1. Electrician,\n            2. Mechanic,\n            3. Beautician,\n            4. Driving,\n            5. Mobile Repair,\n            6. Carpenter,\n            7. Masonry,\n            8. Pottery,\n            9. Tannery/Leather,\n            10. Tailoring,\n            11. Other',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trainings`
--

INSERT INTO `trainings` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Electrician', NULL, NULL, NULL),
(2, 'Mechanic', NULL, NULL, NULL),
(3, 'Beautician', NULL, NULL, NULL),
(4, 'Driving', NULL, NULL, NULL),
(5, 'Mobile Repair', NULL, NULL, NULL),
(6, 'Carpenter', NULL, NULL, NULL),
(7, 'Masonry', NULL, NULL, NULL),
(8, 'Pottery', NULL, NULL, NULL),
(9, 'Tannery/Leather', NULL, NULL, NULL),
(10, 'Tailoring', NULL, NULL, NULL),
(11, 'Other', NULL, NULL, NULL);

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

--
-- Table structure for table `types_of_structures`
--

CREATE TABLE `types_of_structures` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values:\n            1. Permanent,\n            2. Semi-Permanent,\n            3. Kutcha',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `types_of_structures`
--

INSERT INTO `types_of_structures` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Permanent', NULL, NULL, NULL),
(2, 'Semi-Permanent', NULL, NULL, NULL),
(3, 'Kutcha', NULL, NULL, NULL);

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
(1, 'System Admin', '2025-01-14 18:30:00', '2025-01-14 18:30:00'),
(2, 'Agency User', '2025-01-14 18:30:00', '2025-01-14 18:30:00'),
(3, 'Engineer', '2025-01-14 18:30:00', '2025-01-14 18:30:00');

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

--
-- Table structure for table `use_of_structures`
--

CREATE TABLE `use_of_structures` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values: Residential, Commercial, R+C, Non Residential- Non Commercial (Production Unit), Religious Structure(specify-1. Temple 2,Buddhvihar 3.Masjid/Madarsa 4- Church), Public Toilet, Samaj Mandir, Balwadi/Anganwadi, CBO’s Office, Political Party Office, Any other(Specify)',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `use_of_structures`
--

INSERT INTO `use_of_structures` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Residential', NULL, NULL, NULL),
(2, 'Commercial', NULL, NULL, NULL),
(3, 'R+C', NULL, NULL, NULL),
(4, 'Non Residential- Non Commercial (Production Unit)', NULL, NULL, NULL),
(5, 'Religious Structure (Temple)', NULL, NULL, NULL),
(6, 'Religious Structure (Buddhvihar)', NULL, NULL, NULL),
(7, 'Religious Structure (Masjid/Madarsa)', NULL, NULL, NULL),
(8, 'Religious Structure (Church)', NULL, NULL, NULL),
(9, 'Public Toilet', NULL, NULL, NULL),
(10, 'Samaj Mandir', NULL, NULL, NULL),
(11, 'Balwadi/Anganwadi', NULL, NULL, NULL),
(12, 'CBO’s Office', NULL, NULL, NULL),
(13, 'Political Party Office', NULL, NULL, NULL),
(14, 'Any other (Specify)', NULL, NULL, NULL);

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

--
-- Table structure for table `water_types`
--

CREATE TABLE `water_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values: Municipal, Pvt, Nil',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `water_types`
--

INSERT INTO `water_types` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Municipal', NULL, NULL, NULL),
(2, 'Private', NULL, NULL, NULL),
(3, 'Nil', NULL, NULL, NULL);

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

--
-- Table structure for table `workers_types`
--

CREATE TABLE `workers_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Possible values: Temporary, Permanent',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `workers_types`
--

INSERT INTO `workers_types` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Temporary', NULL, NULL, NULL),
(2, 'Permanent', NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `agencies`
--
ALTER TABLE `agencies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `agencies_slug_unique` (`slug`),
  ADD KEY `agencies_created_by_foreign` (`created_by`),
  ADD KEY `agencies_name_index` (`name`),
  ADD KEY `agencies_status_index` (`status`);

--
-- Indexes for table `allotments`
--
ALTER TABLE `allotments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `allotments_lottery_id_foreign` (`lottery_id`),
  ADD KEY `allotments_survey_id_foreign` (`survey_id`),
  ADD KEY `allotments_project_id_foreign` (`project_id`),
  ADD KEY `allotments_inventory_building_rooms_id_foreign` (`inventory_building_rooms_id`);

--
-- Indexes for table `allotment_letters`
--
ALTER TABLE `allotment_letters`
  ADD PRIMARY KEY (`id`),
  ADD KEY `allotment_letters_survey_id_foreign` (`survey_id`),
  ADD KEY `allotment_letters_project_id_foreign` (`project_id`);

--
-- Indexes for table `amenity_assignments`
--
ALTER TABLE `amenity_assignments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `amenity_assignments_society_id_foreign` (`society_id`),
  ADD KEY `amenity_assignments_inventory_building_room_id_foreign` (`inventory_building_room_id`);

--
-- Indexes for table `amenity_assignment_rooms`
--
ALTER TABLE `amenity_assignment_rooms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `amenity_assignment_rooms_amenity_assignment_id_foreign` (`amenity_assignment_id`);

--
-- Indexes for table `association_registrations`
--
ALTER TABLE `association_registrations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `association_registrations_registration_number_unique` (`registration_number`);

--
-- Indexes for table `blocked_lottery_inventories`
--
ALTER TABLE `blocked_lottery_inventories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blocked_lottery_inventories_project_id_foreign` (`project_id`),
  ADD KEY `blocked_lottery_inventories_inventory_id_foreign` (`inventory_id`),
  ADD KEY `blocked_lottery_inventories_lottery_id_foreign` (`lottery_id`);

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

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

--
-- Indexes for table `demolitions`
--
ALTER TABLE `demolitions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `demolitions_survey_id_foreign` (`survey_id`);

--
-- Indexes for table `designations`
--
ALTER TABLE `designations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `designations_designation_index` (`designation`);

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `flgrcs`
--
ALTER TABLE `flgrcs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `flgrcs_project_id_foreign` (`project_id`),
  ADD KEY `flgrcs_survey_id_foreign` (`survey_id`),
  ADD KEY `flgrcs_reason_id_foreign` (`reason_id`);

--
-- Indexes for table `flgrc_chief_user`
--
ALTER TABLE `flgrc_chief_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `flgrc_chief_user_flgrc_id_foreign` (`flgrc_id`),
  ADD KEY `flgrc_chief_user_user_id_foreign` (`user_id`);

--
-- Indexes for table `flgrc_mmrc_user`
--
ALTER TABLE `flgrc_mmrc_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `flgrc_mmrc_user_flgrc_id_foreign` (`flgrc_id`),
  ADD KEY `flgrc_mmrc_user_user_id_foreign` (`user_id`);

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

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

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

--
-- Indexes for table `inventory_building_floors`
--
ALTER TABLE `inventory_building_floors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_building_floors_inventory_location_id_foreign` (`inventory_location_id`),
  ADD KEY `inventory_building_floors_inventory_location_building_id_foreign` (`inventory_location_building_id`),
  ADD KEY `inventory_building_floors_inventory_building_wing_id_foreign` (`inventory_building_wing_id`);

--
-- Indexes for table `inventory_building_rooms`
--
ALTER TABLE `inventory_building_rooms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_building_rooms_inventory_location_id_foreign` (`inventory_location_id`),
  ADD KEY `inventory_building_rooms_inventory_location_building_id_foreign` (`inventory_location_building_id`),
  ADD KEY `inventory_building_rooms_room_types_index` (`room_types`);

--
-- Indexes for table `inventory_building_wings`
--
ALTER TABLE `inventory_building_wings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_building_wings_inventory_location_id_foreign` (`inventory_location_id`),
  ADD KEY `inventory_building_wings_inventory_location_building_id_foreign` (`inventory_location_building_id`);

--
-- Indexes for table `inventory_locations`
--
ALTER TABLE `inventory_locations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_locations_location_index` (`location`);

--
-- Indexes for table `inventory_location_buildings`
--
ALTER TABLE `inventory_location_buildings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_location_buildings_inventory_location_id_foreign` (`inventory_location_id`),
  ADD KEY `inventory_location_buildings_building_name_index` (`building_name`),
  ADD KEY `inventory_location_buildings_building_no_index` (`building_no`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `joint_verification_docs`
--
ALTER TABLE `joint_verification_docs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `joint_verification_docs_project_id_foreign` (`project_id`);

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

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `monthly_income_ranges`
--
ALTER TABLE `monthly_income_ranges`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `monthly_income_ranges_range_unique` (`range`);

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

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

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

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`),
  ADD KEY `permissions_name_index` (`name`);

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

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `projects_sdc_officer_user_id_foreign` (`sdc_officer_user_id`),
  ADD KEY `projects_agency_id_foreign` (`agency_id`),
  ADD KEY `projects_name_index` (`name`),
  ADD KEY `projects_type_1_index` (`type_1`),
  ADD KEY `projects_type_2_index` (`type_2`),
  ADD KEY `projects_status_id_foreign` (`status_id`),
  ADD KEY `projects_junior_project_officer_id_foreign` (`junior_project_officer_id`);

--
-- Indexes for table `project_related_documents`
--
ALTER TABLE `project_related_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_related_documents_project_id_foreign` (`project_id`);

--
-- Indexes for table `project_statuses`
--
ALTER TABLE `project_statuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_statuses_project_id_foreign` (`project_id`);

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

--
-- Indexes for table `receiveds`
--
ALTER TABLE `receiveds`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `receiveds_receipt_no_unique` (`receipt_no`),
  ADD KEY `receiveds_receipt_no_index` (`receipt_no`),
  ADD KEY `receiveds_received_from_index` (`received_from`),
  ADD KEY `receiveds_receipt_date_index` (`receipt_date`),
  ADD KEY `receiveds_fund_category_id_foreign` (`fund_category_id`);

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

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

--
-- Indexes for table `remarks`
--
ALTER TABLE `remarks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `remarks_name_unique` (`name`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`),
  ADD KEY `roles_name_index` (`name`);

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

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `role_permission_old`
--
ALTER TABLE `role_permission_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_permission_old_role_id_foreign` (`role_id`),
  ADD KEY `role_permission_old_permission_id_foreign` (`permission_id`);

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

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

--
-- Indexes for table `societies`
--
ALTER TABLE `societies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `societies_registration_number_unique` (`registration_number`),
  ADD KEY `societies_registration_number_index` (`registration_number`),
  ADD KEY `societies_society_name_index` (`society_name`);

--
-- Indexes for table `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `statuses_name_unique` (`name`);

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

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

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

--
-- Indexes for table `surveys`
--
ALTER TABLE `surveys`
  ADD PRIMARY KEY (`id`),
  ADD KEY `surveys_project_id_foreign` (`project_id`),
  ADD KEY `surveys_agency_user_id_foreign` (`agency_user_id`);

--
-- Indexes for table `survey_agencyuser_commercial`
--
ALTER TABLE `survey_agencyuser_commercial`
  ADD PRIMARY KEY (`id`),
  ADD KEY `survey_agencyuser_commercial_survey_id_foreign` (`survey_id`),
  ADD KEY `survey_agencyuser_commercial_project_id_foreign` (`project_id`),
  ADD KEY `survey_agencyuser_commercial_agency_user_id_foreign` (`agency_user_id`),
  ADD KEY `survey_agencyuser_commercial_remark_id_foreign` (`remark_id`),
  ADD KEY `survey_agencyuser_commercial_structure_holder_id_foreign` (`structure_holder_id`);

--
-- Indexes for table `survey_agencyuser_others`
--
ALTER TABLE `survey_agencyuser_others`
  ADD PRIMARY KEY (`id`),
  ADD KEY `survey_agencyuser_others_survey_id_foreign` (`survey_id`),
  ADD KEY `survey_agencyuser_others_project_id_foreign` (`project_id`),
  ADD KEY `survey_agencyuser_others_agency_user_id_foreign` (`agency_user_id`),
  ADD KEY `survey_agencyuser_others_structure_type_id_foreign` (`structure_type_id`),
  ADD KEY `survey_agencyuser_others_structure_holder_id_foreign` (`structure_holder_id`),
  ADD KEY `survey_agencyuser_others_structure_roof_id_foreign` (`structure_roof_id`),
  ADD KEY `survey_agencyuser_others_structure_wall_id_foreign` (`structure_wall_id`),
  ADD KEY `survey_agencyuser_others_structure_floor_id_foreign` (`structure_floor_id`),
  ADD KEY `survey_agencyuser_others_remark_id_foreign` (`remark_id`);

--
-- Indexes for table `survey_agencyuser_residen_vulner`
--
ALTER TABLE `survey_agencyuser_residen_vulner`
  ADD PRIMARY KEY (`id`),
  ADD KEY `survey_agencyuser_residen_vulner_survey_id_foreign` (`survey_id`),
  ADD KEY `survey_agencyuser_residen_vulner_project_id_foreign` (`project_id`),
  ADD KEY `survey_agencyuser_residen_vulner_agency_user_id_foreign` (`agency_user_id`);

--
-- Indexes for table `survey_documents`
--
ALTER TABLE `survey_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `survey_documents_survey_id_foreign` (`survey_id`),
  ADD KEY `survey_documents_project_id_foreign` (`project_id`),
  ADD KEY `survey_documents_agency_user_id_foreign` (`agency_user_id`),
  ADD KEY `survey_documents_document_types_id_foreign` (`document_types_id`);

--
-- Indexes for table `survey_residential_household`
--
ALTER TABLE `survey_residential_household`
  ADD PRIMARY KEY (`id`),
  ADD KEY `survey_residential_household_survey_id_foreign` (`survey_id`),
  ADD KEY `survey_residential_household_project_id_foreign` (`project_id`),
  ADD KEY `survey_residential_household_agency_user_id_foreign` (`agency_user_id`),
  ADD KEY `survey_residential_household_relation_id_foreign` (`relation_id`),
  ADD KEY `survey_residential_household_gender_id_foreign` (`gender_id`),
  ADD KEY `survey_residential_household_marital_status_id_foreign` (`marital_status_id`),
  ADD KEY `survey_residential_household_education_id_foreign` (`education_id`),
  ADD KEY `survey_residential_household_occupation_id_foreign` (`occupation_id`),
  ADD KEY `survey_residential_household_training_id_foreign` (`training_id`),
  ADD KEY `survey_residential_household_monthly_range_id_foreign` (`monthly_range_id`);

--
-- Indexes for table `survey_user_residentials`
--
ALTER TABLE `survey_user_residentials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `survey_user_residentials_survey_id_foreign` (`survey_id`),
  ADD KEY `survey_user_residentials_project_id_foreign` (`project_id`),
  ADD KEY `survey_user_residentials_agency_user_id_foreign` (`agency_user_id`),
  ADD KEY `survey_user_residentials_structure_holder_id_foreign` (`structure_holder_id`),
  ADD KEY `survey_user_residentials_mother_tongue_id_foreign` (`mother_tongue_id`),
  ADD KEY `survey_user_residentials_caste_group_id_foreign` (`caste_group_id`),
  ADD KEY `survey_user_residentials_religion_id_foreign` (`religion_id`),
  ADD KEY `survey_user_residentials_gender_id_foreign` (`gender_id`),
  ADD KEY `survey_user_residentials_remark_id_foreign` (`remark_id`);

--
-- Indexes for table `sur_residen_socio_economic`
--
ALTER TABLE `sur_residen_socio_economic`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sur_residen_socio_economic_survey_id_foreign` (`survey_id`),
  ADD KEY `sur_residen_socio_economic_project_id_foreign` (`project_id`),
  ADD KEY `sur_residen_socio_economic_agency_user_id_foreign` (`agency_user_id`),
  ADD KEY `sur_residen_socio_economic_types_of_structure_id_foreign` (`types_of_structure_id`),
  ADD KEY `sur_residen_socio_economic_floors_id_foreign` (`floors_id`),
  ADD KEY `sur_residen_socio_economic_rooms_id_foreign` (`rooms_id`),
  ADD KEY `sur_residen_socio_economic_structure_roof_id_foreign` (`structure_roof_id`),
  ADD KEY `sur_residen_socio_economic_structure_wall_id_foreign` (`structure_wall_id`),
  ADD KEY `sur_residen_socio_economic_structure_floor_id_foreign` (`structure_floor_id`),
  ADD KEY `sur_residen_socio_economic_toilet_type_id_foreign` (`toilet_type_id`),
  ADD KEY `sur_residen_socio_economic_water_type_id_foreign` (`water_type_id`),
  ADD KEY `sur_residen_socio_economic_annual_expenditure_id_foreign` (`annual_expenditure_id`),
  ADD KEY `sur_residen_socio_economic_cooking_fuel_id_foreign` (`cooking_fuel_id`);

--
-- Indexes for table `temporary_allotments`
--
ALTER TABLE `temporary_allotments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `temporary_allotments_project_id_foreign` (`project_id`),
  ADD KEY `temporary_allotments_survey_id_foreign` (`survey_id`),
  ADD KEY `temporary_allotments_inventory_building_rooms_id_foreign` (`inventory_building_rooms_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `agencies`
--
ALTER TABLE `agencies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `allotments`
--
ALTER TABLE `allotments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `allotment_letters`
--
ALTER TABLE `allotment_letters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `amenity_assignments`
--
ALTER TABLE `amenity_assignments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `amenity_assignment_rooms`
--
ALTER TABLE `amenity_assignment_rooms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `association_registrations`
--
ALTER TABLE `association_registrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blocked_lottery_inventories`
--
ALTER TABLE `blocked_lottery_inventories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `caste_groups`
--
ALTER TABLE `caste_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cooking_fuels`
--
ALTER TABLE `cooking_fuels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `demolitions`
--
ALTER TABLE `demolitions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `document_types`
--
ALTER TABLE `document_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `educations`
--
ALTER TABLE `educations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `estimate_annual_expenditures`
--
ALTER TABLE `estimate_annual_expenditures`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flgrcs`
--
ALTER TABLE `flgrcs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flgrc_chief_user`
--
ALTER TABLE `flgrc_chief_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flgrc_mmrc_user`
--
ALTER TABLE `flgrc_mmrc_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `floors`
--
ALTER TABLE `floors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `fund_categories`
--
ALTER TABLE `fund_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `genders`
--
ALTER TABLE `genders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `inventory_building_floors`
--
ALTER TABLE `inventory_building_floors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventory_building_rooms`
--
ALTER TABLE `inventory_building_rooms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4673;

--
-- AUTO_INCREMENT for table `inventory_building_wings`
--
ALTER TABLE `inventory_building_wings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventory_locations`
--
ALTER TABLE `inventory_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;

--
-- AUTO_INCREMENT for table `inventory_location_buildings`
--
ALTER TABLE `inventory_location_buildings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `joint_verification_docs`
--
ALTER TABLE `joint_verification_docs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `lotteries`
--
ALTER TABLE `lotteries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `marital_statuses`
--
ALTER TABLE `marital_statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;

--
-- AUTO_INCREMENT for table `monthly_income_ranges`
--
ALTER TABLE `monthly_income_ranges`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mother_tongues`
--
ALTER TABLE `mother_tongues`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `occupations`
--
ALTER TABLE `occupations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;

--
-- AUTO_INCREMENT for table `permissions_old`
--
ALTER TABLE `permissions_old`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `project_related_documents`
--
ALTER TABLE `project_related_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `project_statuses`
--
ALTER TABLE `project_statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT for table `reasons`
--
ALTER TABLE `reasons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `receiveds`
--
ALTER TABLE `receiveds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `relations`
--
ALTER TABLE `relations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `religions`
--
ALTER TABLE `religions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `remarks`
--
ALTER TABLE `remarks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `roles_old`
--
ALTER TABLE `roles_old`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `role_permission_old`
--
ALTER TABLE `role_permission_old`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `shop_types`
--
ALTER TABLE `shop_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `societies`
--
ALTER TABLE `societies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `statuses`
--
ALTER TABLE `statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `structure_holder`
--
ALTER TABLE `structure_holder`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `structure_roofs`
--
ALTER TABLE `structure_roofs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `structure_types`
--
ALTER TABLE `structure_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `surveys`
--
ALTER TABLE `surveys`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `survey_agencyuser_commercial`
--
ALTER TABLE `survey_agencyuser_commercial`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `survey_agencyuser_others`
--
ALTER TABLE `survey_agencyuser_others`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `survey_agencyuser_residen_vulner`
--
ALTER TABLE `survey_agencyuser_residen_vulner`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `survey_documents`
--
ALTER TABLE `survey_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `survey_residential_household`
--
ALTER TABLE `survey_residential_household`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `survey_user_residentials`
--
ALTER TABLE `survey_user_residentials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `sur_residen_socio_economic`
--
ALTER TABLE `sur_residen_socio_economic`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `temporary_allotments`
--
ALTER TABLE `temporary_allotments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `amenity_assignments`
--
ALTER TABLE `amenity_assignments`
  ADD CONSTRAINT `amenity_assignments_inventory_building_room_id_foreign` FOREIGN KEY (`inventory_building_room_id`) REFERENCES `inventory_building_rooms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `amenity_assignments_society_id_foreign` FOREIGN KEY (`society_id`) REFERENCES `societies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `amenity_assignment_rooms`
--
ALTER TABLE `amenity_assignment_rooms`
  ADD CONSTRAINT `amenity_assignment_rooms_amenity_assignment_id_foreign` FOREIGN KEY (`amenity_assignment_id`) REFERENCES `amenity_assignments` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `receiveds`
--
ALTER TABLE `receiveds`
  ADD CONSTRAINT `receiveds_fund_category_id_foreign` FOREIGN KEY (`fund_category_id`) REFERENCES `fund_categories` (`id`);
COMMIT;

