CREATE TABLE IF NOT EXISTS `pelatihan`.`sertifikat_peserta` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `peserta_id` INT(11) NULL DEFAULT NULL,
  `nama` VARCHAR(255) NOT NULL,
  `tahun` YEAR NULL DEFAULT NULL,
  `penyelenggara` VARCHAR(255) NOT NULL,
  `file` VARCHAR(255) NULL DEFAULT NULL,
  `created_at` DATETIME NULL DEFAULT NULL,
  `updated_at` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `peserta_id` (`peserta_id` ASC),
  CONSTRAINT `sertifikat_ibfk_1`
    FOREIGN KEY (`peserta_id`)
    REFERENCES `pelatihan`.`peserta` (`id`))
ENGINE = InnoDB
AUTO_INCREMENT = 3
DEFAULT CHARACTER SET = latin1