CREATE TABLE `main_student` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `nisn` varchar(10) NOT NULL,
  `nis` varchar(10) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `generation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `main_student_generation_id_b38aba7d_fk_main_generation_id` (`generation_id`),
  CONSTRAINT `main_student_generation_id_b38aba7d_fk_main_generation_id` FOREIGN KEY (`generation_id`) REFERENCES `main_generation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci