TABLE `pertanyaan_kuesioner` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pertanyaan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `jenis_pertanyaan` enum('pilihan_ganda','essay') COLLATE utf8mb4_unicode_ci DEFAULT 'pilihan_ganda',
  `status_aktif` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci


TABLE `edom_pilihan_jawaban` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idsoal` int NOT NULL,
  `pilihan` char(1) NOT NULL,
  `jawaban` char(100) NOT NULL,
  `poin` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1


TABLE `edom_status_mengisi` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `id_krs_pelatihan` int DEFAULT NULL,
  `id_jadwal` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nim` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `kd_dosen` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `stsisi` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci



TABLE `hasil_kuesioner` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `id_pertanyaan_kuesioner` int unsigned DEFAULT NULL,
  `thakad` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pilihan` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai` tinyint DEFAULT NULL,
  `id_jadwal` int unsigned DEFAULT NULL,
  `kd_dosen` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nim` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jawaban_essay` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci