table penilaian keberatan v1

CREATE TABLE skp_penilaian_keberatan (
  id varchar(32) NOT NULL,
  skp_penilaian_id varchar(32) NOT NULL,
  keberatan varchar(200) DEFAULT NULL,
  penjelasan_penilai varchar(200) DEFAULT NULL,
  keputusan_atasan varchar(200) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at timestamp NULL DEFAULT NULL,
  deleted_at timestamp NULL DEFAULT NULL,
  periode varchar(255) NOT NULL,
  tahun varchar(45) NOT NULL,
  hasil_kerja_sebelum varchar(45) NOT NULL DEFAULT,
  perilaku_kerja_sebelum varchar(45) NOT NULL DEFAULT,
  hasil_akhir_sebelum varchar(45) NOT NULL DEFAULT,
  hasil_kerja_sesudah varchar(45) DEFAULT NULL,
  perilaku_kerja_sesudah varchar(45) DEFAULT NULL,
  hasil_akhir_sesudah varchar(45) DEFAULT NULL,
  pegawai_id varchar(36) NOT NULL DEFAULT,
  pejabat_penilai_id varchar(45) NOT NULL DEFAULT,
  atasan_pejabat_penilai_id varchar(45) NOT NULL DEFAULT,
  PRIMARY KEY (id),
  KEY fk_skp_penilaian_keberatan_skp_penilaian1_idx (skp_penilaian_id),
  KEY fk_skp_penilaian_keberatan_ref_periode1_idx (periode),
  KEY fk_skp_penilaian_pegawai1_idx (pegawai_id),
  KEY fk_skp_penilaian_pejabat_penilai1_idx (pejabat_penilai_id),
  KEY fk_skp_penilaian_atasan_pejabat_penilai1_idx (atasan_pejabat_penilai_id),
  CONSTRAINT fk_skp_penilaian_keberatan_skp_penilaian1 FOREIGN KEY (skp_penilaian_id) REFERENCES skp_penilaian (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT fk_skp_penilaian_keberatan_ref_periode1 FOREIGN KEY (periode) REFERENCES ref_periode (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT fk_skp_penilaian_keberatan_ref_pegawai1 FOREIGN KEY (pegawai_id) REFERENCES pegawai (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT fk_skp_penilaian_keberatan_ref_pejabat_penilai1 FOREIGN KEY (pejabat_penilai_id) REFERENCES pegawai (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT fk_skp_penilaian_keberatan_ref_atasan_pejabat_penilai1 FOREIGN KEY (atasan_pejabat_penilai_id) REFERENCES pegawai (id) ON DELETE SET NULL ON UPDATE RESTRICT,
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci