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;