INSERT INTO `verify_attendance_details` (`id`, `verify_attendance_id`, `attendance_id`, `employee_id`, `emp_code`, `total_days`, `present`, `absent`, `leave`, `pay`, `created_at`, `updated_at`) VALUES
(5375, 17, 19121, 1058, '5222', 31, '28', '3', '3', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5376, 17, 19122, 1059, '5223', 31, '31', '0', '0', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5377, 17, 19123, 1060, '5224', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5378, 17, 19124, 1061, '5225', 31, '30', '1', '1', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5379, 17, 19125, 1062, '5226', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5380, 17, 19126, 1063, '5227', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5381, 17, 19127, 1064, '5228', 31, '31', '0', '0', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5382, 17, 19128, 1065, '5230', 31, '27.5', '3.5', '3', '30.5', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5383, 17, 19129, 1066, '5231', 31, '0', '31', '0', '0', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5384, 17, 19130, 1067, '5232', 31, '29', '2', '2', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5385, 17, 19131, 1070, '1625', 31, '27', '4', '4', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5386, 17, 19132, 1071, '1626', 31, '29', '2', '2', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5387, 17, 19133, 1072, '1627', 31, '30', '1', '1', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5388, 17, 19134, 1073, '1628', 31, '31', '0', '0', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5389, 17, 19135, 1074, '1629', 31, '30', '1', '1', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5390, 17, 19136, 1075, '1630', 31, '30', '1', '1', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5391, 17, 19137, 1076, '1631', 31, '30', '1', '1', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5392, 17, 19138, 1077, '1632', 31, '26', '5', '5', '26', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5393, 17, 19139, 1078, '5233', 31, '30', '1', '1', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5394, 17, 19140, 1079, '5234', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5395, 17, 19141, 1080, '5235', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5396, 17, 19142, 1081, '5236', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5397, 17, 19143, 1082, '5237', 31, '29', '2', '2', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5398, 17, 19144, 1083, '5238', 31, '31', '0', '0', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5399, 17, 19145, 1084, '5239', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5400, 17, 19146, 1085, '5240', 31, '0', '31', '0', '0', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5401, 17, 19147, 1086, '5241', 31, '0', '31', '0', '0', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5402, 17, 19148, 1087, '5242', 31, '28', '3', '3', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5403, 17, 19149, 1088, '5243', 31, '30', '1', '1', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5404, 17, 19150, 1089, '5244', 31, '27', '4', '4', '27', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5405, 17, 19151, 1090, '5245', 31, '0', '31', '0', '0', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5406, 17, 19152, 1091, '5246', 31, '30.5', '0.5', '0.5', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5407, 17, 19153, 1092, '5247', 31, '0', '31', '0', '0', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5408, 17, 19154, 1093, '5248', 31, '29.5', '1.5', '1', '30.5', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5409, 17, 19155, 1094, '5249', 31, '11', '20', '0', '11', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5410, 17, 19156, 1095, '5250', 31, '29', '2', '2', '29', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5411, 17, 19157, 1096, '5251', 31, '24', '7', '7', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5412, 17, 19158, 1097, '5252', 31, '24', '7', '7', '24', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5413, 17, 19159, 1098, '5253', 31, '27', '4', '4', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5414, 17, 19160, 1099, '5254', 31, '27.5', '3.5', '0', '27.5', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5415, 17, 19161, 1100, '5255', 31, '31', '0', '0', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5416, 17, 19162, 1101, '5256', 31, '11', '20', '20', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5417, 17, 19163, 1102, '5257', 31, '25', '6', '6', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5418, 17, 19164, 1103, '5258', 31, '29', '2', '2', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5419, 17, 19165, 1104, '5259', 31, '25', '6', '6', '31', '2025-07-25 07:57:33', '2025-07-25 11:47:52'),
(5420, 17, 19166, 1105, '5260', 31, '29', '2', '2', '29', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5421, 17, 19167, 1106, '5261', 31, '29.5', '1.5', '1.5', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5422, 17, 19168, 1107, '5262', 31, '29', '2', '2', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5423, 17, 19169, 1110, '2180', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5424, 17, 19170, 1112, '2115', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5425, 17, 19171, 1113, '2181', 31, '28', '3', '1', '29', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5426, 17, 19172, 1115, '2182', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5427, 17, 19173, 1116, '2183', 31, '28.5', '2.5', '2.5', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5428, 17, 19174, 1117, '2184', 31, '28.5', '2.5', '0', '28.5', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5429, 17, 19175, 1122, '63', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5430, 17, 19176, 1124, '64', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5431, 17, 19177, 1125, '65', 31, '29', '2', '2', '29', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5432, 17, 19178, 1126, '66', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5433, 17, 19179, 1127, '67', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5434, 17, 19180, 1128, '69', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5435, 17, 19181, 1131, '70', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5436, 17, 19184, 1137, '5229', 31, '27', '4', '4', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5437, 17, 19185, 1141, '1633', 31, '29', '2', '2', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5438, 17, 19186, 1142, '1635', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5439, 17, 19187, 1143, '1634', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5440, 17, 19188, 1144, '1637', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5441, 17, 19189, 1147, '1636', 31, '28', '3', '3', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5442, 17, 19190, 1148, '1639', 31, '28', '3', '3', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5443, 17, 19191, 1149, '1638', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5444, 17, 19192, 1150, '5263', 31, '11', '20', '20', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5445, 17, 19193, 1151, '5271', 31, '30', '1', '0', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5446, 17, 19194, 1152, '5272', 31, '30', '1', '0', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5447, 17, 19195, 1153, '5264', 31, '11', '20', '20', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5448, 17, 19196, 1154, '5266', 31, '28.5', '2.5', '2.5', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5449, 17, 19197, 1155, '5270', 31, '29', '2', '2', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5450, 17, 19198, 1156, '5265', 31, '24', '7', '7', '24', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5451, 17, 19199, 1157, '5267', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5452, 17, 19200, 1159, '5269', 31, '11', '20', '20', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5453, 17, 19201, 1160, '5268', 31, '30', '1', '1', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5454, 17, 19202, 1161, '5273', 31, '29', '2', '2', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5455, 17, 19204, 1163, '5277', 31, '30.5', '0.5', '0.5', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5456, 17, 19205, 1164, '5274', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5457, 17, 19206, 1165, '5279', 31, '28', '3', '3', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5458, 17, 19207, 1166, '5276', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5459, 17, 19208, 1167, '5275', 31, '11', '20', '20', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5460, 17, 19209, 1169, '1640', 31, '29', '2', '2', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5461, 17, 19210, 1171, '5280', 31, '11', '20', '20', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5462, 17, 19211, 1172, '5281', 31, '30', '1', '1', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5463, 17, 19212, 1173, '5278', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5464, 17, 19213, 1174, '5284', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5465, 17, 19214, 1175, '5282', 31, '29', '2', '2', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5466, 17, 19215, 1176, '5285', 31, '30', '1', '0', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5467, 17, 19216, 1177, '5283', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5468, 17, 19217, 1178, '5286', 31, '30', '1', '1', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5469, 17, 19218, 1179, '5287', 31, '11', '20', '0', '11', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5470, 17, 19219, 1180, '5288', 31, '29', '2', '2', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5471, 17, 19220, 1181, '5289', 31, '30', '1', '1', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5472, 17, 19221, 1185, '301', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5473, 17, 19222, 1186, '302', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5474, 17, 19223, 1187, '300', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5475, 17, 19224, 1188, '303', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5476, 17, 19225, 1189, '1641', 31, '27', '4', '4', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5477, 17, 19226, 1190, '1642', 31, '29.5', '1.5', '1.5', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5478, 17, 19227, 1191, '1643', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5479, 17, 19228, 1192, '5290', 31, '29.5', '1.5', '1.5', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5480, 17, 19229, 1193, '5291', 31, '30', '1', '1', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5481, 17, 19230, 1194, '5292', 31, '28', '3', '3', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5482, 17, 19231, 1195, '5293', 31, '11', '20', '20', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5483, 17, 19232, 1196, '5294', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5484, 17, 19233, 1197, '71', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5485, 17, 19234, 1198, '2185', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5486, 17, 19235, 1199, '5128', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5487, 17, 19236, 1200, '1644', 31, '25.5', '5.5', '5.5', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5488, 17, 19237, 1201, '1645', 31, '24', '7', '7', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5489, 17, 19238, 1202, '5295', 31, '29', '2', '2', '29', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5490, 17, 19239, 1203, '5296', 31, '11', '20', '20', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5491, 17, 19240, 1204, '306', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5492, 17, 19241, 1205, '1646', 31, '27', '4', '3.5', '30.5', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5493, 17, 19242, 1206, '1647', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5494, 17, 19243, 1207, '1648', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5495, 17, 19244, 1208, '1651', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5496, 17, 19245, 1209, '1649', 31, '29', '2', '0', '29', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5497, 17, 19246, 1210, '1650', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5498, 17, 19247, 1211, '5156', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5499, 17, 19248, 1212, '5299', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5500, 17, 19249, 1213, '1656', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5501, 17, 19250, 1214, '5298', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5502, 17, 19251, 1215, '5297', 31, '30', '1', '0', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5503, 17, 19252, 1216, '5300', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5504, 17, 19253, 1217, '33', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5505, 17, 19254, 1218, '1654', 31, '29', '2', '1.5', '30.5', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5506, 17, 19255, 1219, '1652', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5507, 17, 19256, 1220, '1653', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5508, 17, 19257, 1221, '1657', 31, '30', '1', '0', '30', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5509, 17, 19258, 1222, '1655', 31, '30', '1', '1', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5510, 17, 19259, 1223, '2186', 31, '31', '0', '0', '31', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5511, 17, 19260, 1224, '5301', 31, '0', '31', '0', '0', '2025-07-25 07:57:34', '2025-07-25 11:47:52'),
(5512, 19, 18938, 834, '101010', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5513, 19, 18939, 835, '101801', 31, '0', '31', '0', '0', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5514, 19, 18940, 836, '106', 31, '30.5', '0.5', '1', '31.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5515, 19, 18941, 837, '401', 31, '24', '7', '1', '25', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5516, 19, 18942, 838, '601', 31, '27', '4', '0', '27', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5517, 19, 18943, 839, '709', 31, '28.5', '2.5', '4', '32.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5518, 19, 18944, 840, '9', 31, '29.5', '1.5', '1.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5519, 19, 18945, 841, '907', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5520, 19, 18946, 845, '912', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5521, 19, 18948, 847, '903', 31, '29.5', '1.5', '1.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5522, 19, 18949, 848, '902', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5523, 19, 18950, 849, '901', 31, '26', '5', '5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5524, 19, 18951, 850, '710', 31, '29.5', '1.5', '1.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5525, 19, 18952, 854, '708', 31, '30', '1', '1.5', '31.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5526, 19, 18953, 855, '707', 31, '20', '11', '11.5', '31.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5527, 19, 18954, 856, '706', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5528, 19, 18955, 857, '10', 31, '28.5', '2', '2.5', '29', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5529, 19, 18956, 858, '705', 31, '30', '1', '1.5', '31.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5530, 19, 18957, 859, '704', 31, '29', '2', '2', '29', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5531, 19, 18958, 860, '101006', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5532, 19, 18959, 861, '619', 31, '29', '2', '2', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5533, 19, 18960, 862, '101007', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5534, 19, 18961, 863, '618', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5535, 19, 18962, 864, '617', 31, '29', '2', '2', '29', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5536, 19, 18963, 865, '616', 31, '28.5', '2.5', '2.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5537, 19, 18964, 866, '101008', 31, '0', '31', '0', '0', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5538, 19, 18965, 867, '613', 31, '30.5', '0.5', '0.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5539, 19, 18966, 868, '610', 31, '27.5', '3.5', '4', '31.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5540, 19, 18967, 869, '607', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5541, 19, 18968, 870, '606', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5542, 19, 18969, 871, '603', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5543, 19, 18970, 872, '602', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5544, 19, 18971, 873, '508', 31, '26', '5', '5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5545, 19, 18972, 874, '507', 31, '30.5', '0', '0.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5546, 19, 18973, 875, '506', 31, '29', '2', '2', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5547, 19, 18974, 876, '504', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5548, 19, 18975, 877, '409', 31, '27', '4', '4', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5549, 19, 18976, 878, '407', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5550, 19, 18977, 879, '405', 31, '30', '1', '1.5', '31.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5551, 19, 18978, 880, '404', 31, '29', '2', '2', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5552, 19, 18979, 881, '403', 31, '30', '1', '2', '32', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5553, 19, 18980, 882, '402', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5554, 19, 18981, 883, '305', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5555, 19, 18982, 884, '211', 31, '30', '1', '1', '30', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5556, 19, 18983, 885, '210', 31, '29', '2', '3', '32', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5557, 19, 18984, 886, '209', 31, '0', '31', '0', '0', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5558, 19, 18985, 887, '207', 31, '29.5', '1.5', '1.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5559, 19, 18986, 888, '203', 31, '30.5', '0.5', '0.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5560, 19, 18987, 889, '114', 31, '30', '1', '1', '30', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5561, 19, 18988, 890, '112', 31, '30', '1', '2', '32', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5562, 19, 18989, 891, '107', 31, '30', '1', '1', '30', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5563, 19, 18990, 894, '103', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5564, 19, 18991, 895, '102', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5565, 19, 18992, 896, '101811', 31, '29', '2', '2', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5566, 19, 18993, 897, '101809', 31, '30', '1', '1', '30', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5567, 19, 18994, 898, '101808', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5568, 19, 18995, 899, '101807', 31, '30.5', '0.5', '0.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5569, 19, 18996, 900, '101806', 31, '29', '2', '2', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5570, 19, 18997, 901, '101805', 31, '29.5', '1.5', '5.5', '35', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5571, 19, 18998, 902, '101802', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5572, 19, 18999, 903, '101019', 31, '30', '1', '1.5', '31.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5573, 19, 19000, 904, '101018', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5574, 19, 19001, 905, '101017', 31, '30.5', '0.5', '1.5', '32', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5575, 19, 19002, 906, '101016', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5576, 19, 19003, 907, '101009', 31, '30.5', '0.5', '0.5', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5577, 19, 19004, 908, '101012', 31, '31', '0', '0', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5578, 19, 19005, 909, '304', 31, '29.5', '1.5', '2.5', '32', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5579, 19, 19182, 1133, '910', 31, '29', '2', '0.5', '29.5', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5580, 19, 19183, 1136, '911', 31, '30', '1', '1', '31', '2025-07-25 11:12:22', '2025-07-25 11:12:22'),
(5581, 19, 19203, 1162, '915', 31, '30', '1', '1', '30', '2025-07-25 11:12:22', '2025-07-25 11:12:22');

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

--
-- Table structure for table `verify_recovery_amounts`
--

CREATE TABLE `verify_recovery_amounts` (
  `id` bigint UNSIGNED NOT NULL,
  `verify_attendance_id` bigint DEFAULT NULL,
  `employee_salary_id` bigint NOT NULL,
  `employee_id` bigint DEFAULT NULL,
  `emp_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_of_days` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leave` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pay` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci 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 `verify_recovery_amounts`
--

INSERT INTO `verify_recovery_amounts` (`id`, `verify_attendance_id`, `employee_salary_id`, `employee_id`, `emp_code`, `no_of_days`, `leave`, `pay`, `amount`, `created_at`, `updated_at`) VALUES
(1, 2, 458, 568, '3306', '8', '6', '2', '6142', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(2, 2, 453, 573, '3311', '5', '4', '1', '1296', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(3, 2, 451, 577, '3318', '1', '0', '1', '1296', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(4, 2, 463, 340, '3033', '1', '0', '1', '1947', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(5, 2, 633, 457, '3169', '1', '0', '1', '2102', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(6, 2, 634, 458, '3170', '1', '0', '1', '1625', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(7, 2, 635, 459, '3171', '1', '0', '1', '1625', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(8, 2, 639, 463, '3175', '1', '0', '1', '1538', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(9, 2, 642, 466, '3178', '4', '0', '4', '6325', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(10, 2, 645, 469, '3181', '1', '0', '1', '1625', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(11, 2, 648, 472, '3184', '1', '0', '1', '1494', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(12, 2, 655, 480, '3192', '4', '0', '4', '5974', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(13, 2, 658, 483, '3195', '1', '0', '1', '1494', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(14, 2, 661, 486, '3198', '1', '0', '1', '1494', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(15, 2, 666, 487, '3199', '8', '0', '8', '11949', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(16, 2, 467, 345, '3039', '1', '0', '1', '1947', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(17, 2, 398, 323, '3016', '1', '0', '1', '1947', '2025-03-25 10:55:48', '2025-03-26 12:12:59'),
(18, 2, 488, 367, '3067', '3', '0', '3', '4481', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(19, 2, 490, 369, '3069', '0.5', '0', '0.5', '769', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(20, 2, 491, 370, '3070', '2.5', '1', '1.5', '2306', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(21, 2, 492, 371, '3071', '0.5', '0', '0.5', '769', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(22, 2, 496, 375, '3075', '1', '0', '1', '1494', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(23, 2, 501, 380, '3080', '2', '0', '2', '2987', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(24, 2, 503, 382, '3082', '1', '0', '1', '1494', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(25, 2, 504, 383, '3084', '2', '0', '2', '2987', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(26, 2, 508, 387, '3089', '1', '0', '1', '1450', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(27, 2, 510, 389, '3091', '1', '0', '1', '1450', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(28, 2, 512, 391, '3093', '1', '0', '1', '1450', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(29, 2, 385, 310, '3003', '2', '1', '1', '2312', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(30, 2, 402, 327, '3020', '2', '0', '2', '4624', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(31, 2, 294, 407, '3109', '1', '0', '1', '2102', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(32, 2, 379, 412, '3115', '2', '0', '2', '4569', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(33, 2, 520, 417, '3121', '2', '1', '1', '1822', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(34, 2, 524, 422, '3126', '1', '0', '1', '1625', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(35, 2, 526, 424, '3129', '2', '0', '2', '3075', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(36, 2, 527, 425, '3130', '1', '0', '1', '1494', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(37, 2, 449, 579, '3320', '1', '0', '1', '2219', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(38, 2, 447, 581, '3323', '1.5', '0', '1.5', '1945', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(39, 2, 615, 507, '3223', '3.5', '2', '1.5', '2901', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(40, 2, 612, 510, '3229', '1', '0', '1', '1296', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(41, 2, 607, 515, '3234', '2', '0', '2', '2593', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(42, 2, 412, 336, '3029', '1', '0', '1', '1223', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(43, 2, 531, 430, '3136', '2', '0', '2', '2593', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(44, 2, 532, 431, '3137', '3', '0', '3', '3889', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(45, 2, 535, 434, '3140', '1', '0', '1', '1296', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(46, 2, 604, 518, '3237', '0.5', '0', '0.5', '1090', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(47, 2, 597, 525, '3249', '1', '0', '1', '1296', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(48, 2, 596, 526, '3250', '3', '0', '3', '3889', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(49, 2, 579, 544, '3274', '1', '0', '1', '1296', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(50, 2, 437, 591, '3336', '2', '0', '2', '3162', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(51, 2, 432, 595, '3340', '3', '0', '3', '4612', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(52, 2, 428, 599, '3344', '1', '0', '1', '1223', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(53, 2, 557, 558, '3289', '1', '0', '1', '1223', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(54, 2, 396, 321, '3014', '2.5', '2', '0.5', '820', '2025-03-25 10:55:49', '2025-03-26 12:12:59'),
(55, 2, 622, 500, '3213', '2', '1', '1', '1450', '2025-03-25 10:55:50', '2025-03-26 12:12:59'),
(56, 2, 538, 437, '3145', '1', '0', '1', '1531', '2025-03-25 10:55:50', '2025-03-26 12:12:59'),
(57, 2, 539, 438, '3146', '1', '0', '1', '1531', '2025-03-25 10:55:50', '2025-03-26 12:12:59'),
(58, 2, 882, 534, '3259', '8', '0', '8', '10080', '2025-03-25 10:55:50', '2025-03-26 12:12:59'),
(59, 2, 555, 559, '3291', '1', '0', '1', '1223', '2025-03-25 10:55:50', '2025-03-26 12:12:59'),
(60, 2, 591, 531, '3256', '1', '0', '1', '1296', '2025-03-25 10:55:50', '2025-03-26 12:12:59'),
(61, 4, 803, 840, '9', '3', '0', '3', '13635', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(62, 4, 824, 890, '112', '1', '0', '1', '3218', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(63, 4, 830, 884, '211', '3', '2', '1', '4297', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(64, 4, 833, 880, '404', '8', '5', '3', '10223', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(65, 4, 843, 868, '610', '8', '0', '8', '20582', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(66, 4, 860, 849, '901', '8', '0', '8', '24974', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(67, 4, 1053, 1133, '910', '8', '5', '3', '1714', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(68, 4, 1072, 1162, '915', '1', '0', '1', '571', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(69, 4, 814, 902, '101802', '1', '0', '1', '4290', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(70, 4, 815, 901, '101805', '8', '8', '0', '0', '2025-03-25 10:59:38', '2025-03-25 11:37:15'),
(71, 2, 39, 38, '1092', '1', '0', '1', '1767', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(72, 2, 48, 46, '1105', '5', '1', '4', '8516', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(73, 2, 66, 63, '1154', '3', '2', '1', '1546', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(74, 2, 89, 77, '1182', '3', '2', '1', '2188', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(75, 2, 114, 89, '1205', '6', '5', '1', '1943', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(76, 2, 131, 104, '1238', '1', '0', '1', '2070', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(77, 2, 133, 106, '1240', '6', '4', '2', '3739', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(78, 2, 181, 132, '1285', '4', '3', '1', '1633', '2025-03-25 12:09:07', '2025-03-26 12:12:59'),
(79, 2, 250, 156, '1319', '1', '0', '1', '2129', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(80, 2, 257, 158, '1322', '2', '0', '2', '3885', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(81, 2, 275, 163, '1331', '4', '0', '4', '8516', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(82, 2, 301, 170, '1348', '8', '0', '8', '11142', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(83, 2, 336, 180, '1370', '1.5', '1', '0.5', '1142', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(84, 2, 349, 186, '1378', '3', '2', '1', '1767', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(85, 2, 383, 199, '1447', '6.5', '5', '1.5', '2432', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(86, 2, 664, 202, '1452', '4', '2', '2', '3243', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(87, 2, 85, 205, '1457', '0.5', '0', '0.5', '789', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(88, 2, 88, 206, '1458', '4', '3', '1', '1578', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(89, 2, 98, 208, '1502', '1.5', '1', '0.5', '811', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(90, 2, 130, 212, '1509', '1.5', '0', '1.5', '2366', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(91, 2, 149, 217, '1514', '1', '0', '1', '1281', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(92, 2, 153, 219, '1517', '4.5', '4', '0.5', '767', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(93, 2, 159, 221, '1519', '3', '0', '3', '4601', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(94, 2, 166, 224, '1523', '2.5', '1', '1.5', '2240', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(95, 2, 198, 236, '1542', '3', '0', '3', '3319', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(96, 2, 210, 241, '1547', '1.5', '0', '1.5', '2049', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(97, 2, 218, 245, '1555', '4', '3', '1', '1329', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(98, 2, 278, 266, '1577', '4', '0', '4', '5172', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(99, 2, 285, 268, '1579', '3', '2', '1', '1256', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(100, 2, 872, 927, '1621', '1', '0', '1', '954', '2025-03-25 12:09:08', '2025-03-26 12:12:59'),
(101, 2, 1092, 1189, '1641', '1', '0', '1', '1150', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(102, 2, 13, 14, '1040', '1', '0', '1', '2188', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(103, 2, 350, 293, '1604', '8', '0', '8', '9473', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(104, 2, 329, 283, '1594', '0.5', '0', '0.5', '628', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(105, 2, 57, 54, '1129', '1', '0', '1', '2319', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(106, 2, 1, 1, '1001', '1', '0', '1', '3604', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(107, 2, 856, 846, '101023', '1', '0', '1', '1988', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(108, 2, 64, 61, '1147', '8', '0', '8', '20883', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(109, 2, 157, 120, '1263', '2', '0', '2', '5521', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(110, 2, 887, 937, '5116', '4', '0', '4', '6766', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(111, 2, 888, 938, '5117', '8', '1', '7', '11840', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(112, 2, 890, 940, '5119', '8', '7', '1', '1691', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(113, 2, 891, 941, '5120', '8', '0', '8', '13531', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(114, 2, 894, 944, '5123', '1', '0', '1', '2239', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(115, 2, 895, 945, '5124', '3', '0', '3', '5074', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(116, 2, 896, 946, '5125', '2', '0', '2', '3383', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(117, 2, 904, 952, '5130', '5', '2', '3', '5074', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(118, 2, 916, 961, '5139', '2', '1', '1', '2239', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(119, 2, 920, 968, '5143', '8', '2', '6', '10148', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(120, 2, 921, 969, '5144', '7', '0', '7', '11840', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(121, 2, 924, 972, '5147', '1', '0', '1', '2239', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(122, 2, 930, 984, '5154', '5', '2', '3', '5074', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(123, 2, 935, 990, '5160', '7', '0', '7', '11840', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(124, 2, 952, 997, '5167', '7.5', '0', '7.5', '12685', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(125, 2, 963, 1002, '5172', '8', '6', '2', '3383', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(126, 2, 980, 1008, '5177', '6', '2', '4', '10766', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(127, 2, 986, 1010, '5179', '8', '0', '8', '13531', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(128, 2, 987, 1011, '5180', '6', '3', '3', '6717', '2025-03-25 12:09:09', '2025-03-26 12:12:59'),
(129, 2, 936, 1024, '5192', '4', '0', '4', '6766', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(130, 2, 947, 1031, '5198', '8', '0', '8', '13531', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(131, 2, 950, 1033, '5200', '8', '2', '6', '10148', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(132, 2, 951, 1034, '5201', '8', '5', '3', '6717', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(133, 2, 957, 1039, '5204', '2', '0', '2', '3383', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(134, 2, 959, 1042, '5206', '3', '0', '3', '5074', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(135, 2, 971, 1051, '5215', '7.5', '0', '7.5', '12685', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(136, 2, 973, 1052, '5216', '1', '0', '1', '2239', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(137, 2, 978, 1055, '5219', '7.5', '0', '7.5', '12685', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(138, 2, 979, 1056, '5220', '7.5', '1', '6.5', '10994', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(139, 2, 995, 1064, '5228', '1', '0', '1', '1691', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(140, 2, 1019, 1094, '5249', '8', '0', '8', '13531', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(141, 2, 1015, 1098, '5253', '2', '1', '1', '1691', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(142, 2, 1078, 1167, '5275', '7.5', '0', '7.5', '12685', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(143, 2, 419, 608, '5010', '1', '0', '1', '3013', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(144, 2, 249, 639, '5041', '2', '1', '1', '1543', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(145, 2, 241, 642, '5044', '4', '2', '2', '4054', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(146, 2, 238, 643, '5045', '1', '0', '1', '2772', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(147, 2, 235, 644, '5046', '3', '0', '3', '9038', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(148, 2, 187, 651, '5053', '5', '2', '3', '3534', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(149, 2, 82, 673, '5075', '1.5', '1', '0.5', '772', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(150, 2, 38, 676, '5078', '5', '2', '3', '6082', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(151, 2, 36, 677, '5079', '8', '0', '8', '17912', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(152, 2, 677, 705, '5086', '1', '0', '1', '1499', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(153, 2, 690, 682, '5090', '5', '0', '5', '9844', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(154, 2, 884, 679, '5097', '8', '0', '8', '11994', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(155, 2, 892, 942, '5121', '5', '0', '5', '9844', '2025-03-25 12:09:10', '2025-03-26 12:12:59'),
(156, 2, 893, 943, '5122', '7.5', '0', '7.5', '16792', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(157, 2, 898, 948, '5127', '6', '0', '6', '10148', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(158, 2, 910, 955, '5133', '8', '0', '8', '17912', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(159, 2, 913, 958, '5136', '7', '0', '7', '15673', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(160, 2, 914, 959, '5137', '8', '0', '8', '17912', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(161, 2, 922, 970, '5145', '7.5', '0', '7.5', '16792', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(162, 2, 925, 975, '5148', '5', '3', '2', '5383', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(163, 2, 927, 977, '5151', '8', '0', '8', '17912', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(164, 2, 954, 998, '5168', '7', '3', '4', '8956', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(165, 2, 961, 1000, '5170', '8', '3', '5', '11195', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(166, 2, 991, 1014, '5183', '8', '0', '8', '17912', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(167, 2, 958, 1040, '5205', '7', '0', '7', '15673', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(168, 2, 976, 1054, '5218', '1.5', '0', '1.5', '2537', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(169, 2, 996, 1065, '5230', '1', '0', '1', '1499', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(170, 2, 1034, 1078, '5233', '3', '2', '1', '1691', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(171, 2, 1029, 1084, '5239', '8', '0', '8', '17912', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(172, 2, 1018, 1095, '5250', '1', '0', '1', '4299', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(173, 2, 1044, 1104, '5259', '1.5', '0', '1.5', '2537', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(174, 2, 1009, 1106, '5261', '1', '0', '1', '2925', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(175, 2, 1061, 1150, '5263', '7', '2', '5', '11195', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(176, 2, 1077, 1166, '5276', '8', '6', '2', '2999', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(177, 2, 380, 307, '2014', '1', '0', '1', '2772', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(178, 2, 722, 804, '2047', '1', '0', '1', '2143', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(179, 2, 10, 11, '1033', '8', '6', '2', '5042', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(180, 2, 734, 743, '2042', '4', '0', '4', '7662', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(181, 2, 753, 756, '2056', '1', '0', '1', '1071', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(182, 2, 752, 759, '2060', '1', '0', '1', '1071', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(183, 2, 748, 772, '2087', '2', '0', '2', '3493', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(184, 2, 790, 827, '2132', '4', '0', '4', '4286', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(185, 2, 792, 829, '2135', '8', '0', '8', '19533', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(186, 2, 789, 825, '2140', '1', '0', '1', '1499', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(187, 2, 787, 824, '2142', '2', '0', '2', '3391', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(188, 2, 786, 823, '2143', '1', '0', '1', '1071', '2025-03-25 12:09:11', '2025-03-26 12:12:59'),
(189, 2, 754, 812, '2152', '2.5', '0', '2.5', '4336', '2025-03-25 12:09:12', '2025-03-26 12:12:59'),
(190, 2, 756, 801, '2156', '4', '0', '4', '11536', '2025-03-25 12:09:12', '2025-03-26 12:12:59'),
(191, 2, 760, 791, '2161', '4', '0', '4', '10019', '2025-03-25 12:09:12', '2025-03-26 12:12:59'),
(192, 2, 772, 758, '2173', '8', '0', '8', '16794', '2025-03-25 12:09:12', '2025-03-26 12:12:59'),
(193, 2, 1003, 1110, '2180', '1', '0', '1', '2187', '2025-03-25 12:09:12', '2025-03-26 12:12:59'),
(194, 2, 1007, 1117, '2184', '2', '0', '2', '4306', '2025-03-25 12:09:12', '2025-03-26 12:12:59'),
(195, 6, 832, 882, '402', '1', '0', '1', '2907', '2025-04-23 11:50:12', '2025-04-24 11:00:57'),
(196, 6, 1053, 1133, '910', '1', '0', '1', '516', '2025-04-23 11:50:13', '2025-04-24 11:00:57'),
(197, 6, 806, 860, '101006', '1', '0', '1', '2346', '2025-04-23 11:50:13', '2025-04-24 11:00:57'),
(198, 6, 807, 862, '101007', '1', '0', '1', '3993', '2025-04-23 11:50:13', '2025-04-24 11:00:57'),
(199, 6, 818, 898, '101808', '2', '1', '1', '2623', '2025-04-23 11:50:13', '2025-04-24 11:00:57'),
(200, 8, 91, 78, '1184', '1', '0', '1', '1923', '2025-04-25 11:21:25', '2025-04-29 12:34:08'),
(201, 8, 96, 80, '1189', '2', '0', '2', '3952', '2025-04-25 11:21:25', '2025-04-29 12:34:08'),
(202, 8, 123, 98, '1229', '11', '9', '2', '3846', '2025-04-25 11:21:25', '2025-04-29 12:34:08'),
(203, 8, 132, 105, '1239', '1', '0', '1', '1504', '2025-04-25 11:21:25', '2025-04-29 12:34:08'),
(204, 8, 133, 106, '1240', '2', '0', '2', '3377', '2025-04-25 11:21:25', '2025-04-29 12:34:08'),
(205, 8, 143, 114, '1254', '11', '8', '3', '5769', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(206, 8, 225, 149, '1308', '3', '2', '1', '1755', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(207, 8, 248, 155, '1318', '2', '0', '2', '2987', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(208, 8, 250, 156, '1319', '2', '1', '1', '1923', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(209, 8, 257, 158, '1322', '4', '2', '2', '3509', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(210, 8, 349, 186, '1378', '2.5', '2', '0.5', '798', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(211, 8, 363, 193, '1421', '6', '0', '6', '10738', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(212, 8, 382, 198, '1439', '6', '4', '2', '2533', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(213, 8, 72, 201, '1451', '5', '3', '2', '2929', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(214, 8, 81, 204, '1456', '1', '0', '1', '1425', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(215, 8, 130, 212, '1509', '3', '1', '2', '2850', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(216, 8, 153, 219, '1517', '1.5', '1', '0.5', '693', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(217, 8, 164, 223, '1522', '2', '1', '1', '1349', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(218, 8, 166, 224, '1523', '2.5', '1', '1.5', '2024', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(219, 8, 195, 234, '1540', '2', '1', '1', '1234', '2025-04-25 11:21:26', '2025-04-29 12:34:08'),
(220, 8, 198, 236, '1542', '8', '6', '2', '1998', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(221, 8, 201, 237, '1543', '1', '0', '1', '1234', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(222, 8, 203, 238, '1544', '1', '0', '1', '1234', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(223, 8, 212, 242, '1548', '3', '1', '2', '2474', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(224, 8, 218, 245, '1555', '4', '0', '4', '4803', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(225, 8, 232, 252, '1563', '5', '1', '4', '4671', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(226, 8, 240, 257, '1568', '4.5', '4', '0.5', '584', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(227, 8, 278, 266, '1577', '5', '2', '3', '3503', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(228, 8, 1041, 1071, '1626', '0.5', '0', '0.5', '520', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(229, 8, 1056, 1143, '1634', '1', '0', '1', '1039', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(230, 8, 1092, 1189, '1641', '1', '0', '1', '1039', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(231, 8, 335, 286, '1597', '1', '0', '1', '1135', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(232, 8, 19, 20, '1049', '11', '0', '11', '22387', '2025-04-25 11:21:27', '2025-04-29 12:34:08'),
(233, 8, 993, 1015, '5184', '11', '8', '3', '4583', '2025-04-25 11:21:28', '2025-04-29 12:34:08'),
(234, 8, 959, 1042, '5206', '3', '1', '2', '3055', '2025-04-25 11:21:28', '2025-04-29 12:34:08'),
(235, 8, 982, 1058, '5222', '2', '1', '1', '1528', '2025-04-25 11:21:28', '2025-04-29 12:34:08'),
(236, 8, 1019, 1094, '5249', '11', '0', '11', '16805', '2025-04-25 11:21:29', '2025-04-29 12:34:08'),
(237, 8, 316, 623, '5025', '11', '0', '11', '22898', '2025-04-25 11:21:29', '2025-04-29 12:34:08'),
(238, 8, 291, 628, '5030', '11', '0', '11', '29934', '2025-04-25 11:21:29', '2025-04-29 12:34:08'),
(239, 8, 187, 651, '5053', '5', '0', '5', '5320', '2025-04-25 11:21:29', '2025-04-29 12:34:08'),
(240, 8, 162, 657, '5059', '1', '0', '1', '1394', '2025-04-25 11:21:29', '2025-04-29 12:34:08'),
(241, 8, 990, 1061, '5225', '7.5', '7', '0.5', '1011', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(242, 8, 996, 1065, '5230', '2', '0', '2', '2708', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(243, 8, 1016, 1097, '5252', '11', '0', '11', '14896', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(244, 8, 1014, 1099, '5254', '0.5', '0', '0.5', '889', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(245, 8, 1036, 1076, '1631', '1', '0', '1', '2022', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(246, 8, 380, 307, '2014', '2.5', '1', '1.5', '3755', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(247, 8, 722, 804, '2047', '5', '1', '4', '7742', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(248, 8, 730, 731, '2012', '1', '0', '1', '1596', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(249, 8, 732, 725, '2031', '1', '0', '1', '2078', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(250, 8, 749, 769, '2084', '1', '0', '1', '1891', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(251, 8, 748, 772, '2087', '0.5', '0', '0.5', '789', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(252, 8, 743, 784, '2112', '0.5', '0', '0.5', '806', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(253, 8, 742, 786, '2113', '9', '0', '9', '21583', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(254, 8, 788, 826, '2130', '5', '1', '4', '7334', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(255, 8, 789, 825, '2140', '0.5', '0', '0.5', '677', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(256, 8, 787, 824, '2142', '4', '0', '4', '6126', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(257, 8, 779, 816, '2148', '1', '0', '1', '2511', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(258, 8, 769, 766, '2170', '0.5', '0', '0.5', '855', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(259, 8, 774, 747, '2177', '1', '0', '1', '1544', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(260, 8, 1005, 1115, '2182', '1', '0', '1', '2652', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(261, 8, 1007, 1117, '2184', '1.5', '0', '1.5', '2917', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(262, 8, 53, 51, '1124', '1', '0', '1', '2741', '2025-04-25 11:21:30', '2025-04-29 12:34:08'),
(263, 8, 371, 195, '1431', '1.5', '1', '0.5', '1321', '2025-04-25 11:21:31', '2025-04-29 12:34:08'),
(264, 10, 848, 859, '704', '0', '0', '0', '3004', '2025-05-23 07:22:01', '2025-05-23 09:52:39'),
(265, 10, 1053, 1133, '910', '1.5', '1', '0.5', '267', '2025-05-23 07:22:01', '2025-05-23 09:52:39'),
(266, 12, 663, 489, '3201', '1', '0', '1', '1907', '2025-05-26 15:00:55', '2025-05-28 11:40:54'),
(267, 12, 629, 493, '3205', '9', '8', '1', '1210', '2025-05-26 15:00:55', '2025-05-28 11:40:54'),
(268, 12, 627, 495, '3208', '10', '0', '10', '12100', '2025-05-26 15:00:55', '2025-05-28 11:40:54'),
(269, 12, 626, 496, '3209', '6', '0', '6', '7260', '2025-05-26 15:00:55', '2025-05-28 11:40:54'),
(270, 12, 561, 556, '3287', '10', '0', '10', '11419', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(271, 12, 451, 577, '3318', '7.5', '7', '0.5', '605', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(272, 12, 633, 457, '3169', '1', '0', '1', '1962', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(273, 12, 634, 458, '3170', '5', '3', '2', '3033', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(274, 12, 639, 463, '3175', '3.5', '0', '3.5', '5025', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(275, 12, 648, 472, '3184', '5', '0', '5', '6970', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(276, 12, 880, 473, '3185', '1', '0', '1', '1394', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(277, 12, 656, 481, '3193', '4.5', '0', '4.5', '5599', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(278, 12, 658, 483, '3195', '1', '0', '1', '1394', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(279, 12, 661, 486, '3198', '1', '0', '1', '1394', '2025-05-26 15:00:55', '2025-05-28 11:40:55'),
(280, 12, 472, 350, '3045', '3', '0', '3', '5405', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(281, 12, 473, 351, '3046', '1', '0', '1', '1602', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(282, 12, 482, 361, '3059', '2', '0', '2', '2870', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(283, 12, 488, 367, '3067', '3', '0', '3', '4182', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(284, 12, 491, 370, '3070', '4', '3', '1', '1435', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(285, 12, 496, 375, '3075', '1', '0', '1', '1394', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(286, 12, 504, 383, '3084', '2', '0', '2', '2788', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(287, 12, 511, 390, '3092', '0.5', '0', '0.5', '677', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(288, 12, 513, 392, '3094', '1', '0', '1', '1353', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(289, 12, 514, 393, '3095', '1', '0', '1', '1570', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(290, 12, 385, 310, '3003', '1', '0', '1', '2158', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(291, 12, 402, 327, '3020', '3.5', '2', '1.5', '3237', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(292, 12, 299, 408, '3111', '1', '0', '1', '1701', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(293, 12, 379, 412, '3115', '2', '0', '2', '4264', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(294, 12, 521, 419, '3123', '1', '0', '1', '1517', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(295, 12, 524, 422, '3126', '1', '0', '1', '1517', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(296, 12, 621, 501, '3215', '3', '2', '1', '1394', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(297, 12, 448, 580, '3322', '2.5', '2', '0.5', '605', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(298, 12, 447, 581, '3323', '2', '0', '2', '2420', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(299, 12, 446, 582, '3326', '5', '0', '5', '6050', '2025-05-26 15:00:56', '2025-05-28 11:40:55'),
(300, 12, 615, 507, '3223', '6', '2', '4', '7220', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(301, 12, 614, 508, '3226', '1', '0', '1', '1210', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(302, 12, 613, 509, '3227', '1', '0', '1', '1210', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(303, 12, 612, 510, '3229', '2', '0', '2', '2420', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(304, 12, 608, 514, '3233', '1', '0', '1', '1210', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(305, 12, 607, 515, '3234', '8', '0', '8', '9680', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(306, 12, 605, 517, '3236', '2.5', '0', '2.5', '3025', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(307, 12, 390, 315, '3008', '3.5', '3', '0.5', '741', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(308, 12, 397, 322, '3015', '3.5', '2', '1.5', '2222', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(309, 12, 410, 335, '3028', '4', '0', '4', '6279', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(310, 12, 412, 336, '3029', '4.5', '1', '3.5', '3997', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(311, 12, 530, 429, '3135', '3', '2', '1', '1208', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(312, 12, 531, 430, '3136', '4.5', '0', '4.5', '5445', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(313, 12, 535, 434, '3140', '3', '1', '2', '2420', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(314, 12, 596, 526, '3250', '5', '4', '1', '1210', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(315, 12, 595, 527, '3251', '6', '0', '6', '7260', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(316, 12, 586, 537, '3262', '1', '0', '1', '1394', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(317, 12, 580, 543, '3273', '1', '0', '1', '1210', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(318, 12, 441, 587, '3332', '1', '0', '1', '1552', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(319, 12, 440, 588, '3333', '1', '0', '1', '1605', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(320, 12, 439, 589, '3334', '1', '0', '1', '1476', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(321, 12, 436, 592, '3337', '3', '2', '1', '1476', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(322, 12, 432, 595, '3340', '4', '0', '4', '5740', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(323, 12, 429, 598, '3343', '1', '0', '1', '1142', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(324, 12, 428, 599, '3344', '1', '0', '1', '1142', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(325, 12, 427, 600, '3345', '1', '0', '1', '1142', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(326, 12, 426, 601, '3346', '1', '0', '1', '1142', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(327, 12, 559, 557, '3288', '2', '1', '1', '1481', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(328, 12, 557, 558, '3289', '2', '0', '2', '2284', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(329, 12, 624, 498, '3211', '1', '0', '1', '1394', '2025-05-26 15:00:57', '2025-05-28 11:40:55'),
(330, 12, 622, 500, '3213', '3', '1', '2', '2706', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(331, 12, 576, 547, '3277', '2', '0', '2', '2788', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(332, 12, 573, 550, '3280', '2', '0', '2', '2788', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(333, 12, 868, 551, '3281', '2', '0', '2', '3634', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(334, 12, 554, 560, '3292', '4', '0', '4', '5924', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(335, 12, 538, 437, '3145', '1.5', '0', '1.5', '2144', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(336, 12, 539, 438, '3146', '6', '0', '6', '8574', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(337, 12, 588, 535, '3260', '1.5', '0', '1.5', '1815', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(338, 12, 546, 564, '3300', '4', '0', '4', '4840', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(339, 12, 544, 565, '3302', '1', '0', '1', '1210', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(340, 12, 459, 567, '3305', '1', '0', '1', '1210', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(341, 12, 591, 531, '3256', '1', '0', '1', '1210', '2025-05-26 15:00:58', '2025-05-28 11:40:55'),
(342, 12, 89, 77, '1182', '3', '2', '1', '2042', '2025-05-28 11:05:14', '2025-05-28 11:40:55'),
(343, 12, 99, 82, '1192', '3', '0', '3', '5961', '2025-05-28 11:05:14', '2025-05-28 11:40:55'),
(344, 12, 109, 87, '1201', '4', '3', '1', '1813', '2025-05-28 11:05:14', '2025-05-28 11:40:55'),
(345, 12, 114, 89, '1205', '6', '4', '2', '3626', '2025-05-28 11:05:14', '2025-05-28 11:40:55'),
(346, 12, 122, 97, '1227', '3', '2', '1', '1987', '2025-05-28 11:05:14', '2025-05-28 11:40:55'),
(347, 12, 133, 106, '1240', '6', '0', '6', '10470', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(348, 12, 170, 126, '1270', '6', '4', '2', '4084', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(349, 12, 190, 134, '1288', '4', '1', '3', '5797', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(350, 12, 222, 148, '1307', '3', '2', '1', '2353', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(351, 12, 250, 156, '1319', '3', '1', '2', '3974', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(352, 12, 254, 157, '1321', '4', '3', '1', '1849', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(353, 12, 257, 158, '1322', '4', '2', '2', '3626', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(354, 12, 275, 163, '1331', '1', '0', '1', '1987', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(355, 12, 301, 170, '1348', '3.5', '3', '0.5', '650', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(356, 12, 320, 176, '1360', '3', '2', '1', '1877', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(357, 12, 347, 185, '1377', '2', '0', '2', '3178', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(358, 12, 349, 186, '1378', '5', '4', '1', '1650', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(359, 12, 351, 187, '1379', '2', '0', '2', '3108', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(360, 12, 359, 191, '1414', '2', '1', '1', '1731', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(361, 12, 382, 198, '1439', '4', '0', '4', '5236', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(362, 12, 383, 199, '1447', '3', '0', '3', '4540', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(363, 12, 664, 202, '1452', '6', '0', '6', '9080', '2025-05-28 11:05:15', '2025-05-28 11:40:55'),
(364, 12, 149, 217, '1514', '2', '0', '2', '2390', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(365, 12, 159, 221, '1519', '3', '0', '3', '4295', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(366, 12, 166, 224, '1523', '3', '0', '3', '4182', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(367, 12, 186, 230, '1534', '3.5', '3', '0.5', '694', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(368, 12, 198, 236, '1542', '4.5', '0', '4.5', '4646', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(369, 12, 212, 242, '1548', '3', '0', '3', '3835', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(370, 12, 214, 243, '1552', '5', '2', '3', '3825', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(371, 12, 218, 245, '1555', '2', '0', '2', '2482', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(372, 12, 231, 251, '1561', '4', '3', '1', '1241', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(373, 12, 232, 252, '1563', '4', '3', '1', '1207', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(374, 12, 240, 257, '1568', '3.5', '0', '3.5', '4223', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(375, 12, 278, 266, '1577', '5', '0', '5', '6034', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(376, 12, 290, 269, '1580', '2', '1', '1', '1173', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(377, 12, 358, 297, '1608', '0.5', '0', '0.5', '571', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(378, 12, 872, 927, '1621', '1.5', '0', '1.5', '1336', '2025-05-28 11:05:16', '2025-05-28 11:40:55'),
(379, 12, 44, 42, '1098', '2', '0', '2', '4840', '2025-05-28 11:05:17', '2025-05-28 11:40:55'),
(380, 12, 350, 293, '1604', '2', '0', '2', '2277', '2025-05-28 11:05:17', '2025-05-28 11:40:55'),
(381, 12, 329, 283, '1594', '2', '0', '2', '2345', '2025-05-28 11:05:17', '2025-05-28 11:40:55'),
(382, 12, 219, 146, '1305', '3', '1', '2', '3974', '2025-05-28 11:05:17', '2025-05-28 11:40:55'),
(383, 12, 926, 980, '5150', '7', '0', '7', '14628', '2025-05-28 11:05:18', '2025-05-28 11:40:55'),
(384, 12, 949, 1032, '5199', '10', '9', '1', '1579', '2025-05-28 11:05:18', '2025-05-28 11:40:55'),
(385, 12, 973, 1052, '5216', '1', '0', '1', '2090', '2025-05-28 11:05:18', '2025-05-28 11:40:55'),
(386, 12, 1019, 1094, '5249', '10', '0', '10', '15786', '2025-05-28 11:05:18', '2025-05-28 11:40:55'),
(387, 12, 1070, 1160, '5268', '10', '6', '4', '8359', '2025-05-28 11:05:18', '2025-05-28 11:40:55'),
(388, 12, 1087, 1177, '5283', '10', '1', '9', '18807', '2025-05-28 11:05:18', '2025-05-28 11:40:55'),
(389, 12, 312, 279, '1590', '2.5', '2', '0.5', '586', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(390, 12, 321, 621, '5023', '10', '0', '10', '14069', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(391, 12, 252, 638, '5040', '4', '3', '1', '2812', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(392, 12, 173, 656, '5058', '4', '0', '4', '11248', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(393, 12, 106, 664, '5066', '13', '2', '11', '15842', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(394, 12, 92, 669, '5071', '1', '0', '1', '2902', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(395, 12, 690, 682, '5090', '1', '0', '1', '1838', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(396, 12, 681, 709, '5104', '0.5', '0', '0.5', '700', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(397, 12, 964, 1045, '5209', '3', '1', '2', '2799', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(398, 12, 990, 1061, '5225', '1', '0', '1', '2090', '2025-05-28 11:05:19', '2025-05-28 11:40:55'),
(399, 12, 1023, 1090, '5245', '10', '0', '10', '40127', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(400, 12, 1016, 1097, '5252', '10', '0', '10', '13993', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(401, 12, 1014, 1099, '5254', '1', '0', '1', '1838', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(402, 12, 1009, 1106, '5261', '1', '0', '1', '2730', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(403, 12, 1064, 1153, '5264', '10', '0', '10', '25122', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(404, 12, 1065, 1154, '5266', '1', '0', '1', '1074', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(405, 12, 1083, 1161, '5273', '2.5', '2', '0.5', '1301', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(406, 12, 1076, 1165, '5279', '1', '0', '1', '1399', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(407, 12, 1089, 1179, '5287', '7', '6', '1', '1074', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(408, 12, 721, 803, '2049', '0.5', '0', '0.5', '1000', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(409, 12, 734, 743, '2042', '2', '1', '1', '1788', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(410, 12, 736, 749, '2045', '4', '0', '4', '4354', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(411, 12, 748, 772, '2087', '3.5', '1', '2.5', '4075', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(412, 12, 744, 781, '2110', '2', '0', '2', '2793', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(413, 12, 739, 800, '2120', '4', '0', '4', '4000', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(414, 12, 787, 824, '2142', '2', '0', '2', '3165', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(415, 12, 786, 823, '2143', '1', '0', '1', '1000', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(416, 12, 779, 816, '2148', '0.5', '0', '0.5', '1297', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(417, 12, 776, 813, '2151', '1', '0', '1', '1394', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(418, 12, 755, 811, '2155', '1', '0', '1', '1670', '2025-05-28 11:05:20', '2025-05-28 11:40:55'),
(419, 12, 761, 789, '2162', '1', '0', '1', '1000', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(420, 12, 762, 787, '2163', '0.5', '0', '0.5', '1295', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(421, 12, 768, 774, '2169', '2', '0', '2', '5383', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(422, 12, 769, 766, '2170', '0.5', '0', '0.5', '883', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(423, 12, 772, 758, '2173', '3', '0', '3', '5878', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(424, 12, 1003, 1110, '2180', '6', '4', '2', '4082', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(425, 12, 1007, 1117, '2184', '0.5', '0', '0.5', '1005', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(426, 12, 2, 2, '1003', '10', '0', '10', '34711', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(427, 12, 65, 62, '1149', '2', '0', '2', '3974', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(428, 12, 18, 19, '1047', '1', '0', '1', '2729', '2025-05-28 11:05:21', '2025-05-28 11:40:55'),
(429, 16, 452, 576, '3317', '1', '0', '1', '1171', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(430, 16, 451, 577, '3318', '4', '3', '1', '1171', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(431, 16, 395, 320, '3013', '1', '0', '1', '1759', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(432, 16, 633, 457, '3169', '1', '0', '1', '1898', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(433, 16, 634, 458, '3170', '1', '0', '1', '1468', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(434, 16, 639, 463, '3175', '3', '0', '3', '4168', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(435, 16, 641, 465, '3177', '2', '0', '2', '2936', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(436, 16, 642, 466, '3178', '2', '0', '2', '2856', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(437, 16, 644, 468, '3180', '4', '3', '1', '1468', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(438, 16, 645, 469, '3181', '1', '0', '1', '1468', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(439, 16, 648, 472, '3184', '1', '0', '1', '1349', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(440, 16, 653, 478, '3190', '2', '0', '2', '2698', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(441, 16, 654, 479, '3191', '3', '2', '1', '1349', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(442, 16, 655, 480, '3192', '1', '0', '1', '1349', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(443, 16, 656, 481, '3193', '6', '0', '6', '7224', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(444, 16, 658, 483, '3195', '5', '0', '5', '6745', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(445, 16, 659, 484, '3196', '4', '3', '1', '1349', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(446, 16, 666, 487, '3199', '1', '0', '1', '1349', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(447, 16, 472, 350, '3045', '4', '2', '2', '3494', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(448, 16, 473, 351, '3046', '3', '1', '2', '3107', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(449, 16, 381, 308, '3001', '3', '2', '1', '2965', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(450, 16, 484, 363, '3061', '1.5', '1', '0.5', '694', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(451, 16, 485, 364, '3062', '1', '0', '1', '1389', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(452, 16, 487, 366, '3065', '2.5', '2', '0.5', '694', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(453, 16, 488, 367, '3067', '11', '0', '11', '14840', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(454, 16, 490, 369, '3069', '2.5', '2', '0.5', '694', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(455, 16, 491, 370, '3070', '2.5', '1', '1.5', '2083', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(456, 16, 492, 371, '3071', '2', '1', '1', '1389', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(457, 16, 501, 380, '3080', '3', '0', '3', '4047', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(458, 16, 503, 382, '3082', '4', '0', '4', '5396', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(459, 16, 504, 383, '3084', '1', '0', '1', '1349', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(460, 16, 505, 384, '3085', '0.5', '0', '0.5', '675', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(461, 16, 508, 387, '3089', '1', '0', '1', '1309', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(462, 16, 509, 388, '3090', '0.5', '0', '0.5', '655', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(463, 16, 511, 390, '3092', '1', '0', '1', '1309', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(464, 16, 512, 391, '3093', '0.5', '0', '0.5', '655', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(465, 16, 513, 392, '3094', '0.5', '0', '0.5', '655', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(466, 16, 385, 310, '3003', '1.5', '0', '1.5', '3132', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(467, 16, 402, 327, '3020', '5.5', '5', '0.5', '1044', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(468, 16, 519, 398, '3100', '1', '0', '1', '2088', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(469, 16, 239, 401, '3103', '0.5', '0', '0.5', '1121', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(470, 16, 265, 403, '3105', '1', '0', '1', '2241', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(471, 16, 273, 404, '3106', '5', '0', '5', '11536', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(472, 16, 299, 408, '3111', '1.5', '0', '1.5', '2469', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(473, 16, 375, 411, '3114', '2', '1', '1', '2063', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(474, 16, 379, 412, '3115', '5', '0', '5', '10317', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(475, 16, 414, 415, '3118', '1', '0', '1', '1747', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(476, 16, 520, 417, '3121', '11', '0', '11', '18104', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(477, 16, 523, 421, '3125', '1', '0', '1', '1468', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(478, 16, 524, 422, '3126', '1', '0', '1', '1468', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(479, 16, 526, 424, '3129', '1', '0', '1', '1389', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(480, 16, 527, 425, '3130', '5', '2', '3', '4047', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(481, 16, 448, 580, '3322', '0.5', '0', '0.5', '586', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(482, 16, 447, 581, '3323', '5', '0', '5', '5855', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(483, 16, 446, 582, '3326', '8', '0', '8', '9368', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(484, 16, 615, 507, '3223', '4', '1', '3', '5240', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(485, 16, 614, 508, '3226', '3', '2', '1', '1171', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(486, 16, 612, 510, '3229', '2', '0', '2', '2342', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(487, 16, 610, 512, '3231', '11', '10', '1', '1171', '2025-06-26 12:48:32', '2025-06-27 07:07:22'),
(488, 16, 608, 514, '3233', '1', '0', '1', '1171', '2025-06-26 12:48:33', '2025-06-27 07:07:22'),
(489, 16, 607, 515, '3234', '9', '0', '9', '10539', '2025-06-26 12:48:33', '2025-06-27 07:07:22'),
(490, 16, 424, 603, '3380', '2', '1', '1', '1105', '2025-06-26 12:48:33', '2025-06-27 07:07:22'),
(491, 16, 388, 313, '3006', '3', '0', '3', '4557', '2025-06-26 12:48:33', '2025-06-27 07:07:22'),
(492, 16, 397, 322, '3015', '11', '0', '11', '15766', '2025-06-26 12:48:33', '2025-06-27 07:07:22'),
(493, 16, 531, 430, '3136', '3', '0', '3', '3513', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(494, 16, 532, 431, '3137', '1', '0', '1', '1171', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(495, 16, 535, 434, '3140', '3', '0', '3', '3513', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(496, 16, 599, 523, '3246', '6', '0', '6', '7026', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(497, 16, 596, 526, '3250', '11', '0', '11', '12881', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(498, 16, 595, 527, '3251', '8', '0', '8', '9368', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(499, 16, 594, 528, '3252', '3', '0', '3', '3513', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(500, 16, 586, 537, '3262', '0.5', '0', '0.5', '675', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(501, 16, 580, 543, '3273', '1', '0', '1', '1171', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(502, 16, 579, 544, '3274', '2', '0', '2', '2342', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(503, 16, 442, 586, '3331', '6.5', '6', '0.5', '754', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(504, 16, 441, 587, '3332', '11', '0', '11', '16580', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(505, 16, 440, 588, '3333', '1', '0', '1', '1553', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(506, 16, 439, 589, '3334', '1.5', '0', '1.5', '2142', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(507, 16, 438, 590, '3335', '6.5', '6', '0.5', '714', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(508, 16, 437, 591, '3336', '2', '0', '2', '2856', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(509, 16, 436, 592, '3337', '3.5', '0', '3.5', '4999', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(510, 16, 432, 595, '3340', '3', '0', '3', '4166', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(511, 16, 431, 596, '3341', '1', '0', '1', '1389', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(512, 16, 430, 597, '3342', '6', '5', '1', '1389', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(513, 16, 429, 598, '3343', '2.5', '0', '2.5', '2763', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(514, 16, 428, 599, '3344', '1.5', '0', '1.5', '1658', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(515, 16, 427, 600, '3345', '1.5', '0', '1.5', '1658', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(516, 16, 426, 601, '3346', '1', '0', '1', '1105', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(517, 16, 559, 557, '3288', '5.5', '3', '2.5', '3583', '2025-06-26 12:48:33', '2025-06-27 07:07:23');
INSERT INTO `verify_recovery_amounts` (`id`, `verify_attendance_id`, `employee_salary_id`, `employee_id`, `emp_code`, `no_of_days`, `leave`, `pay`, `amount`, `created_at`, `updated_at`) VALUES
(518, 16, 624, 498, '3211', '1', '0', '1', '1349', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(519, 16, 622, 500, '3213', '3', '2', '1', '1309', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(520, 16, 576, 547, '3277', '1', '0', '1', '1349', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(521, 16, 573, 550, '3280', '2.5', '0', '2.5', '3373', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(522, 16, 572, 552, '3282', '1', '0', '1', '1349', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(523, 16, 393, 318, '3011', '1', '0', '1', '1389', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(524, 16, 460, 337, '3030', '10', '0', '10', '17585', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(525, 16, 538, 437, '3145', '0.5', '0', '0.5', '694', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(526, 16, 539, 438, '3146', '6.5', '0', '6.5', '9026', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(527, 16, 549, 444, '3152', '7', '4', '3', '4166', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(528, 16, 882, 534, '3259', '11', '0', '11', '12518', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(529, 16, 546, 564, '3300', '2', '0', '2', '2342', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(530, 16, 544, 565, '3302', '2', '0', '2', '2342', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(531, 16, 555, 559, '3291', '1', '0', '1', '1105', '2025-06-26 12:48:33', '2025-06-27 07:07:23'),
(532, 16, 33, 34, '1086', '11', '0', '11', '17596', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(533, 16, 91, 78, '1184', '10', '0', '10', '19230', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(534, 16, 97, 81, '1191', '3', '1', '2', '4070', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(535, 16, 114, 89, '1205', '2', '0', '2', '3515', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(536, 16, 116, 91, '1221', '4', '0', '4', '7480', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(537, 16, 122, 97, '1227', '2', '0', '2', '3846', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(538, 16, 123, 98, '1229', '3', '0', '3', '5769', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(539, 16, 132, 105, '1239', '1', '0', '1', '1507', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(540, 16, 133, 106, '1240', '8', '1', '7', '11844', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(541, 16, 150, 118, '1258', '3', '0', '3', '5769', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(542, 16, 170, 126, '1270', '1', '0', '1', '1976', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(543, 16, 177, 130, '1279', '8', '0', '8', '15384', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(544, 16, 181, 132, '1285', '11', '0', '11', '16264', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(545, 16, 207, 141, '1299', '4', '0', '4', '8141', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(546, 16, 211, 143, '1301', '3', '1', '2', '3952', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(547, 16, 250, 156, '1319', '5', '2', '3', '5769', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(548, 16, 254, 157, '1321', '3', '2', '1', '1793', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(549, 16, 257, 158, '1322', '7', '6', '1', '1758', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(550, 16, 275, 163, '1331', '4', '0', '4', '7692', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(551, 16, 301, 170, '1348', '7', '0', '7', '8828', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(552, 16, 339, 182, '1373', '6', '5', '1', '1884', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(553, 16, 349, 186, '1378', '6', '4', '2', '3199', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(554, 16, 366, 194, '1430', '3.5', '3', '0.5', '1047', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(555, 16, 382, 198, '1439', '1.5', '1', '0.5', '635', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(556, 16, 383, 199, '1447', '6', '5', '1', '1468', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(557, 16, 664, 202, '1452', '7', '5', '2', '2936', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(558, 16, 85, 205, '1457', '7', '6', '1', '1428', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(559, 16, 88, 206, '1458', '3.5', '3', '0.5', '714', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(560, 16, 108, 210, '1504', '3', '2', '1', '1126', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(561, 16, 128, 211, '1505', '4', '0', '4', '5713', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(562, 16, 130, 212, '1509', '4', '3', '1', '1428', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(563, 16, 144, 215, '1512', '2', '1', '1', '1389', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(564, 16, 147, 216, '1513', '5.5', '3', '2.5', '3472', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(565, 16, 153, 219, '1517', '1.5', '1', '0.5', '694', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(566, 16, 164, 223, '1522', '1.5', '1', '0.5', '675', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(567, 16, 176, 226, '1530', '3.5', '3', '0.5', '675', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(568, 16, 186, 230, '1534', '5.5', '1', '4.5', '6071', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(569, 16, 198, 236, '1542', '5.5', '0', '5.5', '5513', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(570, 16, 203, 238, '1544', '6', '5', '1', '1237', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(571, 16, 212, 242, '1548', '5', '0', '5', '6185', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(572, 16, 218, 245, '1555', '5.5', '3', '2.5', '3010', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(573, 16, 229, 250, '1560', '1', '0', '1', '1204', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(574, 16, 231, 251, '1561', '1', '0', '1', '1204', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(575, 16, 232, 252, '1563', '3', '2', '1', '1171', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(576, 16, 236, 255, '1566', '4.5', '2', '2.5', '2928', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(577, 16, 264, 261, '1572', '2.5', '2', '0.5', '586', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(578, 16, 267, 262, '1573', '2.5', '2', '0.5', '586', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(579, 16, 270, 263, '1574', '3', '2', '1', '1171', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(580, 16, 278, 266, '1577', '6', '0', '6', '7026', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(581, 16, 290, 269, '1580', '6', '5', '1', '1138', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(582, 16, 365, 301, '1612', '1.5', '1', '0.5', '553', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(583, 16, 369, 303, '1614', '2', '0', '2', '3768', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(584, 16, 870, 918, '1619', '1', '0', '1', '1039', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(585, 16, 872, 927, '1621', '2', '1', '1', '862', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(586, 16, 1059, 1147, '1636', '2', '1', '1', '1039', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(587, 16, 1092, 1189, '1641', '1', '0', '1', '1039', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(588, 16, 13, 14, '1040', '2', '0', '2', '3952', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(589, 16, 14, 15, '1041', '3', '2', '1', '2181', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(590, 16, 44, 42, '1098', '1', '0', '1', '2342', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(591, 16, 350, 293, '1604', '2', '0', '2', '2276', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(592, 16, 329, 283, '1594', '1', '0', '1', '1138', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(593, 16, 219, 146, '1305', '3', '1', '2', '3846', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(594, 16, 795, 832, '101021', '3', '0', '3', '5497', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(595, 16, 986, 1010, '5179', '11', '9', '2', '3055', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(596, 16, 960, 1043, '5207', '11', '9', '2', '3055', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(597, 16, 1019, 1094, '5249', '11', '0', '11', '16805', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(598, 16, 419, 608, '5010', '5', '4', '1', '2721', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(599, 16, 158, 658, '5060', '2.5', '2', '0.5', '1041', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(600, 16, 106, 664, '5066', '11', '0', '11', '15331', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(601, 16, 677, 705, '5086', '2', '1', '1', '1354', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(602, 16, 697, 696, '5092', '11', '10', '1', '1354', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(603, 16, 669, 685, '5099', '11', '3', '8', '10833', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(604, 16, 687, 701, '5108', '2', '0', '2', '5284', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(605, 16, 668, 681, '5110', '2', '0', '2', '2708', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(606, 16, 933, 987, '5158', '2.5', '2', '0.5', '1055', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(607, 16, 956, 1038, '5203', '2', '0', '2', '2708', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(608, 16, 974, 1053, '5217', '6', '0', '6', '8125', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(609, 16, 1020, 1093, '5248', '6.5', '1', '5.5', '7448', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(610, 16, 1014, 1099, '5254', '11', '0', '11', '19561', '2025-06-26 12:48:34', '2025-06-27 07:07:23'),
(611, 16, 1065, 1154, '5266', '7', '5', '2', '2078', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(612, 16, 1083, 1161, '5273', '7.5', '6', '1.5', '3777', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(613, 16, 1089, 1179, '5287', '10', '0', '10', '10391', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(614, 16, 1038, 1074, '1629', '3.5', '3', '0.5', '520', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(615, 16, 734, 743, '2042', '5', '0', '5', '8651', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(616, 16, 736, 749, '2045', '1', '0', '1', '1053', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(617, 16, 753, 756, '2056', '3.5', '0', '3.5', '3387', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(618, 16, 751, 763, '2061', '6', '4', '2', '1935', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(619, 16, 749, 769, '2084', '2', '1', '1', '1891', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(620, 16, 748, 772, '2087', '1.5', '0', '1.5', '2366', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(621, 16, 747, 777, '2091', '3', '0', '3', '2903', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(622, 16, 739, 800, '2120', '2.5', '0', '2.5', '2419', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(623, 16, 788, 826, '2130', '1', '0', '1', '1833', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(624, 16, 793, 830, '2136', '3', '0', '3', '5111', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(625, 16, 786, 823, '2143', '1', '0', '1', '968', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(626, 16, 785, 820, '2145', '1', '0', '1', '1902', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(627, 16, 761, 789, '2162', '10', '0', '10', '9677', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(628, 16, 766, 780, '2167', '1', '0', '1', '1660', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(629, 16, 768, 774, '2169', '2', '0', '2', '5210', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(630, 16, 772, 758, '2173', '6', '0', '6', '11377', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(631, 16, 1005, 1115, '2182', '1.5', '0', '1.5', '3977', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(632, 16, 1006, 1116, '2183', '6', '5', '1', '2254', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(633, 16, 1007, 1117, '2184', '2.5', '0', '2.5', '4862', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(634, 16, 5, 6, '1019', '4', '0', '4', '12642', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(635, 16, 65, 62, '1149', '4', '2', '2', '3846', '2025-06-26 12:48:35', '2025-06-27 07:07:23'),
(636, 18, 89, 77, '1182', '1', '0', '1', '2042', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(637, 18, 91, 78, '1184', '10', '0', '10', '19871', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(638, 18, 105, 85, '1198', '2.5', '1', '1.5', '3155', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(639, 18, 109, 87, '1201', '4', '3', '1', '1816', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(640, 18, 118, 93, '1223', '2.5', '2', '0.5', '908', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(641, 18, 121, 96, '1226', '1', '0', '1', '1653', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(642, 18, 140, 111, '1249', '1', '0', '1', '1589', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(643, 18, 150, 118, '1258', '6', '5', '1', '1987', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(644, 18, 242, 151, '1310', '1', '0', '1', '1987', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(645, 18, 248, 155, '1318', '2', '0', '2', '3086', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(646, 18, 250, 156, '1319', '6', '4', '2', '3974', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(647, 18, 257, 158, '1322', '6', '4', '2', '3633', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(648, 18, 271, 162, '1330', '5', '4', '1', '1805', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(649, 18, 336, 180, '1370', '1.5', '0', '1.5', '3197', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(650, 18, 349, 186, '1378', '4', '3', '1', '1653', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(651, 18, 359, 191, '1414', '5', '4', '1', '1731', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(652, 18, 366, 194, '1430', '1.5', '1', '0.5', '1082', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(653, 18, 374, 196, '1433', '5.5', '5', '0.5', '779', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(654, 18, 383, 199, '1447', '8', '7', '1', '1517', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(655, 18, 56, 200, '1448', '10', '0', '10', '15167', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(656, 18, 102, 209, '1503', '1', '0', '1', '1476', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(657, 18, 130, 212, '1509', '1', '0', '1', '1476', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(658, 18, 149, 217, '1514', '1', '0', '1', '1199', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(659, 18, 166, 224, '1523', '2', '0', '2', '2788', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(660, 18, 185, 229, '1533', '5', '4', '1', '1164', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(661, 18, 193, 233, '1539', '1.5', '1', '0.5', '639', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(662, 18, 198, 236, '1542', '4', '0', '4', '4143', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(663, 18, 212, 242, '1548', '2', '1', '1', '1278', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(664, 18, 278, 266, '1577', '2', '0', '2', '2420', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(665, 18, 290, 269, '1580', '2', '1', '1', '1176', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(666, 18, 358, 297, '1608', '2.5', '2', '0.5', '571', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(667, 18, 870, 918, '1619', '1', '0', '1', '1074', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(668, 18, 872, 927, '1621', '3.5', '1', '2.5', '2226', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(669, 18, 1060, 1148, '1639', '0.5', '0', '0.5', '537', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(670, 18, 219, 146, '1305', '3', '0', '3', '5961', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(671, 18, 340, 288, '1599', '1', '0', '1', '1176', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(672, 18, 362, 299, '1610', '1.5', '1', '0.5', '571', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(673, 18, 796, 833, '101022', '3', '0', '3', '8736', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(674, 18, 894, 944, '5123', '10', '0', '10', '20897', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(675, 18, 930, 984, '5154', '10', '0', '10', '15786', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(676, 18, 987, 1011, '5180', '2', '1', '1', '2090', '2025-07-25 07:58:59', '2025-07-25 11:48:25'),
(677, 18, 959, 1042, '5206', '10', '0', '10', '15786', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(678, 18, 1008, 1082, '5237', '1', '0', '1', '1579', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(679, 18, 1019, 1094, '5249', '10', '0', '10', '15786', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(680, 18, 1015, 1098, '5253', '1', '0', '1', '1587', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(681, 18, 305, 275, '1586', '3', '2', '1', '1522', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(682, 18, 321, 621, '5023', '8', '0', '8', '11255', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(683, 18, 247, 640, '5042', '5', '0', '5', '7201', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(684, 18, 202, 649, '5051', '1', '0', '1', '1440', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(685, 18, 106, 664, '5066', '5', '0', '5', '7201', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(686, 18, 677, 705, '5086', '3', '2', '1', '1399', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(687, 18, 690, 682, '5090', '1', '0', '1', '1892', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(688, 18, 697, 696, '5092', '5', '0', '5', '6997', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(689, 18, 669, 685, '5099', '5', '0', '5', '6997', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(690, 18, 1073, 1137, '5229', '1', '0', '1', '2730', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(691, 18, 1020, 1093, '5248', '5', '0', '5', '6997', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(692, 18, 1065, 1154, '5266', '1.5', '1', '0.5', '537', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(693, 18, 1076, 1165, '5279', '5.5', '4', '1.5', '2099', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(694, 18, 1089, 1179, '5287', '10', '0', '10', '10738', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(695, 18, 1098, 1195, '5293', '10', '1', '9', '18807', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(696, 18, 1115, 1215, '5297', '1', '0', '1', '2948', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(697, 18, 1118, 1209, '1649', '1', '0', '1', '2949', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(698, 18, 752, 759, '2060', '2', '1', '1', '1000', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(699, 18, 748, 772, '2087', '1.5', '0', '1.5', '2445', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(700, 18, 787, 824, '2142', '5', '2', '3', '4748', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(701, 18, 785, 820, '2145', '1', '0', '1', '1965', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(702, 18, 754, 812, '2152', '7.5', '4', '3.5', '5666', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(703, 18, 772, 758, '2173', '1', '0', '1', '1959', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(704, 18, 1007, 1117, '2184', '1.5', '0', '1.5', '3014', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(705, 18, 65, 62, '1149', '3', '2', '1', '1987', '2025-07-25 07:59:00', '2025-07-25 11:48:25'),
(706, 18, 639, 463, '3175', '10', '0', '10', '14357', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(707, 18, 642, 466, '3178', '2', '0', '2', '2952', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(708, 18, 645, 469, '3181', '1', '0', '1', '1517', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(709, 18, 880, 473, '3185', '3', '1', '2', '2788', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(710, 18, 652, 477, '3189', '4', '2', '2', '2788', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(711, 18, 653, 478, '3190', '1', '0', '1', '1394', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(712, 18, 654, 479, '3191', '3', '1', '2', '2788', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(713, 18, 656, 481, '3193', '6', '5', '1', '1244', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(714, 18, 658, 483, '3195', '1', '0', '1', '1394', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(715, 18, 659, 484, '3196', '9', '7', '2', '2788', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(716, 18, 661, 486, '3198', '1', '0', '1', '1394', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(717, 18, 666, 487, '3199', '3', '0', '3', '4182', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(718, 18, 472, 350, '3045', '2', '0', '2', '3610', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(719, 18, 478, 357, '3055', '0.5', '0', '0.5', '1242', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(720, 18, 481, 360, '3058', '4', '0', '4', '7411', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(721, 18, 491, 370, '3070', '3', '0', '3', '4305', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(722, 18, 492, 371, '3071', '1', '0', '1', '1435', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(723, 18, 497, 376, '3076', '4', '3', '1', '1394', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(724, 18, 501, 380, '3080', '5', '4', '1', '1394', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(725, 18, 504, 383, '3084', '2', '0', '2', '2788', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(726, 18, 508, 387, '3089', '1', '0', '1', '1353', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(727, 18, 510, 389, '3091', '5', '0', '5', '6766', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(728, 18, 511, 390, '3092', '1', '0', '1', '1353', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(729, 18, 386, 311, '3004', '4', '3', '1', '2097', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(730, 18, 402, 327, '3020', '2', '0', '2', '4316', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(731, 18, 239, 401, '3103', '1.5', '0', '1.5', '3474', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(732, 18, 281, 405, '3107', '2', '0', '2', '3610', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(733, 18, 375, 411, '3114', '1', '0', '1', '2132', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(734, 18, 379, 412, '3115', '1', '0', '1', '2132', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(735, 18, 520, 417, '3121', '4', '0', '4', '6803', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(736, 18, 521, 419, '3123', '1', '0', '1', '1517', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(737, 18, 527, 425, '3130', '3', '0', '3', '4182', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(738, 18, 618, 504, '3219', '1', '0', '1', '2485', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(739, 18, 614, 508, '3226', '2', '0', '2', '2420', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(740, 18, 613, 509, '3227', '1', '0', '1', '1210', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(741, 18, 612, 510, '3229', '2', '0', '2', '2420', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(742, 18, 607, 515, '3234', '5', '0', '5', '6050', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(743, 18, 397, 322, '3015', '4', '0', '4', '5924', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(744, 18, 532, 431, '3137', '4', '0', '4', '4840', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(745, 18, 603, 519, '3239', '3', '0', '3', '4427', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(746, 18, 600, 522, '3244', '1', '0', '1', '1210', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(747, 18, 596, 526, '3250', '1', '0', '1', '1210', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(748, 18, 595, 527, '3251', '6', '0', '6', '7260', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(749, 18, 583, 540, '3269', '1', '0', '1', '1394', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(750, 18, 580, 543, '3273', '2', '0', '2', '2420', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(751, 18, 436, 592, '3337', '1', '0', '1', '1476', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(752, 18, 432, 595, '3340', '4', '0', '4', '5740', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(753, 18, 431, 596, '3341', '2', '0', '2', '2870', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(754, 18, 429, 598, '3343', '1', '0', '1', '1142', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(755, 18, 428, 599, '3344', '1', '0', '1', '1142', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(756, 18, 623, 499, '3212', '3', '1', '2', '3705', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(757, 18, 572, 552, '3282', '2', '0', '2', '2788', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(758, 18, 882, 534, '3259', '10', '0', '10', '11760', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(759, 18, 555, 559, '3291', '1', '0', '1', '1142', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(760, 18, 590, 532, '3257', '0.5', '0', '0.5', '605', '2025-07-25 07:59:01', '2025-07-25 11:48:25'),
(761, 20, 826, 888, '203', '4', '0', '4', '16504', '2025-07-25 11:13:00', '2025-07-25 11:13:00'),
(762, 20, 830, 884, '211', '2', '1', '1', '4010.1', '2025-07-25 11:13:00', '2025-07-25 11:13:00'),
(763, 20, 801, 838, '601', '1', '0', '1', '4209.9', '2025-07-25 11:13:00', '2025-07-25 11:13:00'),
(764, 20, 1053, 1133, '910', '8', '0', '8', '4266.6666666667', '2025-07-25 11:13:00', '2025-07-25 11:13:00');

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

--
-- Table structure for table `wards`
--

CREATE TABLE `wards` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `initial` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_corporation` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `deleted_by` bigint 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 `wards`
--

INSERT INTO `wards` (`id`, `name`, `initial`, `is_corporation`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'MUNICIPAL CORPORATION', 'MUNICIPAL CORPORATION', 1, NULL, 1, NULL, '2024-08-08 12:23:11', '2025-02-25 11:36:36', NULL),
(2, 'MAHARASHTRA GOVT', 'MAHARASHTRA GOVT', 1, NULL, 1, NULL, '2024-08-08 12:23:11', '2025-02-25 11:37:17', NULL),
(3, 'EDUCATION', 'Education', 0, 1, 1, NULL, '2024-09-19 05:04:45', '2024-09-19 05:05:24', NULL),
(4, 'TOWN PLANNING', 'TOWN PLANNING', 1, 1, 1, NULL, '2024-09-19 05:05:08', '2025-02-25 11:37:07', NULL),
(5, 'REMUNERATION', 'REMUNERATION', 1, 1, 1, NULL, '2024-09-19 05:05:51', '2025-02-25 11:36:55', NULL),
(6, 'NULM', 'NULM', 1, 1, 1, NULL, '2024-09-19 05:06:17', '2025-02-25 11:36:45', NULL),
(7, 'PMAY', 'PMAY', 1, 1, 1, NULL, '2024-09-19 05:07:35', '2025-02-25 11:36:26', NULL);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `academic_details`
--
ALTER TABLE `academic_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `academic_details_employee_id_foreign` (`employee_id`),
  ADD KEY `academic_details_created_by_foreign` (`created_by`),
  ADD KEY `academic_details_updated_by_foreign` (`updated_by`),
  ADD KEY `academic_details_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `add_employee_leaves`
--
ALTER TABLE `add_employee_leaves`
  ADD PRIMARY KEY (`id`),
  ADD KEY `add_employee_leaves_employee_id_foreign` (`employee_id`),
  ADD KEY `add_employee_leaves_leave_type_id_foreign` (`leave_type_id`),
  ADD KEY `add_employee_leaves_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `add_employee_leaves_created_by_foreign` (`created_by`),
  ADD KEY `add_employee_leaves_updated_by_foreign` (`updated_by`),
  ADD KEY `add_employee_leaves_deleted_by_foreign` (`deleted_by`),
  ADD KEY `from_date` (`from_date`),
  ADD KEY `to_date` (`to_date`),
  ADD KEY `Emp_Code` (`Emp_Code`);

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

--
-- Indexes for table `allowances`
--
ALTER TABLE `allowances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `allowances_created_by_foreign` (`created_by`),
  ADD KEY `allowances_updated_by_foreign` (`updated_by`),
  ADD KEY `allowances_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `assign_supplimentry_users`
--
ALTER TABLE `assign_supplimentry_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assign_supplimentry_users_add_employee_leave_id_foreign` (`add_employee_leave_id`);

--
-- Indexes for table `attendances`
--
ALTER TABLE `attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attendances_employee_id_foreign` (`employee_id`),
  ADD KEY `attendances_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `attendances_created_by_foreign` (`created_by`),
  ADD KEY `attendances_updated_by_foreign` (`updated_by`),
  ADD KEY `attendances_deleted_by_foreign` (`deleted_by`),
  ADD KEY `Emp_Code` (`Emp_Code`),
  ADD KEY `from_date` (`from_date`),
  ADD KEY `to_date` (`to_date`);

--
-- Indexes for table `attendance_excel_backups`
--
ALTER TABLE `attendance_excel_backups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attendance_excel_backups_attendance_id_foreign` (`attendance_id`),
  ADD KEY `attendance_excel_backups_employee_id_foreign` (`employee_id`),
  ADD KEY `attendance_excel_backups_financial_year_id_foreign` (`financial_year_id`);

--
-- Indexes for table `attendance_excel_crons`
--
ALTER TABLE `attendance_excel_crons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attendance_excel_crons_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `attendance_excel_crons_created_by_foreign` (`created_by`),
  ADD KEY `attendance_excel_crons_updated_by_foreign` (`updated_by`),
  ADD KEY `attendance_excel_crons_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `banks`
--
ALTER TABLE `banks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `banks_created_by_foreign` (`created_by`),
  ADD KEY `banks_updated_by_foreign` (`updated_by`),
  ADD KEY `banks_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `clas`
--
ALTER TABLE `clas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clas_created_by_foreign` (`created_by`),
  ADD KEY `clas_updated_by_foreign` (`updated_by`),
  ADD KEY `clas_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `corporations`
--
ALTER TABLE `corporations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `corporations_created_by_foreign` (`created_by`),
  ADD KEY `corporations_updated_by_foreign` (`updated_by`),
  ADD KEY `corporations_deleted_by_foreign` (`deleted_by`);

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

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

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

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

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

--
-- Indexes for table `date_wise_work_sheets`
--
ALTER TABLE `date_wise_work_sheets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `date_wise_work_sheets_employee_id_foreign` (`employee_id`);

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

--
-- Indexes for table `da_bill_calculates`
--
ALTER TABLE `da_bill_calculates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `da_bill_calculates_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `da_bill_calculates_da_bill_id_foreign` (`da_bill_id`),
  ADD KEY `da_bill_calculates_ward_id_foreign` (`ward_id`),
  ADD KEY `da_bill_calculates_department_id_foreign` (`department_id`),
  ADD KEY `da_bill_calculates_designation_id_foreign` (`designation_id`),
  ADD KEY `da_bill_calculates_freeze_attendance_id_foreign` (`freeze_attendance_id`);

--
-- Indexes for table `da_differances`
--
ALTER TABLE `da_differances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `da_differances_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `da_differances_created_by_foreign` (`created_by`),
  ADD KEY `da_differances_updated_by_foreign` (`updated_by`),
  ADD KEY `da_differances_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `deductions`
--
ALTER TABLE `deductions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deductions_created_by_foreign` (`created_by`),
  ADD KEY `deductions_updated_by_foreign` (`updated_by`),
  ADD KEY `deductions_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `departments_ward_id_foreign` (`ward_id`),
  ADD KEY `departments_created_by_foreign` (`created_by`),
  ADD KEY `departments_updated_by_foreign` (`updated_by`),
  ADD KEY `departments_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `designations`
--
ALTER TABLE `designations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `designations_ward_id_foreign` (`ward_id`),
  ADD KEY `designations_department_id_foreign` (`department_id`),
  ADD KEY `designations_clas_id_foreign` (`clas_id`),
  ADD KEY `designations_created_by_foreign` (`created_by`),
  ADD KEY `designations_updated_by_foreign` (`updated_by`),
  ADD KEY `designations_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `documents_created_by_foreign` (`created_by`),
  ADD KEY `documents_updated_by_foreign` (`updated_by`),
  ADD KEY `documents_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employees_ward_id_foreign` (`ward_id`),
  ADD KEY `employees_department_id_foreign` (`department_id`),
  ADD KEY `employees_clas_id_foreign` (`clas_id`),
  ADD KEY `employees_designation_id_foreign` (`designation_id`),
  ADD KEY `employees_bank_id_foreign` (`bank_id`),
  ADD KEY `employees_created_by_foreign` (`created_by`),
  ADD KEY `employees_updated_by_foreign` (`updated_by`),
  ADD KEY `employees_deleted_by_foreign` (`deleted_by`),
  ADD KEY `employees_status_id_foreign` (`status_id`),
  ADD KEY `employee_id` (`employee_id`);

--
-- Indexes for table `employee_allowances`
--
ALTER TABLE `employee_allowances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_allowances_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_allowances_employee_salary_id_foreign` (`employee_salary_id`),
  ADD KEY `employee_allowances_allowance_id_foreign` (`allowance_id`),
  ADD KEY `employee_allowances_created_by_foreign` (`created_by`),
  ADD KEY `employee_allowances_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_allowances_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_da_differances`
--
ALTER TABLE `employee_da_differances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_da_differances_da_differance_id_foreign` (`da_differance_id`),
  ADD KEY `employee_da_differances_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_da_differances_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `employee_da_differances_created_by_foreign` (`created_by`),
  ADD KEY `employee_da_differances_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_da_differances_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_deductions`
--
ALTER TABLE `employee_deductions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_deductions_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_deductions_employee_salary_id_foreign` (`employee_salary_id`),
  ADD KEY `employee_deductions_deduction_id_foreign` (`deduction_id`),
  ADD KEY `employee_deductions_created_by_foreign` (`created_by`),
  ADD KEY `employee_deductions_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_deductions_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_details`
--
ALTER TABLE `employee_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `employee_details_emp_id_unique` (`emp_id`),
  ADD UNIQUE KEY `employee_details_aadhar_unique` (`aadhar`),
  ADD UNIQUE KEY `employee_details_pan_unique` (`pan`),
  ADD UNIQUE KEY `employee_details_email_unique` (`email`),
  ADD UNIQUE KEY `employee_details_gov_email_unique` (`gov_email`),
  ADD KEY `employee_details_employee_id_foreign` (`employee_id`);

--
-- Indexes for table `employee_festival_advances`
--
ALTER TABLE `employee_festival_advances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_festival_advances_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_festival_advances_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `employee_festival_advances_created_by_foreign` (`created_by`),
  ADD KEY `employee_festival_advances_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_festival_advances_deleted_by_foreign` (`deleted_by`);

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

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

--
-- Indexes for table `employee_leaves`
--
ALTER TABLE `employee_leaves`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_leaves_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_leaves_leave_type_id_foreign` (`leave_type_id`),
  ADD KEY `employee_leaves_created_by_foreign` (`created_by`),
  ADD KEY `employee_leaves_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_leaves_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_loans`
--
ALTER TABLE `employee_loans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_loans_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_loans_loan_id_foreign` (`loan_id`),
  ADD KEY `employee_loans_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `employee_loans_created_by_foreign` (`created_by`),
  ADD KEY `employee_loans_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_loans_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_monthly_festival_advances`
--
ALTER TABLE `employee_monthly_festival_advances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_monthly_festival_advances_employee_id_foreign` (`employee_id`),
  ADD KEY `festival_advance_id` (`employee_festival_advance_id`),
  ADD KEY `employee_monthly_festival_advances_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `employee_monthly_festival_advances_created_by_foreign` (`created_by`),
  ADD KEY `employee_monthly_festival_advances_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_monthly_festival_advances_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_monthly_lics`
--
ALTER TABLE `employee_monthly_lics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_monthly_lics_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_monthly_lics_lic_deduction_id_foreign` (`lic_deduction_id`),
  ADD KEY `employee_monthly_lics_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `employee_monthly_lics_created_by_foreign` (`created_by`),
  ADD KEY `employee_monthly_lics_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_monthly_lics_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_monthly_loans`
--
ALTER TABLE `employee_monthly_loans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_monthly_loans_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_monthly_loans_employee_loan_id_foreign` (`employee_loan_id`),
  ADD KEY `employee_monthly_loans_loan_id_foreign` (`loan_id`),
  ADD KEY `employee_monthly_loans_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `employee_monthly_loans_created_by_foreign` (`created_by`),
  ADD KEY `employee_monthly_loans_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_monthly_loans_deleted_by_foreign` (`deleted_by`);

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

--
-- Indexes for table `employee_provident_funds`
--
ALTER TABLE `employee_provident_funds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_provident_funds_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_provident_funds_created_by_foreign` (`created_by`),
  ADD KEY `employee_provident_funds_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_provident_funds_deleted_by_foreign` (`deleted_by`),
  ADD KEY `employee_provident_funds_financial_year_id_foreign` (`financial_year_id`);

--
-- Indexes for table `employee_salaries`
--
ALTER TABLE `employee_salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_salaries_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_salaries_pay_scale_id_foreign` (`pay_scale_id`),
  ADD KEY `employee_salaries_created_by_foreign` (`created_by`),
  ADD KEY `employee_salaries_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_salaries_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_salary_structures`
--
ALTER TABLE `employee_salary_structures`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_salary_structures_freeze_attendance_id_foreign` (`freeze_attendance_id`);

--
-- Indexes for table `employee_statuses`
--
ALTER TABLE `employee_statuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_statuses_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_statuses_status_id_foreign` (`status_id`),
  ADD KEY `employee_statuses_created_by_foreign` (`created_by`),
  ADD KEY `employee_statuses_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_statuses_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `employee_transfers`
--
ALTER TABLE `employee_transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_transfers_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_transfers_ward_id_foreign` (`ward_id`),
  ADD KEY `employee_transfers_department_id_foreign` (`department_id`),
  ADD KEY `employee_transfers_clas_id_foreign` (`clas_id`),
  ADD KEY `employee_transfers_designation_id_foreign` (`designation_id`),
  ADD KEY `employee_transfers_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `employee_transfers_created_by_foreign` (`created_by`),
  ADD KEY `employee_transfers_updated_by_foreign` (`updated_by`),
  ADD KEY `employee_transfers_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `experiences`
--
ALTER TABLE `experiences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `experiences_employee_id_foreign` (`employee_id`),
  ADD KEY `experiences_created_by_foreign` (`created_by`),
  ADD KEY `experiences_updated_by_foreign` (`updated_by`),
  ADD KEY `experiences_deleted_by_foreign` (`deleted_by`);

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

--
-- Indexes for table `financial_years`
--
ALTER TABLE `financial_years`
  ADD PRIMARY KEY (`id`),
  ADD KEY `financial_years_created_by_foreign` (`created_by`),
  ADD KEY `financial_years_updated_by_foreign` (`updated_by`),
  ADD KEY `financial_years_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `freeze_attendances`
--
ALTER TABLE `freeze_attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeze_attendances_employee_id_foreign` (`employee_id`),
  ADD KEY `freeze_attendances_ward_id_foreign` (`ward_id`),
  ADD KEY `freeze_attendances_department_id_foreign` (`department_id`),
  ADD KEY `freeze_attendances_designation_id_foreign` (`designation_id`),
  ADD KEY `freeze_attendances_clas_id_foreign` (`clas_id`),
  ADD KEY `freeze_attendances_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `freeze_attendances_created_by_foreign` (`created_by`),
  ADD KEY `freeze_attendances_updated_by_foreign` (`updated_by`),
  ADD KEY `freeze_attendances_deleted_by_foreign` (`deleted_by`),
  ADD KEY `Emp_Code` (`Emp_Code`),
  ADD KEY `freeze_status` (`freeze_status`);

--
-- Indexes for table `freeze_crons`
--
ALTER TABLE `freeze_crons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeze_crons_ward_id_foreign` (`ward_id`),
  ADD KEY `freeze_crons_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `freeze_crons_created_by_foreign` (`created_by`),
  ADD KEY `freeze_crons_updated_by_foreign` (`updated_by`),
  ADD KEY `freeze_crons_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `freeze_pensions`
--
ALTER TABLE `freeze_pensions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeze_pensions_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `freeze_pensions_employee_id_foreign` (`employee_id`),
  ADD KEY `freeze_pensions_pension_bank_id_foreign` (`pension_bank_id`),
  ADD KEY `freeze_pensions_created_by_foreign` (`created_by`),
  ADD KEY `freeze_pensions_updated_by_foreign` (`updated_by`),
  ADD KEY `freeze_pensions_deleted_by_foreign` (`deleted_by`);

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

--
-- Indexes for table `freeze_pension_news`
--
ALTER TABLE `freeze_pension_news`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeze_pension_news_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `freeze_pension_news_employee_id_foreign` (`employee_id`),
  ADD KEY `freeze_pension_news_pension_bank_id_foreign` (`pension_bank_id`),
  ADD KEY `freeze_pension_news_created_by_foreign` (`created_by`),
  ADD KEY `freeze_pension_news_updated_by_foreign` (`updated_by`),
  ADD KEY `freeze_pension_news_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `gpf_closing_forms`
--
ALTER TABLE `gpf_closing_forms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gpf_closing_forms_pf_opening_balance_id_foreign` (`pf_opening_balance_id`),
  ADD KEY `gpf_closing_forms_created_by_foreign` (`created_by`),
  ADD KEY `gpf_closing_forms_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `gpf_closing_summary`
--
ALTER TABLE `gpf_closing_summary`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gpf_closing_summary_pf_opening_balance_id_foreign` (`pf_opening_balance_id`),
  ADD KEY `gpf_closing_summary_created_by_foreign` (`created_by`),
  ADD KEY `gpf_closing_summary_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `important_documents`
--
ALTER TABLE `important_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `important_documents_employee_id_foreign` (`employee_id`),
  ADD KEY `important_documents_document_id_foreign` (`document_id`),
  ADD KEY `important_documents_created_by_foreign` (`created_by`),
  ADD KEY `important_documents_updated_by_foreign` (`updated_by`),
  ADD KEY `important_documents_deleted_by_foreign` (`deleted_by`);

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

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

--
-- Indexes for table `income_tax`
--
ALTER TABLE `income_tax`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Emp_Code_FY` (`Emp_Code`,`financial_year_id`),
  ADD KEY `income_tax_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `income_tax_created_by_foreign` (`created_by`),
  ADD KEY `income_tax_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `increment_allowance_salaries`
--
ALTER TABLE `increment_allowance_salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `increment_allowance_salaries_allowance_id_foreign` (`allowance_id`),
  ADD KEY `increment_allowance_salaries_created_by_foreign` (`created_by`),
  ADD KEY `increment_allowance_salaries_updated_by_foreign` (`updated_by`),
  ADD KEY `increment_allowance_salaries_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `increment_basic_salaries`
--
ALTER TABLE `increment_basic_salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `increment_basic_salaries_created_by_foreign` (`created_by`),
  ADD KEY `increment_basic_salaries_updated_by_foreign` (`updated_by`),
  ADD KEY `increment_basic_salaries_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `increment_deductions_salaries`
--
ALTER TABLE `increment_deductions_salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `increment_deductions_salaries_deduction_id_foreign` (`deduction_id`),
  ADD KEY `increment_deductions_salaries_created_by_foreign` (`created_by`),
  ADD KEY `increment_deductions_salaries_updated_by_foreign` (`updated_by`),
  ADD KEY `increment_deductions_salaries_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `leave_counts`
--
ALTER TABLE `leave_counts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `leave_counts_clas_id_foreign` (`clas_id`),
  ADD KEY `leave_counts_leave_type_id_foreign` (`leave_type_id`);

--
-- Indexes for table `leave_types`
--
ALTER TABLE `leave_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `leave_types_created_by_foreign` (`created_by`),
  ADD KEY `leave_types_updated_by_foreign` (`updated_by`),
  ADD KEY `leave_types_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `letterdigitalworks`
--
ALTER TABLE `letterdigitalworks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `letterdigitalworks_employee_id_foreign` (`employee_id`);

--
-- Indexes for table `lic_deductions`
--
ALTER TABLE `lic_deductions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lic_deductions_employee_id_foreign` (`employee_id`),
  ADD KEY `lic_deductions_created_by_foreign` (`created_by`),
  ADD KEY `lic_deductions_updated_by_foreign` (`updated_by`),
  ADD KEY `lic_deductions_deleted_by_foreign` (`deleted_by`),
  ADD KEY `lic_deductions_financial_year_id_foreign` (`financial_year_id`);

--
-- Indexes for table `loans`
--
ALTER TABLE `loans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loans_created_by_foreign` (`created_by`),
  ADD KEY `loans_updated_by_foreign` (`updated_by`),
  ADD KEY `loans_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  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 `nps_closing_forms`
--
ALTER TABLE `nps_closing_forms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nps_closing_forms_pf_opening_balance_id_foreign` (`pf_opening_balance_id`),
  ADD KEY `nps_closing_forms_created_by_foreign` (`created_by`),
  ADD KEY `nps_closing_forms_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `old_employee_allowances`
--
ALTER TABLE `old_employee_allowances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `old_employee_allowances_employee_id_foreign` (`employee_id`),
  ADD KEY `old_employee_allowances_old_employee_salary_id_foreign` (`old_employee_salary_id`),
  ADD KEY `old_employee_allowances_allowance_id_foreign` (`allowance_id`),
  ADD KEY `old_employee_allowances_created_by_foreign` (`created_by`),
  ADD KEY `old_employee_allowances_updated_by_foreign` (`updated_by`),
  ADD KEY `old_employee_allowances_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `old_employee_deductions`
--
ALTER TABLE `old_employee_deductions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `old_employee_deductions_employee_id_foreign` (`employee_id`),
  ADD KEY `old_employee_deductions_old_employee_salary_id_foreign` (`old_employee_salary_id`),
  ADD KEY `old_employee_deductions_deduction_id_foreign` (`deduction_id`),
  ADD KEY `old_employee_deductions_created_by_foreign` (`created_by`),
  ADD KEY `old_employee_deductions_updated_by_foreign` (`updated_by`),
  ADD KEY `old_employee_deductions_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `old_employee_salaries`
--
ALTER TABLE `old_employee_salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `old_employee_salaries_employee_id_foreign` (`employee_id`),
  ADD KEY `old_employee_salaries_pay_scale_id_foreign` (`pay_scale_id`),
  ADD KEY `old_employee_salaries_created_by_foreign` (`created_by`),
  ADD KEY `old_employee_salaries_updated_by_foreign` (`updated_by`),
  ADD KEY `old_employee_salaries_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `old_penssioner_payrolls`
--
ALTER TABLE `old_penssioner_payrolls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `old_penssioner_payrolls_pension_new_id_foreign` (`pension_new_id`),
  ADD KEY `old_penssioner_payrolls_pension_item_master_id_foreign` (`pension_item_master_id`),
  ADD KEY `old_penssioner_payrolls_penssioner_payroll_id_foreign` (`penssioner_payroll_id`);

--
-- Indexes for table `pay_msts`
--
ALTER TABLE `pay_msts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pay_msts_created_by_foreign` (`created_by`),
  ADD KEY `pay_msts_updated_by_foreign` (`updated_by`),
  ADD KEY `pay_msts_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `pay_scales`
--
ALTER TABLE `pay_scales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pay_scales_pay_mst_id_foreign` (`pay_mst_id`),
  ADD KEY `pay_scales_created_by_foreign` (`created_by`),
  ADD KEY `pay_scales_updated_by_foreign` (`updated_by`),
  ADD KEY `pay_scales_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `pensions`
--
ALTER TABLE `pensions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pensions_employee_id_foreign` (`employee_id`),
  ADD KEY `pensions_pension_bank_id_foreign` (`pension_bank_id`),
  ADD KEY `pensions_created_by_foreign` (`created_by`),
  ADD KEY `pensions_updated_by_foreign` (`updated_by`),
  ADD KEY `pensions_deleted_by_foreign` (`deleted_by`);

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

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

--
-- Indexes for table `pension_banks`
--
ALTER TABLE `pension_banks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_banks_created_by_foreign` (`created_by`),
  ADD KEY `pension_banks_updated_by_foreign` (`updated_by`),
  ADD KEY `pension_banks_deleted_by_foreign` (`deleted_by`);

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

--
-- Indexes for table `pension_da_bill_calculates`
--
ALTER TABLE `pension_da_bill_calculates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_da_bill_calculates_pension_da_bill_id_foreign` (`pension_da_bill_id`),
  ADD KEY `pension_da_bill_calculates_pension_new_id_foreign` (`pension_new_id`);

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

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

--
-- Indexes for table `pension_news`
--
ALTER TABLE `pension_news`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_news_employee_id_foreign` (`employee_id`),
  ADD KEY `pension_news_ward_id_foreign` (`ward_id`),
  ADD KEY `pension_news_designation_id_foreign` (`designation_id`),
  ADD KEY `pension_news_pay_scale_id_foreign` (`pay_scale_id`),
  ADD KEY `pension_news_pension_bank_id_foreign` (`pension_bank_id`),
  ADD KEY `pension_news_created_by_foreign` (`created_by`),
  ADD KEY `pension_news_updated_by_foreign` (`updated_by`),
  ADD KEY `pension_news_deleted_by_foreign` (`deleted_by`),
  ADD KEY `pension_news_department_id_foreign` (`department_id`);

--
-- Indexes for table `pension_news_1_1_25`
--
ALTER TABLE `pension_news_1_1_25`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_news_employee_id_foreign` (`employee_id`),
  ADD KEY `pension_news_ward_id_foreign` (`ward_id`),
  ADD KEY `pension_news_designation_id_foreign` (`designation_id`),
  ADD KEY `pension_news_pay_scale_id_foreign` (`pay_scale_id`),
  ADD KEY `pension_news_pension_bank_id_foreign` (`pension_bank_id`),
  ADD KEY `pension_news_created_by_foreign` (`created_by`),
  ADD KEY `pension_news_updated_by_foreign` (`updated_by`),
  ADD KEY `pension_news_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `pension_payroll_calculates`
--
ALTER TABLE `pension_payroll_calculates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_payroll_calculates_pension_new_id_foreign` (`pension_new_id`),
  ADD KEY `pension_payroll_calculates_freeze_pension_cron_id_foreign` (`freeze_pension_cron_id`);

--
-- Indexes for table `pension_payroll_calculates_24_03_25`
--
ALTER TABLE `pension_payroll_calculates_24_03_25`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_payroll_calculates_pension_new_id_foreign` (`pension_new_id`),
  ADD KEY `pension_payroll_calculates_freeze_pension_cron_id_foreign` (`freeze_pension_cron_id`);

--
-- Indexes for table `pension_payroll_calculates_25_03_25`
--
ALTER TABLE `pension_payroll_calculates_25_03_25`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_payroll_calculates_pension_new_id_foreign` (`pension_new_id`),
  ADD KEY `pension_payroll_calculates_freeze_pension_cron_id_foreign` (`freeze_pension_cron_id`);

--
-- Indexes for table `pension_payroll_calculates_bak`
--
ALTER TABLE `pension_payroll_calculates_bak`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pension_payroll_calculates_pension_new_id_foreign` (`pension_new_id`),
  ADD KEY `pension_payroll_calculates_freeze_pension_cron_id_foreign` (`freeze_pension_cron_id`);

--
-- Indexes for table `penssioner_payrolls`
--
ALTER TABLE `penssioner_payrolls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `penssioner_payrolls_pension_new_id_foreign` (`pension_new_id`),
  ADD KEY `penssioner_payrolls_pension_item_master_id_foreign` (`pension_item_master_id`);

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

--
-- Indexes for table `pf_intrest_rates`
--
ALTER TABLE `pf_intrest_rates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pf_intrest_rates_created_by_foreign` (`created_by`),
  ADD KEY `pf_intrest_rates_updated_by_foreign` (`updated_by`),
  ADD KEY `pf_intrest_rates_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `pf_opening_balances`
--
ALTER TABLE `pf_opening_balances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pf_opening_balances_employee_id_foreign` (`employee_id`),
  ADD KEY `pf_opening_balances_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `pf_opening_balances_created_by_foreign` (`created_by`),
  ADD KEY `pf_opening_balances_updated_by_foreign` (`updated_by`),
  ADD KEY `pf_opening_balances_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `remaining_freeze_salaries`
--
ALTER TABLE `remaining_freeze_salaries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `remaining_freeze_salaries_freeze_attendance_id_foreign` (`freeze_attendance_id`),
  ADD KEY `remaining_freeze_salaries_employee_id_foreign` (`employee_id`),
  ADD KEY `remaining_freeze_salaries_created_by_foreign` (`created_by`),
  ADD KEY `remaining_freeze_salaries_updated_by_foreign` (`updated_by`),
  ADD KEY `remaining_freeze_salaries_deleted_by_foreign` (`deleted_by`);

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

--
-- 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 `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `statuses_created_by_foreign` (`created_by`),
  ADD KEY `statuses_updated_by_foreign` (`updated_by`),
  ADD KEY `statuses_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `suplimentary_employee_leave_bills`
--
ALTER TABLE `suplimentary_employee_leave_bills`
  ADD PRIMARY KEY (`id`),
  ADD KEY `suplimentary_employee_leave_bills_suplimentry_leave_id_foreign` (`suplimentry_leave_id`),
  ADD KEY `suplimentary_employee_leave_bills_employee_id_foreign` (`employee_id`),
  ADD KEY `suplimentary_employee_leave_bills_created_by_foreign` (`created_by`),
  ADD KEY `suplimentary_employee_leave_bills_updated_by_foreign` (`updated_by`),
  ADD KEY `suplimentary_employee_leave_bills_deleted_by_foreign` (`deleted_by`),
  ADD KEY `financial_year_id` (`financial_year_id`),
  ADD KEY `emp_code` (`emp_code`);

--
-- Indexes for table `suplimentary_leave_bills`
--
ALTER TABLE `suplimentary_leave_bills`
  ADD PRIMARY KEY (`id`),
  ADD KEY `suplimentary_leave_bills_supplimentary_bill_id_foreign` (`supplimentary_bill_id`),
  ADD KEY `suplimentary_leave_bills_created_by_foreign` (`created_by`),
  ADD KEY `suplimentary_leave_bills_updated_by_foreign` (`updated_by`),
  ADD KEY `suplimentary_leave_bills_deleted_by_foreign` (`deleted_by`),
  ADD KEY `bill_no` (`bill_no`),
  ADD KEY `bill_date` (`bill_date`);

--
-- Indexes for table `suplimentry_employee_bills`
--
ALTER TABLE `suplimentry_employee_bills`
  ADD PRIMARY KEY (`id`),
  ADD KEY `suplimentry_employee_bills_supplimentary_bill_id_foreign` (`supplimentary_bill_id`),
  ADD KEY `suplimentry_employee_bills_employee_id_foreign` (`employee_id`),
  ADD KEY `suplimentry_employee_bills_department_id_foreign` (`department_id`),
  ADD KEY `suplimentry_employee_bills_created_by_foreign` (`created_by`),
  ADD KEY `suplimentry_employee_bills_updated_by_foreign` (`updated_by`),
  ADD KEY `suplimentry_employee_bills_deleted_by_foreign` (`deleted_by`),
  ADD KEY `suplimentry_employee_bills_add_employee_leave_id_foreign` (`add_employee_leave_id`);

--
-- Indexes for table `supplimentary_bills`
--
ALTER TABLE `supplimentary_bills`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supplimentary_bills_ward_id_foreign` (`ward_id`),
  ADD KEY `supplimentary_bills_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `supplimentary_bills_created_by_foreign` (`created_by`),
  ADD KEY `supplimentary_bills_updated_by_foreign` (`updated_by`),
  ADD KEY `supplimentary_bills_deleted_by_foreign` (`deleted_by`),
  ADD KEY `bill_no` (`bill_no`);

--
-- Indexes for table `tds_details`
--
ALTER TABLE `tds_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tds_details_created_by_foreign` (`created_by`),
  ADD KEY `tds_details_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `ten_day_attendnces`
--
ALTER TABLE `ten_day_attendnces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ten_day_attendnces_employee_id_foreign` (`employee_id`),
  ADD KEY `ten_day_attendnces_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `ten_day_attendnces_created_by_foreign` (`created_by`),
  ADD KEY `ten_day_attendnces_updated_by_foreign` (`updated_by`),
  ADD KEY `ten_day_attendnces_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `twenty_day_attendnces`
--
ALTER TABLE `twenty_day_attendnces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `twenty_day_attendnces_employee_id_foreign` (`employee_id`),
  ADD KEY `twenty_day_attendnces_financial_year_id_foreign` (`financial_year_id`),
  ADD KEY `twenty_day_attendnces_created_by_foreign` (`created_by`),
  ADD KEY `twenty_day_attendnces_updated_by_foreign` (`updated_by`),
  ADD KEY `twenty_day_attendnces_deleted_by_foreign` (`deleted_by`);

--
-- Indexes for table `user_departments`
--
ALTER TABLE `user_departments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_departments_department_id_foreign` (`department_id`),
  ADD KEY `user_departments_user_id_foreign` (`user_id`);

--
-- Indexes for table `verify_attendances`
--
ALTER TABLE `verify_attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `verify_attendances_month_from_date_to_date_index` (`month`,`from_date`,`to_date`);

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

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

--
-- Indexes for table `wards`
--
ALTER TABLE `wards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wards_created_by_foreign` (`created_by`),
  ADD KEY `wards_updated_by_foreign` (`updated_by`),
  ADD KEY `wards_deleted_by_foreign` (`deleted_by`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `absent_attendance_excels`
--
ALTER TABLE `absent_attendance_excels`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT for table `academic_details`
--
ALTER TABLE `academic_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `add_employee_leaves`
--
ALTER TABLE `add_employee_leaves`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15174;

--
-- AUTO_INCREMENT for table `adjust_attandance_imports`
--
ALTER TABLE `adjust_attandance_imports`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `allowances`
--
ALTER TABLE `allowances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `assign_supplimentry_users`
--
ALTER TABLE `assign_supplimentry_users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attendances`
--
ALTER TABLE `attendances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19261;

--
-- AUTO_INCREMENT for table `attendance_excel_backups`
--
ALTER TABLE `attendance_excel_backups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2173;

--
-- AUTO_INCREMENT for table `attendance_excel_crons`
--
ALTER TABLE `attendance_excel_crons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `clas`
--
ALTER TABLE `clas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `corporations`
--
ALTER TABLE `corporations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cron_data`
--
ALTER TABLE `cron_data`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `csv_imported_7th_difference`
--
ALTER TABLE `csv_imported_7th_difference`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;

--
-- AUTO_INCREMENT for table `csv_imported_da`
--
ALTER TABLE `csv_imported_da`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4013;

--
-- AUTO_INCREMENT for table `csv_imported_salary`
--
ALTER TABLE `csv_imported_salary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2547;

--
-- AUTO_INCREMENT for table `csv_imported_supplementary`
--
ALTER TABLE `csv_imported_supplementary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1125;

--
-- AUTO_INCREMENT for table `date_wise_work_sheets`
--
ALTER TABLE `date_wise_work_sheets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `da_bills`
--
ALTER TABLE `da_bills`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `da_bill_calculates`
--
ALTER TABLE `da_bill_calculates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46854;

--
-- AUTO_INCREMENT for table `da_differances`
--
ALTER TABLE `da_differances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deductions`
--
ALTER TABLE `deductions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1225;

--
-- AUTO_INCREMENT for table `employee_allowances`
--
ALTER TABLE `employee_allowances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5944;

--
-- AUTO_INCREMENT for table `employee_da_differances`
--
ALTER TABLE `employee_da_differances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_deductions`
--
ALTER TABLE `employee_deductions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8321;

--
-- AUTO_INCREMENT for table `employee_details`
--
ALTER TABLE `employee_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `employee_festival_advances`
--
ALTER TABLE `employee_festival_advances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_gpf_loans`
--
ALTER TABLE `employee_gpf_loans`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `employee_gpf_loan_details`
--
ALTER TABLE `employee_gpf_loan_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=295;

--
-- AUTO_INCREMENT for table `employee_leaves`
--
ALTER TABLE `employee_leaves`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7944;

--
-- AUTO_INCREMENT for table `employee_loans`
--
ALTER TABLE `employee_loans`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_monthly_festival_advances`
--
ALTER TABLE `employee_monthly_festival_advances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_monthly_lics`
--
ALTER TABLE `employee_monthly_lics`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_monthly_loans`
--
ALTER TABLE `employee_monthly_loans`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_pay_installments`
--
ALTER TABLE `employee_pay_installments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=165;

--
-- AUTO_INCREMENT for table `employee_provident_funds`
--
ALTER TABLE `employee_provident_funds`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10695;

--
-- AUTO_INCREMENT for table `employee_salaries`
--
ALTER TABLE `employee_salaries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1124;

--
-- AUTO_INCREMENT for table `employee_salary_structures`
--
ALTER TABLE `employee_salary_structures`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_statuses`
--
ALTER TABLE `employee_statuses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;

--
-- AUTO_INCREMENT for table `employee_transfers`
--
ALTER TABLE `employee_transfers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `experiences`
--
ALTER TABLE `experiences`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `financial_years`
--
ALTER TABLE `financial_years`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `freeze_attendances`
--
ALTER TABLE `freeze_attendances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1039173;

--
-- AUTO_INCREMENT for table `freeze_crons`
--
ALTER TABLE `freeze_crons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=260;

--
-- AUTO_INCREMENT for table `freeze_pensions`
--
ALTER TABLE `freeze_pensions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeze_pension_crons`
--
ALTER TABLE `freeze_pension_crons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `freeze_pension_news`
--
ALTER TABLE `freeze_pension_news`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28798;

--
-- AUTO_INCREMENT for table `gpf_closing_forms`
--
ALTER TABLE `gpf_closing_forms`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `gpf_closing_summary`
--
ALTER TABLE `gpf_closing_summary`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `important_documents`
--
ALTER TABLE `important_documents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `import_excel_files`
--
ALTER TABLE `import_excel_files`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `import_pending_employee_leaves`
--
ALTER TABLE `import_pending_employee_leaves`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `income_tax`
--
ALTER TABLE `income_tax`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1115;

--
-- AUTO_INCREMENT for table `increment_allowance_salaries`
--
ALTER TABLE `increment_allowance_salaries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `increment_basic_salaries`
--
ALTER TABLE `increment_basic_salaries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `increment_deductions_salaries`
--
ALTER TABLE `increment_deductions_salaries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `leave_counts`
--
ALTER TABLE `leave_counts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `leave_types`
--
ALTER TABLE `leave_types`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `letterdigitalworks`
--
ALTER TABLE `letterdigitalworks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lic_deductions`
--
ALTER TABLE `lic_deductions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=352;

--
-- AUTO_INCREMENT for table `loans`
--
ALTER TABLE `loans`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15187;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=218;

--
-- AUTO_INCREMENT for table `nps_closing_forms`
--
ALTER TABLE `nps_closing_forms`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `old_employee_allowances`
--
ALTER TABLE `old_employee_allowances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9484;

--
-- AUTO_INCREMENT for table `old_employee_deductions`
--
ALTER TABLE `old_employee_deductions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16320;

--
-- AUTO_INCREMENT for table `old_employee_salaries`
--
ALTER TABLE `old_employee_salaries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3468;

--
-- AUTO_INCREMENT for table `old_penssioner_payrolls`
--
ALTER TABLE `old_penssioner_payrolls`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1240;

--
-- AUTO_INCREMENT for table `pay_msts`
--
ALTER TABLE `pay_msts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pay_scales`
--
ALTER TABLE `pay_scales`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1346;

--
-- AUTO_INCREMENT for table `pensions`
--
ALTER TABLE `pensions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pension_arrears`
--
ALTER TABLE `pension_arrears`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `pension_arrear_bifurcations`
--
ALTER TABLE `pension_arrear_bifurcations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8788;

--
-- AUTO_INCREMENT for table `pension_banks`
--
ALTER TABLE `pension_banks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `pension_da_bills`
--
ALTER TABLE `pension_da_bills`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `pension_da_bill_calculates`
--
ALTER TABLE `pension_da_bill_calculates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10304;

--
-- AUTO_INCREMENT for table `pension_da_rates`
--
ALTER TABLE `pension_da_rates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT for table `pension_item_masters`
--
ALTER TABLE `pension_item_masters`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `pension_news`
--
ALTER TABLE `pension_news`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=652;

--
-- AUTO_INCREMENT for table `pension_news_1_1_25`
--
ALTER TABLE `pension_news_1_1_25`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=626;

--
-- AUTO_INCREMENT for table `pension_payroll_calculates`
--
ALTER TABLE `pension_payroll_calculates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43265;

--
-- AUTO_INCREMENT for table `pension_payroll_calculates_24_03_25`
--
ALTER TABLE `pension_payroll_calculates_24_03_25`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18829;

--
-- AUTO_INCREMENT for table `pension_payroll_calculates_25_03_25`
--
ALTER TABLE `pension_payroll_calculates_25_03_25`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41194;

--
-- AUTO_INCREMENT for table `pension_payroll_calculates_bak`
--
ALTER TABLE `pension_payroll_calculates_bak`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3664;

--
-- AUTO_INCREMENT for table `penssioner_payrolls`
--
ALTER TABLE `penssioner_payrolls`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1495;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=221;

--
-- AUTO_INCREMENT for table `pf_intrest_rates`
--
ALTER TABLE `pf_intrest_rates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pf_opening_balances`
--
ALTER TABLE `pf_opening_balances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2131;

--
-- AUTO_INCREMENT for table `remaining_freeze_salaries`
--
ALTER TABLE `remaining_freeze_salaries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=292242;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `statuses`
--
ALTER TABLE `statuses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `suplimentary_employee_leave_bills`
--
ALTER TABLE `suplimentary_employee_leave_bills`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8935;

--
-- AUTO_INCREMENT for table `suplimentary_leave_bills`
--
ALTER TABLE `suplimentary_leave_bills`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `suplimentry_employee_bills`
--
ALTER TABLE `suplimentry_employee_bills`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4561;

--
-- AUTO_INCREMENT for table `supplimentary_bills`
--
ALTER TABLE `supplimentary_bills`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `tds_details`
--
ALTER TABLE `tds_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ten_day_attendnces`
--
ALTER TABLE `ten_day_attendnces`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `twenty_day_attendnces`
--
ALTER TABLE `twenty_day_attendnces`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_departments`
--
ALTER TABLE `user_departments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=533;

--
-- AUTO_INCREMENT for table `verify_attendances`
--
ALTER TABLE `verify_attendances`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `verify_attendance_details`
--
ALTER TABLE `verify_attendance_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5582;

--
-- AUTO_INCREMENT for table `verify_recovery_amounts`
--
ALTER TABLE `verify_recovery_amounts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=765;

--
-- AUTO_INCREMENT for table `wards`
--
ALTER TABLE `wards`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `academic_details`
--
ALTER TABLE `academic_details`
  ADD CONSTRAINT `academic_details_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `academic_details_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `academic_details_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `academic_details_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `add_employee_leaves`
--
ALTER TABLE `add_employee_leaves`
  ADD CONSTRAINT `add_employee_leaves_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `add_employee_leaves_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `add_employee_leaves_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `add_employee_leaves_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `add_employee_leaves_leave_type_id_foreign` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`),
  ADD CONSTRAINT `add_employee_leaves_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `allowances`
--
ALTER TABLE `allowances`
  ADD CONSTRAINT `allowances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `allowances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `allowances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `assign_supplimentry_users`
--
ALTER TABLE `assign_supplimentry_users`
  ADD CONSTRAINT `assign_supplimentry_users_add_employee_leave_id_foreign` FOREIGN KEY (`add_employee_leave_id`) REFERENCES `add_employee_leaves` (`id`);

--
-- Constraints for table `attendances`
--
ALTER TABLE `attendances`
  ADD CONSTRAINT `attendances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `attendances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `attendances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `attendances_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `attendances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `attendance_excel_backups`
--
ALTER TABLE `attendance_excel_backups`
  ADD CONSTRAINT `attendance_excel_backups_attendance_id_foreign` FOREIGN KEY (`attendance_id`) REFERENCES `attendances` (`id`),
  ADD CONSTRAINT `attendance_excel_backups_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `attendance_excel_backups_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`);

--
-- Constraints for table `attendance_excel_crons`
--
ALTER TABLE `attendance_excel_crons`
  ADD CONSTRAINT `attendance_excel_crons_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `attendance_excel_crons_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `attendance_excel_crons_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `attendance_excel_crons_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `banks`
--
ALTER TABLE `banks`
  ADD CONSTRAINT `banks_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `banks_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `banks_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `clas`
--
ALTER TABLE `clas`
  ADD CONSTRAINT `clas_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `clas_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `clas_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `corporations`
--
ALTER TABLE `corporations`
  ADD CONSTRAINT `corporations_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `corporations_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `corporations_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `date_wise_work_sheets`
--
ALTER TABLE `date_wise_work_sheets`
  ADD CONSTRAINT `date_wise_work_sheets_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`);

--
-- Constraints for table `da_bill_calculates`
--
ALTER TABLE `da_bill_calculates`
  ADD CONSTRAINT `da_bill_calculates_da_bill_id_foreign` FOREIGN KEY (`da_bill_id`) REFERENCES `da_bills` (`id`),
  ADD CONSTRAINT `da_bill_calculates_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `da_bill_calculates_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  ADD CONSTRAINT `da_bill_calculates_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `da_bill_calculates_freeze_attendance_id_foreign` FOREIGN KEY (`freeze_attendance_id`) REFERENCES `freeze_attendances` (`id`),
  ADD CONSTRAINT `da_bill_calculates_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `da_differances`
--
ALTER TABLE `da_differances`
  ADD CONSTRAINT `da_differances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `da_differances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `da_differances_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `da_differances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `deductions`
--
ALTER TABLE `deductions`
  ADD CONSTRAINT `deductions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `deductions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `deductions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `departments`
--
ALTER TABLE `departments`
  ADD CONSTRAINT `departments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `departments_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `departments_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `departments_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `designations`
--
ALTER TABLE `designations`
  ADD CONSTRAINT `designations_clas_id_foreign` FOREIGN KEY (`clas_id`) REFERENCES `clas` (`id`),
  ADD CONSTRAINT `designations_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `designations_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `designations_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `designations_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `designations_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `documents`
--
ALTER TABLE `documents`
  ADD CONSTRAINT `documents_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `documents_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `documents_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employees`
--
ALTER TABLE `employees`
  ADD CONSTRAINT `employees_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `employees_clas_id_foreign` FOREIGN KEY (`clas_id`) REFERENCES `clas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `employees_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employees_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employees_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `employees_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `employees_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`),
  ADD CONSTRAINT `employees_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employees_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `employee_allowances`
--
ALTER TABLE `employee_allowances`
  ADD CONSTRAINT `employee_allowances_allowance_id_foreign` FOREIGN KEY (`allowance_id`) REFERENCES `allowances` (`id`),
  ADD CONSTRAINT `employee_allowances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_allowances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_allowances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_allowances_employee_salary_id_foreign` FOREIGN KEY (`employee_salary_id`) REFERENCES `employee_salaries` (`id`),
  ADD CONSTRAINT `employee_allowances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_da_differances`
--
ALTER TABLE `employee_da_differances`
  ADD CONSTRAINT `employee_da_differances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_da_differances_da_differance_id_foreign` FOREIGN KEY (`da_differance_id`) REFERENCES `da_differances` (`id`),
  ADD CONSTRAINT `employee_da_differances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_da_differances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_da_differances_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_da_differances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_deductions`
--
ALTER TABLE `employee_deductions`
  ADD CONSTRAINT `employee_deductions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_deductions_deduction_id_foreign` FOREIGN KEY (`deduction_id`) REFERENCES `deductions` (`id`),
  ADD CONSTRAINT `employee_deductions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_deductions_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_deductions_employee_salary_id_foreign` FOREIGN KEY (`employee_salary_id`) REFERENCES `employee_salaries` (`id`),
  ADD CONSTRAINT `employee_deductions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_details`
--
ALTER TABLE `employee_details`
  ADD CONSTRAINT `employee_details_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `employee_festival_advances`
--
ALTER TABLE `employee_festival_advances`
  ADD CONSTRAINT `employee_festival_advances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_festival_advances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_festival_advances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_festival_advances_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_festival_advances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_leaves`
--
ALTER TABLE `employee_leaves`
  ADD CONSTRAINT `employee_leaves_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_leaves_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_leaves_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_leaves_leave_type_id_foreign` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`),
  ADD CONSTRAINT `employee_leaves_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_loans`
--
ALTER TABLE `employee_loans`
  ADD CONSTRAINT `employee_loans_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_loans_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_loans_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_loans_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_loans_loan_id_foreign` FOREIGN KEY (`loan_id`) REFERENCES `loans` (`id`),
  ADD CONSTRAINT `employee_loans_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_monthly_festival_advances`
--
ALTER TABLE `employee_monthly_festival_advances`
  ADD CONSTRAINT `employee_monthly_festival_advances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_monthly_festival_advances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_monthly_festival_advances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_monthly_festival_advances_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_monthly_festival_advances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `festival_advance_id` FOREIGN KEY (`employee_festival_advance_id`) REFERENCES `employee_festival_advances` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `employee_monthly_lics`
--
ALTER TABLE `employee_monthly_lics`
  ADD CONSTRAINT `employee_monthly_lics_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_monthly_lics_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_monthly_lics_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_monthly_lics_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_monthly_lics_lic_deduction_id_foreign` FOREIGN KEY (`lic_deduction_id`) REFERENCES `lic_deductions` (`id`),
  ADD CONSTRAINT `employee_monthly_lics_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_monthly_loans`
--
ALTER TABLE `employee_monthly_loans`
  ADD CONSTRAINT `employee_monthly_loans_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_monthly_loans_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_monthly_loans_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_monthly_loans_employee_loan_id_foreign` FOREIGN KEY (`employee_loan_id`) REFERENCES `employee_loans` (`id`),
  ADD CONSTRAINT `employee_monthly_loans_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_monthly_loans_loan_id_foreign` FOREIGN KEY (`loan_id`) REFERENCES `loans` (`id`),
  ADD CONSTRAINT `employee_monthly_loans_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_provident_funds`
--
ALTER TABLE `employee_provident_funds`
  ADD CONSTRAINT `employee_provident_funds_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_provident_funds_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_provident_funds_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_provident_funds_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_provident_funds_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_salaries`
--
ALTER TABLE `employee_salaries`
  ADD CONSTRAINT `employee_salaries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_salaries_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_salaries_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_salaries_pay_scale_id_foreign` FOREIGN KEY (`pay_scale_id`) REFERENCES `pay_scales` (`id`),
  ADD CONSTRAINT `employee_salaries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_salary_structures`
--
ALTER TABLE `employee_salary_structures`
  ADD CONSTRAINT `employee_salary_structures_freeze_attendance_id_foreign` FOREIGN KEY (`freeze_attendance_id`) REFERENCES `freeze_attendances` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `employee_statuses`
--
ALTER TABLE `employee_statuses`
  ADD CONSTRAINT `employee_statuses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_statuses_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_statuses_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_statuses_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`),
  ADD CONSTRAINT `employee_statuses_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `employee_transfers`
--
ALTER TABLE `employee_transfers`
  ADD CONSTRAINT `employee_transfers_clas_id_foreign` FOREIGN KEY (`clas_id`) REFERENCES `clas` (`id`),
  ADD CONSTRAINT `employee_transfers_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_transfers_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_transfers_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `employee_transfers_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  ADD CONSTRAINT `employee_transfers_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `employee_transfers_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `employee_transfers_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `employee_transfers_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `experiences`
--
ALTER TABLE `experiences`
  ADD CONSTRAINT `experiences_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `experiences_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `experiences_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `experiences_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `financial_years`
--
ALTER TABLE `financial_years`
  ADD CONSTRAINT `financial_years_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `financial_years_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `financial_years_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `freeze_attendances`
--
ALTER TABLE `freeze_attendances`
  ADD CONSTRAINT `freeze_attendances_clas_id_foreign` FOREIGN KEY (`clas_id`) REFERENCES `clas` (`id`),
  ADD CONSTRAINT `freeze_attendances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_attendances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_attendances_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `freeze_attendances_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  ADD CONSTRAINT `freeze_attendances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `freeze_attendances_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `freeze_attendances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_attendances_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `freeze_crons`
--
ALTER TABLE `freeze_crons`
  ADD CONSTRAINT `freeze_crons_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_crons_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_crons_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `freeze_crons_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_crons_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `freeze_pensions`
--
ALTER TABLE `freeze_pensions`
  ADD CONSTRAINT `freeze_pensions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_pensions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_pensions_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `freeze_pensions_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `freeze_pensions_pension_bank_id_foreign` FOREIGN KEY (`pension_bank_id`) REFERENCES `pension_banks` (`id`),
  ADD CONSTRAINT `freeze_pensions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `freeze_pension_news`
--
ALTER TABLE `freeze_pension_news`
  ADD CONSTRAINT `freeze_pension_news_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_pension_news_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `freeze_pension_news_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `freeze_pension_news_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `freeze_pension_news_pension_bank_id_foreign` FOREIGN KEY (`pension_bank_id`) REFERENCES `pension_banks` (`id`),
  ADD CONSTRAINT `freeze_pension_news_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `gpf_closing_forms`
--
ALTER TABLE `gpf_closing_forms`
  ADD CONSTRAINT `gpf_closing_forms_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `gpf_closing_forms_pf_opening_balance_id_foreign` FOREIGN KEY (`pf_opening_balance_id`) REFERENCES `pf_opening_balances` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `gpf_closing_forms_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `gpf_closing_summary`
--
ALTER TABLE `gpf_closing_summary`
  ADD CONSTRAINT `gpf_closing_summary_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `gpf_closing_summary_pf_opening_balance_id_foreign` FOREIGN KEY (`pf_opening_balance_id`) REFERENCES `pf_opening_balances` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `gpf_closing_summary_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `important_documents`
--
ALTER TABLE `important_documents`
  ADD CONSTRAINT `important_documents_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `important_documents_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `important_documents_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`),
  ADD CONSTRAINT `important_documents_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `important_documents_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `income_tax`
--
ALTER TABLE `income_tax`
  ADD CONSTRAINT `income_tax_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `income_tax_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `income_tax_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `increment_allowance_salaries`
--
ALTER TABLE `increment_allowance_salaries`
  ADD CONSTRAINT `increment_allowance_salaries_allowance_id_foreign` FOREIGN KEY (`allowance_id`) REFERENCES `allowances` (`id`),
  ADD CONSTRAINT `increment_allowance_salaries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `increment_allowance_salaries_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `increment_allowance_salaries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `increment_basic_salaries`
--
ALTER TABLE `increment_basic_salaries`
  ADD CONSTRAINT `increment_basic_salaries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `increment_basic_salaries_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `increment_basic_salaries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `increment_deductions_salaries`
--
ALTER TABLE `increment_deductions_salaries`
  ADD CONSTRAINT `increment_deductions_salaries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `increment_deductions_salaries_deduction_id_foreign` FOREIGN KEY (`deduction_id`) REFERENCES `deductions` (`id`),
  ADD CONSTRAINT `increment_deductions_salaries_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `increment_deductions_salaries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `leave_counts`
--
ALTER TABLE `leave_counts`
  ADD CONSTRAINT `leave_counts_clas_id_foreign` FOREIGN KEY (`clas_id`) REFERENCES `clas` (`id`),
  ADD CONSTRAINT `leave_counts_leave_type_id_foreign` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`);

--
-- Constraints for table `leave_types`
--
ALTER TABLE `leave_types`
  ADD CONSTRAINT `leave_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `leave_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `leave_types_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `letterdigitalworks`
--
ALTER TABLE `letterdigitalworks`
  ADD CONSTRAINT `letterdigitalworks_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`);

--
-- Constraints for table `lic_deductions`
--
ALTER TABLE `lic_deductions`
  ADD CONSTRAINT `lic_deductions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `lic_deductions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `lic_deductions_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `lic_deductions_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `lic_deductions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `loans`
--
ALTER TABLE `loans`
  ADD CONSTRAINT `loans_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `loans_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `loans_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `nps_closing_forms`
--
ALTER TABLE `nps_closing_forms`
  ADD CONSTRAINT `nps_closing_forms_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `nps_closing_forms_pf_opening_balance_id_foreign` FOREIGN KEY (`pf_opening_balance_id`) REFERENCES `pf_opening_balances` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `nps_closing_forms_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `old_employee_allowances`
--
ALTER TABLE `old_employee_allowances`
  ADD CONSTRAINT `old_employee_allowances_allowance_id_foreign` FOREIGN KEY (`allowance_id`) REFERENCES `allowances` (`id`),
  ADD CONSTRAINT `old_employee_allowances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `old_employee_allowances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `old_employee_allowances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `old_employee_allowances_old_employee_salary_id_foreign` FOREIGN KEY (`old_employee_salary_id`) REFERENCES `old_employee_salaries` (`id`),
  ADD CONSTRAINT `old_employee_allowances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `old_employee_deductions`
--
ALTER TABLE `old_employee_deductions`
  ADD CONSTRAINT `old_employee_deductions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `old_employee_deductions_deduction_id_foreign` FOREIGN KEY (`deduction_id`) REFERENCES `deductions` (`id`),
  ADD CONSTRAINT `old_employee_deductions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `old_employee_deductions_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `old_employee_deductions_old_employee_salary_id_foreign` FOREIGN KEY (`old_employee_salary_id`) REFERENCES `old_employee_salaries` (`id`),
  ADD CONSTRAINT `old_employee_deductions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `old_employee_salaries`
--
ALTER TABLE `old_employee_salaries`
  ADD CONSTRAINT `old_employee_salaries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `old_employee_salaries_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `old_employee_salaries_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `old_employee_salaries_pay_scale_id_foreign` FOREIGN KEY (`pay_scale_id`) REFERENCES `pay_scales` (`id`),
  ADD CONSTRAINT `old_employee_salaries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `old_penssioner_payrolls`
--
ALTER TABLE `old_penssioner_payrolls`
  ADD CONSTRAINT `old_penssioner_payrolls_pension_item_master_id_foreign` FOREIGN KEY (`pension_item_master_id`) REFERENCES `pension_item_masters` (`id`),
  ADD CONSTRAINT `old_penssioner_payrolls_pension_new_id_foreign` FOREIGN KEY (`pension_new_id`) REFERENCES `pension_news` (`id`),
  ADD CONSTRAINT `old_penssioner_payrolls_penssioner_payroll_id_foreign` FOREIGN KEY (`penssioner_payroll_id`) REFERENCES `penssioner_payrolls` (`id`);

--
-- Constraints for table `pay_msts`
--
ALTER TABLE `pay_msts`
  ADD CONSTRAINT `pay_msts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pay_msts_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pay_msts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `pay_scales`
--
ALTER TABLE `pay_scales`
  ADD CONSTRAINT `pay_scales_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pay_scales_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pay_scales_pay_mst_id_foreign` FOREIGN KEY (`pay_mst_id`) REFERENCES `pay_msts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `pay_scales_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `pensions`
--
ALTER TABLE `pensions`
  ADD CONSTRAINT `pensions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pensions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pensions_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `pensions_pension_bank_id_foreign` FOREIGN KEY (`pension_bank_id`) REFERENCES `pension_banks` (`id`),
  ADD CONSTRAINT `pensions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `pension_banks`
--
ALTER TABLE `pension_banks`
  ADD CONSTRAINT `pension_banks_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pension_banks_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pension_banks_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `pension_da_bill_calculates`
--
ALTER TABLE `pension_da_bill_calculates`
  ADD CONSTRAINT `pension_da_bill_calculates_pension_da_bill_id_foreign` FOREIGN KEY (`pension_da_bill_id`) REFERENCES `pension_da_bills` (`id`),
  ADD CONSTRAINT `pension_da_bill_calculates_pension_new_id_foreign` FOREIGN KEY (`pension_new_id`) REFERENCES `pension_news` (`id`);

--
-- Constraints for table `pension_news`
--
ALTER TABLE `pension_news`
  ADD CONSTRAINT `pension_news_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pension_news_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pension_news_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `pension_news_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  ADD CONSTRAINT `pension_news_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `pension_news_pay_scale_id_foreign` FOREIGN KEY (`pay_scale_id`) REFERENCES `pay_scales` (`id`),
  ADD CONSTRAINT `pension_news_pension_bank_id_foreign` FOREIGN KEY (`pension_bank_id`) REFERENCES `pension_banks` (`id`),
  ADD CONSTRAINT `pension_news_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pension_news_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `pension_payroll_calculates_25_03_25`
--
ALTER TABLE `pension_payroll_calculates_25_03_25`
  ADD CONSTRAINT `pension_payroll_calculates_freeze_pension_cron_id_foreign` FOREIGN KEY (`freeze_pension_cron_id`) REFERENCES `freeze_pension_crons` (`id`),
  ADD CONSTRAINT `pension_payroll_calculates_pension_new_id_foreign` FOREIGN KEY (`pension_new_id`) REFERENCES `pension_news` (`id`);

--
-- Constraints for table `penssioner_payrolls`
--
ALTER TABLE `penssioner_payrolls`
  ADD CONSTRAINT `penssioner_payrolls_pension_item_master_id_foreign` FOREIGN KEY (`pension_item_master_id`) REFERENCES `pension_item_masters` (`id`),
  ADD CONSTRAINT `penssioner_payrolls_pension_new_id_foreign` FOREIGN KEY (`pension_new_id`) REFERENCES `pension_news` (`id`);

--
-- Constraints for table `pf_intrest_rates`
--
ALTER TABLE `pf_intrest_rates`
  ADD CONSTRAINT `pf_intrest_rates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pf_intrest_rates_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pf_intrest_rates_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `pf_opening_balances`
--
ALTER TABLE `pf_opening_balances`
  ADD CONSTRAINT `pf_opening_balances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pf_opening_balances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `pf_opening_balances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `pf_opening_balances_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `pf_opening_balances_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `remaining_freeze_salaries`
--
ALTER TABLE `remaining_freeze_salaries`
  ADD CONSTRAINT `remaining_freeze_salaries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `remaining_freeze_salaries_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `remaining_freeze_salaries_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `remaining_freeze_salaries_freeze_attendance_id_foreign` FOREIGN KEY (`freeze_attendance_id`) REFERENCES `freeze_attendances` (`id`),
  ADD CONSTRAINT `remaining_freeze_salaries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `statuses`
--
ALTER TABLE `statuses`
  ADD CONSTRAINT `statuses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `statuses_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `statuses_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `suplimentary_employee_leave_bills`
--
ALTER TABLE `suplimentary_employee_leave_bills`
  ADD CONSTRAINT `suplimentary_employee_leave_bills_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `suplimentary_employee_leave_bills_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `suplimentary_employee_leave_bills_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `suplimentary_employee_leave_bills_suplimentry_leave_id_foreign` FOREIGN KEY (`suplimentry_leave_id`) REFERENCES `suplimentary_leave_bills` (`id`),
  ADD CONSTRAINT `suplimentary_employee_leave_bills_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `suplimentary_leave_bills`
--
ALTER TABLE `suplimentary_leave_bills`
  ADD CONSTRAINT `suplimentary_leave_bills_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `suplimentary_leave_bills_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `suplimentary_leave_bills_supplimentary_bill_id_foreign` FOREIGN KEY (`supplimentary_bill_id`) REFERENCES `supplimentary_bills` (`id`),
  ADD CONSTRAINT `suplimentary_leave_bills_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `suplimentry_employee_bills`
--
ALTER TABLE `suplimentry_employee_bills`
  ADD CONSTRAINT `suplimentry_employee_bills_add_employee_leave_id_foreign` FOREIGN KEY (`add_employee_leave_id`) REFERENCES `add_employee_leaves` (`id`),
  ADD CONSTRAINT `suplimentry_employee_bills_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `suplimentry_employee_bills_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `suplimentry_employee_bills_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `suplimentry_employee_bills_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `suplimentry_employee_bills_supplimentary_bill_id_foreign` FOREIGN KEY (`supplimentary_bill_id`) REFERENCES `supplimentary_bills` (`id`),
  ADD CONSTRAINT `suplimentry_employee_bills_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `supplimentary_bills`
--
ALTER TABLE `supplimentary_bills`
  ADD CONSTRAINT `supplimentary_bills_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `supplimentary_bills_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `supplimentary_bills_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `supplimentary_bills_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `supplimentary_bills_ward_id_foreign` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`);

--
-- Constraints for table `tds_details`
--
ALTER TABLE `tds_details`
  ADD CONSTRAINT `tds_details_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tds_details_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `ten_day_attendnces`
--
ALTER TABLE `ten_day_attendnces`
  ADD CONSTRAINT `ten_day_attendnces_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `ten_day_attendnces_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `ten_day_attendnces_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `ten_day_attendnces_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `ten_day_attendnces_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `twenty_day_attendnces`
--
ALTER TABLE `twenty_day_attendnces`
  ADD CONSTRAINT `twenty_day_attendnces_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `twenty_day_attendnces_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `twenty_day_attendnces_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  ADD CONSTRAINT `twenty_day_attendnces_financial_year_id_foreign` FOREIGN KEY (`financial_year_id`) REFERENCES `financial_years` (`id`),
  ADD CONSTRAINT `twenty_day_attendnces_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `user_departments`
--
ALTER TABLE `user_departments`
  ADD CONSTRAINT `user_departments_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `user_departments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `wards`
--
ALTER TABLE `wards`
  ADD CONSTRAINT `wards_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `wards_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `wards_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);
COMMIT;

