INSERT INTO `tbl_peserta` VALUES (9, '085252686161', NULL, '829b36babd21be519fa5f9353daf5dbdb796993e', 1, 'Firman Purkhadi', '', '493', NULL, NULL, NULL, NULL, 'peserta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tbl_peserta` VALUES (10, '085387081111', NULL, '829b36babd21be519fa5f9353daf5dbdb796993e', 1, 'Sindu Prasetya', 'Jalan', NULL, '61.03.04.2005', 0.12464948720850227, 110.6099510912834, NULL, 'peserta', '61710002', '61710001', 'SEJARUK TEMBAWANG ', '1990-02-12', 'ISLAM', 'S1', 'LAKI-LAKI', NULL, NULL);
INSERT INTO `tbl_peserta` VALUES (11, '085387081162', NULL, '829b36babd21be519fa5f9353daf5dbdb796993e', 1, 'Sindu', '', NULL, NULL, NULL, NULL, NULL, 'peserta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tbl_peserta` VALUES (14, '085387081161', 'wahyusinduprasetya@gmail.com', NULL, 1, 'Wahyu Sindu', '', '100', '', NULL, NULL, 0x[encoded data, 29818 characters], 'peserta', '12131415', '54321', 'BENGKAYANG ', NULL, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for tbl_peserta_anak
-- ----------------------------
CREATE TABLE `tbl_peserta_anak`  (
  `id_anak` bigint(255) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_peserta` bigint(255) UNSIGNED NULL DEFAULT NULL,
  `nokk` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `nik` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `nama` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `kelamin` enum('LAKI-LAKI','PEREMPUAN') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tempat_lahir` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tanggal_lahir` date NULL DEFAULT NULL,
  `agama` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pendidikan` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `nama_ayah` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `nama_ibu` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `alamat` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `kode_desa` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `id_posyandu` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `foto` longblob NULL,
  `latitude` double NULL DEFAULT NULL,
  `longitude` double NULL DEFAULT NULL,
  `status_gizi` tinyint(4) NULL DEFAULT NULL COMMENT 'Index Status Gizi',
  `status_stunted` tinyint(4) NULL DEFAULT NULL COMMENT 'Status Stunting',
  PRIMARY KEY (`id_anak`) USING BTREE,
  INDEX `id_peserta`(`id_peserta`) USING BTREE,
  INDEX `kode_desa`(`kode_desa`) USING BTREE,
  INDEX `id_posyandu`(`id_posyandu`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1119 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_peserta_anak
-- ----------------------------
INSERT INTO `tbl_peserta_anak` VALUES (1, 1, '1050213100000001', '1050213100001123', 'Fadhil Zafran Nasrullah', 'LAKI-LAKI', 'BANDUNG', '2010-11-17', 'ISLAM', 'SMP', 'ayah', 'bunda', NULL, '61.03.13.2007', '209', 0x[encoded data, 191126 characters], 0.1281773429061895, 110.61083760210506, NULL, NULL);
INSERT INTO `tbl_peserta_anak` VALUES (2, 1, '1050213100000001', '1050213100001125', 'Salma Ilyasa', 'PEREMPUAN', 'BANDUNG', '2021-10-19', 'ISLAM', 'SD', 'Aing', 'Uing', 'Jl. Pesona Antapani I No 14 - test', '61.03.05.2003', '100', 0x[encoded data, 159044 characters], 0.12720815604227528, 110.62020539053752, 2, 3);
INSERT INTO `tbl_peserta_anak` VALUES (3, 1, '1050213100000001', '1050213100000444', 'Afnan Faisal Firdaus', 'LAKI-LAKI', 'BANDUNG', '2016-09-18', 'ISLAM', 'SD', 'Admin Utama', NULL, 'Jl Pelajar Pejuang 124', '61.03.07.2001', '125', 0x[encoded data, 126792 characters], 0.1248064725023288, 110.60263733625177, NULL, NULL);
