tabbel penilaian kebertan sementara

mail@pastecode.io avatar
unknown
plain_text
a year ago
990 B
2
Indexable
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,
  PRIMARY KEY (id),
  KEY fk_skp_penilaian_keberatan_skp_penilaian1_idx (skp_penilaian_id),
  KEY fk_skp_penilaian_keberatan_ref_periode1_idx (periode),
  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,
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;